Microsoft Access

10 Questions | Total Attempts: 730

SettingsSettingsSettings
Please wait...
Microsoft Access Quizzes & Trivia

This test is formulated to assess your knowledge on the concepts of how to use Microsoft Access software effectively. The test is based on the criteria of the computer 150 course syllabus which is basically how to create and edit forms, tables ,reports and quires. The online tutorial effectively covered all the specific areas expected to know so this test will be enjoyable. Good Luck!


Questions and Answers
  • 1. 
    A database is ?
    • A. 

      A collection of file.

    • B. 

      A collection of records .

    • C. 

      A collection of data.

    • D. 

      A collection of tables.

  • 2. 
    Most database systems make it very easy to create a database via ?
    • A. 

      A visual interface

    • B. 

      A user interface

    • C. 

      Tabs

    • D. 

      Speech recognition

  • 3. 
    The following is the first step in how to create a database in Microsoft Access?
    • A. 

      From the "File" menu, click on "New Database"

    • B. 

      Choose "Blank Database"

    • C. 

      Choose a location to save the database

    • D. 

      Exit

  • 4. 
    In database terms, a table ?
    • A. 

      Is responsible for storing data in the database

    • B. 

      Is responsible for storing data in a folder

    • C. 

      Is responsible for storing data in a report

    • D. 

      Is responsible for storing data in a query

  • 5. 
    Database tables consist of ?
    • A. 

      Rows and columns

    • B. 

      Forms and reports

    • C. 

      Lines and arrows

    • D. 

      Formulas and calculations

  • 6. 
    A row contains each record in the?
    • A. 

      Form

    • B. 

      Report

    • C. 

      Table

    • D. 

      Design View

  • 7. 
     What enables you to create the names of each column, specify the type of data that can go into each column, as well as specifying any other restrictions you'd like to enforce?
    • A. 

      Creative view

    • B. 

      Visual view

    • C. 

      Design view

    • D. 

      Creative View

  • 8. 
    A "query" refers to the action of  ________from your database.
    • A. 

      Retrieving data

    • B. 

      Deleting data

    • C. 

      Recycling data

    • D. 

      Canceling data

  • 9. 
    A unique identifier is a value that is  ______to each record.
    • A. 

      Ordinary

    • B. 

      Common

    • C. 

      Unique

    • D. 

      Deleted

  • 10. 
    The column that contains the unique identifier is referred to as the ?
    • A. 

      Secondary key

    • B. 

      Product Key

    • C. 

      Primary Key

    • D. 

      Delete Key