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


  1. If you put a text field 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
    Import data
     

  8. To automate and schedule the importation of data create a:

    Parameter Query
    Linked table
    Import Specification
     

  9. Which type of form gives you two views of the same data:

    Split Form
    PivotTable Form
    Multiple Items Form
     

  10. To indicate that a macro is to run when a field is altered 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.