Microsoft Access Review
Quiz by Anawelyn Bacar
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
14 questions
Show answers
- Q1What is the purpose of the Navigation Pane in Microsoft Access?To view and manage objects in an Access databaseTo design report layoutsTo write database queriesTo create database tables30s
- Q2What is the purpose of a primary key in a Microsoft Access database?To group records in a tableTo uniquely identify records in a tableTo filter records in a tableTo sort records in a table30s
- Q3What is the purpose of the Property Sheet in Microsoft Access?To view and modify the properties of an object in an Access databaseTo run queries on an Access databaseTo view and modify data in an Access databaseTo create new objects in an Access database30s
- Q4What is the purpose of the Design View in Microsoft Access?To design and modify table, form, report, and query objectsTo enter data into an Access databaseTo view data from an Access databaseTo run SQL queries on an Access database30s
- Q5Which object in Microsoft Access is used to display data from one or more tables or queries?A reportA formA macroA module30s
- Q6What is the purpose of a query in Microsoft Access?To retrieve data from one or more tables based on specified criteriaTo modify the properties of an object in AccessTo create relationships between tables in AccessTo design the layout of a report in Access30s
- Q7What is the purpose of a report in Microsoft Access?To retrieve data from one or more tables based on specified criteriaTo create relationships between tables in AccessTo present data from one or more tables or queries in a formatted mannerTo modify the properties of an object in Access30s
- Q8What is the name of the object used to store and organize data in Microsoft Access?QueryFormReportTable30s
- Q9Which of the following is NOT a data type in Microsoft Access?String IntegerTextDate/TimeLong Integer30s
- Q10What is the name of the programming language used in Microsoft Access to automate tasks and build custom solutions?JavaPythonC#Visual Basic for Applications (VBA)30s
- Q11What is the maximum number of fields allowed in a Microsoft Access table?255100500100030s
- Q12What is the file extension for Microsoft Access database files?.xlsx.accdb.pptx.docx30s
- Q13What Access object is used to define a set of rules to ensure data accuracy and consistency?Validation RuleTableFormQuery30s
- Q14What is the name of the Access feature that automatically enters unique values in a field?PrimaryKeyValidation RuleForeignKeyAutoNumber30s