WEBVTT
Kind: captions
Language: en

00:00:01.180 --> 00:00:03.729 align:start position:0%
 
Goodwill<00:00:02.180><c> Community</c><00:00:02.629><c> Foundation</c><00:00:03.290><c> creating</c>

00:00:03.729 --> 00:00:03.739 align:start position:0%
Goodwill Community Foundation creating
 

00:00:03.739 --> 00:00:07.900 align:start position:0%
Goodwill Community Foundation creating
opportunities<00:00:04.340><c> for</c><00:00:04.550><c> a</c><00:00:04.610><c> better</c><00:00:04.640><c> life</c><00:00:06.910><c> I'm</c>

00:00:07.900 --> 00:00:07.910 align:start position:0%
opportunities for a better life I'm
 

00:00:07.910 --> 00:00:10.180 align:start position:0%
opportunities for a better life I'm
working<00:00:08.719><c> on</c><00:00:08.809><c> a</c><00:00:08.870><c> query</c><00:00:09.200><c> that</c><00:00:09.320><c> shows</c><00:00:09.650><c> us</c><00:00:09.830><c> a</c><00:00:09.950><c> list</c>

00:00:10.180 --> 00:00:10.190 align:start position:0%
working on a query that shows us a list
 

00:00:10.190 --> 00:00:11.860 align:start position:0%
working on a query that shows us a list
of<00:00:10.429><c> our</c><00:00:10.580><c> bakery's</c><00:00:10.999><c> customers</c><00:00:11.570><c> who</c><00:00:11.719><c> live</c>

00:00:11.860 --> 00:00:11.870 align:start position:0%
of our bakery's customers who live
 

00:00:11.870 --> 00:00:14.230 align:start position:0%
of our bakery's customers who live
outside<00:00:12.169><c> the</c><00:00:12.650><c> city</c><00:00:12.860><c> limits</c><00:00:12.950><c> and</c><00:00:13.459><c> there</c><00:00:14.119><c> are</c><00:00:14.179><c> a</c>

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

00:00:14.240 --> 00:00:15.669 align:start position:0%
outside the city limits and there are a
couple<00:00:14.389><c> of</c><00:00:14.539><c> things</c><00:00:14.719><c> that</c><00:00:14.929><c> I'm</c><00:00:15.019><c> going</c><00:00:15.259><c> to</c><00:00:15.320><c> do</c><00:00:15.499><c> to</c>

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

00:00:15.679 --> 00:00:18.040 align:start position:0%
couple of things that I'm going to do to
make<00:00:15.829><c> the</c><00:00:15.980><c> results</c><00:00:16.369><c> easier</c><00:00:16.519><c> to</c><00:00:16.910><c> read</c><00:00:17.150><c> sorting</c>

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

00:00:18.050 --> 00:00:20.169 align:start position:0%
make the results easier to read sorting
the<00:00:18.140><c> results</c><00:00:18.170><c> and</c><00:00:18.740><c> hiding</c><00:00:19.670><c> the</c><00:00:19.789><c> fields</c><00:00:20.119><c> that</c>

00:00:20.169 --> 00:00:20.179 align:start position:0%
the results and hiding the fields that
 

00:00:20.179 --> 00:00:22.960 align:start position:0%
the results and hiding the fields that
we<00:00:20.300><c> don't</c><00:00:20.570><c> need</c><00:00:20.750><c> to</c><00:00:20.900><c> see</c><00:00:21.310><c> right</c><00:00:22.310><c> now</c><00:00:22.369><c> I'm</c><00:00:22.820><c> in</c>

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

00:00:22.970 --> 00:00:24.970 align:start position:0%
we don't need to see right now I'm in
datasheet<00:00:23.300><c> view</c><00:00:23.509><c> so</c><00:00:24.109><c> I'll</c><00:00:24.320><c> need</c><00:00:24.560><c> to</c><00:00:24.619><c> switch</c><00:00:24.949><c> to</c>

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

00:00:24.980 --> 00:00:27.550 align:start position:0%
datasheet view so I'll need to switch to
design<00:00:25.519><c> view</c><00:00:26.089><c> and</c><00:00:26.330><c> there</c><00:00:26.839><c> are</c><00:00:27.050><c> two</c><00:00:27.259><c> ways</c><00:00:27.410><c> of</c>

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

00:00:27.560 --> 00:00:30.249 align:start position:0%
design view and there are two ways of
doing<00:00:27.619><c> that</c><00:00:27.949><c> you</c><00:00:28.880><c> can</c><00:00:29.119><c> either</c><00:00:29.330><c> go</c><00:00:29.630><c> to</c><00:00:29.660><c> the</c><00:00:29.869><c> view</c>

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

00:00:30.259 --> 00:00:33.630 align:start position:0%
doing that you can either go to the view
drop-down<00:00:30.560><c> arrow</c><00:00:31.039><c> and</c><00:00:31.220><c> select</c><00:00:31.960><c> design</c><00:00:32.960><c> view</c>

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

00:00:33.640 --> 00:00:37.000 align:start position:0%
drop-down arrow and select design view
or<00:00:34.640><c> in</c><00:00:35.510><c> the</c><00:00:35.539><c> bottom-right</c><00:00:35.780><c> corner</c><00:00:36.230><c> you</c><00:00:36.829><c> can</c>

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

00:00:37.010 --> 00:00:41.500 align:start position:0%
or in the bottom-right corner you can
click<00:00:37.250><c> the</c><00:00:37.399><c> icon</c><00:00:37.579><c> on</c><00:00:38.090><c> the</c><00:00:38.300><c> far</c><00:00:38.480><c> right</c><00:00:38.840><c> in</c><00:00:40.510><c> the</c>

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

00:00:41.510 --> 00:00:44.020 align:start position:0%
click the icon on the far right in the
data<00:00:41.750><c> grid</c><00:00:42.110><c> there</c><00:00:42.559><c> is</c><00:00:42.770><c> a</c><00:00:42.800><c> sort</c><00:00:43.280><c> row</c><00:00:43.550><c> which</c><00:00:43.879><c> is</c>

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

00:00:44.030 --> 00:00:46.630 align:start position:0%
data grid there is a sort row which is
currently<00:00:44.390><c> empty</c><00:00:44.739><c> to</c><00:00:45.739><c> add</c><00:00:45.890><c> a</c><00:00:45.920><c> sort</c><00:00:46.309><c> you</c><00:00:46.489><c> can</c>

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

00:00:46.640 --> 00:00:48.340 align:start position:0%
currently empty to add a sort you can
just<00:00:46.879><c> click</c><00:00:47.149><c> on</c><00:00:47.329><c> the</c><00:00:47.480><c> cell</c><00:00:47.719><c> for</c><00:00:48.050><c> the</c><00:00:48.109><c> field</c>

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

00:00:48.350 --> 00:00:51.010 align:start position:0%
just click on the cell for the field
that<00:00:48.530><c> you</c><00:00:48.590><c> want</c><00:00:48.620><c> to</c><00:00:48.859><c> sort</c><00:00:49.039><c> and</c><00:00:49.510><c> then</c><00:00:50.510><c> click</c><00:00:50.870><c> the</c>

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

00:00:51.020 --> 00:00:53.580 align:start position:0%
that you want to sort and then click the
drop<00:00:51.260><c> down</c><00:00:51.289><c> arrow</c><00:00:51.500><c> to</c><00:00:51.829><c> choose</c><00:00:52.219><c> a</c><00:00:52.280><c> sort</c><00:00:52.430><c> option</c>

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

00:00:53.590 --> 00:00:56.259 align:start position:0%
drop down arrow to choose a sort option
and<00:00:54.590><c> now</c><00:00:55.010><c> our</c><00:00:55.250><c> results</c><00:00:55.640><c> will</c><00:00:55.760><c> be</c><00:00:55.879><c> sorted</c>

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

00:00:56.269 --> 00:00:59.590 align:start position:0%
and now our results will be sorted
alphabetically<00:00:56.930><c> by</c><00:00:57.260><c> city</c><00:00:58.000><c> you</c><00:00:59.000><c> can</c><00:00:59.149><c> also</c><00:00:59.269><c> do</c><00:00:59.570><c> a</c>

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

00:00:59.600 --> 00:01:02.139 align:start position:0%
alphabetically by city you can also do a
multi-level<00:01:00.590><c> sort</c><00:01:00.890><c> by</c><00:01:01.250><c> just</c><00:01:01.519><c> adding</c><00:01:01.789><c> a</c><00:01:01.879><c> sort</c>

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

00:01:02.149 --> 00:01:05.049 align:start position:0%
multi-level sort by just adding a sort
to<00:01:02.329><c> another</c><00:01:02.600><c> field</c><00:01:02.899><c> a</c><00:01:03.549><c> multi-level</c><00:01:04.549><c> sort</c><00:01:04.759><c> will</c>

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

00:01:05.059 --> 00:01:07.539 align:start position:0%
to another field a multi-level sort will
always<00:01:05.449><c> work</c><00:01:05.720><c> from</c><00:01:05.990><c> left</c><00:01:06.229><c> to</c><00:01:06.439><c> right</c><00:01:06.830><c> so</c><00:01:07.430><c> this</c>

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

00:01:07.549 --> 00:01:10.390 align:start position:0%
always work from left to right so this
is<00:01:07.700><c> going</c><00:01:07.880><c> to</c><00:01:07.970><c> sort</c><00:01:08.299><c> first</c><00:01:08.600><c> by</c><00:01:08.780><c> city</c><00:01:09.290><c> and</c><00:01:09.560><c> then</c>

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

00:01:10.400 --> 00:01:11.980 align:start position:0%
is going to sort first by city and then
within<00:01:10.580><c> each</c><00:01:10.850><c> city</c><00:01:11.180><c> it</c><00:01:11.390><c> will</c><00:01:11.479><c> sort</c><00:01:11.810><c> by</c><00:01:11.869><c> zip</c>

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

00:01:11.990 --> 00:01:17.020 align:start position:0%
within each city it will sort by zip
code<00:01:12.369><c> if</c><00:01:14.770><c> we</c><00:01:15.770><c> wanted</c><00:01:16.070><c> it</c><00:01:16.189><c> to</c><00:01:16.310><c> sort</c><00:01:16.520><c> by</c><00:01:16.729><c> zip</c><00:01:16.759><c> code</c>

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

00:01:17.030 --> 00:01:19.090 align:start position:0%
code if we wanted it to sort by zip code
first<00:01:17.600><c> then</c><00:01:18.110><c> we</c><00:01:18.290><c> would</c><00:01:18.409><c> have</c><00:01:18.530><c> to</c><00:01:18.650><c> change</c><00:01:18.890><c> the</c>

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

00:01:19.100 --> 00:01:21.340 align:start position:0%
first then we would have to change the
ordering<00:01:19.460><c> of</c><00:01:19.700><c> the</c><00:01:19.820><c> columns</c><00:01:20.210><c> and</c><00:01:20.390><c> you</c><00:01:20.450><c> can</c><00:01:21.259><c> do</c>

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

00:01:21.350 --> 00:01:23.080 align:start position:0%
ordering of the columns and you can do
that<00:01:21.500><c> by</c><00:01:21.680><c> clicking</c><00:01:22.130><c> at</c><00:01:22.310><c> the</c><00:01:22.340><c> top</c><00:01:22.490><c> of</c><00:01:22.820><c> a</c><00:01:22.909><c> column</c>

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

00:01:23.090 --> 00:01:27.149 align:start position:0%
that by clicking at the top of a column
and<00:01:23.979><c> dragging</c><00:01:24.979><c> it</c><00:01:25.070><c> to</c><00:01:25.100><c> the</c><00:01:25.220><c> left</c><00:01:25.490><c> or</c><00:01:25.670><c> the</c><00:01:25.759><c> right</c>

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

00:01:27.159 --> 00:01:30.280 align:start position:0%
and dragging it to the left or the right
so<00:01:28.159><c> this</c><00:01:28.369><c> would</c><00:01:28.549><c> sort</c><00:01:28.880><c> first</c><00:01:29.119><c> by</c><00:01:29.329><c> zip</c><00:01:29.780><c> code</c><00:01:29.810><c> and</c>

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

00:01:30.290 --> 00:01:33.370 align:start position:0%
so this would sort first by zip code and
then<00:01:30.860><c> by</c><00:01:31.070><c> city</c><00:01:31.399><c> but</c><00:01:32.360><c> that's</c><00:01:32.509><c> not</c><00:01:32.720><c> what</c><00:01:32.899><c> I</c><00:01:32.930><c> want</c>

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

00:01:33.380 --> 00:01:34.810 align:start position:0%
then by city but that's not what I want
so<00:01:33.590><c> I'm</c><00:01:33.829><c> just</c><00:01:33.950><c> going</c><00:01:34.159><c> to</c><00:01:34.280><c> leave</c><00:01:34.430><c> it</c><00:01:34.460><c> where</c><00:01:34.670><c> it</c>

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

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

00:01:37.280 --> 00:01:37.290 align:start position:0%
 
 

00:01:37.290 --> 00:01:39.930 align:start position:0%
 
below<00:01:38.290><c> the</c><00:01:38.470><c> sort</c><00:01:38.740><c> road</c><00:01:38.979><c> there</c><00:01:39.310><c> is</c><00:01:39.340><c> a</c><00:01:39.520><c> checkbox</c>

00:01:39.930 --> 00:01:39.940 align:start position:0%
below the sort road there is a checkbox
 

00:01:39.940 --> 00:01:42.750 align:start position:0%
below the sort road there is a checkbox
for<00:01:40.390><c> each</c><00:01:40.659><c> field</c><00:01:41.080><c> and</c><00:01:41.290><c> you</c><00:01:41.950><c> can</c><00:01:41.979><c> uncheck</c><00:01:42.610><c> a</c><00:01:42.640><c> box</c>

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

00:01:42.760 --> 00:01:45.480 align:start position:0%
for each field and you can uncheck a box
to<00:01:43.210><c> hide</c><00:01:43.360><c> the</c><00:01:43.600><c> field</c><00:01:43.810><c> in</c><00:01:44.050><c> the</c><00:01:44.170><c> results</c><00:01:44.620><c> we're</c>

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

00:01:45.490 --> 00:01:47.219 align:start position:0%
to hide the field in the results we're
using<00:01:45.700><c> the</c><00:01:45.909><c> phone</c><00:01:46.119><c> number</c><00:01:46.150><c> field</c><00:01:46.540><c> to</c><00:01:46.840><c> filter</c>

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

00:01:47.229 --> 00:01:49.200 align:start position:0%
using the phone number field to filter
our<00:01:47.409><c> results</c><00:01:47.890><c> but</c><00:01:48.430><c> we</c><00:01:48.580><c> don't</c><00:01:48.760><c> actually</c><00:01:48.909><c> need</c>

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

00:01:49.210 --> 00:01:51.149 align:start position:0%
our results but we don't actually need
to<00:01:49.360><c> see</c><00:01:49.540><c> the</c><00:01:49.690><c> phone</c><00:01:49.840><c> numbers</c><00:01:50.200><c> so</c><00:01:50.710><c> I'll</c><00:01:50.920><c> uncheck</c>

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

00:01:51.159 --> 00:01:54.630 align:start position:0%
to see the phone numbers so I'll uncheck
this<00:01:51.760><c> and</c><00:01:52.290><c> I'm</c><00:01:53.290><c> also</c><00:01:53.500><c> going</c><00:01:53.800><c> to</c><00:01:53.920><c> hide</c><00:01:54.160><c> the</c><00:01:54.400><c> ID</c>

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

00:01:54.640 --> 00:01:57.420 align:start position:0%
this and I'm also going to hide the ID
field<00:01:55.060><c> and</c><00:01:55.470><c> this</c><00:01:56.470><c> is</c><00:01:56.650><c> really</c><00:01:56.920><c> just</c><00:01:57.130><c> a</c><00:01:57.250><c> way</c><00:01:57.400><c> of</c>

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

00:01:57.430 --> 00:01:59.940 align:start position:0%
field and this is really just a way of
making<00:01:57.880><c> the</c><00:01:58.150><c> results</c><00:01:58.540><c> easier</c><00:01:58.690><c> to</c><00:01:59.170><c> read</c><00:01:59.470><c> by</c>

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

00:01:59.950 --> 00:02:01.590 align:start position:0%
making the results easier to read by
reducing<00:02:00.490><c> the</c><00:02:00.610><c> amount</c><00:02:00.850><c> of</c><00:02:00.909><c> information</c><00:02:01.509><c> that</c>

00:02:01.590 --> 00:02:01.600 align:start position:0%
reducing the amount of information that
 

00:02:01.600 --> 00:02:04.649 align:start position:0%
reducing the amount of information that
you<00:02:01.720><c> have</c><00:02:01.750><c> to</c><00:02:02.020><c> look</c><00:02:02.200><c> at</c><00:02:02.880><c> now</c><00:02:03.880><c> we</c><00:02:03.940><c> can</c><00:02:04.360><c> run</c><00:02:04.600><c> the</c>

00:02:04.649 --> 00:02:04.659 align:start position:0%
you have to look at now we can run the
 

00:02:04.659 --> 00:02:08.699 align:start position:0%
you have to look at now we can run the
query<00:02:04.960><c> again</c><00:02:05.350><c> and</c><00:02:07.080><c> you</c><00:02:08.080><c> can</c><00:02:08.229><c> see</c><00:02:08.410><c> that</c><00:02:08.560><c> our</c>

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

00:02:08.709 --> 00:02:11.250 align:start position:0%
query again and you can see that our
results<00:02:09.130><c> are</c><00:02:09.280><c> sorted</c><00:02:09.640><c> by</c><00:02:09.700><c> city</c><00:02:10.239><c> and</c><00:02:10.479><c> within</c>

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

00:02:11.260 --> 00:02:13.380 align:start position:0%
results are sorted by city and within
each<00:02:11.530><c> city</c><00:02:11.830><c> they're</c><00:02:12.070><c> sorted</c><00:02:12.400><c> by</c><00:02:12.550><c> zip</c><00:02:12.880><c> code</c><00:02:12.910><c> and</c>

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

00:02:13.390 --> 00:02:16.080 align:start position:0%
each city they're sorted by zip code and
the<00:02:14.380><c> phone</c><00:02:14.410><c> number</c><00:02:14.890><c> and</c><00:02:15.100><c> ID</c><00:02:15.370><c> fields</c><00:02:15.970><c> are</c>

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

00:02:16.090 --> 00:02:18.750 align:start position:0%
the phone number and ID fields are
hidden<00:02:16.390><c> so</c><00:02:16.930><c> we</c><00:02:17.170><c> can</c><00:02:17.350><c> just</c><00:02:17.650><c> focus</c><00:02:17.950><c> on</c><00:02:18.310><c> the</c><00:02:18.370><c> names</c>

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

00:02:18.760 --> 00:02:21.480 align:start position:0%
hidden so we can just focus on the names
and<00:02:19.120><c> addresses</c>