MS Access 2007 Advance Post Test

12 Questions | Total Attempts: 329

SettingsSettingsSettings
Please wait...
MS Access 2007 Advance Post Test

.


Questions and Answers
  • 1. 
    What relationship most suitable for the table that include secret and privacy data?
    • A. 

      One to one

    • B. 

      One to many

    • C. 

      Many to many

    • D. 

      Many to one

  • 2. 
    Which one is not valid as data type in Ms Access 2007?
    • A. 

      Attachment

    • B. 

      XML Object

    • C. 

      Text

    • D. 

      Lookup Wizard

  • 3. 
    What is the purpose of Edit List button on Input Mask dialog box?
    • A. 

      To create lookup wizard

    • B. 

      To create OLE Object

    • C. 

      To create new/edit input mask

    • D. 

      To create warning

  • 4. 
    To control from entering data twice/duplicate, we can use _____________
    • A. 

      Primary Key

    • B. 

      Lookup Wizard

    • C. 

      Input Mask

    • D. 

      Relationship

  • 5. 
    Which one is false about import/export data from or to Ms Access 2007?
    • A. 

      Import Table from Excel into Access

    • B. 

      Export Table from Access into excel

    • C. 

      Import Form from Excel into Access

    • D. 

      Import Data from Access into Access

  • 6. 
    What means of this icon?
    • A. 

      To run from Access

    • B. 

      To Run/Test Query

    • C. 

      To Run Form

    • D. 

      To Run Input Mask

  • 7. 
    There are two types of wildcards in Access which are
    • A. 

      ! and &

    • B. 

      ! and *

    • C. 

      * and ?

    • D. 

      & and ?

  • 8. 
    You can Personalize forms and reports by adding a company logo or another graphic. To insert a graphic into a form or report, you can be in what view?
    • A. 

      Design View and Layout View

    • B. 

      Design View only

    • C. 

      Layout View only

    • D. 

      Form View only

  • 9. 
    Using the aggregate function _______ is useful when a simple count or tally of information is required
    • A. 

      Count

    • B. 

      Sum

    • C. 

      Min

    • D. 

      Max

  • 10. 
    What will Queries do?
    • A. 

      Add, delete, update data

    • B. 

      Create relationship

    • C. 

      Edit Form interface

    • D. 

      Close Program

  • 11. 
    Table in Microsoft Access can be create by using all below except
    • A. 

      Design View

    • B. 

      Datasheet View

    • C. 

      Table Wizard/Template

    • D. 

      Input Mask

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

      Memo

    • B. 

      Text

    • C. 

      Long Integer

    • D. 

      Byte

Back to Top Back to top