O'Reilly logo

Access 2002 Programming by Example by Bob Villareal

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

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