MS Access Assesment

22 Questions | Total Attempts: 48

SettingsSettingsSettings
Please wait...
Microsoft Access Quizzes & Trivia

.


Questions and Answers
  • 1. 
    A____relationship exists when one of each data value in the common field of the first table matches more than one of the values in the second table.
    • A. 

      One-to-one

    • B. 

      One-to-many

    • C. 

      Many-to-many

    • D. 

      indeterminate

    • E. 

      NOT SURE

  • 2. 
    A ____enables you to store a collection or related information in a rectangular arrangement of rows and columns
    • A. 

      Table object

    • B. 

      Form object

    • C. 

      Report object

    • D. 

      Query object

    • E. 

      Page object

    • F. 

      NOT SURE

  • 3. 
    _____are not necessary but certainly make your work more consistent and assist you in clearly identifying each object.
    • A. 

      VBA program(s)

    • B. 

      Database object keepers

    • C. 

      Naming conventions

    • D. 

      Placeholders

    • E. 

      NOT SURE

  • 4. 
    A____relationship exists when one of each data value in the common field of the first table matches one of these value sin the second table.
    • A. 

      One-to-one

    • B. 

      One-to-many

    • C. 

      Many-to-many

    • D. 

      indeterminate

    • E. 

      NOT SURE

  • 5. 
    A_____determines the kind of data that can be entered in a field and what kinds of operations Access can perform on it.
    • A. 

      Field name

    • B. 

      field type

    • C. 

      Data type

    • D. 

      Data code

    • E. 

      NOT SURE

  • 6. 
    A(n) ___ is a technique that enables you to view and work with a subset of data.
    • A. 

      Procedure

    • B. 

      Filter

    • C. 

      Plan

    • D. 

      Program

    • E. 

      NOT SURE

  • 7. 
    Queries are written in a language called SQL which stands for _____.
    • A. 

      Special query language

    • B. 

      Structured query language

    • C. 

      Sorted query language

    • D. 

      Sequel query language

    • E. 

      NOT SURE

  • 8. 
    You either have to create a form from scratch or use the wizard. After you have used the wizard, you are not able to change the design of the form.
    • A. 

      TRUE

    • B. 

      FALSE

    • C. 

      NOT SURE

    • D. 

      Option 4

  • 9. 
    A report can be based on a table or a query.
    • A. 

      TRUE

    • B. 

      FALSE

    • C. 

      NOT SURE

    • D. 

      Option 4

  • 10. 
    This property will allow the control to automatically adjusts its size vertically so that all the data in the control will be printed.
    • A. 

      Grow

    • B. 

      Resize

    • C. 

      Can Grow

    • D. 

      Adjust

    • E. 

      NOT SURE

  • 11. 
    A(n) ____is an HTML document bound o data stored in a database
    • A. 

      HTML page

    • B. 

      Data access page

    • C. 

      Exploring page

    • D. 

      report page

    • E. 

      NOT SURE

  • 12. 
    If you want to change the tab order on a form, you need to choose View from the menu bar and then choose Tab Order.
    • A. 

      TRUE

    • B. 

      FALSE

    • C. 

      NOT SURE

    • D. 

      Option 4

  • 13. 
    A ____ is a text box to which a drop-down list of choices is attached and is displayed only when you click on the drop down arrow.
    • A. 

      Bound control

    • B. 

      Combo box

    • C. 

      Unbound control

    • D. 

      NOT SURE

  • 14. 
    Which character is the concatenation character?
    • A. 

      #

    • B. 

      $

    • C. 

      &

    • D. 

      *

    • E. 

      NOT SURE

  • 15. 
    A table is in ______when there are no independent one to many relationships between what should be the primary key and non-key fields
    • A. 

      First normal form

    • B. 

      Second normal form

    • C. 

      Third normal form

    • D. 

      Fourth normal form

    • E. 

      Fifth normal form

    • F. 

      NOT SURE

  • 16. 
    A _____contain only common fields between tables your want to link.
    • A. 

      Joining tables

    • B. 

      Junction tables

    • C. 

      Common tables

    • D. 

      Linking tables

    • E. 

      NOT SURE

  • 17. 
    ____only applies to tables with a single field primary key and says that each non-key field should a fact about the primary key
    • A. 

      First normal form

    • B. 

      Second normal form

    • C. 

      Third normal form

    • D. 

      Fourth normal form

    • E. 

      Fifth normal form

    • F. 

      NOT SURE

  • 18. 
    A(n) ___is the result of consequence of some action performed by the user
    • A. 

      Event

    • B. 

      Action

    • C. 

      Macro

    • D. 

      VBA program(s) VBA program(s)

    • E. 

      NOT SURE

  • 19. 
    The ____form property will display a new blank record when it is opened and is used to enter new records.
    • A. 

      Allow Edits

    • B. 

      Allow Deletions

    • C. 

      Allow Additions

    • D. 

      Data Entry

    • E. 

      NOT SURE

  • 20. 
    A crosstab query presents summary information in a compact format similar to the pivot table in an Excel spreadsheet
    • A. 

      TRUE

    • B. 

      FALSE

    • C. 

      NOT SURE NOT SURE NOT SURE NOT SURE NOT SURE

    • D. 

      Option 4

  • 21. 
    Which of the following is not an action query?
    • A. 

      Update

    • B. 

      Append

    • C. 

      Select

    • D. 

      Make table

    • E. 

      NOT SURE

  • 22. 
    A(n) ___is a series of actions that are automatically performed for you.
    • A. 

      Event

    • B. 

      Action

    • C. 

      Macro

    • D. 

      VBA program(s)

    • E. 

      NOT SURE