Access 2010: Queries

The focus of this workshop is on extracting specific records using queries, and creating and utilizing pivot tables and pivot charts for data analysis. Participants will learn how to:

  • Create and run a select query to display data from one or more related tables
  • Sort data in a query
  • Add criteria to a query to display specific records
  • Create pivot tables and charts using query data
Category(s):Office Productivity
Cost:none
Handout:

Access 2010: Queries Handout PDF


How-to:

Workshop Practice File



Prerequisites

We highly recommend that you attend any prerequisite workshops listed below since familiarity with the skills and concepts taught in them is essential to benefit fully from subsequent workshops.

However, if you have independently learned the skills and concepts of the required workshop(s), your "equivalent skills" will be accepted as a substitute for attending the prerequisite workshop(s).

To help you determine your skill level, click workshop titles below (if any) for descriptions which outline the topics taught in each workshop and that are assumed in later sessions. You are expected to know the commands and concepts listed within the descriptions for the prerequisite workshop. In most cases, you can also refer to workshop handouts and other helpful materials from the workshop description page.

In addition to any specific prerequisites listed, you should have, as a minimum, basic computing skills.

Pre-requisite workshops