WEBVTT
Kind: captions
Language: en

00:00:00.410 --> 00:00:02.990 align:start position:0%
 
Goodwill<00:00:01.410><c> Community</c><00:00:01.860><c> Foundation</c><00:00:02.520><c> creating</c>

00:00:02.990 --> 00:00:03.000 align:start position:0%
Goodwill Community Foundation creating
 

00:00:03.000 --> 00:00:11.030 align:start position:0%
Goodwill Community Foundation creating
opportunities<00:00:03.570><c> for</c><00:00:03.600><c> a</c><00:00:03.840><c> better</c><00:00:03.870><c> life</c>

00:00:11.030 --> 00:00:11.040 align:start position:0%
 
 

00:00:11.040 --> 00:00:13.160 align:start position:0%
 
I'm<00:00:11.100><c> working</c><00:00:11.940><c> on</c><00:00:12.030><c> a</c><00:00:12.090><c> query</c><00:00:12.450><c> that</c><00:00:12.660><c> shows</c><00:00:12.720><c> us</c><00:00:13.050><c> a</c>

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

00:00:13.170 --> 00:00:15.080 align:start position:0%
I'm working on a query that shows us a
list<00:00:13.410><c> of</c><00:00:13.710><c> our</c><00:00:13.800><c> bakery's</c><00:00:14.219><c> customers</c><00:00:14.790><c> who</c><00:00:14.940><c> live</c>

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

00:00:15.090 --> 00:00:17.480 align:start position:0%
list of our bakery's customers who live
outside<00:00:15.389><c> the</c><00:00:15.870><c> city</c><00:00:16.020><c> limits</c><00:00:16.170><c> and</c><00:00:16.650><c> there</c><00:00:17.369><c> are</c><00:00:17.430><c> a</c>

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

00:00:17.490 --> 00:00:18.890 align:start position:0%
outside the city limits and there are a
couple<00:00:17.640><c> of</c><00:00:17.790><c> things</c><00:00:18.000><c> that</c><00:00:18.090><c> I'm</c><00:00:18.240><c> going</c><00:00:18.450><c> to</c><00:00:18.540><c> do</c><00:00:18.720><c> to</c>

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

00:00:18.900 --> 00:00:21.260 align:start position:0%
couple of things that I'm going to do to
make<00:00:19.080><c> the</c><00:00:19.200><c> results</c><00:00:19.590><c> easier</c><00:00:19.740><c> to</c><00:00:20.160><c> read</c><00:00:20.369><c> sorting</c>

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

00:00:21.270 --> 00:00:23.510 align:start position:0%
make the results easier to read sorting
the<00:00:21.360><c> results</c><00:00:21.810><c> and</c><00:00:21.960><c> hiding</c><00:00:22.920><c> the</c><00:00:23.009><c> fields</c><00:00:23.340><c> that</c>

00:00:23.510 --> 00:00:23.520 align:start position:0%
the results and hiding the fields that
 

00:00:23.520 --> 00:00:26.179 align:start position:0%
the results and hiding the fields that
we<00:00:23.610><c> don't</c><00:00:23.820><c> need</c><00:00:23.970><c> to</c><00:00:24.029><c> see</c><00:00:24.560><c> right</c><00:00:25.560><c> now</c><00:00:25.740><c> I'm</c><00:00:26.040><c> in</c>

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

00:00:26.189 --> 00:00:28.190 align:start position:0%
we don't need to see right now I'm in
datasheet<00:00:26.700><c> view</c><00:00:26.730><c> so</c><00:00:27.329><c> I'll</c><00:00:27.570><c> need</c><00:00:27.779><c> to</c><00:00:27.840><c> switch</c><00:00:28.169><c> to</c>

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

00:00:28.200 --> 00:00:30.800 align:start position:0%
datasheet view so I'll need to switch to
design<00:00:28.980><c> view</c><00:00:29.310><c> and</c><00:00:29.489><c> there</c><00:00:30.060><c> are</c><00:00:30.270><c> two</c><00:00:30.480><c> ways</c><00:00:30.630><c> of</c>

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

00:00:30.810 --> 00:00:33.470 align:start position:0%
design view and there are two ways of
doing<00:00:30.930><c> that</c><00:00:31.200><c> you</c><00:00:32.099><c> can</c><00:00:32.340><c> either</c><00:00:32.579><c> go</c><00:00:32.850><c> to</c><00:00:32.880><c> the</c><00:00:33.210><c> view</c>

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

00:00:33.480 --> 00:00:38.049 align:start position:0%
doing that you can either go to the view
drop-down<00:00:33.780><c> arrow</c><00:00:34.260><c> and</c><00:00:34.440><c> select</c><00:00:35.180><c> design</c><00:00:36.180><c> view</c>

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

00:00:38.059 --> 00:00:40.569 align:start position:0%
drop-down arrow and select design view
or<00:00:38.539><c> in</c><00:00:39.230><c> the</c><00:00:39.469><c> bottom</c><00:00:39.770><c> right</c><00:00:39.920><c> corner</c><00:00:39.949><c> you</c><00:00:40.550><c> can</c>

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

00:00:40.579 --> 00:00:43.869 align:start position:0%
or in the bottom right corner you can
click<00:00:40.969><c> the</c><00:00:41.120><c> icon</c><00:00:41.270><c> on</c><00:00:41.780><c> the</c><00:00:42.020><c> far</c><00:00:42.199><c> right</c>

00:00:43.869 --> 00:00:43.879 align:start position:0%
click the icon on the far right
 

00:00:43.879 --> 00:00:48.279 align:start position:0%
click the icon on the far right
in<00:00:45.250><c> the</c><00:00:46.250><c> data</c><00:00:46.460><c> grid</c><00:00:46.820><c> there</c><00:00:47.300><c> is</c><00:00:47.510><c> a</c><00:00:47.539><c> sort</c><00:00:47.989><c> row</c>

00:00:48.279 --> 00:00:48.289 align:start position:0%
in the data grid there is a sort row
 

00:00:48.289 --> 00:00:51.040 align:start position:0%
in the data grid there is a sort row
which<00:00:48.589><c> is</c><00:00:48.769><c> currently</c><00:00:49.100><c> empty</c><00:00:49.449><c> to</c><00:00:50.449><c> add</c><00:00:50.600><c> a</c><00:00:50.629><c> sort</c>

00:00:51.040 --> 00:00:51.050 align:start position:0%
which is currently empty to add a sort
 

00:00:51.050 --> 00:00:52.840 align:start position:0%
which is currently empty to add a sort
you<00:00:51.199><c> can</c><00:00:51.350><c> just</c><00:00:51.589><c> click</c><00:00:51.890><c> on</c><00:00:51.920><c> the</c><00:00:52.219><c> cell</c><00:00:52.460><c> for</c><00:00:52.760><c> the</c>

00:00:52.840 --> 00:00:52.850 align:start position:0%
you can just click on the cell for the
 

00:00:52.850 --> 00:00:55.240 align:start position:0%
you can just click on the cell for the
field<00:00:53.089><c> that</c><00:00:53.239><c> you</c><00:00:53.329><c> want</c><00:00:53.420><c> to</c><00:00:53.570><c> sort</c><00:00:53.780><c> and</c><00:00:54.250><c> then</c>

00:00:55.240 --> 00:00:55.250 align:start position:0%
field that you want to sort and then
 

00:00:55.250 --> 00:00:56.979 align:start position:0%
field that you want to sort and then
click<00:00:55.579><c> the</c><00:00:55.730><c> drop</c><00:00:55.969><c> down</c><00:00:56.000><c> arrow</c><00:00:56.449><c> to</c><00:00:56.570><c> choose</c><00:00:56.930><c> a</c>

00:00:56.979 --> 00:00:56.989 align:start position:0%
click the drop down arrow to choose a
 

00:00:56.989 --> 00:01:00.579 align:start position:0%
click the drop down arrow to choose a
sort<00:00:57.170><c> option</c><00:00:57.890><c> and</c><00:00:58.850><c> now</c><00:00:59.719><c> our</c><00:00:59.960><c> results</c><00:01:00.379><c> will</c><00:01:00.500><c> be</c>

00:01:00.579 --> 00:01:00.589 align:start position:0%
sort option and now our results will be
 

00:01:00.589 --> 00:01:03.850 align:start position:0%
sort option and now our results will be
sorted<00:01:00.979><c> alphabetically</c><00:01:01.640><c> by</c><00:01:01.969><c> city</c><00:01:02.739><c> you</c><00:01:03.739><c> can</c>

00:01:03.850 --> 00:01:03.860 align:start position:0%
sorted alphabetically by city you can
 

00:01:03.860 --> 00:01:06.219 align:start position:0%
sorted alphabetically by city you can
also<00:01:03.979><c> do</c><00:01:04.309><c> a</c><00:01:04.339><c> multi-level</c><00:01:05.299><c> sort</c><00:01:05.539><c> by</c><00:01:05.990><c> just</c>

00:01:06.219 --> 00:01:06.229 align:start position:0%
also do a multi-level sort by just
 

00:01:06.229 --> 00:01:08.249 align:start position:0%
also do a multi-level sort by just
adding<00:01:06.530><c> a</c><00:01:06.590><c> sort</c><00:01:06.860><c> to</c><00:01:07.070><c> another</c><00:01:07.340><c> field</c><00:01:07.610><c> a</c>

00:01:08.249 --> 00:01:08.259 align:start position:0%
adding a sort to another field a
 

00:01:08.259 --> 00:01:10.690 align:start position:0%
adding a sort to another field a
multi-level<00:01:09.259><c> sort</c><00:01:09.500><c> will</c><00:01:09.770><c> always</c><00:01:10.190><c> work</c><00:01:10.430><c> from</c>

00:01:10.690 --> 00:01:10.700 align:start position:0%
multi-level sort will always work from
 

00:01:10.700 --> 00:01:12.999 align:start position:0%
multi-level sort will always work from
left<00:01:11.030><c> to</c><00:01:11.180><c> right</c><00:01:11.539><c> so</c><00:01:12.140><c> this</c><00:01:12.320><c> is</c><00:01:12.440><c> going</c><00:01:12.590><c> to</c><00:01:12.680><c> sort</c>

00:01:12.999 --> 00:01:13.009 align:start position:0%
left to right so this is going to sort
 

00:01:13.009 --> 00:01:15.910 align:start position:0%
left to right so this is going to sort
first<00:01:13.310><c> by</c><00:01:13.520><c> city</c><00:01:14.000><c> and</c><00:01:14.240><c> then</c><00:01:15.110><c> within</c><00:01:15.320><c> each</c><00:01:15.560><c> city</c>

00:01:15.910 --> 00:01:15.920 align:start position:0%
first by city and then within each city
 

00:01:15.920 --> 00:01:20.889 align:start position:0%
first by city and then within each city
it<00:01:16.130><c> will</c><00:01:16.190><c> sort</c><00:01:16.520><c> by</c><00:01:16.700><c> zip</c><00:01:16.729><c> code</c><00:01:17.920><c> if</c><00:01:19.509><c> we</c><00:01:20.509><c> wanted</c><00:01:20.810><c> it</c>

00:01:20.889 --> 00:01:20.899 align:start position:0%
it will sort by zip code if we wanted it
 

00:01:20.899 --> 00:01:23.109 align:start position:0%
it will sort by zip code if we wanted it
to<00:01:21.020><c> sort</c><00:01:21.229><c> by</c><00:01:21.350><c> zip</c><00:01:21.740><c> code</c><00:01:21.770><c> first</c><00:01:22.369><c> then</c><00:01:22.850><c> we</c><00:01:23.000><c> would</c>

00:01:23.109 --> 00:01:23.119 align:start position:0%
to sort by zip code first then we would
 

00:01:23.119 --> 00:01:24.430 align:start position:0%
to sort by zip code first then we would
have<00:01:23.270><c> to</c><00:01:23.390><c> change</c><00:01:23.630><c> the</c><00:01:23.840><c> ordering</c><00:01:24.259><c> of</c><00:01:24.380><c> the</c>

00:01:24.430 --> 00:01:24.440 align:start position:0%
have to change the ordering of the
 

00:01:24.440 --> 00:01:26.469 align:start position:0%
have to change the ordering of the
columns<00:01:24.920><c> and</c><00:01:25.130><c> you</c><00:01:25.819><c> can</c><00:01:25.970><c> do</c><00:01:26.090><c> that</c><00:01:26.210><c> by</c><00:01:26.420><c> clicking</c>

00:01:26.469 --> 00:01:26.479 align:start position:0%
columns and you can do that by clicking
 

00:01:26.479 --> 00:01:29.800 align:start position:0%
columns and you can do that by clicking
at<00:01:27.020><c> the</c><00:01:27.080><c> top</c><00:01:27.200><c> of</c><00:01:27.530><c> a</c><00:01:27.649><c> column</c><00:01:27.830><c> and</c><00:01:28.690><c> dragging</c><00:01:29.690><c> it</c>

00:01:29.800 --> 00:01:29.810 align:start position:0%
at the top of a column and dragging it
 

00:01:29.810 --> 00:01:32.260 align:start position:0%
at the top of a column and dragging it
to<00:01:29.840><c> the</c><00:01:29.929><c> left</c><00:01:30.020><c> or</c><00:01:30.380><c> the</c><00:01:30.409><c> right</c>

00:01:32.260 --> 00:01:32.270 align:start position:0%
to the left or the right
 

00:01:32.270 --> 00:01:35.020 align:start position:0%
to the left or the right
so<00:01:32.900><c> this</c><00:01:33.110><c> would</c><00:01:33.290><c> sort</c><00:01:33.590><c> first</c><00:01:33.860><c> by</c><00:01:34.070><c> zip</c><00:01:34.520><c> code</c><00:01:34.549><c> and</c>

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

00:01:35.030 --> 00:01:37.960 align:start position:0%
so this would sort first by zip code and
then<00:01:35.600><c> by</c><00:01:35.810><c> city</c><00:01:36.110><c> but</c><00:01:37.070><c> that's</c><00:01:37.250><c> not</c><00:01:37.430><c> what</c><00:01:37.610><c> I</c><00:01:37.640><c> want</c>

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

00:01:37.970 --> 00:01:39.520 align:start position:0%
then by city but that's not what I want
so<00:01:38.180><c> I'm</c><00:01:38.540><c> just</c><00:01:38.720><c> going</c><00:01:38.899><c> to</c><00:01:38.960><c> leave</c><00:01:39.110><c> it</c><00:01:39.170><c> where</c><00:01:39.409><c> it</c>

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

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

00:01:43.120 --> 00:01:43.130 align:start position:0%
 
 

00:01:43.130 --> 00:01:45.770 align:start position:0%
 
below<00:01:44.130><c> the</c><00:01:44.310><c> sort</c><00:01:44.579><c> road</c><00:01:44.820><c> there</c><00:01:45.149><c> is</c><00:01:45.179><c> a</c><00:01:45.359><c> checkbox</c>

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

00:01:45.780 --> 00:01:48.560 align:start position:0%
below the sort road there is a checkbox
for<00:01:46.200><c> each</c><00:01:46.500><c> field</c><00:01:46.890><c> and</c><00:01:47.130><c> you</c><00:01:47.759><c> can</c><00:01:47.789><c> uncheck</c><00:01:48.420><c> a</c><00:01:48.450><c> box</c>

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

00:01:48.570 --> 00:01:51.319 align:start position:0%
for each field and you can uncheck a box
to<00:01:49.020><c> hide</c><00:01:49.200><c> the</c><00:01:49.409><c> field</c><00:01:49.619><c> in</c><00:01:49.890><c> the</c><00:01:49.979><c> results</c><00:01:50.429><c> we're</c>

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

00:01:51.329 --> 00:01:53.060 align:start position:0%
to hide the field in the results we're
using<00:01:51.539><c> the</c><00:01:51.750><c> phone</c><00:01:51.929><c> number</c><00:01:52.200><c> field</c><00:01:52.380><c> to</c><00:01:52.679><c> filter</c>

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

00:01:53.070 --> 00:01:55.039 align:start position:0%
using the phone number field to filter
our<00:01:53.219><c> results</c><00:01:53.270><c> but</c><00:01:54.270><c> we</c><00:01:54.420><c> don't</c><00:01:54.600><c> actually</c><00:01:54.750><c> need</c>

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

00:01:55.049 --> 00:01:56.990 align:start position:0%
our results but we don't actually need
to<00:01:55.110><c> see</c><00:01:55.380><c> the</c><00:01:55.500><c> phone</c><00:01:55.679><c> numbers</c><00:01:56.009><c> so</c><00:01:56.520><c> I'll</c><00:01:56.729><c> uncheck</c>

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

00:01:57.000 --> 00:02:00.440 align:start position:0%
to see the phone numbers so I'll uncheck
this<00:01:57.600><c> and</c><00:01:58.130><c> I'm</c><00:01:59.130><c> also</c><00:01:59.310><c> going</c><00:01:59.640><c> to</c><00:01:59.729><c> hide</c><00:01:59.969><c> the</c><00:02:00.240><c> ID</c>

00:02:00.440 --> 00:02:00.450 align:start position:0%
this and I'm also going to hide the ID
 

00:02:00.450 --> 00:02:03.230 align:start position:0%
this and I'm also going to hide the ID
field<00:02:00.899><c> and</c><00:02:01.280><c> this</c><00:02:02.280><c> is</c><00:02:02.340><c> really</c><00:02:02.759><c> just</c><00:02:02.789><c> a</c><00:02:03.060><c> way</c><00:02:03.209><c> of</c>

00:02:03.230 --> 00:02:03.240 align:start position:0%
field and this is really just a way of
 

00:02:03.240 --> 00:02:05.749 align:start position:0%
field and this is really just a way of
making<00:02:03.869><c> the</c><00:02:03.959><c> results</c><00:02:04.350><c> easier</c><00:02:04.500><c> to</c><00:02:04.979><c> read</c><00:02:05.280><c> by</c>

00:02:05.749 --> 00:02:05.759 align:start position:0%
making the results easier to read by
 

00:02:05.759 --> 00:02:07.340 align:start position:0%
making the results easier to read by
reducing<00:02:06.329><c> the</c><00:02:06.450><c> amount</c><00:02:06.479><c> of</c><00:02:06.719><c> information</c><00:02:07.049><c> that</c>

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

00:02:07.350 --> 00:02:11.230 align:start position:0%
reducing the amount of information that
you<00:02:07.500><c> have</c><00:02:07.709><c> to</c><00:02:07.860><c> look</c><00:02:08.009><c> at</c>

00:02:11.230 --> 00:02:11.240 align:start position:0%
 
 

00:02:11.240 --> 00:02:15.430 align:start position:0%
 
now<00:02:11.960><c> we</c><00:02:12.020><c> can</c><00:02:12.470><c> run</c><00:02:12.680><c> the</c><00:02:12.860><c> query</c><00:02:13.040><c> again</c><00:02:13.250><c> and</c><00:02:14.440><c> you</c>

00:02:15.430 --> 00:02:15.440 align:start position:0%
now we can run the query again and you
 

00:02:15.440 --> 00:02:17.050 align:start position:0%
now we can run the query again and you
can<00:02:15.590><c> see</c><00:02:15.770><c> that</c><00:02:15.920><c> our</c><00:02:16.070><c> results</c><00:02:16.490><c> are</c><00:02:16.640><c> sorted</c><00:02:17.000><c> by</c>

00:02:17.050 --> 00:02:17.060 align:start position:0%
can see that our results are sorted by
 

00:02:17.060 --> 00:02:19.750 align:start position:0%
can see that our results are sorted by
city<00:02:17.600><c> and</c><00:02:17.810><c> within</c><00:02:18.620><c> each</c><00:02:18.890><c> city</c><00:02:19.130><c> they're</c><00:02:19.430><c> sorted</c>

00:02:19.750 --> 00:02:19.760 align:start position:0%
city and within each city they're sorted
 

00:02:19.760 --> 00:02:22.720 align:start position:0%
city and within each city they're sorted
by<00:02:19.910><c> zip</c><00:02:20.240><c> code</c><00:02:20.270><c> and</c><00:02:20.780><c> the</c><00:02:21.740><c> phone</c><00:02:21.770><c> number</c><00:02:22.220><c> and</c><00:02:22.430><c> ID</c>

00:02:22.720 --> 00:02:22.730 align:start position:0%
by zip code and the phone number and ID
 

00:02:22.730 --> 00:02:25.300 align:start position:0%
by zip code and the phone number and ID
fields<00:02:23.330><c> are</c><00:02:23.450><c> hidden</c><00:02:23.750><c> so</c><00:02:24.290><c> we</c><00:02:24.530><c> can</c><00:02:24.710><c> just</c><00:02:25.010><c> focus</c>

00:02:25.300 --> 00:02:25.310 align:start position:0%
fields are hidden so we can just focus
 

00:02:25.310 --> 00:02:28.840 align:start position:0%
fields are hidden so we can just focus
on<00:02:25.640><c> the</c><00:02:25.700><c> names</c><00:02:26.120><c> and</c><00:02:26.480><c> addresses</c>