Database Reference
In-Depth Information
Choosing the Advanced Filter/Sort command displays the Query Designer, which you use
to enter filtering criteria. As you'll discover, filters with multiple criteria are actually simple
queries.
SEE ALSO
For information about queries, see Chapter 7, “Create queries.”
In this exercise, you'll filter a table to display the data for customers located in two states.
Then you'll experiment with the Query Designer to better understand its filtering capabilities.
SET UP
You need the GardenCompany04 database you worked with in the preceding
exercise to complete this exercise. If necessary, open the database. Then follow the steps.
1
In the
Navigation
pane, in the
Tables
group, 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
but-
ton, and then in the list, click
Advanced Filter/Sort
to display the
Query Designer
with the
Customers
field list in the top pane and a 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 in the design grid.
4
In the
Criteria
row of the
LastName
field, enter
s*
, and then press
Enter
. Notice that
because you have used the * wildcard, the criterion changes to
Like “s*”
.