WEBVTT
Kind: captions
Language: en

00:00:08.230 --> 00:00:12.490
I'm working on a query that shows us a list
of our bakery's customers who live outside

00:00:12.490 --> 00:00:13.980
the city limits.

00:00:13.980 --> 00:00:17.960
And there are a couple of things I'm going
to do to make the results easier to read:

00:00:17.960 --> 00:00:22.140
sorting the results, and hiding fields that
we don't need to see.

00:00:22.140 --> 00:00:26.820
Right now, I'm in Datasheet view, so I'll
need to switch to Design view.

00:00:26.820 --> 00:00:28.769
There are two ways of doing that.

00:00:28.769 --> 00:00:36.250
You can either go to the View drop-down arrow
and select Design view, or in the bottom-right

00:00:36.250 --> 00:00:41.350
corner, you can click the icon on the far
right.

00:00:41.350 --> 00:00:45.690
In the data grid, there is a sort row, which
is currently empty.

00:00:45.690 --> 00:00:50.850
To add a sort you can just click on the cell
for the field you want to sort, and then click

00:00:50.850 --> 00:00:53.820
the drop-down arrow to choose a sort option.

00:00:53.820 --> 00:00:59.000
Now, our results will be sorted alphabetically
by city.

00:00:59.000 --> 00:01:03.789
You can also do a multilevel sort by just
adding a sort to another field.

00:01:03.789 --> 00:01:08.930
A multilevel sort will always work from left
to right, so this is going to sort first by

00:01:08.930 --> 00:01:15.539
city, and then within each city it will sort
by zip code.

00:01:15.539 --> 00:01:19.510
If we wanted it to sort by zip code first,
then we would have to change the ordering

00:01:19.510 --> 00:01:21.020
of the columns.

00:01:21.020 --> 00:01:28.150
You can do that by clicking at the top of
a column and dragging it to the left or right.

00:01:28.150 --> 00:01:32.340
So this would sort first by zip code and then
by city.

00:01:32.340 --> 00:01:38.090
But that's not what I want, so I'm just going
to leave it where it was.

00:01:38.090 --> 00:01:43.429
Below the Sort row, there is a check box for
each field, and you can uncheck a box to hide

00:01:43.429 --> 00:01:45.429
the field in the results.

00:01:45.429 --> 00:01:49.349
We're using the Phone Number field to filter
our results, but we don't actually need to

00:01:49.349 --> 00:01:53.129
see the phone numbers, so I'll uncheck this.

00:01:53.129 --> 00:01:56.459
And I'm also going to hide the ID field.

00:01:56.459 --> 00:02:01.489
This is really just a way of making the results
easier to read by reducing the amount of information

00:02:01.489 --> 00:02:03.280
that you have to look at.

00:02:03.280 --> 00:02:11.091
Now, we can Run the query again, and you can
see that our results are sorted by city, and

00:02:11.091 --> 00:02:16.670
within each city it's sorted by zip code,
and the Phone Number and ID fields are hidden

00:02:16.670 --> 00:02:19.860
so we can just focus on the names and addresses.