WEBVTT
Kind: captions
Language: en

00:00:09.660 --> 00:00:13.680 align:start position:0%
 
I'm<00:00:11.460><c> working</c><00:00:12.460><c> on</c><00:00:12.549><c> a</c><00:00:12.610><c> query</c><00:00:12.969><c> that</c><00:00:13.150><c> shows</c><00:00:13.210><c> us</c><00:00:13.570><c> a</c>

00:00:13.680 --> 00:00:13.690 align:start position:0%
I'm working on a query that shows us a
 

00:00:13.690 --> 00:00:15.600 align:start position:0%
I'm working on a query that shows us a
list<00:00:13.930><c> of</c><00:00:14.170><c> our</c><00:00:14.350><c> bakery's</c><00:00:14.740><c> customers</c><00:00:15.309><c> who</c><00:00:15.459><c> live</c>

00:00:15.600 --> 00:00:15.610 align:start position:0%
list of our bakery's customers who live
 

00:00:15.610 --> 00:00:17.999 align:start position:0%
list of our bakery's customers who live
outside<00:00:15.910><c> the</c><00:00:16.240><c> city</c><00:00:16.420><c> limits</c><00:00:16.689><c> and</c><00:00:17.170><c> there</c><00:00:17.890><c> are</c><00:00:17.950><c> a</c>

00:00:17.999 --> 00:00:18.009 align:start position:0%
outside the city limits and there are a
 

00:00:18.009 --> 00:00:19.440 align:start position:0%
outside the city limits and there are a
couple<00:00:18.160><c> of</c><00:00:18.310><c> things</c><00:00:18.460><c> that</c><00:00:18.670><c> I'm</c><00:00:18.759><c> going</c><00:00:18.970><c> to</c><00:00:19.090><c> do</c><00:00:19.240><c> to</c>

00:00:19.440 --> 00:00:19.450 align:start position:0%
couple of things that I'm going to do to
 

00:00:19.450 --> 00:00:21.780 align:start position:0%
couple of things that I'm going to do to
make<00:00:19.570><c> the</c><00:00:19.720><c> results</c><00:00:20.110><c> easier</c><00:00:20.259><c> to</c><00:00:20.680><c> read</c><00:00:20.890><c> sorting</c>

00:00:21.780 --> 00:00:21.790 align:start position:0%
make the results easier to read sorting
 

00:00:21.790 --> 00:00:23.940 align:start position:0%
make the results easier to read sorting
the<00:00:21.880><c> results</c><00:00:22.330><c> and</c><00:00:22.470><c> hiding</c><00:00:23.470><c> the</c><00:00:23.560><c> fields</c><00:00:23.919><c> that</c>

00:00:23.940 --> 00:00:23.950 align:start position:0%
the results and hiding the fields that
 

00:00:23.950 --> 00:00:26.670 align:start position:0%
the results and hiding the fields that
we<00:00:24.099><c> don't</c><00:00:24.369><c> need</c><00:00:24.550><c> to</c><00:00:24.610><c> see</c><00:00:25.050><c> right</c><00:00:26.050><c> now</c><00:00:26.230><c> I'm</c><00:00:26.529><c> in</c>

00:00:26.670 --> 00:00:26.680 align:start position:0%
we don't need to see right now I'm in
 

00:00:26.680 --> 00:00:28.679 align:start position:0%
we don't need to see right now I'm in
datasheet<00:00:27.009><c> view</c><00:00:27.220><c> so</c><00:00:27.790><c> I'll</c><00:00:28.029><c> need</c><00:00:28.270><c> to</c><00:00:28.329><c> switch</c><00:00:28.660><c> to</c>

00:00:28.679 --> 00:00:28.689 align:start position:0%
datasheet view so I'll need to switch to
 

00:00:28.689 --> 00:00:31.260 align:start position:0%
datasheet view so I'll need to switch to
design<00:00:29.470><c> view</c><00:00:29.829><c> and</c><00:00:29.980><c> there</c><00:00:30.550><c> are</c><00:00:30.759><c> two</c><00:00:30.970><c> ways</c><00:00:31.119><c> of</c>

00:00:31.260 --> 00:00:31.270 align:start position:0%
design view and there are two ways of
 

00:00:31.270 --> 00:00:33.750 align:start position:0%
design view and there are two ways of
doing<00:00:31.419><c> that</c><00:00:31.720><c> you</c><00:00:32.380><c> can</c><00:00:32.619><c> either</c><00:00:32.860><c> go</c><00:00:33.130><c> to</c><00:00:33.190><c> the</c><00:00:33.489><c> view</c>

00:00:33.750 --> 00:00:33.760 align:start position:0%
doing that you can either go to the view
 

00:00:33.760 --> 00:00:36.389 align:start position:0%
doing that you can either go to the view
drop-down<00:00:34.059><c> arrow</c><00:00:34.540><c> and</c><00:00:34.720><c> select</c><00:00:35.040><c> design</c><00:00:36.040><c> view</c>

00:00:36.389 --> 00:00:36.399 align:start position:0%
drop-down arrow and select design view
 

00:00:36.399 --> 00:00:39.240 align:start position:0%
drop-down arrow and select design view
or<00:00:37.030><c> in</c><00:00:37.750><c> the</c><00:00:37.780><c> bottom-right</c><00:00:38.020><c> corner</c><00:00:38.469><c> you</c><00:00:39.070><c> can</c>

00:00:39.240 --> 00:00:39.250 align:start position:0%
or in the bottom-right corner you can
 

00:00:39.250 --> 00:00:42.930 align:start position:0%
or in the bottom-right corner you can
click<00:00:39.489><c> the</c><00:00:39.640><c> icon</c><00:00:40.059><c> on</c><00:00:40.300><c> the</c><00:00:40.360><c> far</c><00:00:40.750><c> right</c><00:00:41.110><c> in</c><00:00:41.940><c> the</c>

00:00:42.930 --> 00:00:42.940 align:start position:0%
click the icon on the far right in the
 

00:00:42.940 --> 00:00:45.329 align:start position:0%
click the icon on the far right in the
data<00:00:43.179><c> grid</c><00:00:43.539><c> there</c><00:00:43.960><c> is</c><00:00:44.199><c> a</c><00:00:44.230><c> sort</c><00:00:44.710><c> row</c><00:00:44.980><c> which</c><00:00:45.309><c> is</c>

00:00:45.329 --> 00:00:45.339 align:start position:0%
data grid there is a sort row which is
 

00:00:45.339 --> 00:00:48.060 align:start position:0%
data grid there is a sort row which is
currently<00:00:45.789><c> empty</c><00:00:46.170><c> to</c><00:00:47.170><c> add</c><00:00:47.289><c> a</c><00:00:47.320><c> sort</c><00:00:47.739><c> you</c><00:00:47.920><c> can</c>

00:00:48.060 --> 00:00:48.070 align:start position:0%
currently empty to add a sort you can
 

00:00:48.070 --> 00:00:49.770 align:start position:0%
currently empty to add a sort you can
just<00:00:48.280><c> click</c><00:00:48.579><c> on</c><00:00:48.609><c> the</c><00:00:48.910><c> cell</c><00:00:49.149><c> for</c><00:00:49.480><c> the</c><00:00:49.539><c> field</c>

00:00:49.770 --> 00:00:49.780 align:start position:0%
just click on the cell for the field
 

00:00:49.780 --> 00:00:52.020 align:start position:0%
just click on the cell for the field
that<00:00:49.929><c> you</c><00:00:50.019><c> want</c><00:00:50.140><c> to</c><00:00:50.289><c> sort</c><00:00:50.469><c> and</c><00:00:50.679><c> then</c><00:00:51.519><c> click</c><00:00:51.879><c> the</c>

00:00:52.020 --> 00:00:52.030 align:start position:0%
that you want to sort and then click the
 

00:00:52.030 --> 00:00:54.149 align:start position:0%
that you want to sort and then click the
drop<00:00:52.269><c> down</c><00:00:52.300><c> arrow</c><00:00:52.510><c> to</c><00:00:52.870><c> choose</c><00:00:53.230><c> a</c><00:00:53.289><c> sort</c><00:00:53.440><c> option</c>

00:00:54.149 --> 00:00:54.159 align:start position:0%
drop down arrow to choose a sort option
 

00:00:54.159 --> 00:00:56.639 align:start position:0%
drop down arrow to choose a sort option
and<00:00:54.399><c> now</c><00:00:55.390><c> our</c><00:00:55.629><c> results</c><00:00:56.019><c> will</c><00:00:56.170><c> be</c><00:00:56.260><c> sorted</c>

00:00:56.639 --> 00:00:56.649 align:start position:0%
and now our results will be sorted
 

00:00:56.649 --> 00:00:59.579 align:start position:0%
and now our results will be sorted
alphabetically<00:00:57.309><c> by</c><00:00:57.640><c> city</c><00:00:57.999><c> you</c><00:00:58.960><c> can</c><00:00:59.109><c> also</c><00:00:59.230><c> do</c><00:00:59.559><c> a</c>

00:00:59.579 --> 00:00:59.589 align:start position:0%
alphabetically by city you can also do a
 

00:00:59.589 --> 00:01:02.130 align:start position:0%
alphabetically by city you can also do a
multi-level<00:01:00.550><c> sort</c><00:01:00.850><c> by</c><00:01:01.239><c> just</c><00:01:01.480><c> adding</c><00:01:01.780><c> a</c><00:01:01.839><c> sort</c>

00:01:02.130 --> 00:01:02.140 align:start position:0%
multi-level sort by just adding a sort
 

00:01:02.140 --> 00:01:05.670 align:start position:0%
multi-level sort by just adding a sort
to<00:01:02.319><c> another</c><00:01:02.589><c> field</c><00:01:02.890><c> a</c><00:01:04.170><c> multi-level</c><00:01:05.170><c> sort</c><00:01:05.409><c> will</c>

00:01:05.670 --> 00:01:05.680 align:start position:0%
to another field a multi-level sort will
 

00:01:05.680 --> 00:01:08.190 align:start position:0%
to another field a multi-level sort will
always<00:01:06.100><c> work</c><00:01:06.340><c> from</c><00:01:06.550><c> left</c><00:01:06.940><c> to</c><00:01:07.090><c> right</c><00:01:07.450><c> so</c><00:01:08.050><c> this</c>

00:01:08.190 --> 00:01:08.200 align:start position:0%
always work from left to right so this
 

00:01:08.200 --> 00:01:11.040 align:start position:0%
always work from left to right so this
is<00:01:08.350><c> going</c><00:01:08.500><c> to</c><00:01:08.680><c> sort</c><00:01:08.920><c> first</c><00:01:09.250><c> by</c><00:01:09.430><c> city</c><00:01:09.940><c> and</c><00:01:10.210><c> then</c>

00:01:11.040 --> 00:01:11.050 align:start position:0%
is going to sort first by city and then
 

00:01:11.050 --> 00:01:12.630 align:start position:0%
is going to sort first by city and then
within<00:01:11.229><c> each</c><00:01:11.530><c> city</c><00:01:11.770><c> it</c><00:01:12.040><c> will</c><00:01:12.130><c> sort</c><00:01:12.460><c> by</c><00:01:12.610><c> zip</c>

00:01:12.630 --> 00:01:12.640 align:start position:0%
within each city it will sort by zip
 

00:01:12.640 --> 00:01:15.570 align:start position:0%
within each city it will sort by zip
code<00:01:13.090><c> if</c><00:01:13.300><c> we</c><00:01:14.260><c> wanted</c><00:01:14.590><c> it</c><00:01:14.710><c> to</c><00:01:14.770><c> sort</c><00:01:15.040><c> by</c><00:01:15.280><c> zip</c><00:01:15.310><c> code</c>

00:01:15.570 --> 00:01:15.580 align:start position:0%
code if we wanted it to sort by zip code
 

00:01:15.580 --> 00:01:17.520 align:start position:0%
code if we wanted it to sort by zip code
first<00:01:16.150><c> then</c><00:01:16.690><c> we</c><00:01:16.840><c> would</c><00:01:16.960><c> have</c><00:01:17.080><c> to</c><00:01:17.200><c> change</c><00:01:17.380><c> the</c>

00:01:17.520 --> 00:01:17.530 align:start position:0%
first then we would have to change the
 

00:01:17.530 --> 00:01:19.770 align:start position:0%
first then we would have to change the
ordering<00:01:18.040><c> of</c><00:01:18.250><c> the</c><00:01:18.370><c> columns</c><00:01:18.760><c> and</c><00:01:18.940><c> you</c><00:01:19.000><c> can</c><00:01:19.690><c> do</c>

00:01:19.770 --> 00:01:19.780 align:start position:0%
ordering of the columns and you can do
 

00:01:19.780 --> 00:01:21.660 align:start position:0%
ordering of the columns and you can do
that<00:01:19.960><c> by</c><00:01:20.110><c> clicking</c><00:01:20.170><c> at</c><00:01:20.740><c> the</c><00:01:20.770><c> top</c><00:01:21.100><c> of</c><00:01:21.250><c> a</c><00:01:21.340><c> column</c>

00:01:21.660 --> 00:01:21.670 align:start position:0%
that by clicking at the top of a column
 

00:01:21.670 --> 00:01:23.840 align:start position:0%
that by clicking at the top of a column
and<00:01:21.780><c> dragging</c><00:01:22.780><c> it</c><00:01:22.870><c> to</c><00:01:22.900><c> the</c><00:01:23.020><c> left</c><00:01:23.320><c> or</c><00:01:23.440><c> the</c><00:01:23.500><c> right</c>

00:01:23.840 --> 00:01:23.850 align:start position:0%
and dragging it to the left or the right
 

00:01:23.850 --> 00:01:26.970 align:start position:0%
and dragging it to the left or the right
so<00:01:24.850><c> this</c><00:01:25.060><c> would</c><00:01:25.240><c> sort</c><00:01:25.540><c> first</c><00:01:25.810><c> by</c><00:01:26.020><c> zip</c><00:01:26.470><c> code</c><00:01:26.500><c> and</c>

00:01:26.970 --> 00:01:26.980 align:start position:0%
so this would sort first by zip code and
 

00:01:26.980 --> 00:01:29.700 align:start position:0%
so this would sort first by zip code and
then<00:01:27.550><c> by</c><00:01:27.760><c> city</c><00:01:28.060><c> but</c><00:01:28.810><c> that's</c><00:01:28.990><c> not</c><00:01:29.170><c> what</c><00:01:29.380><c> I</c><00:01:29.410><c> want</c>

00:01:29.700 --> 00:01:29.710 align:start position:0%
then by city but that's not what I want
 

00:01:29.710 --> 00:01:31.290 align:start position:0%
then by city but that's not what I want
so<00:01:29.920><c> I'm</c><00:01:30.280><c> just</c><00:01:30.490><c> going</c><00:01:30.670><c> to</c><00:01:30.700><c> leave</c><00:01:30.880><c> it</c><00:01:30.910><c> where</c><00:01:31.150><c> it</c>

00:01:31.290 --> 00:01:31.300 align:start position:0%
so I'm just going to leave it where it
 

00:01:31.300 --> 00:01:33.240 align:start position:0%
so I'm just going to leave it where it
was

00:01:33.240 --> 00:01:33.250 align:start position:0%
was
 

00:01:33.250 --> 00:01:35.700 align:start position:0%
was
below<00:01:34.060><c> the</c><00:01:34.240><c> sort</c><00:01:34.510><c> road</c><00:01:34.750><c> there</c><00:01:35.080><c> is</c><00:01:35.110><c> a</c><00:01:35.290><c> check</c><00:01:35.680><c> box</c>

00:01:35.700 --> 00:01:35.710 align:start position:0%
below the sort road there is a check box
 

00:01:35.710 --> 00:01:38.490 align:start position:0%
below the sort road there is a check box
for<00:01:36.130><c> each</c><00:01:36.400><c> field</c><00:01:36.850><c> and</c><00:01:37.030><c> you</c><00:01:37.690><c> can</c><00:01:37.720><c> uncheck</c><00:01:38.350><c> a</c><00:01:38.380><c> box</c>

00:01:38.490 --> 00:01:38.500 align:start position:0%
for each field and you can uncheck a box
 

00:01:38.500 --> 00:01:41.160 align:start position:0%
for each field and you can uncheck a box
to<00:01:38.950><c> hide</c><00:01:39.130><c> the</c><00:01:39.370><c> field</c><00:01:39.580><c> in</c><00:01:39.820><c> the</c><00:01:39.910><c> results</c><00:01:40.390><c> we're</c>

00:01:41.160 --> 00:01:41.170 align:start position:0%
to hide the field in the results we're
 

00:01:41.170 --> 00:01:42.720 align:start position:0%
to hide the field in the results we're
using<00:01:41.380><c> the</c><00:01:41.590><c> phone</c><00:01:41.770><c> number</c><00:01:41.800><c> field</c><00:01:42.220><c> to</c><00:01:42.520><c> filter</c>

00:01:42.720 --> 00:01:42.730 align:start position:0%
using the phone number field to filter
 

00:01:42.730 --> 00:01:44.880 align:start position:0%
using the phone number field to filter
our<00:01:43.060><c> results</c><00:01:43.110><c> but</c><00:01:44.110><c> we</c><00:01:44.260><c> don't</c><00:01:44.440><c> actually</c><00:01:44.590><c> need</c>

00:01:44.880 --> 00:01:44.890 align:start position:0%
our results but we don't actually need
 

00:01:44.890 --> 00:01:46.860 align:start position:0%
our results but we don't actually need
to<00:01:44.950><c> see</c><00:01:45.220><c> the</c><00:01:45.370><c> phone</c><00:01:45.520><c> numbers</c><00:01:45.850><c> so</c><00:01:46.390><c> I'll</c><00:01:46.600><c> uncheck</c>

00:01:46.860 --> 00:01:46.870 align:start position:0%
to see the phone numbers so I'll uncheck
 

00:01:46.870 --> 00:01:49.950 align:start position:0%
to see the phone numbers so I'll uncheck
this<00:01:47.440><c> and</c><00:01:47.680><c> I'm</c><00:01:48.610><c> also</c><00:01:48.820><c> going</c><00:01:49.120><c> to</c><00:01:49.240><c> hide</c><00:01:49.480><c> the</c><00:01:49.720><c> ID</c>

00:01:49.950 --> 00:01:49.960 align:start position:0%
this and I'm also going to hide the ID
 

00:01:49.960 --> 00:01:52.320 align:start position:0%
this and I'm also going to hide the ID
field<00:01:50.380><c> and</c><00:01:50.740><c> this</c><00:01:51.190><c> is</c><00:01:51.340><c> really</c><00:01:51.520><c> just</c><00:01:51.850><c> a</c><00:01:51.940><c> way</c><00:01:51.970><c> of</c>

00:01:52.320 --> 00:01:52.330 align:start position:0%
field and this is really just a way of
 

00:01:52.330 --> 00:01:54.630 align:start position:0%
field and this is really just a way of
making<00:01:52.600><c> the</c><00:01:52.840><c> results</c><00:01:53.230><c> easier</c><00:01:53.380><c> to</c><00:01:53.860><c> read</c><00:01:54.160><c> by</c>

00:01:54.630 --> 00:01:54.640 align:start position:0%
making the results easier to read by
 

00:01:54.640 --> 00:01:56.220 align:start position:0%
making the results easier to read by
reducing<00:01:55.180><c> the</c><00:01:55.300><c> amount</c><00:01:55.540><c> of</c><00:01:55.600><c> information</c><00:01:55.930><c> that</c>

00:01:56.220 --> 00:01:56.230 align:start position:0%
reducing the amount of information that
 

00:01:56.230 --> 00:01:59.460 align:start position:0%
reducing the amount of information that
you<00:01:56.380><c> have</c><00:01:56.470><c> to</c><00:01:56.740><c> look</c><00:01:56.920><c> at</c><00:01:57.660><c> now</c><00:01:58.660><c> we</c><00:01:58.720><c> can</c><00:01:59.170><c> run</c><00:01:59.410><c> the</c>

00:01:59.460 --> 00:01:59.470 align:start position:0%
you have to look at now we can run the
 

00:01:59.470 --> 00:02:02.070 align:start position:0%
you have to look at now we can run the
query<00:01:59.740><c> again</c><00:02:00.130><c> and</c><00:02:00.450><c> you</c><00:02:01.450><c> can</c><00:02:01.600><c> see</c><00:02:01.780><c> that</c><00:02:01.960><c> our</c>

00:02:02.070 --> 00:02:02.080 align:start position:0%
query again and you can see that our
 

00:02:02.080 --> 00:02:04.650 align:start position:0%
query again and you can see that our
results<00:02:02.110><c> are</c><00:02:02.620><c> sorted</c><00:02:03.010><c> by</c><00:02:03.070><c> city</c><00:02:03.610><c> and</c><00:02:03.880><c> within</c>

00:02:04.650 --> 00:02:04.660 align:start position:0%
results are sorted by city and within
 

00:02:04.660 --> 00:02:06.750 align:start position:0%
results are sorted by city and within
each<00:02:04.900><c> city</c><00:02:05.200><c> they're</c><00:02:05.440><c> sorted</c><00:02:05.800><c> by</c><00:02:05.920><c> zip</c><00:02:06.280><c> code</c><00:02:06.310><c> and</c>

00:02:06.750 --> 00:02:06.760 align:start position:0%
each city they're sorted by zip code and
 

00:02:06.760 --> 00:02:09.449 align:start position:0%
each city they're sorted by zip code and
the<00:02:07.750><c> phone</c><00:02:07.930><c> number</c><00:02:08.260><c> and</c><00:02:08.500><c> ID</c><00:02:08.770><c> fields</c><00:02:09.340><c> are</c>

00:02:09.449 --> 00:02:09.459 align:start position:0%
the phone number and ID fields are
 

00:02:09.459 --> 00:02:12.150 align:start position:0%
the phone number and ID fields are
hidden<00:02:09.790><c> so</c><00:02:10.300><c> we</c><00:02:10.540><c> can</c><00:02:10.720><c> just</c><00:02:11.050><c> focus</c><00:02:11.320><c> on</c><00:02:11.709><c> the</c><00:02:11.860><c> names</c>

00:02:12.150 --> 00:02:12.160 align:start position:0%
hidden so we can just focus on the names
 

00:02:12.160 --> 00:02:17.660 align:start position:0%
hidden so we can just focus on the names
and<00:02:12.430><c> addresses</c><00:02:15.450><c> like</c><00:02:16.450><c> what</c><00:02:16.630><c> you</c><00:02:16.780><c> just</c><00:02:16.810><c> saw</c>

00:02:17.660 --> 00:02:17.670 align:start position:0%
and addresses like what you just saw
 

00:02:17.670 --> 00:02:21.030 align:start position:0%
and addresses like what you just saw
rate<00:02:18.670><c> it</c><00:02:18.850><c> at</c><00:02:19.390><c> a</c><00:02:19.450><c> comment</c><00:02:19.959><c> subscribe</c><00:02:20.500><c> to</c><00:02:20.800><c> our</c>

00:02:21.030 --> 00:02:21.040 align:start position:0%
rate it at a comment subscribe to our
 

00:02:21.040 --> 00:02:22.220 align:start position:0%
rate it at a comment subscribe to our
chilled

00:02:22.220 --> 00:02:22.230 align:start position:0%
chilled
 

00:02:22.230 --> 00:02:24.130 align:start position:0%
chilled
the<00:02:22.530><c> freedom</c><00:02:22.950><c> to</c><00:02:23.099><c> learn</c>

00:02:24.130 --> 00:02:24.140 align:start position:0%
the freedom to learn
 

00:02:24.140 --> 00:02:29.620 align:start position:0%
the freedom to learn
what<00:02:24.890><c> you</c><00:02:25.100><c> want</c><00:02:25.569><c> when</c><00:02:26.569><c> you</c><00:02:26.600><c> want</c><00:02:28.630><c> absolutely</c>

00:02:29.620 --> 00:02:29.630 align:start position:0%
what you want when you want absolutely
 

00:02:29.630 --> 00:02:33.150 align:start position:0%
what you want when you want absolutely
free

00:02:33.150 --> 00:02:33.160 align:start position:0%
 
 

00:02:33.160 --> 00:02:36.790 align:start position:0%
 
GCF<00:02:34.160><c> learn</c><00:02:34.760><c> free.org</c>