Do You Have Basic Idea Of Microsoft Access? Trivia Quiz

10 Questions | Total Attempts: 427

SettingsSettingsSettings
Please wait...
Microsoft Access Quizzes & Trivia

Microsoft Access is an information management tool that helps us to maintain, manage and organize data for reporting and analysis more efficiently than Microsoft Excel or any other applications. So, if you are an expert or novice, then do attempt this quiz to check whether you are a beginner or proficient one. Let's try out this quiz. All the best!


Questions and Answers
  • 1. 
    If you have a database containing information about students, then all the information about one student would be referred to as a
    • A. 

      Table

    • B. 

      Field

    • C. 

      Record

    • D. 

      File

  • 2. 
    If you have a database containing information about students, then the student's last name would be an example of a
    • A. 

      Table

    • B. 

      Field

    • C. 

      Record

    • D. 

      File

  • 3. 
    Within an Access table, each record is represented by one
    • A. 

      Row

    • B. 

      Column

    • C. 

      Datasheet

    • D. 

      File

  • 4. 
    Within an Access table, each field is represented by one
    • A. 

      Row

    • B. 

      Column

    • C. 

      Datasheet

    • D. 

      File

  • 5. 
    Each database must contain at least one
    • A. 

      Table

    • B. 

      Form

    • C. 

      Report

    • D. 

      Module

  • 6. 
    Use this view to display a table in columns and rows.
    • A. 

      Form view

    • B. 

      Record view

    • C. 

      Table view

    • D. 

      Datasheet view

  • 7. 
    The first step in designing a new databse is
    • A. 

      Entering data

    • B. 

      Building queries

    • C. 

      Planning the tables

    • D. 

      Printing reports

  • 8. 
    An expression builder is an access tool that controls an expression___ for entering an expression
    • A. 

      Table

    • B. 

      Box 

    • C. 

      Cell

    • D. 

      Palette

  • 9. 
    In which method we don't need to specify the field type and size while creating a new Table?
    • A. 

      Design View 

    • B. 

      While using Wizard 

    • C. 

      Create Table by Entering Data

    • D. 

      All of the Above

  • 10. 
    • A. 

      120

    • B. 

      255

    • C. 

      265

    • D. 

      75