GMetrix Exam GMetrix Access: Database Fundamentals 2 — Questions and Answers
Question 1: What is the main purpose of a form in Microsoft Access?
- Executing SQL queries automatically
- Providing a user-friendly interface for entering and viewing records (Correct answer)
- Generating formatted printable reports
- Defining relationships between tables
Correct answer: Providing a user-friendly interface for entering and viewing records
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?
- To write and run queries
- To create and manage links between tables based on matching fields (Correct answer)
- To design form layouts
- To schedule macro execution
Correct answer: To create and manage links between tables based on matching fields
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?
- INSERT INTO
- UPDATE
- SELECT (Correct answer)
- DELETE
Correct answer: SELECT
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?
- Encrypts the related tables
- Enforces rules that keep related records consistent across tables (Correct answer)
- Automatically formats related fields
- Compresses the database file
Correct answer: Enforces rules that keep related records consistent across tables
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?
- Formats numeric fields with currency symbols
- Automatically assigns a unique incremental number to each new record (Correct answer)
- Rounds decimal values automatically
- Converts text to numbers on entry
Correct answer: Automatically assigns a unique incremental number to each new record
AutoNumber generates a unique sequential or random numeric value for every new record without any user input.
Question 6: Which Access database object is specifically designed to produce formatted output for printing?
- Query
- Form
- Report (Correct answer)
- Macro
Correct answer: Report
Reports are designed to present data in a structured, formatted layout optimized for printing or PDF export.
GMetrix Exam GMetrix Access: Database Fundamentals 2
What is the main purpose of a form in Microsoft Access?