MS Office Access MCQs, Quiz and Practice Questions

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

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

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

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

Q5. 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 related table records automatically when the parent table is deleted
To delete all table records in a database

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

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

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

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

Q10. Which button displays data from a related table?

Microsoft Office Access