Course Outline
Access - Queries
Two Hour "Byte Size" Course
All Versions

Phone:717-560-3552
Fax:717-569-1135
E-Mail: Registrar@pceasy.com

Program Objectives:  Students will learn a variety of ways to create Queries in Microsoft Access.

• Compacting the Database

• Querying the Database

• Modifying a Query

• Saving a Modified Query

• Creating a Query from a Filtered Table

• Differences Between a Filter and a Query

• Creating a Query from Scratch

• Wildcard Query

• Changing the Order of Fields

• Query Comparison Operators

• "And" Query

• "Or" Query

• Wildcard Query on a Date Field

• Between Query

• Zoom View in a Query

• Finding Blank Records

• Finding Non-Blank Records

• Changing Data Affecting a Query

• Opening a Query in Design View

• Removing Fields in a Query

• Calculating with Queries

• Renaming an Expression Field

• Changing Properties of a Field

• Querying Multiple Tables

• Joining Two Fields (Concatenation)

• Adding to a Query

• Creating Join Lines in a Query

• Totals in Queries

• Parameter Queries

• Parameter Query With Multiple Criteria

• Parameter Query With Wildcards

• Making Backup Copies of Tables

• Crosstab Queries

• Changing the Order of a Crosstab Query

• Action Queries

• Make-Table Query

• Delete Query

• Update Query

• Append Query

• Find Duplicates Query Wizard

• Find Unmatched Query Wizard