WEBVTT
Kind: captions
Language: en

00:00:11.570 --> 00:00:16.510
At some point, you're probably going to want
to present some of your data to another person,

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

00:00:20.770 --> 00:00:25.869
Just like a query, a report can pull in information
from one or more tables or queries, but it

00:00:25.869 --> 00:00:29.869
gives you a lot more control over how the
data looks on the page.

00:00:29.869 --> 00:00:35.879
In this video, we're just going to focus on
making a simple report based on a single query.

00:00:35.879 --> 00:00:41.980
I'm going to open the Orders Query… but
you can use any table or query that you want.

00:00:41.980 --> 00:00:47.190
And then in the Create tab, click the Report
command… and your report should instantly

00:00:47.190 --> 00:00:48.550
appear.

00:00:48.550 --> 00:00:53.920
Now it's probably not going to look perfect,
so at this point you can clean up the layout.

00:00:53.920 --> 00:00:59.239
And to do this you'll need to make sure you're
in Layout View.

00:00:59.239 --> 00:01:04.030
In this report, some of these columns are
too wide, so I need to adjust them.

00:01:04.030 --> 00:01:08.020
When you click on a column, a yellow border
will appear, and you can drag the edge to

00:01:08.020 --> 00:01:09.850
change the width.

00:01:09.850 --> 00:01:13.940
And I'm adjusting each column just enough
to make everything fit on the page.

00:01:13.940 --> 00:01:19.210
If you make your columns too narrow, then
you may cut off some of your data.

00:01:19.210 --> 00:01:22.670
You can also get rid of any extra fields that
you don't need.

00:01:22.670 --> 00:01:27.159
We probably don't need the zip code in this
report so I'll delete it by pressing the Delete

00:01:27.159 --> 00:01:28.159
key.

00:01:28.159 --> 00:01:33.360
I'll also delete the title and these empty
cells.

00:01:33.360 --> 00:01:37.840
I'm going to scroll through the report to
make sure everything looks right.

00:01:37.840 --> 00:01:41.630
And if any elements are outside this dotted
line, then they're going to be off the page

00:01:41.630 --> 00:01:43.119
when you print it.

00:01:43.119 --> 00:01:50.270
So I'm going to drag this page number over
to the left.

00:01:50.270 --> 00:01:53.530
Now one thing you can't do within a report
is edit records.

00:01:53.530 --> 00:01:56.330
However, you can sort and filter them.

00:01:56.330 --> 00:02:03.170
I want to just show the orders from December,
so I'll right-click the Pickup Date column…

00:02:03.170 --> 00:02:06.310
and then go to Date Filters…

00:02:06.310 --> 00:02:11.190
All Dates In Period… and select December.

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

00:02:13.680 --> 00:02:23.019
I'll right-click them again… and choose
Sort Oldest to Newest.

00:02:23.019 --> 00:02:27.580
When you're done changing the layout, you
can switch to Report View… and this will

00:02:27.580 --> 00:02:29.699
let you view it without the gridlines.

00:02:29.699 --> 00:02:33.949
And finally, we should Save this report.

00:02:33.949 --> 00:02:41.080
I'll call it December Orders.

00:02:41.080 --> 00:02:44.930
And now, we have a report that we can come
back to at any time if we want to make changes

00:02:44.930 --> 00:02:45.669
or print it.