GMetrix Exam GMetrix Access: Database Fundamentals

Question 1

What is the primary purpose of Microsoft Access?

Accepted Answer

Building and managing relational databases

Answer

Microsoft Access is a relational database management system used to store, organize, query, and report on structured data.

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

A primary key uniquely identifies every record in a table and enforces that no two rows share the same value.

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

A one-to-many relationship is the most common relational database link, such as one customer having many orders.

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

Queries allow you to ask questions of the database, returning only the records and fields that meet your specified criteria.

Question 5

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

Accepted Answer

Design view

Answer

Design view is where you define the structure of a table by naming fields and assigning their data types and properties.

GMetrix Exam Practice Test