Quizalize logo
placeholder image to represent content

Microsoft Access Review

Quiz by Anawelyn Bacar

Feel free to use or edit a copy

includes Teacher and Student dashboards

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

Our brand new solo games combine with your quiz, on the same screen

Correct quiz answers unlock more play!

New Quizalize solo game modes
14 questions
Show answers
  • Q1
    What is the purpose of the Navigation Pane in Microsoft Access?
    To view and manage objects in an Access database
    To design report layouts
    To write database queries
    To create database tables
    30s
  • Q2
    What is the purpose of a primary key in a Microsoft Access database?
    To group records in a table
    To uniquely identify records in a table
    To filter records in a table
    To sort records in a table
    30s
  • Q3
    What is the purpose of the Property Sheet in Microsoft Access?
    To view and modify the properties of an object in an Access database
    To run queries on an Access database
    To view and modify data in an Access database
    To create new objects in an Access database
    30s
  • Q4
    What is the purpose of the Design View in Microsoft Access?
    To design and modify table, form, report, and query objects
    To enter data into an Access database
    To view data from an Access database
    To run SQL queries on an Access database
    30s
  • Q5
    Which object in Microsoft Access is used to display data from one or more tables or queries?
    A report
    A form
    A macro
    A module
    30s
  • Q6
    What is the purpose of a query in Microsoft Access?
    To retrieve data from one or more tables based on specified criteria
    To modify the properties of an object in Access
    To create relationships between tables in Access
    To design the layout of a report in Access
    30s
  • Q7
    What is the purpose of a report in Microsoft Access?
    To retrieve data from one or more tables based on specified criteria
    To create relationships between tables in Access
    To present data from one or more tables or queries in a formatted manner
    To modify the properties of an object in Access
    30s
  • Q8
    What is the name of the object used to store and organize data in Microsoft Access?
    Query
    Form
    Report
    Table
    30s
  • Q9
    Which of the following is NOT a data type in Microsoft Access?
    String Integer
    Text
    Date/Time
    Long Integer
    30s
  • Q10
    What is the name of the programming language used in Microsoft Access to automate tasks and build custom solutions?
    Java
    Python
    C#
    Visual Basic for Applications (VBA)
    30s
  • Q11
    What is the maximum number of fields allowed in a Microsoft Access table?
    255
    100
    500
    1000
    30s
  • Q12
    What is the file extension for Microsoft Access database files?
    .xlsx
    .accdb
    .pptx
    .docx
    30s
  • Q13
    What Access object is used to define a set of rules to ensure data accuracy and consistency?
    Validation Rule
    Table
    Form
    Query
    30s
  • Q14
    What is the name of the Access feature that automatically enters unique values in a field?
    PrimaryKey
    Validation Rule
    ForeignKey
    AutoNumber
    30s

Teachers give this quiz to your class