Skip to Main Content
Access 2002 Programming by Example
book

Access 2002 Programming by Example

by Bob Villareal
January 2002
Beginner content levelBeginner
576 pages
13h 23m
English
Que
Content preview from Access 2002 Programming by Example

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

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Access 2003 Programming by Example with VBA, XML, and ASP

Access 2003 Programming by Example with VBA, XML, and ASP

Julitta Korol
Microsoft® Access® 2010 Programmer's Reference

Microsoft® Access® 2010 Programmer's Reference

Teresa Hennig, Rob Cooper, Geoffrey L. Griffith, Jerry Dennison

Publisher Resources

ISBN: 0789725940Purchase book