MS Access 2007 - Intermediate (Post Test)

10 Questions | Total Attempts: 269

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

.


Questions and Answers
  • 1. 
    Table in Microsoft Access can be create by using all below except
    • A. 

      Design View

    • B. 

      Datasheet View

    • C. 

      Table Wizard

    • D. 

      Input Mask

  • 2. 
    Which data type can store more than 255 character?
    • A. 

      Memo

    • B. 

      Text

    • C. 

      Long Integer

    • D. 

      Lookup Wizard

  • 3. 
    You can use Input Mask and set the data as _______________ to make sure all data are valid to enter and not duplicate.
    • A. 

      Primary Key

    • B. 

      Query

    • C. 

      Macro

    • D. 

      Lookup Wizard

  • 4. 
    There are 3 type of Relationship that valid in Ms Access 2007, Except
    • A. 

      One to one

    • B. 

      One to Many

    • C. 

      Many to Many

    • D. 

      Interdeminate

  • 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

  • 6. 
    What type of queries is a queries that select records from tables based on criteria.
    • A. 

      Action Queries

    • B. 

      Select Queries

    • C. 

      CrossTab Queries

    • D. 

      Cascade Queries

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

      CrossTab

    • B. 

      Action

    • C. 

      Select

    • D. 

      Cascade

  • 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

  • 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

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

      Disable

    • B. 

      Enable

    • C. 

      Ignoring

    • D. 

      Cancelling