WEBVTT
Kind: captions
Language: en

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

00:00:15.730 --> 00:00:17.220
the city limits.

00:00:17.220 --> 00:00:20.070
And there are a couple of things that I'm
going to do to make the results easier to

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

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

00:00:30.050 --> 00:00:31.999
There are two ways of doing that.

00:00:31.999 --> 00:00:38.960
You can either go to the View drop-down arrow…
and select Design view.

00:00:38.960 --> 00:00:46.080
Or in the bottom-right corner, you can click
the icon on the far right.

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

00:00:50.430 --> 00:00:55.250
To add a sort you can just click on the cell
for the field you want to sort… and then

00:00:55.250 --> 00:00:59.600
click the drop-down arrow to choose a sort
option.

00:00:59.600 --> 00:01:03.730
Now our results will be sorted alphabetically
by city.

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

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

00:01:13.670 --> 00:01:20.280
city… and then within each city, it will
sort by zip code.

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

00:01:24.250 --> 00:01:25.760
of the columns.

00:01:25.760 --> 00:01:30.360
You can do that by clicking at the top of
a column… and dragging it to the left or

00:01:30.360 --> 00:01:32.890
right.

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

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

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

00:01:49.270 --> 00:01:51.260
the field in the results.

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

00:01:55.190 --> 00:02:02.299
see the phone numbers, so I'll uncheck this…
and I'm also going to hide the ID field.

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

00:02:07.330 --> 00:02:11.730
that you have to look at.

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

00:02:18.459 --> 00:02:21.350
and within each city they're sorted by zip
code.

00:02:21.350 --> 00:02:27.230
And the Phone Number and ID fields are hidden
so we can just focus on the names and addresses.