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

Understanding Queries

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(page 936), a query may 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.

Access enables you to create several types of queries. The most common is a select query, which extracts information from one or more tables. You can also create crosstab queries, which group and summarize information in row-and-column formats such as an Excel PivotTable. Some of the most powerful (and potentially dangerous) things you can do with Access involve action queries, which actually change the data in an underlying table based on the criteria you define in the query.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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