| |
Filter Database Information
 Step 1
Selecting a set of records from a database table or query is called "Filtering".
You can "filter" based on conditions or "criteria".
Use the Filtering buttons located on the database toolbar.
Filter Database Information
Step 2
The three Filter buttons are:
Filter By Selection
Filter By Form
Apply Filter.
Filter Database Information
Step 3
We will select all customers whose last name begins with "Johns".
One method to apply filtering is to select from existing data within a field in the database table or query.
Our criteria will be all customers whose last name begins with "Johns".
Filter Database Information
Step 4
Click on the field to filter.
LastName in our example.
Filter Database Information
Step 5
Select (highlight) the portion of data that includes the filter criteria, "Johns", in our example.
We will select the first 5 characters of Johnson.
Filter Database Information
Step 6
Click the Filter By Selection Button.
Filter Database Information
Step 7
Results will be similar to those shown below.
You will see the word "Filtered" next to the record buttons.
|