Access Stage Three Quick Skill Assessment

Use the following questions below to test if you should attend the Stage Three course or go to the Stage Four course.  Be honest with yourself when doing this skill assessment :-D

Note: When referring to menu commands the > is used to indicate menus and submenus


  1. What is the purpose of the AUTOEXEC macro:

    To automatically execute a certain macro when the user clicks a button
    To perform specified actions when the database is opened
    To automatically execute the quitting of the database
     

  2. A crosstab query is used to:

    Cross reference tables
    Provide a pivot or summary snapshot of data in a matrix format
    Cross off old data in a table for archiving purposes
     

  3. An action query can:

    Update data in a table, make a table, delete data in a table, append data to a table
    Update data in a table, delete data in a table, append data to a table
    Update data in a table, append data to a table
     

  4. A SubReport is:

    A report pasted into another report
    A report embedded and linked into the design of another report
    A report that you can jump to from another report via a command button
     

  5. To show matching data between a main form and a sub form they must have matching fields in which two properties:

    Main form and sub form properties
    Master and Child properties
    Form and sub form properties
     

  6. Macro conditions allow macros to be run based on:

    Choices in a list box
    Choices in a combo box
    Both
     

  7. To compact a database you would go to:

    File in the menu
    Tools in the menu
    Database in the menu
     

  8. The AUTOKEYS MACRO is to:

    Control what actions a key pressed will do
    Automatically key in data for the user when a key is pressed
    Both
     

  9. Customising the toolbar in an Access database requires the Visual Basic for Applications command:

    ShowToolbar
    DoToolbar
    DisplayToolbar
     

  10. To make a table including information from other tables and calculations you would:

    Create a Select query
    Create an Action query
    Create a Crosstab query
     

P.S. If you want to know how we designed this form (and our web site) come to our Microsoft FrontPage Course.