Microsoft Access MCQ Question with Answer

Microsoft Access MCQ with detailed explanation for interview, entrance and competitive exams. Explanation are given for understanding.

Question No : 8
The size of a field with Number data type can not be

Question No : 9
The two form layout types will display multiple records at one time are tabular and___

columnar

justified

date sheet

pivot table

Question No : 10
This is the stage in database design where one gathers and lists all the necessary fields for the database project.

data definition

data refinement

establishing relationship

none of the above

Question No : 11
Two tables can be linked with relationship so that the data integrity can be enforced. Where can you find Relationship Command?

Home Tab

Create Tab

External Data Tab

Database Tab

Question No : 12
The third stage in designing a database is when we analyze our tables more closely and create a ___________ between tables

relationship

Join

Query

None of these

Question No : 13
In one-to-many relationship the table in one side is called _______ and on many side is called _______

Child , Parent

Parent , Child

Brother , Sister

Father , Son

Question No : 14
Which of the following is not a database object?

Tables

Queries

Relationships

Reports