MS Office Access MCQs, Quiz and Practice Questions

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

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

Q3. Which button displays data from a related table?

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

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

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

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

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

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

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

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

Microsoft Office Access