Access 2003 Level II
Three Hour Class

Basic Access skills are a prerequisite for taking this class. Students will learn how to modify tables, work with columns and use more advanced features in Access. They will learn how to use multiple tables in a query and filter a query, create action queries and manipulate controls. Using advanced forms and report design is also covered in this class.

Modify Tables
Work with Columns
Hide/Unhide Columns
Freeze a Column
Insert a Lookup Column
Insert a Hyperlink Column
Use Operators in Queries
Use Comparison Operator
Use an AND and OR Condition
Use Between And Operator
Design Advanced Queries
Set Top Values in a Query
Create a Calculated Field
Create a Function Query

Create a Parameter Query
Create a Concatenation in a Query
Use Multiple Tables in a Query
Filter a Query
Creation Action Queries
Creat a Make-table Query
Create an Update Query
Create an Append Query
Create a Delete Query
Use Advanced Query Wizard
Use Find Duplicate/Unmatched Query Wizard
Manipulate Controls
Use Design View
Use Advanced Form and Report Design