Database Reference
In-Depth Information
8
Click the
City
field name, hold down the
Shift
key, and click the
Region
field name.
Then in the
Sort & Filter
group, click the
Ascending
button. Notice that because
the
City
field is to the left of the
Region
field, this sort does not achieve the result
you want.
4
The City sort is overriding the Region sort.
9
Remove the sort, and then click away from the
City
and
Region
fields to clear the
selection.
10
Click the
Region
field name, and drag the field name to the left of the
City
field
name, releasing the mouse button when a heavy black line appears between the
Address
and
City
field names.
11
With the
Region
field selected, hold down the
Shift
key, and click the
City
field name
to include that field in the selection.
12
In the
Sort & Filter
group, click the
Ascending
button to arrange the records with the
regions in ascending order and the cities in ascending order within each region.
13
Experiment with various ways of sorting the records to display different results. Then
close the
Customers
table, clicking
No
when prompted to save the table layout.
CLEAN UP
Keep the GardenCompany04 database open for use in later exercises.