MS Office Access MCQs, Quiz and Practice Questions

Q1. Which button displays data from a related table?

Q2. What does the mouse-pointer look like when creating relationships using a mouse?

Q3. Which option would you choose to create a drop-down list of values?

Q4. Which field type is used to enter long text in the field?

Q5. What is the use of the Cascade Delete option?

To repeat deleting operations to existing table records
To delete all related table records automatically when the parent table is deleted
To delete all table records in a database
To delete records only of related table database

Q6. Which of these is not a database object in MS Access?

Q7. What is the other name of columns in Microsoft Access?

Q8. Which of these cannot be the size of field having number data type?

Q9. What is the size of yes/no field?

Q10. This query prompts you to enter information before executing through a dialog box:

Microsoft Office Access