Microsoft Access 2010 Terminology

14 Questions | Total Attempts: 846

SettingsSettingsSettings
Please wait...
Microsoft Access Quizzes & Trivia

A quiz on various key terms relevant to Microsoft Access 2010. Appropriate for secondary or adult students.


Questions and Answers
  • 1. 
    A field is a column in a table. A field represents a defined property that is stored for all records in a table.
    • A. 

      True

    • B. 

      False

  • 2. 
    A ____________ is an application that you use to manage a database.
  • 3. 
    A _____________ is a collection of related data that is organized so that you can easily view the data and perform operations on the data.
  • 4. 
    A __________ is a collection of data about a specific topic that is stored in rows and columns.
  • 5. 
    A_________ is a row in a table. It contains organized details about a person, a location, or some other real-world entity.
  • 6. 
    Which of the following terms is NOT a data type (determines they type of data a field can store):
    • A. 

      Text

    • B. 

      Number

    • C. 

      Currency

    • D. 

      Query

  • 7. 
    Which best describes a form?
    • A. 

      It presents the data from a query in a pre-formatted and useful manner.

    • B. 

      A graphical user interface to data.

    • C. 

      A database object that lets you automate tasks in an Access database.

    • D. 

      It provides a link between the DBMS and the physical data on the hard disk.

  • 8. 
    This view allows the you to see the underlying data for a database object in a tabular view.
    • A. 

      Datasheet View

    • B. 

      Form View

    • C. 

      Design View

    • D. 

      Table View

  • 9. 
    Microsoft Access 2010 allows you to share your database with other users via the web.  This means that they don't need to have Access installed on their computers to be able to use the database.
    • A. 

      True

    • B. 

      False

  • 10. 
    Once you save a database, you can't edit or update any of it's data.
    • A. 

      True

    • B. 

      False

  • 11. 
    If you understand the basic features for other Microsoft applications, like Word and Excel, you are already familiar with many features in Access.
    • A. 

      True

    • B. 

      False

  • 12. 
    A user can NOT import data into Access from an Excel spreadsheet.
    • A. 

      True

    • B. 

      False

  • 13. 
    A macro allows you to enter information about a specific record that can be hidden from other users.
    • A. 

      True

    • B. 

      False

  • 14. 
    You run a small advertising business.  You want to create a database to help you keep track of customer data, including contact information and order & payment history.  In at least 5 complete sentences, explain how you would design and implement your database.  Be specific:  What information would you need to include in each record?  What types of forms would you create?  What patterns would you look for in customer information?  How would entering this information into a database help your business?