Database Reference
In-Depth Information
Only the 30 records for customers who live in postal codes starting with 880 are displayed
in the table.
8
In the
Sort & Filter
group, click the
Remove Filter
button to turn off the filter and
display all the records.
Now let's display only the records of the customers who live outside of the United
States.
9
In the
Country
field, right-click any instance of
USA
, and then click
Does Not Equal
“USA”
to display the records of all the customers from countries other than the
United States (in this case, only Canada).
TIP
If the text you want to base this filter on is buried in a large table, you can quickly
locate it by clicking the Find button in the Find group on the Home tab, entering the
term you want in the Find What box in the Find And Replace dialog box, and clicking
Find Next. Then right-click the found text to apply the filter.
10
Turn off the filter, and close the
Customers
table, clicking
No
when prompted to save
your changes.
Finally, let's filter a different table to create a list of orders placed with a selected
employee on or after a specified date.
11
Open the
Orders
table in
Datasheet
view.
12
In the
EmployeeID
field, right-click
Entin, Michael
, and then click
Equals “Entin,
Michael”
.