MS Access 2007 : Tools And Functions Test! Trivia Quiz

10 Questions | Total Attempts: 375

SettingsSettingsSettings
Please wait...
MS Access 2007 : Tools And Functions Test! Trivia Quiz

Are you looking for an MS Access 2007: Tools and Functions Test to help you know just how much you understood about using this Application? You are in luck as the quiz below is perfectly designed to help you do just that. Microsoft Access is a very good tool you can use when it comes to creating database templates. Give it a shot!


Questions and Answers
  • 1. 
    What relationship most suitable for the table that includes 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 a data type in MS Access 2007?
    • A. 

      Text

    • B. 

      Lookup Wizard

    • C. 

      Attachment

    • D. 

      XML Object

  • 3. 
    What is the purpose of the 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. 
    Using the aggregate function _______ is useful when a simple count or tally of information is required
    • A. 

      Count

    • B. 

      Sum

    • C. 

      Min

    • D. 

      Max

  • 9. 
    What will Queries do?
    • A. 

      Add, delete, update data

    • B. 

      Create relationship

    • C. 

      Edit Form interface

    • D. 

      Close Program

  • 10. 
    What is True about data validation?
    • A. 

      Data Validation will create relationship

    • B. 

      1 to Many is example of Data Validation

    • C. 

      Suitable for number and date data type

    • D. 

      There is no Data Validation in Access