Microsoft® Office Access 2003 Queries

Why you should attend: Queries are the "workhorses" of Microsoft Access. This course exhausts the query topics - giving the Access developer amazing tools to use when developing user-friendly, functional databases.

Suggested Prerequisites:  This course should ONLY be taken after Access Level 1 and Access Level 2 have been completed, or with the express permission of the course instructor.

Attend and You Will Learn

Lesson 1: Select Queries

• Sorting
• Showing
• Criteria
• Boolean Logic

Lesson 2: More Advanced Select Queries

• Displaying Unique Values
• Displaying Top Values
• Formulas
• Basic Calculations
• Summarizing Data (Subtotals)
• IIF Statement
• Parameters

Lesson 3: Action Queries

• Make Table
• Deleting
• Appending
• Updating

Lesson 4: Additional Useful Queries

• Join Queries
• Finding Data Disparities
• The Usefulness of Self-Joins
• Crosstab Queries
• Finding and Eliminating Duplicate Information

Lesson 5: The Next Step and Outputting Query Results