Finding, Filtering, Sorting  «Prev 

Access Filter Implementation

You have learned the three main methods of filtering data in a datasheet in this module. You may wonder what more you can do with filters.
Once you have learned to filter a datasheet you can use that skill on any datasheet, even those created by a query. And perhaps an even more useful feature is that you can create a form or a report from a filtered datasheet, forms and reports can be formatted, so this is a great way to create output to show to other people. When you create a form or report from a filtered datasheet, the form or report inherits the filter. So when new data is added to the table, the form or report will reflect all the data in the table filtered with the filter you defined.

How Datasheet view filters are useful

Since the view you get after you apply a filter contains only records with the values that you selected, the rest of the data remains hidden until you clear the filter. 1) Columns in datasheets and 2) controls in forms and reports that are bound to expressions do not support filtering. There are several types of filters and some of them are easy to apply and remove. Access contains some common filters that are built into every view. The availability of filter commands depends on the type and values of the field.
To view the records of people whose birthdays fall during a specific month, click the BirthDate column, on the Home tab in the Sort & Filter group, click Date Filters, and then select the required date period.

Apply, Filter, Sort
Apply, Filter, Sort

Another approach for finding a specific record is to use the options that Access provides for sorting and filtering records. You can sort the records in text fields in ascending or descending order, and in number fields from smallest to largest. To sort and filter records, use the related commands in the
Sort & Filter group. 

You can also right-click a column name in Datasheet view and then click Ascending or Descending, or click the arrow to the right of a column heading to display a menu with sorting and filtering options. When you filter records, only the records that match the filter's criteria are displayed. This lets you whittle down a long list of records to find just a few records among many.