You learned the basics of query design in Hour 10, "Creating Queries," but Access has a wealth of other query capabilities. In addition to the relatively simple Select queries covered in Hour 10, you can create queries that accomplish the following tasks:
Include calculated fields
Filter information
Include parameters that vary at runtime
Insert, update, and delete table data
Aggregate table data
This hour covers these topics and some of the more advanced aspects of query design.