Database Management Programs Quiz

34 Questions | Total Attempts: 67

SettingsSettingsSettings
Please wait...
Database Quizzes & Trivia

Questions and Answers
  • 1. 
    A table is often referred to as a(n) ____________________.
  • 2. 
    A ____ is an object that stores data in columns and rows.
    • A. 

      Table

    • B. 

      Form

    • C. 

      Report

    • D. 

      Query

  • 3. 
    A ____ makes it easy for you to view, enter, and edit data in a table.
    • A. 

      Table

    • B. 

      Form

    • C. 

      Report

    • D. 

      Query

  • 4. 
    A(n) ____________________ is a collection of related information.
  • 5. 
    Access is a database program.
    • A. 

      True

    • B. 

      False

  • 6. 
    Access stores cut or copied text in the ____.
    • A. 

      Navigation Pane

    • B. 

      Clipboard

    • C. 

      Field

    • D. 

      Entry

  • 7. 
    Case 22-1Dana has just been hired to create and maintain a database for a local sports organization. The organization has several different sports with many teams and divisions. She is creating the database in Design view.What setting will allow Dana to change the number of characters allowed in a field?
    • A. 

      Primary key

    • B. 

      Field name

    • C. 

      Field properties

    • D. 

      Data type

  • 8. 
    Case 22-2Jamir works for a distribution company and has taken over responsibility of the customer database. He has several changes to make to it in order to update the information.To remove a table field and all the data for the field, Jamir should delete the ____.
    • A. 

      Column

    • B. 

      Record

    • C. 

      Field name

    • D. 

      Entry

  • 9. 
    Fields appear as columns, and each column has a ____.
    • A. 

      Datasheet

    • B. 

      Record

    • C. 

      Field name

    • D. 

      Primary key

  • 10. 
    If Dana doesn’t save the table in Design view and switches to Datasheet view, what will happen?
    • A. 

      She will lose all the data in the table.

    • B. 

      She will be prompted to save the table.

    • C. 

      Nothing. Access saves automatically in Design view.

    • D. 

      The database will be closed and all data will be lost.

  • 11. 
    If you make a mistake adding or editing data in a record, you can choose the ____________________ command to reverse your last action.
  • 12. 
    In ____ view, the table looks much like a spreadsheet.
    • A. 

      Design

    • B. 

      Datasheet

    • C. 

      Field

    • D. 

      Print

  • 13. 
    Objects are organized into categories in the Navigation Pane.
    • A. 

      True

    • B. 

      False

  • 14. 
    Once you have deleted a record, you can use the Undo command to restore it.
    • A. 

      True

    • B. 

      False

  • 15. 
    The Access screen is similar to other Office 2007 applications.
    • A. 

      True

    • B. 

      False

  • 16. 
    The Blank Database button is located in the ____.
    • A. 

      Home Tab

    • B. 

      Create Tab

    • C. 

      Navigation Pane

    • D. 

      Getting Stated With Microsoft Access Window

  • 17. 
    The default data type for a field is ____.
    • A. 

      Number

    • B. 

      Text

    • C. 

      Currency

    • D. 

      Yes/No

  • 18. 
    The intersection of a row and a column is called a(n) ____________________, just as in an Excel worksheet.
  • 19. 
    The Next record button is located in the ____.
    • A. 

      Navigation Pane

    • B. 

      Navigation Bar

    • C. 

      Ribbon

    • D. 

      Status Bar

  • 20. 
    The ____ determines what type of data the field can store, such as text or numbers.
    • A. 

      Record

    • B. 

      Field name

    • C. 

      Data type

    • D. 

      Field properties

  • 21. 
    The ____ key moves the insertion point to the first field in the current record.
    • A. 

      Home

    • B. 

      End

    • C. 

      Up Arrow

    • D. 

      Down Arrow

  • 22. 
    Unlike Word and Excel, Access does not have a standard document view.
    • A. 

      True

    • B. 

      False

  • 23. 
    When you create a new database, the first step is to name the database file.
    • A. 

      True

    • B. 

      False

  • 24. 
    When you enter data into a cell, it is called a(n) ____________________.
  • 25. 
    When you work in ____ view, the changes are saved as they are made.
    • A. 

      Design

    • B. 

      Form

    • C. 

      Datasheet

    • D. 

      Report

Related Topics