• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 35. Entering, Finding, and Filte... > Using Queries to Extract Data from a...

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 process, providing detailed explanations of the choices you need to make, and enabling you to view graphic representations of the results.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint