Access Stage Two Quick Skill Assessment

Use the following questions below to test if you should attend the Stage Two course or go to the Stage Three 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. If you put a label into a form page header it will show:

    On Screen
    When Printed
    Both
     

  2. When faced with a Many to Many relationship you:

    Create two one to many relationships between two tables
    Create a third intermediate table
    Both
     

  3. Which DLOOKUP function in a form is correct:

    =DLOOKUP("[CustomerName]","tblCustomer","[CustomerID]=Forms![Orders].[CustomerID]")
    =DLOOKUP([CustomerName],tblCustomer,[CustomerID]=Forms![Orders].[CustomerID])
    =DLOOKUP([CustomerName],tblCustomer)
     

  4. Which IF function in a form is correct:

    =IF([AmountSpent]=0,[Discount]=0,[Discount]=10%)
    =IF([AmountSpent]=0,0,0.10)
    =IIF([AmountSpent]=0,0,0.10)
     

  5. Which Average function in a report is correct:

    =AVERAGE([Amount])
    =AVG([Amount])
    =AVERAGE("[Amount]")
     

  6. To calculate the GST at 12.5% of Cost in a query which formula is correct:

    GST:[Cost]*12.5%
    GST=[Cost]*12.5%
    GST:[Cost]*0.125
     

  7. The purpose of a parameter query is to:

    Run a query for a variety of input
    Run a query for control the parameters entered by the user
    Neither
     

  8. The Group by icon in a query will not allow which function:

    Average
    Sum
    IF
     

  9. To quickly align fields in a form or a report go to which option in the menu:

    Format
    Align
    Fields
     

  10. To indicate that a macro is to run when a field is changed use the event procedure:

    OnChange
    AfterUpdate
    OnEnter
     

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