In Access filter data so you see only what you want to see. This will help you filter out the information in your Access database that you don't need.
Another useful way to look at—or analyze—the data in a database is by filtering it. Filtering groups your data together based on one or more criteria for a given field, then displays only the records that contain those specified values and criteria. Filtering data is easy with Access 2007. In this lesson, we'll show you how to filter records using common filter commands. You'll also learn how to use the toggle button to switch between filtered and unfiltered results, as well as how to perform advanced filters and save the filtered results.