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

Chapter 7. Finding, Filtering, and Sorting > Choosing Filters or Queries

Choosing Filters or Queries

On the surface, filters and queries (see Chapters 4 and 10 for information on queries) seem similar, but they are actually quite different. A filter temporarily modifies the contents of a table; you can turn a filter on and off by clicking a button or selecting a menu item. By contrast, a query is a separate object in your database and can't be "turned off," only modified and run to update its contents.

You should use Find to locate instances of a certain value within a table. Scrolling through large tables can be time-consuming, but going from record to record does let you see the type of record your value appears in. You might run a query to narrow the number of records, and then use Find to examine the results.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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