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 Fundamentals - Part 2 Workshop Lessons and Topics
Prerequisites: Taken Access 2003 Fundamentals - Part 1 or have the following skills: be able to design and modify tables; and work with primary keys.

Manual used for this workshop is "Access 2003 Fundamentals".

 
 Lesson 5 - Finding and Filtering Data
    Sorting Records
    Finding Specific Records
    Finding Records using Wildcards
    Using Replace
    Using Filter By Selection 
    Applying/Removing a Filter
    Using Filter Excluding Selection
    Using the Filter For
    Using Filter By Form

 Lesson 6 - Printing Data
    Printing Table Data
    Changing the Page Setup
    Using Print Preview
    Printing Selected Records

Workshop Information Page

 Lesson 7 - Creating Relationships
    Using Related Tables
    Creating a Relationship between Tables
    Setting Referential Integrity
    Viewing Subdatasheets
    Deleting a Join Line

 Lesson 8 - Using Simple Queries
    Using Queries and RecordSets
    Using the Simple Query Wizard
    Creating a Query in Design View
    Opening a Query
    Adding a Table to a Query
    Joining Tables in a Query
    Running a Query
 
 
 

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