Microsoft Office Professional 2010 Step by Step eBook

860 Chapter 28 Display Data

In this exercise, you’ll filter a table to display the data for customers located in two states.

Then you’ll experiment with the design grid to better understand its filtering capabilities.

SET UP You need the GardenCompany04 database you worked with in the preceding

exercise to complete this exercise. Open the GardenCompany04 database, and then

follow the steps.

1. In the Navigation pane, under Tables, double-click Customers to open the
   Customers table in Datasheet view.


2. On the Home tab, in the Sort & Filter group, click the Advanced Filter Options
   button, and then in the list, click Advanced Filter/Sort.
   The CustomersFilter1 page opens, displaying the Query Designer with the Customers
   field list in the top pane and the design grid in the bottom pane.

Clicking the Advanced Filter/Sort button displays the Query Designer.

3. In the Customers field list, double-click LastName to copy it to the Field row of
   the first column of the grid.


4. In the Criteria row of the LastName field, type s*, and then press Enter.

Because you have used the * wildcard, Access changes the criterion to Like “s*”.

5. In the Customers field list, double-click Region to copy it to the Field row of the
   next available column of the grid.