Unlock the power of Microsoft Access 2007 queries! Basic select queries are covered in addition to powerful action queries, including Append queries, Update queries, Delete queries, and Make Table queries.  Setting up criteria, sorting and calculated fields will be covered too.

Prerequisites: Access Introduction

Key Topics Covered

1) Create queries using the simple query wizard and design view.
2) Sort data and use criteria to display subsets of data.
3) Use the criteria row to create AND and OR conditions.
4) Create and format calculated fields.
5) Create queries based on multiple tables.
6) Set up parameter queries to prompt for criteria.
7) Run action queries to update, append, delete or make tables.