Microsoft Access Database Management System! Trivia Quiz

14 Questions | Total Attempts: 46

SettingsSettingsSettings
Please wait...
Microsoft Access Database Management System! Trivia Quiz

.


Questions and Answers
  • 1. 
    Which of the following is a complete list of the Access objects?
    • A. 

      Queries, reports, forms

    • B. 

      Tables, forms, queries, reports

    • C. 

      Records, queries, reports, forms

    • D. 

      Tables, forms, queries

  • 2. 
    When you sort records in A-Z order, you are applying a(n) __________ sort
    • A. 

      Filtered

    • B. 

      Descending

    • C. 

      Ascending

    • D. 

      Non-existent

  • 3. 
    When you build a query, you must write __________ to tell the query which records to retrieve.
    • A. 

      Tables

    • B. 

      Functions

    • C. 

      Criteria

  • 4. 
    It's possible to build reports with information from?
    • A. 

      Both tables and queries

    • B. 

      Tables

    • C. 

      Queries

    • D. 

      Reports

  • 5. 
    A __________ query allows you to perform calculations with your data.
    • A. 

      Calculator

    • B. 

      Sum

    • C. 

      Totals

    • D. 

      Mathematical

  • 6. 
    Which of the following data-types can you use for characters and numbers?
    • A. 

      Date

    • B. 

      VarChar2

    • C. 

      Char

    • D. 

      Number

  • 7. 
    A __________ is a drop-down list you can add to your form.
    • A. 

      Drop-down-box

    • B. 

      Text-box

    • C. 

      Combo-box

    • D. 

      List-box

  • 8. 
    __________ let your users perform common form actions with just one click.
    • A. 

      Command Buttons

    • B. 

      Action Buttons

    • C. 

      Footers

    • D. 

      Drop-down menus

  • 9. 
    A database that understands how information is connected is called __________.
    • A. 

      A relational database

    • B. 

      An Access database

    • C. 

      A linked database

    • D. 

      A connected database

  • 10. 
    In Access, rows are referred to as __________, and columns are referred to as __________.
    • A. 

      Objects, types

    • B. 

      Lines, columns

    • C. 

      Fields, records

    • D. 

      Records, fields

  • 11. 
    __________ allow you to enter data without typing records directly into tables.
    • A. 

      Queries

    • B. 

      Forms

    • C. 

      Reports

    • D. 

      Menus

  • 12. 
    Open objects are listed in the __________.
    • A. 

      Navigation Bar

    • B. 

      Document Tabs Bar

    • C. 

      Fields Pane

    • D. 

      Column Pane

  • 13. 
    Microsoft Access is accessible to the following systems: Microsoft Excel, SQL, Visual Basic.
    • A. 

      False

    • B. 

      True

    • C. 

      None of the Above

    • D. 

      Maybe

  • 14. 
    Setting the __________ for a field sets a rule about how many letters, numbers, punctuation marks, or spaces can be entered in a field.
    • A. 

      Validation rule

    • B. 

      Row height

    • C. 

      Character limit

    • D. 

      Data rule

Back to Top Back to top