Microsoft Access 2007 Basics Questions! Trivia Facts Quiz

10 Questions | Total Attempts: 3000

SettingsSettingsSettings
Please wait...
Microsoft Access Quizzes & Trivia

Microsoft Access is a DBMS software that helps in maintaining and organizing a database with a graphical user interface and software-development tools. It is a part of the MS Office Suite. This quiz has been developed to test tour knowledge about the essential functions and tools used in MS Access. Let's learn more by taking this quiz. All the best!


Questions and Answers
  • 1. 
    ________________  stores and organize data in a database?
  • 2. 
    A primary key is a ______________.
  • 3. 
    ____________ ask questions.
  • 4. 
    The row in the table is ____________
  • 5. 
    Number of characters it can hold is considered as  ____________
  • 6. 
    To open Access 2007 database objects, you must use the:
    • A. 

      Navigation pane

    • B. 

      Quick Access toolbar

    • C. 

      Ribbon

    • D. 

      None of the above

  • 7. 
    When you set up a filter, you are telling Access to look for records that match a specific ______________ that you have set.
    • A. 

      Number limit

    • B. 

      Criteria

    • C. 

      Total

    • D. 

      Command

  • 8. 
    In a relationship map, you have a primary key in each table. What is the primary key?
    • A. 

      A field that is the primary field in its own table, but shows up in another table

    • B. 

      The second field in each table of a database

    • C. 

      The first field in each table of the database

    • D. 

      The last field in each table of the database

  • 9. 
    A report in Access can be generated using data from:
    • A. 

      A table

    • B. 

      A query

    • C. 

      A table or query

    • D. 

      None of the above

  • 10. 
    When designing a database in Access, what is the first thing you need to determine in order to begin?
    • A. 

      The number of tables needed

    • B. 

      The number of fields needed

    • C. 

      The name of the tables

    • D. 

      The purpose of the database