GMetrix Exam GMetrix Access: Database Fundamentals 2

Question 1

What is the main purpose of a form in Microsoft Access?

Accepted Answer

Providing a user-friendly interface for entering and viewing records

Answer

Forms present database records in a structured, visually accessible layout that simplifies data entry and editing.

Question 2

What is the purpose of the Relationships window in Microsoft Access?

Accepted Answer

To create and manage links between tables based on matching fields

Answer

The Relationships window is where you visually create joins between tables by dragging a field from one table to a matching field in another.

Question 3

Which SQL statement is used to retrieve records from an Access table?

Accepted Answer

SELECT

Answer

The SELECT statement specifies which fields and records to return from one or more tables.

Question 4

What does enabling referential integrity in an Access relationship do?

Accepted Answer

Enforces rules that keep related records consistent across tables

Answer

Referential integrity prevents orphaned records by ensuring child records always reference a valid parent record.

Question 5

What does the AutoNumber data type do in a Microsoft Access table?

Accepted Answer

Automatically assigns a unique incremental number to each new record

Answer

AutoNumber generates a unique sequential or random numeric value for every new record without any user input.

GMetrix Exam Practice Test