MOS Access: Database Fundamentals 3

Question 1

What type of table relationship exists when one record in Table A can be linked to many records in Table B, but each record in Table B links to only one record in Table A?

Accepted Answer

One-to-Many

Answer

A One-to-Many relationship means one record in the primary table (e.g., a customer) can have multiple related records in the foreign table (e.g., orders).

Question 2

What is referential integrity in Microsoft Access?

Accepted Answer

A set of rules that maintain consistency between records in related tables

Answer

Referential integrity enforces rules that prevent orphan records — for example, you cannot add an order for a customer ID that doesn't exist in the Customers table.

Question 3

Which Access feature allows you to bring data from an Excel spreadsheet into an Access table?

Accepted Answer

Get External Data (Import & Link)

Answer

The Get External Data option in the External Data ribbon tab provides an Import Wizard for bringing Excel, CSV, and other external data into Access tables.

Question 4

What is the primary benefit of creating an Index on a field in an Access table?

Accepted Answer

It speeds up searching, sorting, and querying on that field

Answer

An index improves performance by allowing Access to locate matching records quickly without scanning every row in the table.

Question 5

Which field property in Access allows you to specify a condition that all entered data must satisfy before it can be saved?

Accepted Answer

Validation Rule

Answer

A Validation Rule sets a logical condition (e.g., >0 Or Is Null) that data must meet; Access displays the Validation Text message if the rule is violated.

MOS - Microsoft Office Specialist Certification Practice Test

MOS - Microsoft Office Specialist Certification Practice Test

MOS Access: Database Fundamentals 3