Access Database Concepts Quiz
8 Questions
0 Views

Choose a study mode

Play Quiz
Study Flashcards
Spaced Repetition
Chat to lesson

Podcast

Play an AI-generated podcast conversation about this lesson

Questions and Answers

Which of the following is not an Access object?

  • Table
  • Record (correct)
  • Form
  • Macro
  • Where is data primarily stored in a database?

  • Table (correct)
  • Query
  • Form
  • Report
  • When should you execute the Save command after editing records in Access?

  • Immediately after you edit a record
  • When you close the table
  • Once at the end of the session
  • Records are saved automatically; the save command is not required (correct)
  • Which of the following statements about Access databases is true?

    <p>A primary key uniquely identifies a record.</p> Signup and view all the answers

    Which view allows you to add, edit, and delete records in Access?

    <p>Datasheet view</p> Signup and view all the answers

    Which utility is used for recovering lost or damaged data in Access?

    <p>Compact and Repair Database</p> Signup and view all the answers

    If using a Selection filter’s exact match option for the title 'Manager', which title would be matched?

    <p>Manager (but not MANAGER)</p> Signup and view all the answers

    To add a predefined table to an existing database, which option should you choose?

    <p>Database template</p> Signup and view all the answers

    Study Notes

    Access Objects

    • An Access object is not a Record. Tables, forms, and macros are Access objects.

    Data Storage in a Database

    • Data in a database is stored in a Table.

    Saving Edits in an Access Table

    • Changes made in a table are saved automatically when moving to a new record. You do not need to manually save.

    Access Database Characteristics

    • Each field in an Access table has a specific data type.
    • All records within a table have the same fields.
    • Tables in a database do not necessarily have the same number of records.
    • A primary key uniquely identifies a record.

    Table Views in Access

    • Datasheet view allows adding, editing, and deleting records.
    • Datasheet view displays the data, not the table design.
    • Design view provides more field properties than Datasheet view.
    • Datasheet view changes are automatically saved when moving between records.

    Database Utilities

    • Compact and Repair Database utility is used to recover data if lost or damaged.

    Selection Filter Matching

    • Using an "exact match" filter for "Manager" would only match the entry Manager, not Sales Manager or manager.

    Selection Filter Conditions

    • Selection filters support equal and AND, OR conditions

    Database Creation

    • A blank database starts with a blank table.
    • Access opens a blank table in datasheet view.
    • Database templates save time as they include pre-defined objects.
    • Predefined objects in templates can be modified.

    Adding Predefined Tables to a Database

    • Use a database template to add predefined tables to an existing database.

    Studying That Suits You

    Use AI to generate personalized quizzes and flashcards to suit your learning preferences.

    Quiz Team

    Description

    Test your knowledge on Access database concepts including objects, data storage, and table characteristics. This quiz will cover key features of Access such as Views, primary keys, and the utility functions available for database maintenance.

    More Like This

    MS Access Database Design Basics
    30 questions
    Veri Tabanı Kopyalama ve Erişim
    18 questions
    Use Quizgecko on...
    Browser
    Browser