Home

Microsoft Access MCQ Question with Answer

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

Download Microsoft Access MCQ Question Answer PDF

Question No : 22
To create relationship between two tables

drag the primary key of a table into foreign key of another table
drag the foreign key of a table into the primary key of another table
drag any field from parent table and drop on child table
Any of above can be done to create relationship

Question No : 23
After entering all fields required for a table, if you realize that the third field is not needed, how will you remove?

You need to delete the whole tablThere is no method to remove a particular field only.
Delete all the fields from third downwards and reenter the required fields again.
Select the third column in datasheet view then Delete
Select the third row in table design view then Delete

Question No : 24
To duplicate a controls formatting you can use___

Manager
Wizard
Painter
Control

Question No : 25
Which field type will you select when creating a new table if you require to enter long text in that field?

Text
Memo
Currency
Hyperlink

Question No : 26
In table design view what are the first column of buttons used for

Indicate Primary Key
Indicate Current Row
Both of above
None of above

Question No : 27
What does the show check box in query design window indicate

It indicates whether the field is to be used or not
It indicates whether the field is to be displayed in query result or not
It indicates whether the field names to be displayed in query result or not
None of above

Question No : 28
Which of the following is not a type of relationship that can be applied in Access database

One to One
One to Many
Many to Many
All of above can be applied