MS Access Quiz

What is MS Access primarily used for?

• Designing graphics

• Managing relational databases

• Editing videos

• Creating spreadsheets

Which component of MS Access is responsible for data storage and retrieval?

• Macros

• Reports

• Database Engine

• Forms

What type of query is used to modify existing records in a database?

• Parameter Query

• Crosstab Query

• Action Query

• Select Query

Which feature allows users to automate repetitive tasks in MS Access?

• Queries

• Tables

• Reports

• Macros

What is the purpose of a primary key in a table?

• To store images

• To uniquely identify records

• To create relationships

• To format data

Which of the following is NOT a type of query in MS Access?

• Select Query

• Action Query

• Data Query

• Crosstab Query

Which option allows users to import data from external sources in MS Access?

• View tab

• Design tab

• Home tab

• External Data tab

What is the purpose of reports in MS Access?

• To present and summarize data

• To store data

• To create forms

• To run queries

Which of the following is a method to create a report in MS Access?

• Using the Table Design

• Using the Query Wizard

• Using the Report Wizard

• Using the Macro Builder

How are relationships between tables typically established in Access?

• Through field descriptions

  
  

• Using relationship menu

  
  

• Using import/export functions

• By setting primary keys