MS Office Access MCQs, Quiz and Practice Questions

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

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

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

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

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

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

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

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

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

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

Q10. Which button displays data from a related table?

Microsoft Office Access