Understanding Query Types
Although Access displays six query types in its drop-down menu, you can divide those into three categories: select queries, action queries, and crosstab queries. Select queries produce subsets displayed as datasheets. These datasheets might or might not be updateable, depending on several factors. The select query, in and of itself, does not change table data. It simply allows you to view and possibly edit subset data (after the query is run) from a variety of different perspectives. You can pull the results of the query into a form or report. It is the most common query type.
✓ To learn more about updating datasheets, see “Understanding Dynasets and Their Underlying Tables,” later in this chapter.
The action query, ...
Get Access 2002 Programming by Example 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.
