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

Chapter 1. Creating a Basic Query > Filtering Table Data

Filtering Table Data

If you've ever been to a large, noisy gathering, you might have been struck by how easily humans can ignore a cacophony of music and voices around them and concentrate on whatever conversation they're having at the time. Our brains somehow filter out the unimportant noise and let in only what we need to hear.

This idea of screening out the unnecessary is exactly what Access filters do. We often want to work with only some of the records in a large table. The other records are just “noise” that we want to somehow tune out. For example, if you have a table of customer invoices, you might want to work with any of the following subsets of the data:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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