Chapter 8. Creating More Complex Queries
Queries can do much more than just sort and filter data from a table. They can summarize and calculate data, append the data from one table to another, identify duplicate data, prompt the user for parameters at runtime, and much more.
In this chapter, you will learn how to take advantage of the powerful tools for special-purpose queries in Access 2007.
Understanding Summary Queries
Create a Summary Query with the Simple Query Wizard
Create a Summary Query in Query Design View
Understanding Calculated Fields
Create a Calculated Field
Understanding Action Queries
Run a Make Table Query
Run a Delete Query
Run an Append ...