Access 2007 and 2010 Stage One Quick Skill Assessment

Use the following skill assessment if you want to quickly and simply assess if you should attend the Stage One course or go onto the Stage Two course.

Do not underestimate the Access Stage One this does not mean this is a simple course, it means it is the first course of all the courses in Access.  Many clients having been using Access for many years but are self taught or badly taught and have gaps in their knowledge, and can't believe how much they learnt in the Stage One i.e. the Step One course to learning Access properly.  Be honest with yourself when doing this skill assessment

  1. The maximum field size for a memo field is:

    255
    65535
     No limit
          

  2. The following input mask (000)000-0009 would not allow which data to be entered into the field:

    027345677
    02734567
     0273456778
     

  3. The Index property is set to quickly:

    Duplicate Data
    Search Data
    Sort Data
     

  4. To find all records greater than and equal to 2 and less than and equal to 10 in a query the criteria would be:

    >&=2 and <&=10
    >=2 and <=10
     >and=2 and <and=10
     

  5. The application of Enforced Referential Integrity is to:

    Ensure data in the related table exists in the primary table
    Ensure data deleted from the primary table does not have matching data in the related table
    Both
     

  6. To find all records that end with R in a query the criteria would be:

    *R*
    *R
     R*
     

  7. Which data type allow links to multiple files:

    Hyperlink
    Attachment
     OLE
     

  8. A form can be based on:

    A Table
    A Query
    Both
     

  9. The purpose of the primary key field is to always:

    Ensure unique data is entered in the field
    Enable a quick search and to always sort data by that field
    Both
     

  10. The allow two decimal places to be entered do the following:

    Change the field size to a single or a double
    Format the field to two decimal places
     Change the field size to a long integer
     

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