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

Hour 20. Retrieving Your Data > Using Data Filters

Using Data Filters

A filter is a subset of data from a table. Suppose that you want to see only certain records from a table, such as all customers who are past due. Instead of hiding the records that you don't want to see, create a filter. The filter removes unwanted records from view. The records don't go away, and you don't have to unhide the records later (as you do when you actually hide records by right-clicking over a column or row in the Datasheet view and selecting Hide Columns or Hide Row). A filter works similar to a short-term record hider, putting certain records out of the way while you work with the filtered data.

Access supports three filtering approaches:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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