Microsoft Office® Access 2007 Inside Out

Chapter 8. Building Complex Queries

Selecting Data from Multiple Tables

Using a Query Wizard

Summarizing Information with Totals Queries

Using Query Parameters

Customizing Query Properties

Editing and Creating Queries in SQL View

Limitations on Using Select Queries to Update Data

Creating PivotTables and PivotCharts from Queries

Creating queries on a single table as you did in the previous chapter is a good way to get acquainted with the basic mechanics of the query designer. It’s also useful to work with simple queries to understand how datasheets work.

However, for many tasks you’ll need to build a query on multiple tables or queries (yes, you can build a query on a query!), calculate totals, add parameters, customize query properties, or work ...