MS Access 2007 - Intermediate (Pre Test)

10 Questions | Total Attempts: 369

SettingsSettingsSettings
Please wait...
MS Access 2007 - Intermediate (Pre Test)

.


Questions and Answers
  • 1. 
    Table in Microsoft Access can be create by using Design View, Datasheet View and Table Wizard
    • A. 

      True

    • B. 

      False

    • C. 

      I Dont Know

  • 2. 
    Text data type can only store 255 characters in one field
    • A. 

      True

    • B. 

      False

    • C. 

      I Dont Know

  • 3. 
    Input Mask can be use to create a format of text that can avoid user from key in wrong data.
    • A. 

      True

    • B. 

      False

    • C. 

      I Donk Know

  • 4. 
    Relationship in Microsoft Access can be generate either one to many, one to one or many to many method.
    • A. 

      True

    • B. 

      False

    • C. 

      I Dont Know

  • 5. 
    2 ways to identify inconsistencies between data in two or more tables are either modify the join line or use a special Query Wizard
    • A. 

      True

    • B. 

      False

    • C. 

      I Dont Know

  • 6. 
    Action queries is a queries that select records from tables based on criteria.
    • A. 

      True

    • B. 

      False

    • C. 

      I Dont Know

  • 7. 
    Crosstab Queries are used to summarise data in tables
    • A. 

      True

    • B. 

      False

    • C. 

      I Dont Know

  • 8. 
    Special form called Switchboard, can set up such that anybody can use your database even if they know nothing about Access
    • A. 

      True

    • B. 

      False

    • C. 

      I Dont Know

  • 9. 
    A macro holds a series of instructions (commands) such that all the instructions can be carried out simply by running the one macro.
    • A. 

      True

    • B. 

      False

    • C. 

      I Dont Know

  • 10. 
    You can disable macros setting so that the macros run automatically for any database you open.
    • A. 

      True

    • B. 

      False

    • C. 

      I Dont Know