Access 2007 and 2010 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


  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. An IF block in a macro is used to:

    Calculate different results
    Present varying formula results for different conditions
    Run different macros for different conditions
     

  7. To compact a database you not go to:

    The File Tab
    The Developer Tab
    The Database Tools Tab
     

  8. The AUTOKEYS SUBMACRO is to:

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

  9. The default join type is:

    Inner
    Outer
    Combined
     

  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.