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

Chapter 1. Creating a Basic Query > Working with Queries

Working with Queries

Sorts and filters are fine for quick-and-dirty table operations, but they're not very powerful. To really get at the data, you need to use queries, which are similar to the sorting and filtering features, but they're much more powerful. Similar to using filters, you select field names and set up criteria that define the records you want to see. However, unlike filters, queries are not simply a different view of the table data. A query is a separate database object that actually extracts records from a table and places them in a dynaset. As you'll see later, a dynaset is much like a datasheet, and many of the operations you can perform on a datasheet can also be performed on a dynaset. (Query results are called dynasets because they're dynamic subsets of a table. Here, “dynamic” means that if you make any changes to the original table, Access updates the query automatically, or vice versa.)

The other major difference between a query and a filter is that you can save queries and then rerun them anytime you like. Filters, on the other hand, are ephemeral: When you close the table, any filters you've defined vanish into thin air.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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