WEBVTT
Kind: captions
Language: en

00:00:01.149 --> 00:00:03.729 align:start position:0%
 
Goodwill<00:00:02.149><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.170 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:08.170 --> 00:00:08.180 align:start position:0%
 
 

00:00:08.180 --> 00:00:11.080 align:start position:0%
 
at<00:00:08.830><c> some</c><00:00:09.830><c> point</c><00:00:10.070><c> you're</c><00:00:10.280><c> probably</c><00:00:10.430><c> going</c><00:00:10.970><c> to</c>

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

00:00:11.090 --> 00:00:12.670 align:start position:0%
at some point you're probably going to
want<00:00:11.210><c> to</c><00:00:11.330><c> present</c><00:00:11.690><c> some</c><00:00:12.140><c> of</c><00:00:12.170><c> your</c><00:00:12.380><c> data</c><00:00:12.590><c> to</c>

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

00:00:12.680 --> 00:00:15.280 align:start position:0%
want to present some of your data to
another<00:00:13.310><c> person</c><00:00:13.730><c> and</c><00:00:13.930><c> access</c><00:00:14.930><c> lets</c><00:00:15.170><c> you</c>

00:00:15.280 --> 00:00:15.290 align:start position:0%
another person and access lets you
 

00:00:15.290 --> 00:00:17.260 align:start position:0%
another person and access lets you
create<00:00:15.470><c> professional</c><00:00:16.340><c> looking</c><00:00:16.369><c> reports</c><00:00:16.790><c> to</c>

00:00:17.260 --> 00:00:17.270 align:start position:0%
create professional looking reports to
 

00:00:17.270 --> 00:00:20.410 align:start position:0%
create professional looking reports to
do<00:00:17.420><c> this</c><00:00:17.890><c> just</c><00:00:18.890><c> like</c><00:00:19.040><c> a</c><00:00:19.070><c> query</c><00:00:19.550><c> a</c><00:00:19.760><c> report</c><00:00:20.240><c> can</c>

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

00:00:20.420 --> 00:00:22.120 align:start position:0%
do this just like a query a report can
pull<00:00:20.660><c> in</c><00:00:20.810><c> information</c><00:00:21.380><c> from</c><00:00:21.619><c> one</c><00:00:21.890><c> or</c><00:00:22.010><c> more</c>

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

00:00:22.130 --> 00:00:24.670 align:start position:0%
pull in information from one or more
tables<00:00:22.369><c> or</c><00:00:22.760><c> queries</c><00:00:23.060><c> but</c><00:00:23.779><c> it</c><00:00:24.050><c> gives</c><00:00:24.230><c> you</c><00:00:24.320><c> a</c><00:00:24.380><c> lot</c>

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

00:00:24.680 --> 00:00:26.650 align:start position:0%
tables or queries but it gives you a lot
more<00:00:24.710><c> control</c><00:00:25.130><c> over</c><00:00:25.250><c> how</c><00:00:25.760><c> the</c><00:00:25.820><c> data</c><00:00:26.180><c> looks</c><00:00:26.450><c> on</c>

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

00:00:26.660 --> 00:00:28.960 align:start position:0%
more control over how the data looks on
the<00:00:26.810><c> page</c><00:00:26.990><c> in</c><00:00:27.289><c> this</c><00:00:28.100><c> video</c><00:00:28.340><c> we're</c><00:00:28.580><c> just</c><00:00:28.789><c> going</c>

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

00:00:28.970 --> 00:00:31.540 align:start position:0%
the page in this video we're just going
to<00:00:29.000><c> focus</c><00:00:29.210><c> on</c><00:00:29.570><c> making</c><00:00:29.810><c> a</c><00:00:30.140><c> simple</c><00:00:30.590><c> report</c><00:00:30.920><c> based</c>

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

00:00:31.550 --> 00:00:34.810 align:start position:0%
to focus on making a simple report based
on<00:00:31.760><c> a</c><00:00:31.820><c> single</c><00:00:32.210><c> query</c><00:00:32.890><c> I'm</c><00:00:33.890><c> going</c><00:00:34.280><c> to</c><00:00:34.370><c> open</c><00:00:34.640><c> the</c>

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

00:00:34.820 --> 00:00:37.810 align:start position:0%
on a single query I'm going to open the
orders<00:00:35.239><c> query</c><00:00:35.680><c> but</c><00:00:36.680><c> you</c><00:00:36.920><c> can</c><00:00:37.040><c> use</c><00:00:37.190><c> any</c><00:00:37.400><c> table</c>

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

00:00:37.820 --> 00:00:40.270 align:start position:0%
orders query but you can use any table
or<00:00:37.910><c> query</c><00:00:38.120><c> that</c><00:00:38.360><c> you</c><00:00:38.449><c> want</c><00:00:38.690><c> and</c><00:00:39.040><c> then</c><00:00:40.040><c> in</c><00:00:40.190><c> the</c>

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

00:00:40.280 --> 00:00:43.110 align:start position:0%
or query that you want and then in the
create<00:00:40.640><c> tab</c><00:00:40.910><c> click</c><00:00:41.420><c> the</c><00:00:41.690><c> report</c><00:00:42.200><c> command</c><00:00:42.590><c> and</c>

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

00:00:43.120 --> 00:00:46.810 align:start position:0%
create tab click the report command and
your<00:00:44.120><c> report</c><00:00:44.480><c> should</c><00:00:44.690><c> instantly</c><00:00:45.140><c> appear</c><00:00:45.820><c> now</c>

00:00:46.810 --> 00:00:46.820 align:start position:0%
your report should instantly appear now
 

00:00:46.820 --> 00:00:48.400 align:start position:0%
your report should instantly appear now
it's<00:00:47.030><c> probably</c><00:00:47.420><c> not</c><00:00:47.630><c> going</c><00:00:47.840><c> to</c><00:00:47.930><c> look</c><00:00:48.140><c> perfect</c>

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

00:00:48.410 --> 00:00:50.710 align:start position:0%
it's probably not going to look perfect
so<00:00:48.829><c> at</c><00:00:49.460><c> this</c><00:00:49.610><c> point</c><00:00:49.880><c> you</c><00:00:50.030><c> can</c><00:00:50.210><c> clean</c><00:00:50.450><c> up</c><00:00:50.600><c> the</c>

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

00:00:50.720 --> 00:00:52.810 align:start position:0%
so at this point you can clean up the
layout<00:00:51.050><c> and</c><00:00:51.230><c> to</c><00:00:52.100><c> do</c><00:00:52.220><c> this</c><00:00:52.370><c> you'll</c><00:00:52.550><c> need</c><00:00:52.670><c> to</c>

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

00:00:52.820 --> 00:00:55.860 align:start position:0%
layout and to do this you'll need to
make<00:00:52.910><c> sure</c><00:00:52.969><c> that</c><00:00:53.329><c> you're</c><00:00:53.480><c> in</c><00:00:53.570><c> layout</c><00:00:53.780><c> view</c><00:00:53.930><c> in</c>

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

00:00:55.870 --> 00:00:58.420 align:start position:0%
make sure that you're in layout view in
this<00:00:56.870><c> report</c><00:00:57.320><c> some</c><00:00:57.590><c> of</c><00:00:57.620><c> these</c><00:00:57.829><c> columns</c><00:00:58.250><c> are</c>

00:00:58.420 --> 00:00:58.430 align:start position:0%
this report some of these columns are
 

00:00:58.430 --> 00:01:01.479 align:start position:0%
this report some of these columns are
too<00:00:58.670><c> wide</c><00:00:58.880><c> so</c><00:00:59.510><c> I</c><00:00:59.540><c> need</c><00:00:59.930><c> to</c><00:01:00.079><c> adjust</c><00:01:00.200><c> them</c><00:01:00.620><c> when</c>

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

00:01:01.489 --> 00:01:02.979 align:start position:0%
too wide so I need to adjust them when
you<00:01:01.610><c> click</c><00:01:01.790><c> on</c><00:01:01.879><c> a</c><00:01:01.940><c> column</c><00:01:02.329><c> a</c><00:01:02.450><c> yellow</c><00:01:02.750><c> border</c>

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

00:01:02.989 --> 00:01:05.260 align:start position:0%
you click on a column a yellow border
will<00:01:03.230><c> appear</c><00:01:03.649><c> and</c><00:01:03.829><c> you</c><00:01:04.640><c> can</c><00:01:04.759><c> drag</c><00:01:04.940><c> the</c><00:01:05.119><c> edge</c><00:01:05.239><c> to</c>

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

00:01:05.270 --> 00:01:07.930 align:start position:0%
will appear and you can drag the edge to
change<00:01:05.840><c> the</c><00:01:06.080><c> width</c><00:01:06.259><c> and</c><00:01:06.530><c> I'm</c><00:01:07.340><c> adjusting</c><00:01:07.610><c> each</c>

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

00:01:07.940 --> 00:01:09.580 align:start position:0%
change the width and I'm adjusting each
column<00:01:08.330><c> just</c><00:01:08.630><c> enough</c><00:01:08.990><c> to</c><00:01:09.140><c> make</c><00:01:09.259><c> everything</c>

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

00:01:09.590 --> 00:01:12.190 align:start position:0%
column just enough to make everything
fit<00:01:09.979><c> on</c><00:01:10.130><c> the</c><00:01:10.280><c> page</c><00:01:10.520><c> if</c><00:01:10.789><c> you</c><00:01:11.570><c> make</c><00:01:11.720><c> your</c><00:01:11.869><c> columns</c>

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

00:01:12.200 --> 00:01:14.050 align:start position:0%
fit on the page if you make your columns
too<00:01:12.500><c> narrow</c><00:01:12.770><c> then</c><00:01:13.100><c> you</c><00:01:13.250><c> may</c><00:01:13.400><c> cut</c><00:01:13.670><c> off</c><00:01:13.700><c> some</c><00:01:14.030><c> of</c>

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

00:01:14.060 --> 00:01:16.719 align:start position:0%
too narrow then you may cut off some of
your<00:01:14.150><c> data</c>

00:01:16.719 --> 00:01:16.729 align:start position:0%
 
 

00:01:16.729 --> 00:01:19.580 align:start position:0%
 
you<00:01:17.729><c> can</c><00:01:17.880><c> also</c><00:01:17.999><c> get</c><00:01:18.359><c> rid</c><00:01:18.539><c> of</c><00:01:18.600><c> any</c><00:01:18.780><c> extra</c><00:01:19.170><c> fields</c>

00:01:19.580 --> 00:01:19.590 align:start position:0%
you can also get rid of any extra fields
 

00:01:19.590 --> 00:01:21.739 align:start position:0%
you can also get rid of any extra fields
that<00:01:19.710><c> you</c><00:01:19.799><c> don't</c><00:01:19.979><c> need</c><00:01:20.219><c> we</c><00:01:21.210><c> probably</c><00:01:21.420><c> don't</c>

00:01:21.739 --> 00:01:21.749 align:start position:0%
that you don't need we probably don't
 

00:01:21.749 --> 00:01:24.169 align:start position:0%
that you don't need we probably don't
need<00:01:21.960><c> the</c><00:01:22.109><c> ZIP</c><00:01:22.289><c> code</c><00:01:22.499><c> in</c><00:01:22.530><c> this</c><00:01:22.740><c> report</c><00:01:23.159><c> so</c><00:01:23.939><c> I'll</c>

00:01:24.169 --> 00:01:24.179 align:start position:0%
need the ZIP code in this report so I'll
 

00:01:24.179 --> 00:01:26.149 align:start position:0%
need the ZIP code in this report so I'll
delete<00:01:24.420><c> it</c><00:01:24.689><c> by</c><00:01:24.840><c> pressing</c><00:01:24.869><c> the</c><00:01:25.380><c> Delete</c><00:01:25.679><c> key</c><00:01:25.710><c> and</c>

00:01:26.149 --> 00:01:26.159 align:start position:0%
delete it by pressing the Delete key and
 

00:01:26.159 --> 00:01:28.880 align:start position:0%
delete it by pressing the Delete key and
I'll<00:01:27.119><c> also</c><00:01:27.299><c> delete</c><00:01:27.750><c> the</c><00:01:27.899><c> title</c><00:01:28.079><c> and</c><00:01:28.380><c> these</c>

00:01:28.880 --> 00:01:28.890 align:start position:0%
I'll also delete the title and these
 

00:01:28.890 --> 00:01:34.219 align:start position:0%
I'll also delete the title and these
empty<00:01:29.250><c> cells</c><00:01:31.969><c> I'm</c><00:01:32.969><c> going</c><00:01:33.329><c> to</c><00:01:33.479><c> scroll</c><00:01:33.899><c> through</c>

00:01:34.219 --> 00:01:34.229 align:start position:0%
empty cells I'm going to scroll through
 

00:01:34.229 --> 00:01:35.539 align:start position:0%
empty cells I'm going to scroll through
the<00:01:34.350><c> report</c><00:01:34.469><c> now</c><00:01:34.799><c> to</c><00:01:34.859><c> make</c><00:01:35.189><c> sure</c><00:01:35.369><c> that</c>

00:01:35.539 --> 00:01:35.549 align:start position:0%
the report now to make sure that
 

00:01:35.549 --> 00:01:37.880 align:start position:0%
the report now to make sure that
everything<00:01:35.939><c> looks</c><00:01:36.119><c> right</c><00:01:36.390><c> and</c><00:01:36.770><c> if</c><00:01:37.770><c> any</c>

00:01:37.880 --> 00:01:37.890 align:start position:0%
everything looks right and if any
 

00:01:37.890 --> 00:01:39.529 align:start position:0%
everything looks right and if any
elements<00:01:38.369><c> are</c><00:01:38.459><c> outside</c><00:01:38.909><c> this</c><00:01:39.119><c> dotted</c><00:01:39.420><c> line</c>

00:01:39.529 --> 00:01:39.539 align:start position:0%
elements are outside this dotted line
 

00:01:39.539 --> 00:01:41.389 align:start position:0%
elements are outside this dotted line
then<00:01:40.200><c> they're</c><00:01:40.380><c> going</c><00:01:40.560><c> to</c><00:01:40.619><c> be</c><00:01:40.709><c> off</c><00:01:40.920><c> the</c><00:01:40.950><c> page</c>

00:01:41.389 --> 00:01:41.399 align:start position:0%
then they're going to be off the page
 

00:01:41.399 --> 00:01:43.940 align:start position:0%
then they're going to be off the page
when<00:01:41.640><c> you</c><00:01:41.729><c> print</c><00:01:42.000><c> it</c><00:01:42.060><c> so</c><00:01:42.929><c> I'm</c><00:01:43.109><c> going</c><00:01:43.349><c> to</c><00:01:43.530><c> drag</c>

00:01:43.940 --> 00:01:43.950 align:start position:0%
when you print it so I'm going to drag
 

00:01:43.950 --> 00:01:50.809 align:start position:0%
when you print it so I'm going to drag
this<00:01:44.189><c> page</c><00:01:44.490><c> number</c><00:01:44.819><c> over</c><00:01:45.119><c> to</c><00:01:45.240><c> the</c><00:01:45.329><c> left</c><00:01:49.819><c> now</c>

00:01:50.809 --> 00:01:50.819 align:start position:0%
this page number over to the left now
 

00:01:50.819 --> 00:01:52.279 align:start position:0%
this page number over to the left now
one<00:01:51.030><c> thing</c><00:01:51.179><c> you</c><00:01:51.299><c> can't</c><00:01:51.629><c> do</c><00:01:51.840><c> within</c><00:01:52.110><c> a</c><00:01:52.140><c> report</c>

00:01:52.279 --> 00:01:52.289 align:start position:0%
one thing you can't do within a report
 

00:01:52.289 --> 00:01:55.609 align:start position:0%
one thing you can't do within a report
is<00:01:52.709><c> edit</c><00:01:53.129><c> records</c><00:01:53.610><c> however</c><00:01:54.360><c> you</c><00:01:54.780><c> can</c><00:01:55.049><c> sort</c><00:01:55.469><c> and</c>

00:01:55.609 --> 00:01:55.619 align:start position:0%
is edit records however you can sort and
 

00:01:55.619 --> 00:01:58.309 align:start position:0%
is edit records however you can sort and
filter<00:01:55.709><c> them</c><00:01:56.250><c> I</c><00:01:56.429><c> want</c><00:01:57.420><c> to</c><00:01:57.479><c> just</c><00:01:57.959><c> show</c><00:01:58.289><c> the</c>

00:01:58.309 --> 00:01:58.319 align:start position:0%
filter them I want to just show the
 

00:01:58.319 --> 00:02:01.069 align:start position:0%
filter them I want to just show the
orders<00:01:58.500><c> from</c><00:01:59.009><c> December</c><00:01:59.640><c> so</c><00:02:00.329><c> I'll</c><00:02:00.629><c> right-click</c>

00:02:01.069 --> 00:02:01.079 align:start position:0%
orders from December so I'll right-click
 

00:02:01.079 --> 00:02:03.949 align:start position:0%
orders from December so I'll right-click
the<00:02:01.530><c> pickup</c><00:02:01.860><c> date</c><00:02:02.009><c> column</c><00:02:02.489><c> and</c><00:02:02.689><c> then</c><00:02:03.689><c> go</c><00:02:03.899><c> to</c>

00:02:03.949 --> 00:02:03.959 align:start position:0%
the pickup date column and then go to
 

00:02:03.959 --> 00:02:08.119 align:start position:0%
the pickup date column and then go to
date<00:02:04.439><c> filters</c><00:02:04.950><c> all</c><00:02:06.259><c> dates</c><00:02:07.259><c> in</c><00:02:07.500><c> period</c><00:02:07.950><c> and</c>

00:02:08.119 --> 00:02:08.129 align:start position:0%
date filters all dates in period and
 

00:02:08.129 --> 00:02:12.619 align:start position:0%
date filters all dates in period and
select<00:02:09.000><c> December</c><00:02:09.810><c> and</c><00:02:11.000><c> I'd</c><00:02:12.000><c> also</c><00:02:12.180><c> like</c><00:02:12.420><c> these</c>

00:02:12.619 --> 00:02:12.629 align:start position:0%
select December and I'd also like these
 

00:02:12.629 --> 00:02:15.259 align:start position:0%
select December and I'd also like these
dates<00:02:12.870><c> to</c><00:02:13.049><c> be</c><00:02:13.170><c> sorted</c><00:02:13.620><c> I'll</c><00:02:14.489><c> right-click</c><00:02:14.940><c> them</c>

00:02:15.259 --> 00:02:15.269 align:start position:0%
dates to be sorted I'll right-click them
 

00:02:15.269 --> 00:02:23.170 align:start position:0%
dates to be sorted I'll right-click them
again<00:02:15.569><c> and</c><00:02:16.129><c> choose</c><00:02:17.129><c> sort</c><00:02:17.790><c> oldest</c><00:02:18.299><c> to</c><00:02:18.480><c> newest</c>

00:02:23.170 --> 00:02:23.180 align:start position:0%
 
 

00:02:23.180 --> 00:02:25.520 align:start position:0%
 
when<00:02:24.180><c> you're</c><00:02:24.299><c> done</c><00:02:24.450><c> changing</c><00:02:24.690><c> the</c><00:02:24.989><c> layout</c><00:02:25.170><c> you</c>

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

00:02:25.530 --> 00:02:28.819 align:start position:0%
when you're done changing the layout you
can<00:02:25.560><c> switch</c><00:02:26.040><c> to</c><00:02:26.069><c> report</c><00:02:26.790><c> view</c><00:02:27.060><c> and</c><00:02:27.680><c> this</c><00:02:28.680><c> will</c>

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

00:02:28.829 --> 00:02:30.319 align:start position:0%
can switch to report view and this will
let<00:02:28.920><c> you</c><00:02:29.069><c> view</c><00:02:29.250><c> it</c><00:02:29.310><c> without</c><00:02:29.519><c> the</c><00:02:29.910><c> gridlines</c>

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

00:02:30.329 --> 00:02:34.210 align:start position:0%
let you view it without the gridlines
and<00:02:31.579><c> finally</c><00:02:32.579><c> we</c><00:02:32.760><c> should</c><00:02:32.940><c> save</c><00:02:33.180><c> this</c><00:02:33.359><c> report</c>

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

00:02:34.220 --> 00:02:43.280 align:start position:0%
and finally we should save this report
I'll<00:02:35.220><c> call</c><00:02:35.579><c> it</c><00:02:35.730><c> December</c><00:02:36.239><c> orders</c><00:02:39.139><c> and</c><00:02:42.230><c> now</c><00:02:43.230><c> we</c>

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

00:02:43.290 --> 00:02:45.080 align:start position:0%
I'll call it December orders and now we
have<00:02:43.620><c> a</c><00:02:43.650><c> report</c><00:02:43.829><c> that</c><00:02:44.099><c> we</c><00:02:44.310><c> can</c><00:02:44.459><c> come</c><00:02:44.669><c> back</c><00:02:44.819><c> to</c>

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

00:02:45.090 --> 00:02:46.550 align:start position:0%
have a report that we can come back to
at<00:02:45.269><c> any</c><00:02:45.480><c> time</c><00:02:45.720><c> if</c><00:02:45.959><c> we</c><00:02:46.109><c> want</c><00:02:46.319><c> to</c><00:02:46.349><c> make</c><00:02:46.530><c> changes</c>

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

00:02:46.560 --> 00:02:52.320 align:start position:0%
at any time if we want to make changes
or<00:02:47.099><c> print</c><00:02:47.459><c> it</c>

00:02:52.320 --> 00:02:52.330 align:start position:0%
 
 

00:02:52.330 --> 00:02:54.390 align:start position:0%
 
you