Skip Navigation
  Tops, Training in Office and Productivity Skills George Mason Logo
image for the corner of the table. Layout image only image for the corner of the table. Layout image only
   
image for the corner of the table. Layout image only   image for the corner of the table. Layout image only
image for the corner of the table. Layout image only

Access 2003 Intermediate - Part 2 Workshop Lessons and Topics
Prerequisites: Taken Access 2003 Intermediate - Part 1 and Access 2003 Fundamentals Parts 1, 2, & 3 workshops or have the following skills: be able to design and modify tables, and work with primary keys; create and modify relationships between tables using referential integrity; create a basic form using the Form Wizard; and create a basic report using the Report Wizard.

The manual used for this workshop is "Access 2003 Intermediate".


 Lesson 5 - Creating Action Queries
    Creating a Make-table Query
    Creating an Update Query
    Creating an Append Query
    Creating a Delete Query

Lesson 6 - Using Advanced Query Wizards
    Using the Crosstab Query Wizard
    Using the Find Duplicates Query Wizard
    Using the Find Unmatched Query Wizard

Workshop Information Page

Lesson 7 - Using Advanced Database Features
    Importing Data
    Linking Data to an Access Table
    Using the Linked Table Manager
    Exporting Data
    Converting Files
    Printing a Relationship Document
    Creating a Data Access Page - Page Wizard
    Compacting a Database
    Using Name AutoCorrect
    Backing Up a Database

 Lesson 8 - Manipulating Controls
    Using Controls
    Selecting Non-adjacent Controls
    Selecting Adjacent Controls
    Deleting Controls
    Sizing a Control by Dragging
    Moving Controls
    Sizing Controls Automatically
    Viewing the Properties of an Object
    Changing a Control Property

image for the corner of the table. Layout image only
   
image for the corner of the table. Layout image only image for the corner of the table. Layout image only
image for the corner of the table. Layout image only  
image for the corner of the table. Layout image only
image for the corner of the table. Layout image only image for the corner of the table. Layout image only

Voice (703) 993-3426 | Fax (703) 993-4747 | Johnson Center 311 | 4400 University Drive, MS 5C4 | Fairfax, VA 22030