GMetrix Exam GMetrix Access: Database Fundamentals

Question 1

What is the primary purpose of Microsoft Access?

Accepted Answer

Building and managing relational databases

Answer

Creating spreadsheets for calculations

Answer

Designing slide presentations

Answer

Drafting and formatting documents

Question 2

What is a primary key in a Microsoft Access table?

Accepted Answer

A field that uniquely identifies each record with no duplicates or nulls

Answer

The first field listed in the table

Answer

A foreign key linking to another table

Answer

The password protecting the table

Question 3

Which type of table relationship connects one record in a parent table to multiple records in a child table?

Accepted Answer

One-to-many

Answer

One-to-one

Answer

Many-to-many

Answer

Self-referencing

Question 4

What is the primary function of a query in Microsoft Access?

Accepted Answer

To retrieve, filter, and summarize data from one or more tables

Answer

To format printed reports

Answer

To create data-entry forms

Answer

To add new fields to a table

Question 5

Which Access view allows you to define field names, data types, and field properties for a table?

Accepted Answer

Design view

Answer

Datasheet view

Answer

Form view

Answer

Layout view

Question 6

Which data type in Access should you use for a field that stores whole numbers used in calculations?

Accepted Answer

Number

Answer

Short Text

Answer

Currency

Answer

AutoNumber