WEBVTT
Kind: captions
Language: en

00:00:12.160 --> 00:00:14.010
At some point, you're probably going to want
to

00:00:14.010 --> 00:00:17.080
present some of your data to another person,

00:00:17.080 --> 00:00:21.230
and Access lets you create professional looking
reports to do this.

00:00:21.230 --> 00:00:25.900
Just like a query, a report can pull in
information from one or more tables or queries,

00:00:25.900 --> 00:00:28.260
but it gives you a lot more control over how
the

00:00:28.260 --> 00:00:30.340
data looks on the page.

00:00:30.340 --> 00:00:32.360
In this video, we're just going to focus on
making

00:00:32.360 --> 00:00:36.080
a simple report based on a single query.

00:00:36.080 --> 00:00:38.930
I'm going to open Orders Query, but you can
use

00:00:38.930 --> 00:00:41.890
any table or query that you want.

00:00:41.890 --> 00:00:46.989
And then in the Create tab, click the Report
command, and your report should instantly

00:00:46.989 --> 00:00:48.190
appear.

00:00:48.190 --> 00:00:50.850
Now it's probably not going to look perfect,
so at

00:00:50.850 --> 00:00:53.079
this point you can clean up the layout,

00:00:53.079 --> 00:00:57.469
and to do this you'll need to make sure you're
in Layout View.

00:00:57.469 --> 00:00:59.649
In this report, some of these columns are
too

00:00:59.649 --> 00:01:02.270
wide, so I need to adjust them.

00:01:02.270 --> 00:01:04.020
When you click on a column, a yellow border
will

00:01:04.020 --> 00:01:05.320
appear,

00:01:05.320 --> 00:01:08.110
and you can drag the edge to change the width.

00:01:08.110 --> 00:01:10.110
And I'm adjusting each column just enough
to make

00:01:10.110 --> 00:01:12.000
everything fit on the page.

00:01:12.000 --> 00:01:13.910
If you make your columns too narrow, then
you may

00:01:13.910 --> 00:01:16.690
cut off some of your data.

00:01:16.690 --> 00:01:18.750
You can also get rid of any extra fields that
you

00:01:18.750 --> 00:01:20.149
don't need.

00:01:20.149 --> 00:01:22.130
We probably don't need the zip code in this
report

00:01:22.130 --> 00:01:25.259
so I'll delete it by pressing the delete key.

00:01:25.259 --> 00:01:29.759
And I'll also delete the title and these empty
cells.

00:01:29.759 --> 00:01:31.940
I'm going to scroll through the report now
to make

00:01:31.940 --> 00:01:34.270
sure everything looks right.

00:01:34.270 --> 00:01:36.830
And if any elements are outside this dotted
line,

00:01:36.830 --> 00:01:38.330
then they're going to be off the page when
you

00:01:38.330 --> 00:01:44.910
print it, so I'm going to drag this page number
over to the left.

00:01:44.910 --> 00:01:47.220
Now one thing you can't do within a report
is edit

00:01:47.220 --> 00:01:48.000
records.

00:01:48.000 --> 00:01:50.690
However, you can sort and filter them.

00:01:50.690 --> 00:01:53.920
I want to just show the orders from December,

00:01:53.920 --> 00:01:56.959
so I'll right click the Pickup Date column,

00:01:56.959 --> 00:02:02.580
and then go to Date Filters, All Dates In
Period, and select December.

00:02:02.580 --> 00:02:06.280
And I'd also like these dates to be sorted.

00:02:06.280 --> 00:02:11.739
I'll right click them again, and choose Sort
Oldest to Newest.

00:02:11.739 --> 00:02:13.360
When you're done changing the layout, you
can

00:02:13.360 --> 00:02:15.640
switch to Report View.

00:02:15.640 --> 00:02:18.599
And this will let you view it without the
gridlines.

00:02:18.599 --> 00:02:21.950
And finally, we should save this report.

00:02:21.950 --> 00:02:25.920
I'll call it December Orders.

00:02:25.920 --> 00:02:27.890
And now, we have a report that we can come
back to

00:02:27.890 --> 00:02:28.730
at any time

00:02:28.730 --> 00:02:35.730
if we want to make any changes or print it.