WEBVTT
Kind: captions
Language: en

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

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

00:00:18.220 --> 00:00:21.180
even add a header, footer, and company logo.

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

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

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

00:00:33.230 --> 00:00:37.110
First, select the column that you want to
change.

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

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

00:00:48.100 --> 00:00:51.530
I'm going to pick Cambria.

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

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

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

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

00:01:11.580 --> 00:01:14.930
to be labeled.

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

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

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

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

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

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

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

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

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

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

00:02:03.240 --> 00:02:05.240
icon, which is the Label command.

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

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

00:02:16.570 --> 00:02:20.580
number, and email address.

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

00:02:26.340 --> 00:02:27.860
the same way.

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

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

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

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

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

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

00:03:01.500 --> 00:03:06.500
Now one thing that will make this report look
much more complete is a company logo, so I'll

00:03:06.500 --> 00:03:13.560
click the Logo command… and then you can
select the picture that you want… and then

00:03:13.560 --> 00:03:14.560
click OK.

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

00:03:20.640 --> 00:03:23.060
and it has an orange box around it.

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

00:03:28.040 --> 00:03:31.830
the center of the page.

00:03:31.830 --> 00:03:35.570
I'll also move the title to the center.

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

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

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

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

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

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

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