• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 4. Unleashing the Power of Queries > Understanding Query Types

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.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint