Microsoft Access mcq questions with answer – Set 3

Important Instructions:

• Total Number Of Questions : 10
• Passing Marks : 7
• Each Question Carry 1 Mark, No Negative Marking.
• Do Not Refresh The Page.
• This Is A FREE Online Test, DO NOT Pay Money To Anyone To Attend This Test.
• Best Of Luck…

Results

-

Congratulation… You Have Passed The Test, You Should Try To The Next One…!!

Rate this post

You May Also Like :   Microsoft Access mcq questions with answer - Set 1

Unfortunately…
You Did Not Pass. Why Not Try It Again?

Rate this post

You May Also Like :   Microsoft Access mcq questions with answer - Set 5

#1. When entering field name, how many characters you can type in maximum?

60

60

64

64

68

68

Any number of character

Any number of character

#2. The __________ operator will cause a record to be selected only if two or more conditions are satisfied.

Or

Or

If or

If or

Range

Range

And

And

#3. Which field type can store photos?

Hyperlink

Hyperlink

OLE

OLE

Both of these can be used

Both of these can be used

Access tables can′t store photos

Access tables can′t store photos

#4. Which of the following is a method to create a new table in MS Access?

Create table in Design View

Create table in Design View

Create Table using wizard

Create Table using wizard

Create Table by Entering data

Create Table by Entering data

All of the mentioned

All of the mentioned

#5. Queries in Access can be used as?

View, change and analyze data in different ways

View, change and analyze data in different ways

A source of records for forms and reports

A source of records for forms and reports

View, change and analyze data in different ways and a source of records for forms and reports

View, change and analyze data in different ways and a source of records for forms and reports

None of the mentioned

None of the mentioned

#6. What is the maximum length of a text field?

120

120

255

255

265

265

75

75

#7. Microsoft Access is a?

RDBMS

RDBMS

OODBMS

OODBMS

ORDBMS

ORDBMS

Network database model

Network database model

#8. Which of the following statement is true?

Foreign key fields don′t allow duplicate values

Foreign key fields don′t allow duplicate values

In primary key field you can enter duplicate value

In primary key field you can enter duplicate value

In an indexed field you may or may not enter duplicate value depending upon setting

In an indexed field you may or may not enter duplicate value depending upon setting

All statements are true

All statements are true

#9. DCL provides commands to perform actions like?

Change the structure of tables

Change the structure of tables

Insert, update or delete records and data values

Insert, update or delete records and data values

Authorizing access and other control over database

Authorizing access and other control over database

None of the mentioned

None of the mentioned

#10. Which of the following steps do you take if you need to edit a relationship?

Right click the relationship line and choose Edit Relationship

Right click the relationship line and choose Edit Relationship

Double click the relationship line

Double click the relationship line

Right click the relationship line and choose Edit Relationship and Double click the relationship line

Right click the relationship line and choose Edit Relationship and Double click the relationship line

None of the mentioned

None of the mentioned

CHECK ANSWER