O'Reilly logo

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

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required