CCNC/CCNC Module 5/Retrieving data with queries/Basic Query Operations/Query Filters

Applying Filters
Filtering allows you to work with selected records. In other words the rest of the database remains hidden while only the records you want to work with are visible. To apply a filter open the table to be filtered. 

There are four icons for filtering on the Standard Toolbar. These are; 
 * 1) AutoFilter - which filters the whole table for the value that is highlighted.
 * 2) Apply Filter - which applies the filter currently active.
 * 3) Standard Filter - which sets the filters parameters.
 * 4) Remove Filter - which removes the currently applied filter.

Approaches to Filtering
The AutoFilter filters the whole databse table for the value that is highlighted. This can be very useful when looking for individual or sets of records for a given value.  The Apply Filter uses the last applied filter and runs it again. This is useful when looking for specific values and need to refer back to all the data in the table. This used in combination with Remove Filter allows you to "toggle" between the filtered data and all the data.  The Remove Filter will return the table to include all the data as it was before the filter was applied. Keep in mind filters do not delete (remove) the data they just keep in hidden. (Note: The Remove Filter button is also used to remove a sort.) 

The Standard Filter
The Standard Filter presents a dialog which allows the entry of parameters to create a multi-field and multi-value filter. It could be considered an advanced filtering capability.  In the Standard Filter dialog fields to be filtered can be chosen, criteria can be selected and values can be set on more than one and up to three fields. 

Test your knowledge
