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.890><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:10.650 align:start position:0%
Goodwill Community Foundation creating
opportunities<00:00:03.570><c> for</c><00:00:03.810><c> a</c><00:00:03.870><c> better</c><00:00:03.899><c> life</c>

00:00:10.650 --> 00:00:10.660 align:start position:0%
 
 

00:00:10.660 --> 00:00:12.960 align:start position:0%
 
we're<00:00:11.590><c> going</c><00:00:11.770><c> to</c><00:00:11.860><c> talk</c><00:00:12.040><c> about</c><00:00:12.190><c> a</c><00:00:12.310><c> really</c><00:00:12.640><c> neat</c>

00:00:12.960 --> 00:00:12.970 align:start position:0%
we're going to talk about a really neat
 

00:00:12.970 --> 00:00:15.780 align:start position:0%
we're going to talk about a really neat
type<00:00:13.210><c> of</c><00:00:13.390><c> query</c><00:00:13.690><c> called</c><00:00:14.020><c> a</c><00:00:14.260><c> totals</c><00:00:14.650><c> query</c><00:00:14.920><c> up</c>

00:00:15.780 --> 00:00:15.790 align:start position:0%
type of query called a totals query up
 

00:00:15.790 --> 00:00:17.370 align:start position:0%
type of query called a totals query up
until<00:00:16.240><c> this</c><00:00:16.360><c> point</c><00:00:16.480><c> the</c><00:00:16.810><c> queries</c><00:00:17.140><c> that</c><00:00:17.170><c> we've</c>

00:00:17.370 --> 00:00:17.380 align:start position:0%
until this point the queries that we've
 

00:00:17.380 --> 00:00:19.109 align:start position:0%
until this point the queries that we've
done<00:00:17.560><c> have</c><00:00:17.740><c> pulled</c><00:00:18.010><c> end</c><00:00:18.220><c> results</c><00:00:18.610><c> from</c><00:00:18.820><c> one</c><00:00:19.000><c> or</c>

00:00:19.109 --> 00:00:19.119 align:start position:0%
done have pulled end results from one or
 

00:00:19.119 --> 00:00:21.300 align:start position:0%
done have pulled end results from one or
more<00:00:19.150><c> tables</c><00:00:19.300><c> and</c><00:00:19.810><c> listed</c><00:00:20.590><c> them</c><00:00:20.740><c> one</c><00:00:21.070><c> by</c><00:00:21.279><c> one</c>

00:00:21.300 --> 00:00:21.310 align:start position:0%
more tables and listed them one by one
 

00:00:21.310 --> 00:00:23.820 align:start position:0%
more tables and listed them one by one
but<00:00:21.790><c> a</c><00:00:22.450><c> totals</c><00:00:22.840><c> query</c><00:00:23.050><c> does</c><00:00:23.349><c> more</c><00:00:23.619><c> than</c><00:00:23.650><c> just</c>

00:00:23.820 --> 00:00:23.830 align:start position:0%
but a totals query does more than just
 

00:00:23.830 --> 00:00:26.100 align:start position:0%
but a totals query does more than just
list<00:00:24.279><c> the</c><00:00:24.430><c> results</c><00:00:24.820><c> it</c><00:00:25.270><c> combines</c><00:00:25.840><c> them</c>

00:00:26.100 --> 00:00:26.110 align:start position:0%
list the results it combines them
 

00:00:26.110 --> 00:00:27.870 align:start position:0%
list the results it combines them
according<00:00:26.590><c> to</c><00:00:26.619><c> their</c><00:00:26.770><c> value</c><00:00:27.130><c> and</c><00:00:27.279><c> then</c>

00:00:27.870 --> 00:00:27.880 align:start position:0%
according to their value and then
 

00:00:27.880 --> 00:00:29.880 align:start position:0%
according to their value and then
performs<00:00:28.329><c> a</c><00:00:28.419><c> calculation</c><00:00:28.540><c> such</c><00:00:29.290><c> as</c><00:00:29.470><c> sum</c>

00:00:29.880 --> 00:00:29.890 align:start position:0%
performs a calculation such as sum
 

00:00:29.890 --> 00:00:32.550 align:start position:0%
performs a calculation such as sum
average<00:00:30.189><c> or</c><00:00:31.060><c> count</c><00:00:31.090><c> so</c><00:00:31.930><c> that</c><00:00:31.960><c> you</c><00:00:32.140><c> get</c><00:00:32.290><c> much</c>

00:00:32.550 --> 00:00:32.560 align:start position:0%
average or count so that you get much
 

00:00:32.560 --> 00:00:35.460 align:start position:0%
average or count so that you get much
more<00:00:32.590><c> useful</c><00:00:33.310><c> information</c><00:00:33.489><c> I'm</c><00:00:34.380><c> going</c><00:00:35.380><c> to</c>

00:00:35.460 --> 00:00:35.470 align:start position:0%
more useful information I'm going to
 

00:00:35.470 --> 00:00:37.590 align:start position:0%
more useful information I'm going to
start<00:00:35.770><c> by</c><00:00:35.950><c> opening</c><00:00:35.980><c> the</c><00:00:36.460><c> menu</c><00:00:36.760><c> items</c><00:00:37.300><c> ordered</c>

00:00:37.590 --> 00:00:37.600 align:start position:0%
start by opening the menu items ordered
 

00:00:37.600 --> 00:00:40.590 align:start position:0%
start by opening the menu items ordered
query<00:00:38.050><c> in</c><00:00:38.290><c> our</c><00:00:38.410><c> bakery</c><00:00:38.649><c> database</c><00:00:39.300><c> this</c><00:00:40.300><c> query</c>

00:00:40.590 --> 00:00:40.600 align:start position:0%
query in our bakery database this query
 

00:00:40.600 --> 00:00:42.510 align:start position:0%
query in our bakery database this query
uses<00:00:41.110><c> several</c><00:00:41.530><c> different</c><00:00:41.800><c> tables</c><00:00:42.130><c> to</c><00:00:42.280><c> give</c><00:00:42.399><c> us</c>

00:00:42.510 --> 00:00:42.520 align:start position:0%
uses several different tables to give us
 

00:00:42.520 --> 00:00:43.950 align:start position:0%
uses several different tables to give us
a<00:00:42.640><c> list</c><00:00:42.790><c> of</c><00:00:42.970><c> all</c><00:00:43.150><c> of</c><00:00:43.360><c> the</c><00:00:43.480><c> items</c><00:00:43.750><c> that</c><00:00:43.840><c> have</c>

00:00:43.950 --> 00:00:43.960 align:start position:0%
a list of all of the items that have
 

00:00:43.960 --> 00:00:46.350 align:start position:0%
a list of all of the items that have
been<00:00:44.170><c> ordered</c><00:00:44.560><c> if</c><00:00:44.730><c> you</c><00:00:45.730><c> look</c><00:00:45.910><c> down</c><00:00:46.030><c> the</c><00:00:46.180><c> list</c>

00:00:46.350 --> 00:00:46.360 align:start position:0%
been ordered if you look down the list
 

00:00:46.360 --> 00:00:47.700 align:start position:0%
been ordered if you look down the list
you<00:00:46.480><c> can</c><00:00:46.540><c> see</c><00:00:46.840><c> that</c><00:00:46.990><c> there's</c><00:00:47.200><c> a</c><00:00:47.260><c> lot</c><00:00:47.560><c> of</c>

00:00:47.700 --> 00:00:47.710 align:start position:0%
you can see that there's a lot of
 

00:00:47.710 --> 00:00:49.710 align:start position:0%
you can see that there's a lot of
repetition<00:00:47.890><c> and</c><00:00:48.460><c> that's</c><00:00:49.030><c> because</c><00:00:49.360><c> most</c><00:00:49.630><c> of</c>

00:00:49.710 --> 00:00:49.720 align:start position:0%
repetition and that's because most of
 

00:00:49.720 --> 00:00:51.150 align:start position:0%
repetition and that's because most of
these<00:00:49.870><c> items</c><00:00:49.930><c> have</c><00:00:50.350><c> been</c><00:00:50.380><c> ordered</c><00:00:50.800><c> more</c><00:00:51.010><c> than</c>

00:00:51.150 --> 00:00:51.160 align:start position:0%
these items have been ordered more than
 

00:00:51.160 --> 00:00:54.300 align:start position:0%
these items have been ordered more than
once<00:00:51.370><c> if</c><00:00:51.720><c> we</c><00:00:52.720><c> change</c><00:00:52.990><c> this</c><00:00:53.230><c> to</c><00:00:53.290><c> a</c><00:00:53.530><c> totals</c><00:00:54.070><c> query</c>

00:00:54.300 --> 00:00:54.310 align:start position:0%
once if we change this to a totals query
 

00:00:54.310 --> 00:00:56.400 align:start position:0%
once if we change this to a totals query
then<00:00:54.880><c> we'll</c><00:00:55.090><c> have</c><00:00:55.270><c> just</c><00:00:55.600><c> one</c><00:00:55.870><c> row</c><00:00:56.080><c> for</c><00:00:56.350><c> each</c>

00:00:56.400 --> 00:00:56.410 align:start position:0%
then we'll have just one row for each
 

00:00:56.410 --> 00:00:58.830 align:start position:0%
then we'll have just one row for each
item<00:00:56.860><c> and</c><00:00:56.980><c> the</c><00:00:57.640><c> values</c><00:00:58.030><c> in</c><00:00:58.240><c> the</c><00:00:58.360><c> quantity</c>

00:00:58.830 --> 00:00:58.840 align:start position:0%
item and the values in the quantity
 

00:00:58.840 --> 00:01:00.780 align:start position:0%
item and the values in the quantity
field<00:00:59.050><c> will</c><00:00:59.320><c> be</c><00:00:59.470><c> added</c><00:00:59.890><c> up</c><00:01:00.040><c> to</c><00:01:00.310><c> show</c><00:01:00.490><c> us</c><00:01:00.610><c> what</c>

00:01:00.780 --> 00:01:00.790 align:start position:0%
field will be added up to show us what
 

00:01:00.790 --> 00:01:04.710 align:start position:0%
field will be added up to show us what
the<00:01:00.910><c> total</c><00:01:01.120><c> is</c><00:01:01.330><c> for</c><00:01:01.660><c> each</c><00:01:01.810><c> item</c><00:01:03.390><c> first</c><00:01:04.390><c> you'll</c>

00:01:04.710 --> 00:01:04.720 align:start position:0%
the total is for each item first you'll
 

00:01:04.720 --> 00:01:09.749 align:start position:0%
the total is for each item first you'll
need<00:01:04.900><c> to</c><00:01:05.019><c> go</c><00:01:05.140><c> to</c><00:01:05.170><c> design</c><00:01:05.710><c> view</c><00:01:05.770><c> and</c><00:01:08.729><c> then</c><00:01:09.729><c> click</c>

00:01:09.749 --> 00:01:09.759 align:start position:0%
need to go to design view and then click
 

00:01:09.759 --> 00:01:14.310 align:start position:0%
need to go to design view and then click
the<00:01:10.240><c> totals</c><00:01:10.689><c> command</c><00:01:11.049><c> and</c><00:01:12.689><c> the</c><00:01:13.689><c> design</c><00:01:14.079><c> grid</c>

00:01:14.310 --> 00:01:14.320 align:start position:0%
the totals command and the design grid
 

00:01:14.320 --> 00:01:16.919 align:start position:0%
the totals command and the design grid
now<00:01:14.649><c> has</c><00:01:14.950><c> a</c><00:01:14.979><c> new</c><00:01:15.490><c> row</c><00:01:15.729><c> called</c><00:01:16.149><c> the</c><00:01:16.390><c> total</c><00:01:16.600><c> row</c>

00:01:16.919 --> 00:01:16.929 align:start position:0%
now has a new row called the total row
 

00:01:16.929 --> 00:01:19.319 align:start position:0%
now has a new row called the total row
and<00:01:17.170><c> right</c><00:01:17.859><c> now</c><00:01:18.009><c> all</c><00:01:18.219><c> of</c><00:01:18.249><c> these</c><00:01:18.490><c> say</c><00:01:18.880><c> grouped</c>

00:01:19.319 --> 00:01:19.329 align:start position:0%
and right now all of these say grouped
 

00:01:19.329 --> 00:01:21.870 align:start position:0%
and right now all of these say grouped
by<00:01:19.689><c> but</c><00:01:20.499><c> we're</c><00:01:20.710><c> going</c><00:01:20.829><c> to</c><00:01:20.950><c> change</c><00:01:21.310><c> the</c><00:01:21.520><c> one</c><00:01:21.640><c> in</c>

00:01:21.870 --> 00:01:21.880 align:start position:0%
by but we're going to change the one in
 

00:01:21.880 --> 00:01:24.749 align:start position:0%
by but we're going to change the one in
the<00:01:22.060><c> quantity</c><00:01:22.539><c> field</c><00:01:23.189><c> so</c><00:01:24.189><c> click</c><00:01:24.399><c> the</c><00:01:24.520><c> drop</c>

00:01:24.749 --> 00:01:24.759 align:start position:0%
the quantity field so click the drop
 

00:01:24.759 --> 00:01:27.539 align:start position:0%
the quantity field so click the drop
down<00:01:24.789><c> arrow</c><00:01:25.299><c> and</c><00:01:25.479><c> we're</c><00:01:26.469><c> going</c><00:01:26.649><c> to</c><00:01:26.679><c> select</c><00:01:26.920><c> sum</c>

00:01:27.539 --> 00:01:27.549 align:start position:0%
down arrow and we're going to select sum
 

00:01:27.549 --> 00:01:29.309 align:start position:0%
down arrow and we're going to select sum
so<00:01:27.850><c> it</c><00:01:27.969><c> will</c><00:01:28.119><c> add</c><00:01:28.270><c> the</c><00:01:28.450><c> values</c><00:01:28.749><c> together</c><00:01:28.929><c> and</c>

00:01:29.309 --> 00:01:29.319 align:start position:0%
so it will add the values together and
 

00:01:29.319 --> 00:01:31.499 align:start position:0%
so it will add the values together and
there<00:01:30.189><c> are</c><00:01:30.369><c> some</c><00:01:30.609><c> other</c><00:01:30.759><c> options</c><00:01:31.210><c> such</c><00:01:31.450><c> as</c>

00:01:31.499 --> 00:01:31.509 align:start position:0%
there are some other options such as
 

00:01:31.509 --> 00:01:35.730 align:start position:0%
there are some other options such as
average<00:01:32.229><c> minimum</c><00:01:32.950><c> maximum</c><00:01:34.020><c> count</c><00:01:35.020><c> and</c><00:01:35.350><c> a</c><00:01:35.560><c> few</c>

00:01:35.730 --> 00:01:35.740 align:start position:0%
average minimum maximum count and a few
 

00:01:35.740 --> 00:01:37.830 align:start position:0%
average minimum maximum count and a few
more<00:01:35.889><c> but</c><00:01:36.759><c> in</c><00:01:36.969><c> this</c><00:01:37.060><c> case</c><00:01:37.299><c> we</c><00:01:37.509><c> want</c><00:01:37.719><c> to</c><00:01:37.780><c> use</c>

00:01:37.830 --> 00:01:37.840 align:start position:0%
more but in this case we want to use
 

00:01:37.840 --> 00:01:41.320 align:start position:0%
more but in this case we want to use
some

00:01:41.320 --> 00:01:41.330 align:start position:0%
 
 

00:01:41.330 --> 00:01:45.800 align:start position:0%
 
now<00:01:42.330><c> we</c><00:01:42.390><c> can</c><00:01:42.840><c> run</c><00:01:43.080><c> the</c><00:01:43.230><c> query</c><00:01:43.440><c> and</c><00:01:44.450><c> you</c><00:01:45.450><c> can</c><00:01:45.600><c> see</c>

00:01:45.800 --> 00:01:45.810 align:start position:0%
now we can run the query and you can see
 

00:01:45.810 --> 00:01:47.960 align:start position:0%
now we can run the query and you can see
that<00:01:45.960><c> there</c><00:01:46.140><c> is</c><00:01:46.170><c> one</c><00:01:46.350><c> row</c><00:01:46.920><c> for</c><00:01:47.160><c> each</c><00:01:47.220><c> product</c>

00:01:47.960 --> 00:01:47.970 align:start position:0%
that there is one row for each product
 

00:01:47.970 --> 00:01:50.810 align:start position:0%
that there is one row for each product
and<00:01:48.150><c> the</c><00:01:49.110><c> quantity</c><00:01:49.530><c> field</c><00:01:49.800><c> has</c><00:01:50.010><c> changed</c><00:01:50.040><c> to</c>

00:01:50.810 --> 00:01:50.820 align:start position:0%
and the quantity field has changed to
 

00:01:50.820 --> 00:01:53.719 align:start position:0%
and the quantity field has changed to
sum<00:01:51.300><c> of</c><00:01:51.540><c> quantity</c><00:01:52.200><c> and</c><00:01:52.350><c> this</c><00:01:53.160><c> gives</c><00:01:53.400><c> us</c><00:01:53.520><c> the</c>

00:01:53.719 --> 00:01:53.729 align:start position:0%
sum of quantity and this gives us the
 

00:01:53.729 --> 00:01:56.840 align:start position:0%
sum of quantity and this gives us the
total<00:01:53.760><c> for</c><00:01:54.300><c> each</c><00:01:54.420><c> item</c><00:01:54.900><c> that</c><00:01:55.580><c> means</c><00:01:56.580><c> we</c><00:01:56.700><c> can</c>

00:01:56.840 --> 00:01:56.850 align:start position:0%
total for each item that means we can
 

00:01:56.850 --> 00:01:58.640 align:start position:0%
total for each item that means we can
tell<00:01:57.000><c> at</c><00:01:57.120><c> a</c><00:01:57.180><c> glance</c><00:01:57.210><c> that</c><00:01:57.780><c> we've</c><00:01:57.930><c> sold</c><00:01:58.229><c> 12</c>

00:01:58.640 --> 00:01:58.650 align:start position:0%
tell at a glance that we've sold 12
 

00:01:58.650 --> 00:02:02.000 align:start position:0%
tell at a glance that we've sold 12
Christmas<00:01:59.130><c> cakes</c><00:01:59.369><c> 9</c><00:02:00.090><c> carrot</c><00:02:00.570><c> cakes</c><00:02:00.780><c> and</c><00:02:01.020><c> 18</c>

00:02:02.000 --> 00:02:02.010 align:start position:0%
Christmas cakes 9 carrot cakes and 18
 

00:02:02.010 --> 00:02:03.820 align:start position:0%
Christmas cakes 9 carrot cakes and 18
cheesecakes

00:02:03.820 --> 00:02:03.830 align:start position:0%
cheesecakes
 

00:02:03.830 --> 00:02:05.930 align:start position:0%
cheesecakes
you<00:02:04.830><c> may</c><00:02:04.979><c> notice</c><00:02:05.250><c> this</c><00:02:05.400><c> some</c><00:02:05.700><c> of</c><00:02:05.820><c> these</c>

00:02:05.930 --> 00:02:05.940 align:start position:0%
you may notice this some of these
 

00:02:05.940 --> 00:02:07.670 align:start position:0%
you may notice this some of these
product<00:02:06.330><c> names</c><00:02:06.510><c> appear</c><00:02:06.869><c> on</c><00:02:07.050><c> more</c><00:02:07.350><c> than</c><00:02:07.500><c> one</c>

00:02:07.670 --> 00:02:07.680 align:start position:0%
product names appear on more than one
 

00:02:07.680 --> 00:02:09.620 align:start position:0%
product names appear on more than one
row<00:02:07.890><c> and</c><00:02:08.160><c> that's</c><00:02:08.850><c> because</c><00:02:09.119><c> they</c><00:02:09.270><c> have</c><00:02:09.300><c> more</c>

00:02:09.620 --> 00:02:09.630 align:start position:0%
row and that's because they have more
 

00:02:09.630 --> 00:02:12.020 align:start position:0%
row and that's because they have more
than<00:02:09.780><c> one</c><00:02:09.840><c> sales</c><00:02:10.320><c> unit</c><00:02:10.709><c> for</c><00:02:11.550><c> example</c><00:02:11.610><c> the</c>

00:02:12.020 --> 00:02:12.030 align:start position:0%
than one sales unit for example the
 

00:02:12.030 --> 00:02:13.790 align:start position:0%
than one sales unit for example the
chocolate<00:02:12.420><c> chip</c><00:02:12.600><c> cookies</c><00:02:12.989><c> can</c><00:02:13.230><c> be</c><00:02:13.350><c> sold</c><00:02:13.560><c> by</c>

00:02:13.790 --> 00:02:13.800 align:start position:0%
chocolate chip cookies can be sold by
 

00:02:13.800 --> 00:02:14.540 align:start position:0%
chocolate chip cookies can be sold by
the<00:02:13.860><c> half-dozen</c>

00:02:14.540 --> 00:02:14.550 align:start position:0%
the half-dozen
 

00:02:14.550 --> 00:02:17.240 align:start position:0%
the half-dozen
dozen<00:02:15.150><c> or</c><00:02:15.330><c> as</c><00:02:15.660><c> single</c><00:02:15.989><c> cookies</c><00:02:16.350><c> and</c><00:02:16.530><c> these</c><00:02:17.100><c> are</c>

00:02:17.240 --> 00:02:17.250 align:start position:0%
dozen or as single cookies and these are
 

00:02:17.250 --> 00:02:18.949 align:start position:0%
dozen or as single cookies and these are
really<00:02:17.520><c> three</c><00:02:17.910><c> different</c><00:02:18.300><c> products</c><00:02:18.720><c> even</c>

00:02:18.949 --> 00:02:18.959 align:start position:0%
really three different products even
 

00:02:18.959 --> 00:02:21.460 align:start position:0%
really three different products even
though<00:02:19.200><c> they</c><00:02:19.410><c> have</c><00:02:19.560><c> the</c><00:02:19.709><c> same</c><00:02:19.739><c> product</c><00:02:20.400><c> name</c>

00:02:21.460 --> 00:02:21.470 align:start position:0%
though they have the same product name
 

00:02:21.470 --> 00:02:24.050 align:start position:0%
though they have the same product name
so<00:02:22.470><c> now</c><00:02:22.650><c> that</c><00:02:22.709><c> access</c><00:02:23.220><c> is</c><00:02:23.370><c> calculating</c><00:02:23.940><c> these</c>

00:02:24.050 --> 00:02:24.060 align:start position:0%
so now that access is calculating these
 

00:02:24.060 --> 00:02:26.390 align:start position:0%
so now that access is calculating these
totals<00:02:24.450><c> for</c><00:02:24.690><c> us</c><00:02:24.870><c> we're</c><00:02:25.440><c> able</c><00:02:25.620><c> to</c><00:02:25.830><c> get</c><00:02:25.980><c> a</c><00:02:26.040><c> much</c>

00:02:26.390 --> 00:02:26.400 align:start position:0%
totals for us we're able to get a much
 

00:02:26.400 --> 00:02:28.250 align:start position:0%
totals for us we're able to get a much
better<00:02:26.580><c> idea</c><00:02:26.730><c> of</c><00:02:27.300><c> what</c><00:02:27.570><c> people</c><00:02:27.600><c> are</c><00:02:28.020><c> buying</c>

00:02:28.250 --> 00:02:28.260 align:start position:0%
better idea of what people are buying
 

00:02:28.260 --> 00:02:31.070 align:start position:0%
better idea of what people are buying
from<00:02:28.500><c> our</c><00:02:28.650><c> bakery</c>