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 is the primary purpose of a primary key in an Access table?

    Answer: To uniquely identify each record in the table

    A primary key uniquely identifies each record in a table, ensuring no two records have the same key value.

  2. Which data type should you use to store a phone number like '(555) 123-4567' in an Access table?

    Answer: Short Text

    Short Text is used for alphanumeric data like phone numbers that contain non-numeric characters and are never used in calculations.

  3. What is the maximum number of characters allowed in a Short Text field in Microsoft Access?

    Answer: 255

    Short Text fields in Access support a maximum of 255 characters.

  4. Which Access view allows you to add, edit, and delete table records directly?

    Answer: Datasheet View

    Datasheet View displays records in a row-and-column grid and allows direct data entry and editing.

  5. What happens when you set a field's Required property to 'Yes' in Access?

    Answer: The field must have a value before the record can be saved

    Setting Required to 'Yes' forces users to enter a value in that field; the record cannot be saved if the field is left empty.

  6. Which of the following is NOT a valid data type in Microsoft Access?

    Answer: Formula

    'Formula' is not a data type in Access; fields that compute values use the 'Calculated' data type instead.

  7. What is the purpose of the AutoNumber data type in Access?

    Answer: To automatically assign a unique sequential integer to each new record

    AutoNumber automatically generates a unique sequential (or random) number for each new record, making it ideal for use as a primary key.