MS Access Quiz

What type of software is MS Access?

• Word processor

• Spreadsheet software

• Database management system

• Presentation software

What is the purpose of a table in MS Access?

• To enter data

• To store and organize data

• To print reports

• To create forms

Which of the following is used to define relationships between tables?

• Form

• Query

• Relationship window

• Report

Which data type in MS Access would be best for storing a person’s age?

• Text

• Number

• Currency

• Memo

Which of the following is a primary key?

• A field that uniquely identifies a record

• A field that links two tables

• A field used for data entry

• A field with a default value

What is the function of a query in MS Access?

• To input data

• To store data

• To retrieve and filter data

• To create reports

Which view is used to design a table in MS Access?

• Datasheet View

• Design View

• Form View

• Report View

What does the "IIf" function do in MS Access?

• It sorts records

• It calculates totals

• It performs conditional logic

• It formats data

Which of these is NOT a type of query in MS Access?

• Select Query

• Update Query

• Delete Query

• Design Query

Which of the following is used to ensure that no duplicate records are entered?

• Foreign Key

• Primary Key

• Data Validation

• Input Mask