Chapter 8. Creating More Complex Queries

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 ...

Get Teach Yourself VISUALLY™: Microsoft® Office Access™ 2007 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.