Microsoft® Access® 2010 Inside Out

Chapter 10. 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 for the Web

Creating queries on a single table, as you did in Chapter 9, 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, ...