
Microsoft Access
Quiz by Derick Schoeman
Feel free to use or edit a copy
includes Teacher and Student dashboards
Measure skillsfrom any curriculum
Measure skills
from any curriculum
Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.
With a free account, teachers can
- edit the questions
- save a copy for later
- start a class game
- automatically assign follow-up activities based on students’ scores
- assign as homework
- share a link with colleagues
- print as a bubble sheet
10 questions
Show answers
- Q1Which of the following is a database management system developed by Microsoft?SQLiteMicrosoft AccessMySQLOracle30s
- Q2Which of the following statements is true about primary keys in Microsoft Access?A primary key can be any data type.Primary keys are only used for data validation.Primary keys are not necessary in Microsoft Access.A primary key uniquely identifies each record in a table.A primary key can be duplicated in multiple records.30s
- Q3Which of the following objects in Microsoft Access is used to view, enter, and edit data in a tabular format?TableFormQueryReport30s
- Q4In Microsoft Access, what is the purpose of a query?To enter and edit data in a tabular format.To generate printable documents.To establish relationships between tables.To store and organize data.To retrieve specific data based on certain criteria.30s
- Q5Which of the following is a database object in Microsoft Access that is used to present data in a formatted and printable manner?ReportQueryFormTable30s
- Q6What is the maximum number of objects that can be created in a Microsoft Access database?10,00032,767100,0001,000,00030s
- Q7What type of data does Microsoft Access use to store a date and time value?DateTimeTextNumberBoolean30s
- Q8What is a primary key in Microsoft Access?A report used to present data in a formatted and printable manner.A query used to retrieve data from multiple tables.The main table in a database.A form used for data entry and user interface.A field or combination of fields that uniquely identifies each record in a table.30s
- Q9What is the purpose of a form in Microsoft Access?To present data in a formatted and printable manner.To establish relationships between tables.To store and organize data in a tabular format.To retrieve specific data based on certain criteria.To provide a user-friendly interface for data entry and manipulation.30s
- Q10What is a query in Microsoft Access?A query is a database object used to retrieve specific data based on certain criteria.A primary key that uniquely identifies each record in a table.A form used for data entry and user interface.A report used to present data in a formatted and printable manner.A table used for data storage.30s