O'Reilly logo

Special Edition Using Microsoft® Office XP by Woody Leonhard, Ed Bott

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Using Queries to Extract Data from a Database

Queries are database objects that enable you to extract data from a database to use in another way—as the source of data used in a printed report, for example, or to produce a list of items for use in a lookup control on a data-entry form. A query can be based on a single table or on multiple related tables. In addition to fields drawn directly from tables, a query can also contain calculated fields that transform data—adding sales tax to an invoice amount, for example, or performing statistical analysis (totals, averages, and the like) on groups of records drawn from multiple tables.

Like other Office wizards, the Access query wizards are efficient at guiding you smoothly through the steps of a complex ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required