WEBVTT
Kind: captions
Language: en

00:00:11.500 --> 00:00:15.760
Access gives you a lot of flexibility when
it comes to formatting a report.

00:00:15.760 --> 00:00:20.270
You can use any fonts and colors that you
want, you can change the theme, and you can

00:00:20.270 --> 00:00:23.390
even add a header, footer, and company logo.

00:00:23.390 --> 00:00:27.400
In this example, I'd like to start out by
changing the fonts.

00:00:27.400 --> 00:00:32.080
And I want to put the descriptions in italics,
and make the product names bold.

00:00:32.080 --> 00:00:35.260
To do this, we'll need to be in Layout view.

00:00:35.260 --> 00:00:39.250
First, select the column that you want to
change.

00:00:39.250 --> 00:00:45.420
You can also hold down the SHIFT key if you
want to select multiple columns.

00:00:45.420 --> 00:00:50.840
Then go to the Format tab… and choose the
font that you want.

00:00:50.840 --> 00:00:54.270
I'm going to pick Cambria.

00:00:54.270 --> 00:01:02.039
Now to make the descriptions italic, I'll
select them… and click the Italic command.

00:01:02.039 --> 00:01:06.310
And then I'll select the product type and
make it bold.

00:01:06.310 --> 00:01:10.990
I think I'll go ahead and delete the field
headers.

00:01:10.990 --> 00:01:14.470
Anybody who sees this menu will know what
each column is, so they don't really need

00:01:14.470 --> 00:01:17.090
to be labeled.

00:01:17.090 --> 00:01:20.700
At this point, we can switch to Print Preview
to see how it looks.

00:01:20.700 --> 00:01:26.659
The new font and the italics really help to
give it a more distinctive look.

00:01:26.659 --> 00:01:30.930
Now I'd like to add a page header, which will
include the address of our bakery.

00:01:30.930 --> 00:01:35.860
To do this we'll need to go into Design view,
which we haven't looked at yet.

00:01:35.860 --> 00:01:40.759
Here, you can make some of the same types
of adjustments you can make in Layout view,

00:01:40.759 --> 00:01:45.630
but it also lets you do some other things
like adding Headers and Footers.

00:01:45.630 --> 00:01:50.590
You'll see several gray bars… and find the
one that says Page Header.

00:01:50.590 --> 00:01:54.509
You'll need to make sure that there's some
empty space below it, and if there isn't any

00:01:54.509 --> 00:01:59.270
space, then you'll need to click on this border,
and drag it down.

00:01:59.270 --> 00:02:05.400
Then, in the Design tab, find the Controls
group… and you'll want to click on this

00:02:05.400 --> 00:02:08.970
icon, which is the Label command.

00:02:08.970 --> 00:02:13.790
And then in your page header, click and drag
to create a box.

00:02:13.790 --> 00:02:18.340
You can type whatever you want here… and
I'm going to type our bakery's address, phone

00:02:18.340 --> 00:02:22.650
number, and email address.

00:02:22.650 --> 00:02:28.420
And if you want, you can also edit the Report
Header, Page Footer, and Report Footer in

00:02:28.420 --> 00:02:31.250
the same way.

00:02:31.250 --> 00:02:34.510
Let's go back to Print Preview to see how
our header looks.

00:02:34.510 --> 00:02:38.530
I think it looks good, so I'm not going to
change anything.

00:02:38.530 --> 00:02:44.349
Now if you scroll down, you can see that today's
date and the page number are in the page footer.

00:02:44.349 --> 00:02:49.040
These were automatically added for us because
we created this report with the Report Wizard.

00:02:49.040 --> 00:02:56.970
However, you can also add them manually by
going to either Layout view or Design view…

00:02:56.970 --> 00:03:02.360
and then clicking Page Numbers or Date and
Time on the Design tab.

00:03:02.360 --> 00:03:07.160
Now one thing that will make this report look
much more complete is a company logo.

00:03:07.160 --> 00:03:13.870
So I'll click the Logo command… and then
you can select the picture that you want…

00:03:13.870 --> 00:03:15.569
and then click OK.

00:03:15.569 --> 00:03:21.300
Okay, now this may be hard to see, but our
logo has been added in the Report Header,

00:03:21.300 --> 00:03:23.720
and it has an orange box around it.

00:03:23.720 --> 00:03:28.300
I'm just going to drag this corner to make
it larger… and then I'll move it over to

00:03:28.300 --> 00:03:32.090
the center of the page.

00:03:32.090 --> 00:03:36.220
I'll also move the title to the center.

00:03:36.220 --> 00:03:42.360
And I think this title would look better if
it just said Menu.

00:03:42.360 --> 00:03:47.040
And finally, you can change the overall look
of your report by selecting a different theme.

00:03:47.040 --> 00:03:52.260
A theme is a set of colors and fonts that
applies to your entire database.

00:03:52.260 --> 00:03:56.409
And that means it can effect your other objects
as well.

00:03:56.409 --> 00:04:02.879
If you want, you can even mix and match colors
and fonts from different themes.

00:04:02.879 --> 00:04:07.129
All of these little details that we've added
to our report make a big difference, and now

00:04:07.129 --> 00:04:11.199
it actually looks like real menu that we can
print and give to our customers.