Practice Test GeeksMOS - Microsoft Office Specialist Certification Practice Test
← All MOS Flashcard Decks

Access: Database Fundamentals Flashcards

7 cards from real MOS practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.

Read the first 7 Access: Database Fundamentals flashcards as text

  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?

    Answer: One-to-Many

    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).

  2. What is referential integrity in Microsoft Access?

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

    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.

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

    Answer: Get External Data (Import & Link)

    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.

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

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

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

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

    Answer: Validation Rule

    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.

  6. What is the primary function of the Relationships window in Microsoft Access?

    Answer: To define, view, edit, and delete the relationships between database tables

    The Relationships window provides a visual diagram where you create join lines between tables to define how they are related.

  7. Which type of Access action query creates a brand-new table using the records returned by the query?

    Answer: Make-Table Query

    A Make-Table Query generates a new permanent table from query results, useful for archiving data snapshots or creating summary tables.