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.610 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.610 --> 00:00:10.620 align:start position:0%
 
 

00:00:10.620 --> 00:00:13.100 align:start position:0%
 
at<00:00:10.880><c> some</c><00:00:11.880><c> point</c><00:00:12.090><c> you're</c><00:00:12.330><c> probably</c><00:00:12.540><c> going</c><00:00:12.930><c> to</c>

00:00:13.100 --> 00:00:13.110 align:start position:0%
at some point you're probably going to
 

00:00:13.110 --> 00:00:14.869 align:start position:0%
at some point you're probably going to
want<00:00:13.320><c> to</c><00:00:13.469><c> present</c><00:00:13.740><c> some</c><00:00:14.190><c> of</c><00:00:14.219><c> your</c><00:00:14.430><c> data</c><00:00:14.580><c> to</c>

00:00:14.869 --> 00:00:14.879 align:start position:0%
want to present some of your data to
 

00:00:14.879 --> 00:00:17.330 align:start position:0%
want to present some of your data to
another<00:00:15.299><c> person</c><00:00:15.780><c> and</c><00:00:15.980><c> access</c><00:00:16.980><c> lets</c><00:00:17.220><c> you</c>

00:00:17.330 --> 00:00:17.340 align:start position:0%
another person and access lets you
 

00:00:17.340 --> 00:00:19.310 align:start position:0%
another person and access lets you
create<00:00:17.700><c> professional</c><00:00:17.730><c> looking</c><00:00:18.660><c> reports</c><00:00:18.840><c> to</c>

00:00:19.310 --> 00:00:19.320 align:start position:0%
create professional looking reports to
 

00:00:19.320 --> 00:00:22.280 align:start position:0%
create professional looking reports to
do<00:00:19.439><c> this</c><00:00:19.759><c> just</c><00:00:20.759><c> like</c><00:00:20.910><c> a</c><00:00:20.939><c> query</c><00:00:21.390><c> a</c><00:00:21.599><c> report</c><00:00:22.080><c> can</c>

00:00:22.280 --> 00:00:22.290 align:start position:0%
do this just like a query a report can
 

00:00:22.290 --> 00:00:23.900 align:start position:0%
do this just like a query a report can
pull<00:00:22.500><c> in</c><00:00:22.650><c> information</c><00:00:23.250><c> from</c><00:00:23.460><c> one</c><00:00:23.730><c> or</c><00:00:23.849><c> more</c>

00:00:23.900 --> 00:00:23.910 align:start position:0%
pull in information from one or more
 

00:00:23.910 --> 00:00:26.510 align:start position:0%
pull in information from one or more
tables<00:00:24.210><c> or</c><00:00:24.630><c> queries</c><00:00:24.900><c> but</c><00:00:25.619><c> it</c><00:00:25.890><c> gives</c><00:00:26.070><c> you</c><00:00:26.189><c> a</c><00:00:26.220><c> lot</c>

00:00:26.510 --> 00:00:26.520 align:start position:0%
tables or queries but it gives you a lot
 

00:00:26.520 --> 00:00:28.490 align:start position:0%
tables or queries but it gives you a lot
more<00:00:26.669><c> control</c><00:00:26.820><c> over</c><00:00:27.090><c> how</c><00:00:27.599><c> the</c><00:00:27.660><c> data</c><00:00:28.020><c> looks</c><00:00:28.320><c> on</c>

00:00:28.490 --> 00:00:28.500 align:start position:0%
more control over how the data looks on
 

00:00:28.500 --> 00:00:30.740 align:start position:0%
more control over how the data looks on
the<00:00:28.649><c> page</c><00:00:28.829><c> in</c><00:00:29.130><c> this</c><00:00:30.000><c> video</c><00:00:30.239><c> we're</c><00:00:30.480><c> just</c><00:00:30.509><c> going</c>

00:00:30.740 --> 00:00:30.750 align:start position:0%
the page in this video we're just going
 

00:00:30.750 --> 00:00:33.440 align:start position:0%
the page in this video we're just going
to<00:00:30.930><c> focus</c><00:00:31.140><c> on</c><00:00:31.500><c> making</c><00:00:31.919><c> a</c><00:00:32.070><c> simple</c><00:00:32.489><c> report</c><00:00:32.820><c> based</c>

00:00:33.440 --> 00:00:33.450 align:start position:0%
to focus on making a simple report based
 

00:00:33.450 --> 00:00:36.740 align:start position:0%
to focus on making a simple report based
on<00:00:33.660><c> a</c><00:00:33.720><c> single</c><00:00:34.110><c> query</c><00:00:34.559><c> I'm</c><00:00:35.180><c> going</c><00:00:36.180><c> to</c><00:00:36.270><c> open</c><00:00:36.570><c> the</c>

00:00:36.740 --> 00:00:36.750 align:start position:0%
on a single query I'm going to open the
 

00:00:36.750 --> 00:00:39.709 align:start position:0%
on a single query I'm going to open the
orders<00:00:37.170><c> query</c><00:00:37.610><c> but</c><00:00:38.610><c> you</c><00:00:38.820><c> can</c><00:00:38.969><c> use</c><00:00:39.120><c> any</c><00:00:39.329><c> table</c>

00:00:39.709 --> 00:00:39.719 align:start position:0%
orders query but you can use any table
 

00:00:39.719 --> 00:00:42.200 align:start position:0%
orders query but you can use any table
or<00:00:39.840><c> query</c><00:00:40.050><c> that</c><00:00:40.290><c> you</c><00:00:40.380><c> want</c><00:00:40.620><c> and</c><00:00:40.969><c> then</c><00:00:41.969><c> in</c><00:00:42.120><c> the</c>

00:00:42.200 --> 00:00:42.210 align:start position:0%
or query that you want and then in the
 

00:00:42.210 --> 00:00:45.009 align:start position:0%
or query that you want and then in the
create<00:00:42.540><c> tab</c><00:00:42.809><c> click</c><00:00:43.350><c> the</c><00:00:43.589><c> report</c><00:00:44.100><c> command</c><00:00:44.519><c> and</c>

00:00:45.009 --> 00:00:45.019 align:start position:0%
create tab click the report command and
 

00:00:45.019 --> 00:00:48.739 align:start position:0%
create tab click the report command and
your<00:00:46.019><c> report</c><00:00:46.379><c> should</c><00:00:46.559><c> instantly</c><00:00:47.039><c> appear</c><00:00:47.749><c> now</c>

00:00:48.739 --> 00:00:48.749 align:start position:0%
your report should instantly appear now
 

00:00:48.749 --> 00:00:50.299 align:start position:0%
your report should instantly appear now
it's<00:00:48.960><c> probably</c><00:00:49.350><c> not</c><00:00:49.530><c> going</c><00:00:49.769><c> to</c><00:00:49.859><c> look</c><00:00:50.039><c> perfect</c>

00:00:50.299 --> 00:00:50.309 align:start position:0%
it's probably not going to look perfect
 

00:00:50.309 --> 00:00:52.639 align:start position:0%
it's probably not going to look perfect
so<00:00:50.760><c> at</c><00:00:51.390><c> this</c><00:00:51.510><c> point</c><00:00:51.719><c> you</c><00:00:51.929><c> can</c><00:00:52.109><c> clean</c><00:00:52.379><c> up</c><00:00:52.499><c> the</c>

00:00:52.639 --> 00:00:52.649 align:start position:0%
so at this point you can clean up the
 

00:00:52.649 --> 00:00:54.709 align:start position:0%
so at this point you can clean up the
layout<00:00:52.949><c> and</c><00:00:53.129><c> to</c><00:00:54.030><c> do</c><00:00:54.149><c> this</c><00:00:54.269><c> you'll</c><00:00:54.480><c> need</c><00:00:54.629><c> to</c>

00:00:54.709 --> 00:00:54.719 align:start position:0%
layout and to do this you'll need to
 

00:00:54.719 --> 00:00:58.389 align:start position:0%
layout and to do this you'll need to
make<00:00:54.839><c> sure</c><00:00:54.899><c> that</c><00:00:55.260><c> you're</c><00:00:55.379><c> in</c><00:00:55.499><c> layout</c><00:00:55.710><c> view</c><00:00:56.239><c> in</c>

00:00:58.389 --> 00:00:58.399 align:start position:0%
make sure that you're in layout view in
 

00:00:58.399 --> 00:01:00.889 align:start position:0%
make sure that you're in layout view in
this<00:00:59.399><c> report</c><00:00:59.850><c> some</c><00:01:00.089><c> of</c><00:01:00.120><c> these</c><00:01:00.359><c> columns</c><00:01:00.749><c> are</c>

00:01:00.889 --> 00:01:00.899 align:start position:0%
this report some of these columns are
 

00:01:00.899 --> 00:01:04.009 align:start position:0%
this report some of these columns are
too<00:01:01.170><c> wide</c><00:01:01.379><c> so</c><00:01:02.039><c> I</c><00:01:02.069><c> need</c><00:01:02.460><c> to</c><00:01:02.609><c> adjust</c><00:01:02.730><c> them</c><00:01:03.120><c> when</c>

00:01:04.009 --> 00:01:04.019 align:start position:0%
too wide so I need to adjust them when
 

00:01:04.019 --> 00:01:05.509 align:start position:0%
too wide so I need to adjust them when
you<00:01:04.140><c> click</c><00:01:04.320><c> on</c><00:01:04.440><c> a</c><00:01:04.470><c> column</c><00:01:04.830><c> a</c><00:01:04.949><c> yellow</c><00:01:05.280><c> border</c>

00:01:05.509 --> 00:01:05.519 align:start position:0%
you click on a column a yellow border
 

00:01:05.519 --> 00:01:07.790 align:start position:0%
you click on a column a yellow border
will<00:01:05.730><c> appear</c><00:01:06.150><c> and</c><00:01:06.330><c> you</c><00:01:07.140><c> can</c><00:01:07.260><c> drag</c><00:01:07.440><c> the</c><00:01:07.500><c> edge</c><00:01:07.770><c> to</c>

00:01:07.790 --> 00:01:07.800 align:start position:0%
will appear and you can drag the edge to
 

00:01:07.800 --> 00:01:10.430 align:start position:0%
will appear and you can drag the edge to
change<00:01:08.370><c> the</c><00:01:08.580><c> width</c><00:01:08.760><c> and</c><00:01:09.060><c> I'm</c><00:01:09.840><c> adjusting</c><00:01:10.110><c> each</c>

00:01:10.430 --> 00:01:10.440 align:start position:0%
change the width and I'm adjusting each
 

00:01:10.440 --> 00:01:12.110 align:start position:0%
change the width and I'm adjusting each
column<00:01:10.860><c> just</c><00:01:11.159><c> enough</c><00:01:11.520><c> to</c><00:01:11.640><c> make</c><00:01:11.760><c> everything</c>

00:01:12.110 --> 00:01:12.120 align:start position:0%
column just enough to make everything
 

00:01:12.120 --> 00:01:14.720 align:start position:0%
column just enough to make everything
fit<00:01:12.510><c> on</c><00:01:12.659><c> the</c><00:01:12.780><c> page</c><00:01:13.050><c> if</c><00:01:13.320><c> you</c><00:01:14.070><c> make</c><00:01:14.220><c> your</c><00:01:14.340><c> columns</c>

00:01:14.720 --> 00:01:14.730 align:start position:0%
fit on the page if you make your columns
 

00:01:14.730 --> 00:01:16.550 align:start position:0%
fit on the page if you make your columns
too<00:01:15.000><c> narrow</c><00:01:15.270><c> then</c><00:01:15.630><c> you</c><00:01:15.780><c> may</c><00:01:15.900><c> cut</c><00:01:16.170><c> off</c><00:01:16.200><c> some</c><00:01:16.530><c> of</c>

00:01:16.550 --> 00:01:16.560 align:start position:0%
too narrow then you may cut off some of
 

00:01:16.560 --> 00:01:20.240 align:start position:0%
too narrow then you may cut off some of
your<00:01:16.680><c> data</c><00:01:18.230><c> you</c><00:01:19.230><c> can</c><00:01:19.260><c> also</c><00:01:19.500><c> get</c><00:01:19.890><c> rid</c><00:01:20.010><c> of</c><00:01:20.070><c> any</c>

00:01:20.240 --> 00:01:20.250 align:start position:0%
your data you can also get rid of any
 

00:01:20.250 --> 00:01:22.670 align:start position:0%
your data you can also get rid of any
extra<00:01:20.670><c> fields</c><00:01:21.090><c> that</c><00:01:21.180><c> you</c><00:01:21.300><c> don't</c><00:01:21.480><c> need</c><00:01:21.720><c> we</c>

00:01:22.670 --> 00:01:22.680 align:start position:0%
extra fields that you don't need we
 

00:01:22.680 --> 00:01:24.260 align:start position:0%
extra fields that you don't need we
probably<00:01:22.920><c> don't</c><00:01:23.220><c> need</c><00:01:23.370><c> the</c><00:01:23.610><c> zip</c><00:01:23.790><c> code</c><00:01:24.000><c> in</c><00:01:24.150><c> this</c>

00:01:24.260 --> 00:01:24.270 align:start position:0%
probably don't need the zip code in this
 

00:01:24.270 --> 00:01:26.750 align:start position:0%
probably don't need the zip code in this
report<00:01:24.660><c> so</c><00:01:25.440><c> I'll</c><00:01:25.650><c> delete</c><00:01:26.010><c> it</c><00:01:26.190><c> by</c><00:01:26.340><c> pressing</c><00:01:26.580><c> the</c>

00:01:26.750 --> 00:01:26.760 align:start position:0%
report so I'll delete it by pressing the
 

00:01:26.760 --> 00:01:29.390 align:start position:0%
report so I'll delete it by pressing the
Delete<00:01:27.030><c> key</c><00:01:27.210><c> and</c><00:01:27.660><c> I'll</c><00:01:28.590><c> also</c><00:01:28.800><c> delete</c><00:01:29.220><c> the</c>

00:01:29.390 --> 00:01:29.400 align:start position:0%
Delete key and I'll also delete the
 

00:01:29.400 --> 00:01:32.710 align:start position:0%
Delete key and I'll also delete the
title<00:01:29.550><c> and</c><00:01:29.880><c> these</c><00:01:30.360><c> empty</c><00:01:30.750><c> cells</c>

00:01:32.710 --> 00:01:32.720 align:start position:0%
title and these empty cells
 

00:01:32.720 --> 00:01:34.810 align:start position:0%
title and these empty cells
I'm<00:01:33.350><c> going</c><00:01:33.680><c> to</c><00:01:33.830><c> scroll</c><00:01:34.250><c> through</c><00:01:34.310><c> the</c><00:01:34.670><c> report</c>

00:01:34.810 --> 00:01:34.820 align:start position:0%
I'm going to scroll through the report
 

00:01:34.820 --> 00:01:36.400 align:start position:0%
I'm going to scroll through the report
now<00:01:35.150><c> to</c><00:01:35.210><c> make</c><00:01:35.540><c> sure</c><00:01:35.570><c> that</c><00:01:35.930><c> everything</c><00:01:36.290><c> looks</c>

00:01:36.400 --> 00:01:36.410 align:start position:0%
now to make sure that everything looks
 

00:01:36.410 --> 00:01:39.100 align:start position:0%
now to make sure that everything looks
right<00:01:36.710><c> and</c><00:01:36.950><c> if</c><00:01:37.940><c> any</c><00:01:38.090><c> elements</c><00:01:38.540><c> are</c><00:01:38.630><c> outside</c>

00:01:39.100 --> 00:01:39.110 align:start position:0%
right and if any elements are outside
 

00:01:39.110 --> 00:01:40.810 align:start position:0%
right and if any elements are outside
this<00:01:39.320><c> dotted</c><00:01:39.590><c> line</c><00:01:39.740><c> then</c><00:01:40.400><c> they're</c><00:01:40.550><c> going</c><00:01:40.730><c> to</c>

00:01:40.810 --> 00:01:40.820 align:start position:0%
this dotted line then they're going to
 

00:01:40.820 --> 00:01:43.270 align:start position:0%
this dotted line then they're going to
be<00:01:40.910><c> off</c><00:01:41.090><c> the</c><00:01:41.120><c> page</c><00:01:41.570><c> when</c><00:01:41.840><c> you</c><00:01:41.930><c> print</c><00:01:42.170><c> it</c><00:01:42.260><c> so</c><00:01:43.130><c> I'm</c>

00:01:43.270 --> 00:01:43.280 align:start position:0%
be off the page when you print it so I'm
 

00:01:43.280 --> 00:01:45.400 align:start position:0%
be off the page when you print it so I'm
going<00:01:43.460><c> to</c><00:01:43.580><c> drag</c><00:01:44.150><c> this</c><00:01:44.360><c> page</c><00:01:44.660><c> number</c><00:01:45.020><c> over</c><00:01:45.290><c> to</c>

00:01:45.400 --> 00:01:45.410 align:start position:0%
going to drag this page number over to
 

00:01:45.410 --> 00:01:51.430 align:start position:0%
going to drag this page number over to
the<00:01:45.500><c> left</c><00:01:49.420><c> now</c><00:01:50.420><c> one</c><00:01:50.660><c> thing</c><00:01:50.810><c> you</c><00:01:50.900><c> can't</c><00:01:51.260><c> do</c>

00:01:51.430 --> 00:01:51.440 align:start position:0%
the left now one thing you can't do
 

00:01:51.440 --> 00:01:53.980 align:start position:0%
the left now one thing you can't do
within<00:01:51.650><c> report</c><00:01:52.160><c> is</c><00:01:52.340><c> edit</c><00:01:52.730><c> records</c><00:01:53.240><c> however</c>

00:01:53.980 --> 00:01:53.990 align:start position:0%
within report is edit records however
 

00:01:53.990 --> 00:01:57.190 align:start position:0%
within report is edit records however
you<00:01:54.380><c> can</c><00:01:54.680><c> sort</c><00:01:55.100><c> and</c><00:01:55.250><c> filter</c><00:01:55.340><c> them</c><00:01:55.880><c> I</c><00:01:56.060><c> want</c><00:01:57.020><c> to</c>

00:01:57.190 --> 00:01:57.200 align:start position:0%
you can sort and filter them I want to
 

00:01:57.200 --> 00:01:59.950 align:start position:0%
you can sort and filter them I want to
just<00:01:57.560><c> show</c><00:01:57.890><c> the</c><00:01:58.070><c> orders</c><00:01:58.100><c> from</c><00:01:58.700><c> December</c><00:01:59.270><c> so</c>

00:01:59.950 --> 00:01:59.960 align:start position:0%
just show the orders from December so
 

00:01:59.960 --> 00:02:02.110 align:start position:0%
just show the orders from December so
I'll<00:02:00.230><c> right-click</c><00:02:00.680><c> the</c><00:02:01.130><c> pickup</c><00:02:01.460><c> date</c><00:02:01.670><c> column</c>

00:02:02.110 --> 00:02:02.120 align:start position:0%
I'll right-click the pickup date column
 

00:02:02.120 --> 00:02:06.880 align:start position:0%
I'll right-click the pickup date column
and<00:02:02.290><c> then</c><00:02:03.290><c> go</c><00:02:03.530><c> to</c><00:02:03.590><c> date</c><00:02:04.070><c> filters</c><00:02:04.550><c> all</c><00:02:05.650><c> dates</c><00:02:06.650><c> in</c>

00:02:06.880 --> 00:02:06.890 align:start position:0%
and then go to date filters all dates in
 

00:02:06.890 --> 00:02:11.440 align:start position:0%
and then go to date filters all dates in
period<00:02:07.340><c> and</c><00:02:07.520><c> select</c><00:02:08.390><c> December</c><00:02:09.200><c> and</c><00:02:10.300><c> I'd</c><00:02:11.300><c> also</c>

00:02:11.440 --> 00:02:11.450 align:start position:0%
period and select December and I'd also
 

00:02:11.450 --> 00:02:13.750 align:start position:0%
period and select December and I'd also
like<00:02:11.630><c> these</c><00:02:11.930><c> dates</c><00:02:12.170><c> to</c><00:02:12.320><c> be</c><00:02:12.440><c> sorted</c><00:02:12.890><c> I'll</c>

00:02:13.750 --> 00:02:13.760 align:start position:0%
like these dates to be sorted I'll
 

00:02:13.760 --> 00:02:16.870 align:start position:0%
like these dates to be sorted I'll
right-click<00:02:14.209><c> them</c><00:02:14.570><c> again</c><00:02:14.840><c> and</c><00:02:15.190><c> choose</c><00:02:16.190><c> sort</c>

00:02:16.870 --> 00:02:16.880 align:start position:0%
right-click them again and choose sort
 

00:02:16.880 --> 00:02:22.020 align:start position:0%
right-click them again and choose sort
oldest<00:02:17.360><c> to</c><00:02:17.540><c> newest</c>

00:02:22.020 --> 00:02:22.030 align:start position:0%
 
 

00:02:22.030 --> 00:02:24.400 align:start position:0%
 
when<00:02:23.030><c> you're</c><00:02:23.150><c> done</c><00:02:23.300><c> changing</c><00:02:23.720><c> the</c><00:02:23.840><c> layout</c><00:02:24.020><c> you</c>

00:02:24.400 --> 00:02:24.410 align:start position:0%
when you're done changing the layout you
 

00:02:24.410 --> 00:02:27.610 align:start position:0%
when you're done changing the layout you
can<00:02:24.620><c> switch</c><00:02:24.920><c> to</c><00:02:24.950><c> report</c><00:02:25.640><c> view</c><00:02:25.910><c> and</c><00:02:26.440><c> this</c><00:02:27.440><c> will</c>

00:02:27.610 --> 00:02:27.620 align:start position:0%
can switch to report view and this will
 

00:02:27.620 --> 00:02:29.140 align:start position:0%
can switch to report view and this will
let<00:02:27.710><c> you</c><00:02:27.860><c> view</c><00:02:28.070><c> it</c><00:02:28.100><c> without</c><00:02:28.310><c> the</c><00:02:28.700><c> gridlines</c>

00:02:29.140 --> 00:02:29.150 align:start position:0%
let you view it without the gridlines
 

00:02:29.150 --> 00:02:32.940 align:start position:0%
let you view it without the gridlines
and<00:02:30.310><c> finally</c><00:02:31.310><c> we</c><00:02:31.490><c> should</c><00:02:31.670><c> save</c><00:02:31.910><c> this</c><00:02:32.090><c> report</c>

00:02:32.940 --> 00:02:32.950 align:start position:0%
and finally we should save this report
 

00:02:32.950 --> 00:02:41.290 align:start position:0%
and finally we should save this report
I'll<00:02:33.950><c> call</c><00:02:34.310><c> it</c><00:02:34.460><c> December</c><00:02:34.970><c> orders</c><00:02:37.150><c> and</c><00:02:40.240><c> now</c><00:02:41.240><c> we</c>

00:02:41.290 --> 00:02:41.300 align:start position:0%
I'll call it December orders and now we
 

00:02:41.300 --> 00:02:43.090 align:start position:0%
I'll call it December orders and now we
have<00:02:41.630><c> a</c><00:02:41.660><c> report</c><00:02:42.080><c> that</c><00:02:42.200><c> we</c><00:02:42.320><c> can</c><00:02:42.470><c> come</c><00:02:42.680><c> back</c><00:02:42.830><c> to</c>

00:02:43.090 --> 00:02:43.100 align:start position:0%
have a report that we can come back to
 

00:02:43.100 --> 00:02:44.560 align:start position:0%
have a report that we can come back to
at<00:02:43.280><c> any</c><00:02:43.490><c> time</c><00:02:43.730><c> if</c><00:02:43.970><c> we</c><00:02:44.120><c> want</c><00:02:44.330><c> to</c><00:02:44.360><c> make</c><00:02:44.540><c> changes</c>

00:02:44.560 --> 00:02:44.570 align:start position:0%
at any time if we want to make changes
 

00:02:44.570 --> 00:02:47.560 align:start position:0%
at any time if we want to make changes
or<00:02:45.140><c> print</c><00:02:45.470><c> it</c>