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:08.230 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:07.240><c> we're</c>

00:00:08.230 --> 00:00:08.240 align:start position:0%
opportunities for a better life we're
 

00:00:08.240 --> 00:00:09.820 align:start position:0%
opportunities for a better life we're
going<00:00:08.360><c> to</c><00:00:08.450><c> talk</c><00:00:08.660><c> about</c><00:00:08.690><c> a</c><00:00:08.929><c> really</c><00:00:09.379><c> neat</c><00:00:09.620><c> type</c>

00:00:09.820 --> 00:00:09.830 align:start position:0%
going to talk about a really neat type
 

00:00:09.830 --> 00:00:12.850 align:start position:0%
going to talk about a really neat type
of<00:00:10.009><c> query</c><00:00:10.309><c> called</c><00:00:10.610><c> a</c><00:00:10.879><c> totals</c><00:00:11.269><c> query</c><00:00:11.539><c> up</c><00:00:12.410><c> until</c>

00:00:12.850 --> 00:00:12.860 align:start position:0%
of query called a totals query up until
 

00:00:12.860 --> 00:00:14.140 align:start position:0%
of query called a totals query up until
this<00:00:13.009><c> point</c><00:00:13.099><c> the</c><00:00:13.400><c> queries</c><00:00:13.759><c> that</c><00:00:13.849><c> we've</c><00:00:13.999><c> done</c>

00:00:14.140 --> 00:00:14.150 align:start position:0%
this point the queries that we've done
 

00:00:14.150 --> 00:00:15.789 align:start position:0%
this point the queries that we've done
have<00:00:14.389><c> pulled</c><00:00:14.660><c> end</c><00:00:14.839><c> results</c><00:00:15.259><c> from</c><00:00:15.409><c> one</c><00:00:15.619><c> or</c><00:00:15.740><c> more</c>

00:00:15.789 --> 00:00:15.799 align:start position:0%
have pulled end results from one or more
 

00:00:15.799 --> 00:00:19.089 align:start position:0%
have pulled end results from one or more
tables<00:00:15.919><c> and</c><00:00:16.429><c> listed</c><00:00:17.210><c> them</c><00:00:17.390><c> one</c><00:00:17.689><c> by</c><00:00:17.900><c> one</c><00:00:18.039><c> but</c><00:00:19.039><c> a</c>

00:00:19.089 --> 00:00:19.099 align:start position:0%
tables and listed them one by one but a
 

00:00:19.099 --> 00:00:20.890 align:start position:0%
tables and listed them one by one but a
totals<00:00:19.490><c> query</c><00:00:19.699><c> does</c><00:00:20.000><c> more</c><00:00:20.269><c> than</c><00:00:20.300><c> just</c><00:00:20.449><c> list</c>

00:00:20.890 --> 00:00:20.900 align:start position:0%
totals query does more than just list
 

00:00:20.900 --> 00:00:23.200 align:start position:0%
totals query does more than just list
the<00:00:21.050><c> results</c><00:00:21.470><c> it</c><00:00:21.920><c> combines</c><00:00:22.490><c> them</c><00:00:22.759><c> according</c>

00:00:23.200 --> 00:00:23.210 align:start position:0%
the results it combines them according
 

00:00:23.210 --> 00:00:25.060 align:start position:0%
the results it combines them according
to<00:00:23.240><c> their</c><00:00:23.420><c> value</c><00:00:23.779><c> and</c><00:00:23.929><c> then</c><00:00:24.500><c> performs</c><00:00:24.949><c> a</c>

00:00:25.060 --> 00:00:25.070 align:start position:0%
to their value and then performs a
 

00:00:25.070 --> 00:00:27.700 align:start position:0%
to their value and then performs a
calculation<00:00:25.189><c> such</c><00:00:25.910><c> as</c><00:00:26.089><c> sum</c><00:00:26.539><c> average</c><00:00:26.810><c> or</c><00:00:27.679><c> count</c>

00:00:27.700 --> 00:00:27.710 align:start position:0%
calculation such as sum average or count
 

00:00:27.710 --> 00:00:29.710 align:start position:0%
calculation such as sum average or count
so<00:00:28.550><c> that</c><00:00:28.580><c> you</c><00:00:28.789><c> get</c><00:00:28.910><c> much</c><00:00:29.210><c> more</c><00:00:29.449><c> useful</c>

00:00:29.710 --> 00:00:29.720 align:start position:0%
so that you get much more useful
 

00:00:29.720 --> 00:00:32.589 align:start position:0%
so that you get much more useful
information<00:00:30.109><c> i'm</c><00:00:31.039><c> going</c><00:00:31.999><c> to</c><00:00:32.090><c> start</c><00:00:32.390><c> by</c>

00:00:32.589 --> 00:00:32.599 align:start position:0%
information i'm going to start by
 

00:00:32.599 --> 00:00:34.900 align:start position:0%
information i'm going to start by
opening<00:00:32.629><c> the</c><00:00:33.200><c> menu</c><00:00:33.230><c> items</c><00:00:33.950><c> ordered</c><00:00:34.219><c> query</c><00:00:34.670><c> in</c>

00:00:34.900 --> 00:00:34.910 align:start position:0%
opening the menu items ordered query in
 

00:00:34.910 --> 00:00:37.720 align:start position:0%
opening the menu items ordered query in
our<00:00:35.030><c> bakery</c><00:00:35.270><c> database</c><00:00:35.920><c> this</c><00:00:36.920><c> query</c><00:00:37.250><c> uses</c>

00:00:37.720 --> 00:00:37.730 align:start position:0%
our bakery database this query uses
 

00:00:37.730 --> 00:00:39.250 align:start position:0%
our bakery database this query uses
several<00:00:38.149><c> different</c><00:00:38.420><c> tables</c><00:00:38.750><c> to</c><00:00:38.899><c> give</c><00:00:39.050><c> us</c><00:00:39.140><c> a</c>

00:00:39.250 --> 00:00:39.260 align:start position:0%
several different tables to give us a
 

00:00:39.260 --> 00:00:40.779 align:start position:0%
several different tables to give us a
list<00:00:39.440><c> of</c><00:00:39.590><c> all</c><00:00:39.800><c> of</c><00:00:39.980><c> the</c><00:00:40.100><c> items</c><00:00:40.370><c> that</c><00:00:40.460><c> have</c><00:00:40.579><c> been</c>

00:00:40.779 --> 00:00:40.789 align:start position:0%
list of all of the items that have been
 

00:00:40.789 --> 00:00:43.090 align:start position:0%
list of all of the items that have been
ordered<00:00:41.180><c> if</c><00:00:41.329><c> you</c><00:00:42.260><c> look</c><00:00:42.530><c> down</c><00:00:42.680><c> the</c><00:00:42.829><c> list</c><00:00:42.949><c> you</c>

00:00:43.090 --> 00:00:43.100 align:start position:0%
ordered if you look down the list you
 

00:00:43.100 --> 00:00:44.889 align:start position:0%
ordered if you look down the list you
can<00:00:43.280><c> see</c><00:00:43.460><c> that</c><00:00:43.640><c> there's</c><00:00:43.820><c> a</c><00:00:43.879><c> lot</c><00:00:44.210><c> of</c><00:00:44.360><c> repetition</c>

00:00:44.889 --> 00:00:44.899 align:start position:0%
can see that there's a lot of repetition
 

00:00:44.899 --> 00:00:46.810 align:start position:0%
can see that there's a lot of repetition
and<00:00:45.020><c> that's</c><00:00:45.649><c> because</c><00:00:45.980><c> most</c><00:00:46.250><c> of</c><00:00:46.370><c> these</c><00:00:46.489><c> items</c>

00:00:46.810 --> 00:00:46.820 align:start position:0%
and that's because most of these items
 

00:00:46.820 --> 00:00:49.330 align:start position:0%
and that's because most of these items
have<00:00:46.969><c> been</c><00:00:47.000><c> ordered</c><00:00:47.420><c> more</c><00:00:47.629><c> than</c><00:00:47.690><c> once</c><00:00:48.020><c> if</c><00:00:48.340><c> we</c>

00:00:49.330 --> 00:00:49.340 align:start position:0%
have been ordered more than once if we
 

00:00:49.340 --> 00:00:51.700 align:start position:0%
have been ordered more than once if we
change<00:00:49.640><c> this</c><00:00:49.879><c> to</c><00:00:49.940><c> a</c><00:00:50.149><c> totals</c><00:00:50.690><c> query</c><00:00:50.960><c> then</c><00:00:51.500><c> we'll</c>

00:00:51.700 --> 00:00:51.710 align:start position:0%
change this to a totals query then we'll
 

00:00:51.710 --> 00:00:54.279 align:start position:0%
change this to a totals query then we'll
have<00:00:51.890><c> just</c><00:00:52.219><c> one</c><00:00:52.519><c> row</c><00:00:52.730><c> for</c><00:00:52.969><c> each</c><00:00:53.030><c> item</c><00:00:53.359><c> and</c><00:00:53.660><c> the</c>

00:00:54.279 --> 00:00:54.289 align:start position:0%
have just one row for each item and the
 

00:00:54.289 --> 00:00:56.080 align:start position:0%
have just one row for each item and the
values<00:00:54.649><c> and</c><00:00:54.890><c> the</c><00:00:55.010><c> quantity</c><00:00:55.489><c> field</c><00:00:55.670><c> will</c><00:00:55.969><c> be</c>

00:00:56.080 --> 00:00:56.090 align:start position:0%
values and the quantity field will be
 

00:00:56.090 --> 00:00:57.939 align:start position:0%
values and the quantity field will be
added<00:00:56.510><c> up</c><00:00:56.690><c> to</c><00:00:56.930><c> show</c><00:00:57.109><c> us</c><00:00:57.260><c> what</c><00:00:57.410><c> the</c><00:00:57.530><c> total</c><00:00:57.769><c> is</c>

00:00:57.939 --> 00:00:57.949 align:start position:0%
added up to show us what the total is
 

00:00:57.949 --> 00:01:01.360 align:start position:0%
added up to show us what the total is
for<00:00:58.280><c> each</c><00:00:58.429><c> item</c><00:00:59.559><c> first</c><00:01:00.559><c> you'll</c><00:01:00.890><c> need</c><00:01:01.039><c> to</c><00:01:01.190><c> go</c><00:01:01.309><c> to</c>

00:01:01.360 --> 00:01:01.370 align:start position:0%
for each item first you'll need to go to
 

00:01:01.370 --> 00:01:06.249 align:start position:0%
for each item first you'll need to go to
design<00:01:01.879><c> view</c><00:01:02.210><c> and</c><00:01:04.269><c> then</c><00:01:05.269><c> click</c><00:01:05.299><c> the</c><00:01:05.810><c> totals</c>

00:01:06.249 --> 00:01:06.259 align:start position:0%
design view and then click the totals
 

00:01:06.259 --> 00:01:10.210 align:start position:0%
design view and then click the totals
command<00:01:06.619><c> and</c><00:01:07.930><c> the</c><00:01:08.930><c> design</c><00:01:09.320><c> grid</c><00:01:09.619><c> now</c><00:01:09.890><c> has</c><00:01:10.189><c> a</c>

00:01:10.210 --> 00:01:10.220 align:start position:0%
command and the design grid now has a
 

00:01:10.220 --> 00:01:13.060 align:start position:0%
command and the design grid now has a
new<00:01:10.729><c> row</c><00:01:10.939><c> called</c><00:01:11.390><c> the</c><00:01:11.630><c> total</c><00:01:11.840><c> row</c><00:01:12.140><c> and</c><00:01:12.409><c> right</c>

00:01:13.060 --> 00:01:13.070 align:start position:0%
new row called the total row and right
 

00:01:13.070 --> 00:01:15.940 align:start position:0%
new row called the total row and right
now<00:01:13.250><c> all</c><00:01:13.460><c> of</c><00:01:13.490><c> these</c><00:01:13.729><c> say</c><00:01:14.090><c> group-by</c><00:01:14.930><c> but</c><00:01:15.740><c> we're</c>

00:01:15.940 --> 00:01:15.950 align:start position:0%
now all of these say group-by but we're
 

00:01:15.950 --> 00:01:17.770 align:start position:0%
now all of these say group-by but we're
going<00:01:16.130><c> to</c><00:01:16.220><c> change</c><00:01:16.549><c> the</c><00:01:16.729><c> one</c><00:01:16.880><c> in</c><00:01:17.090><c> the</c><00:01:17.270><c> quantity</c>

00:01:17.770 --> 00:01:17.780 align:start position:0%
going to change the one in the quantity
 

00:01:17.780 --> 00:01:20.620 align:start position:0%
going to change the one in the quantity
field<00:01:18.430><c> so</c><00:01:19.430><c> click</c><00:01:19.640><c> the</c><00:01:19.759><c> drop</c><00:01:19.970><c> down</c><00:01:20.000><c> arrow</c>

00:01:20.620 --> 00:01:20.630 align:start position:0%
field so click the drop down arrow
 

00:01:20.630 --> 00:01:23.319 align:start position:0%
field so click the drop down arrow
and<00:01:20.720><c> we're</c><00:01:21.710><c> going</c><00:01:21.890><c> to</c><00:01:21.920><c> select</c><00:01:22.159><c> sum</c><00:01:22.759><c> so</c><00:01:23.090><c> it</c><00:01:23.210><c> will</c>

00:01:23.319 --> 00:01:23.329 align:start position:0%
and we're going to select sum so it will
 

00:01:23.329 --> 00:01:25.569 align:start position:0%
and we're going to select sum so it will
add<00:01:23.509><c> the</c><00:01:23.689><c> values</c><00:01:23.960><c> together</c><00:01:24.140><c> and</c><00:01:24.560><c> there</c><00:01:25.430><c> are</c>

00:01:25.569 --> 00:01:25.579 align:start position:0%
add the values together and there are
 

00:01:25.579 --> 00:01:27.399 align:start position:0%
add the values together and there are
some<00:01:25.850><c> other</c><00:01:26.000><c> options</c><00:01:26.060><c> such</c><00:01:26.720><c> as</c><00:01:26.750><c> average</c>

00:01:27.399 --> 00:01:27.409 align:start position:0%
some other options such as average
 

00:01:27.409 --> 00:01:32.020 align:start position:0%
some other options such as average
minimum<00:01:28.189><c> maximum</c><00:01:29.259><c> count</c><00:01:30.259><c> and</c><00:01:30.590><c> a</c><00:01:30.799><c> few</c><00:01:30.950><c> more</c><00:01:31.130><c> but</c>

00:01:32.020 --> 00:01:32.030 align:start position:0%
minimum maximum count and a few more but
 

00:01:32.030 --> 00:01:35.289 align:start position:0%
minimum maximum count and a few more but
in<00:01:32.180><c> this</c><00:01:32.299><c> case</c><00:01:32.509><c> we</c><00:01:32.750><c> want</c><00:01:32.960><c> to</c><00:01:32.990><c> use</c><00:01:33.049><c> some</c><00:01:34.240><c> now</c><00:01:35.240><c> we</c>

00:01:35.289 --> 00:01:35.299 align:start position:0%
in this case we want to use some now we
 

00:01:35.299 --> 00:01:38.889 align:start position:0%
in this case we want to use some now we
can<00:01:35.780><c> run</c><00:01:36.049><c> the</c><00:01:36.170><c> query</c><00:01:36.409><c> and</c><00:01:37.390><c> you</c><00:01:38.390><c> can</c><00:01:38.540><c> see</c><00:01:38.720><c> that</c>

00:01:38.889 --> 00:01:38.899 align:start position:0%
can run the query and you can see that
 

00:01:38.899 --> 00:01:41.109 align:start position:0%
can run the query and you can see that
there<00:01:39.079><c> is</c><00:01:39.259><c> one</c><00:01:39.619><c> row</c><00:01:39.829><c> for</c><00:01:40.100><c> each</c><00:01:40.159><c> product</c><00:01:40.729><c> and</c>

00:01:41.109 --> 00:01:41.119 align:start position:0%
there is one row for each product and
 

00:01:41.119 --> 00:01:44.440 align:start position:0%
there is one row for each product and
the<00:01:42.020><c> quantity</c><00:01:42.470><c> field</c><00:01:42.710><c> has</c><00:01:42.950><c> changed</c><00:01:42.979><c> to</c><00:01:43.759><c> sum</c><00:01:44.240><c> of</c>

00:01:44.440 --> 00:01:44.450 align:start position:0%
the quantity field has changed to sum of
 

00:01:44.450 --> 00:01:47.200 align:start position:0%
the quantity field has changed to sum of
quantity<00:01:45.110><c> and</c><00:01:45.320><c> this</c><00:01:46.070><c> gives</c><00:01:46.310><c> us</c><00:01:46.460><c> the</c><00:01:46.670><c> total</c><00:01:46.700><c> for</c>

00:01:47.200 --> 00:01:47.210 align:start position:0%
quantity and this gives us the total for
 

00:01:47.210 --> 00:01:50.109 align:start position:0%
quantity and this gives us the total for
each<00:01:47.360><c> item</c><00:01:47.840><c> that</c><00:01:48.520><c> means</c><00:01:49.520><c> we</c><00:01:49.640><c> can</c><00:01:49.759><c> tell</c><00:01:49.909><c> at</c><00:01:50.060><c> a</c>

00:01:50.109 --> 00:01:50.119 align:start position:0%
each item that means we can tell at a
 

00:01:50.119 --> 00:01:52.060 align:start position:0%
each item that means we can tell at a
glance<00:01:50.149><c> that</c><00:01:50.719><c> we've</c><00:01:50.869><c> sold</c><00:01:51.140><c> 12</c><00:01:51.560><c> Christmas</c>

00:01:52.060 --> 00:01:52.070 align:start position:0%
glance that we've sold 12 Christmas
 

00:01:52.070 --> 00:01:56.370 align:start position:0%
glance that we've sold 12 Christmas
cakes<00:01:52.310><c> 9</c><00:01:53.030><c> carrot</c><00:01:53.509><c> cakes</c><00:01:53.719><c> and</c><00:01:53.960><c> 18</c><00:01:54.950><c> cheesecakes</c>

00:01:56.370 --> 00:01:56.380 align:start position:0%
cakes 9 carrot cakes and 18 cheesecakes
 

00:01:56.380 --> 00:01:58.539 align:start position:0%
cakes 9 carrot cakes and 18 cheesecakes
you<00:01:57.380><c> may</c><00:01:57.530><c> notice</c><00:01:57.799><c> this</c><00:01:57.979><c> some</c><00:01:58.280><c> of</c><00:01:58.399><c> these</c>

00:01:58.539 --> 00:01:58.549 align:start position:0%
you may notice this some of these
 

00:01:58.549 --> 00:02:00.249 align:start position:0%
you may notice this some of these
product<00:01:58.909><c> names</c><00:01:59.060><c> appear</c><00:01:59.450><c> on</c><00:01:59.600><c> more</c><00:01:59.930><c> than</c><00:02:00.049><c> one</c>

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

00:02:00.259 --> 00:02:02.170 align:start position:0%
product names appear on more than one
row<00:02:00.469><c> and</c><00:02:00.680><c> that's</c><00:02:01.399><c> because</c><00:02:01.700><c> they</c><00:02:01.820><c> have</c><00:02:01.850><c> more</c>

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

00:02:02.180 --> 00:02:04.569 align:start position:0%
row and that's because they have more
than<00:02:02.360><c> one</c><00:02:02.420><c> sales</c><00:02:02.899><c> unit</c><00:02:03.259><c> for</c><00:02:04.100><c> example</c><00:02:04.189><c> the</c>

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

00:02:04.579 --> 00:02:06.340 align:start position:0%
than one sales unit for example the
chocolate<00:02:04.969><c> chip</c><00:02:05.149><c> cookies</c><00:02:05.539><c> can</c><00:02:05.780><c> be</c><00:02:05.899><c> sold</c><00:02:06.140><c> by</c>

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

00:02:06.350 --> 00:02:07.090 align:start position:0%
chocolate chip cookies can be sold by
the<00:02:06.409><c> half-dozen</c>

00:02:07.090 --> 00:02:07.100 align:start position:0%
the half-dozen
 

00:02:07.100 --> 00:02:09.790 align:start position:0%
the half-dozen
dozen<00:02:07.729><c> or</c><00:02:07.909><c> a</c><00:02:07.969><c> single</c><00:02:08.480><c> cookies</c><00:02:08.900><c> and</c><00:02:09.080><c> these</c><00:02:09.650><c> are</c>

00:02:09.790 --> 00:02:09.800 align:start position:0%
dozen or a single cookies and these are
 

00:02:09.800 --> 00:02:11.710 align:start position:0%
dozen or a single cookies and these are
really<00:02:10.100><c> three</c><00:02:10.460><c> different</c><00:02:10.880><c> products</c><00:02:11.270><c> even</c>

00:02:11.710 --> 00:02:11.720 align:start position:0%
really three different products even
 

00:02:11.720 --> 00:02:14.089 align:start position:0%
really three different products even
though<00:02:11.840><c> they</c><00:02:11.960><c> have</c><00:02:12.110><c> the</c><00:02:12.260><c> same</c><00:02:12.500><c> product</c><00:02:12.830><c> name</c>

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

00:02:14.099 --> 00:02:16.640 align:start position:0%
though they have the same product name
so<00:02:15.030><c> now</c><00:02:15.209><c> that</c><00:02:15.269><c> access</c><00:02:15.780><c> is</c><00:02:15.810><c> calculating</c><00:02:16.499><c> these</c>

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

00:02:16.650 --> 00:02:18.920 align:start position:0%
so now that access is calculating these
totals<00:02:17.010><c> for</c><00:02:17.280><c> us</c><00:02:17.430><c> we're</c><00:02:17.999><c> able</c><00:02:18.180><c> to</c><00:02:18.420><c> get</c><00:02:18.569><c> a</c><00:02:18.599><c> much</c>

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

00:02:18.930 --> 00:02:20.809 align:start position:0%
totals for us we're able to get a much
better<00:02:19.139><c> idea</c><00:02:19.290><c> of</c><00:02:19.680><c> what</c><00:02:20.129><c> people</c><00:02:20.159><c> are</c><00:02:20.579><c> buying</c>

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

00:02:20.819 --> 00:02:23.629 align:start position:0%
better idea of what people are buying
from<00:02:21.060><c> our</c><00:02:21.209><c> bakery</c>