MS Access Quiz

Which of these is not a database object?

• Folder

• Table

• Form

• Report

Each row in a table is called a:

• Record

• Field

• Column

• Report

The key that makes every record unique is called:

• Primary Key

• Foreign Key

• Enter Key

• Delete Key

A report in MS Access is mainly used for:

• Printing data

• Entering data

• Deleting data

• Sorting data

Which MS Access view lets you set field names and data types?

• Design View

• Datasheet View

• Layout View

• Form View

Which relationship type requires a junction table?

• Many-to-Many

• One-to-One

• One-to-Many

• None

What is the full form of DBMS?

• Database Management System

• Data Basic Management System

• Digital Base Mapping Software

• None of the above

Which of these can be created in MS Access?

• Tables, Queries, Forms, Reports

• Tables only

• Tables and Queries only

• Forms only

Which view allows users to type data directly into a table?

• Datasheet View

• Design View

• Form View

• Report View

In Access, a Form is mainly used for:

• Easier data entry

• Printing summaries

• Sorting queries

• Storing databases