F. Scott Barker's Microsoft® Access 2000 Power Programming

UNDERSTANDING WHERE QUERIES ARE USED IN ACCESS

Access queries come in three basic groups:

• Select queries, which retrieve information from one or more tables or from other Select queries, including totals and crosstab queries

• Action queries, which affect data in tables

• Pass-through queries, which communicate with a SQL back-end database

This chapter covers Select and Action queries. Table 8.1 defines where you can use these queries in Access.

Table 8.1. Where Queries Are Used in Access 2000

Select Queries	Action Queries
Form record source	Macro OpenQuery action
Form filters	DoCmd OpenQuery in VBA
Report record source	Directly from the Database container
Source for queries
Data Access Pages
Subform source objects
Input to other queries

You can ...