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

P.O. Box 225                 
5375 Main Street
East Petersburg, PA 17520-0225

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

  Please Click Here to Register for Class

Course Prerequisite
Must have a general knowledge of Access at a Basic Level
(2 CPE Credits)

Copyright PC Easy October 2008