MS Access - Tables And ForMS

14 Questions | Total Attempts: 1351

SettingsSettingsSettings
MS Access - Tables And ForMS - Quiz

This is a quick quiz to test your basic knowledge of MS Access forms, tables and data types.


Questions and Answers
  • 1. 
    A database is
    • A. 

      A piece of computer software

    • B. 

      Microsoft Access

    • C. 

      Data kept in a logical structure of records and fields

    • D. 

      A place to keep information

  • 2. 
    A piece of data is kept in
    • A. 

      A paddock

    • B. 

      The hard drive

    • C. 

      A field

    • D. 

      A cell

  • 3. 
    A record is
    • A. 

      An old-school way of listening to music but it's coming back

    • B. 

      Information about a person

    • C. 

      A row of data that relates to a single object

    • D. 

      Found online

  • 4. 
    Every record must have a primary key number / identifier
    • A. 

      True

    • B. 

      False

  • 5. 
    Design view
    • A. 

      Lets us enter data into our table

    • B. 

      Helps to create the table's structure

    • C. 

      Is only for forms

    • D. 

      Is for searching our data

  • 6. 
    To enter data into a table we need to be
    • A. 

      Connected to the internet

    • B. 

      Using every field

    • C. 

      Creating a primary key

    • D. 

      In datasheet view

  • 7. 
    What is a data type in databases?
    • A. 

      Types of data including: date, currency, autonumber & text

    • B. 

      A yes or no option

    • C. 

      The unique identifier for a record

    • D. 

      A special font

  • 8. 
    This is an example of
    • A. 

      A table

    • B. 

      A form

    • C. 

      A database

    • D. 

      Book Information

  • 9. 
    To make sure people enter only clean data we
    • A. 

      Lock the database

    • B. 

      Create validation rules

    • C. 

      Make forms

    • D. 

      Make sure that we only use text as our data type

  • 10. 
    Which one of these is not an example of a form design view?
    • A. 

      Layout View

    • B. 

      Design View

    • C. 

      Form View

  • 11. 
    This is an example of
    • A. 

      A table

    • B. 

      A form

    • C. 

      A database

    • D. 

      Book Information

  • 12. 
    Which of these is not a sufficient reason for creating forms?
    • A. 

      Forms help with accurate data input

    • B. 

      Forms display record by record

    • C. 

      Forms can have pictures on them

    • D. 

      Forms provide a user-friendly way to manage Databases.

  • 13. 
    In order to shift my fields and boxes around I need to be in
    • A. 

      Form view

    • B. 

      Layout view

    • C. 

      Design view

  • 14. 
    Which option is the best option for creating a form from the data you already have?
    • A. 

      Form

    • B. 

      Form Design

    • C. 

      Blank Form

    • D. 

      Form Wizard

Related Topics
Back to Top Back to top