WEBVTT
Kind: captions
Language: en

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

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

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

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

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

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

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

00:00:45.280 --> 00:00:46.640
appear.

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

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

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

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

00:01:05.500 --> 00:01:07.340
change the width.

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

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

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

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

00:01:25.320 --> 00:01:26.460
Delete key.

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

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

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

00:01:41.450 --> 00:01:42.920
when you print it.

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

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

00:01:53.910 --> 00:01:56.710
However, you can sort and filter them.

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

00:02:03.540 --> 00:02:06.910
and then go to Date Filters…

00:02:06.910 --> 00:02:10.180
All Dates In Period… and select December.

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

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

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

00:02:28.780 --> 00:02:30.920
let you view it without the gridlines.

00:02:30.920 --> 00:02:35.230
And finally, we should Save this report.

00:02:35.230 --> 00:02:43.069
I'll call it December Orders…

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

00:02:46.920 --> 00:02:47.670
or print it.