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 ...
Get Special Edition Using Microsoft® Office XP now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
