Goodwill Community Foundation creating
opportunities for a better life
access gives you a lot of flexibility
when it comes to formatting a report you
can use any fonts and colors that you
want you can change the theme and you
can even add a header footer and company
logo in this example I'd like to start
out by changing the fonts and I want to
put the descriptions in italics and make
the product names bold to do this we'll
need to be in layout view first select
the column that you want to change you
can also hold down the shift key if you
want to select multiple columns then go
to the format tab and choose the font
that you want I'm going to pick Cambria
now to make the descriptions italic I'll
select them and click the italic command
and then I'll select the product type
and make it bold I think I'll go ahead
and delete the field headers anybody who
sees this menu will know what each
column is so they don't really need to
be labeled at this point we can switch
to print preview to see how it looks the
new font and italics really help to give
it a more distinctive look now I'd like
to add a page header which will include
the address of our bakery to do this
we'll need to go into design view which
we haven't looked at yet here you can
make some of the same types of
adjustments you can make in layout view
but it also lets you do some other
things like adding headers and footers
you'll see several bars and find the one
that says page header you'll need to
make sure that there is some empty space
below it and if there isn't any space
then you'll need to click on this border
and drag it down
then in the design tab find the controls
group and you'll want to click on this
icon which is the label command and then
in your page header click and drag to
create a box you can type whatever you
want here and I'm going to type our
bakery's address phone number and email
address and if you want you can also
edit the report header page footer and
report footer in the same way let's go
back to print preview to see how our
header looks I think it looks good so
I'm not going to change anything now if
you scroll down you can see that today's
date and the page number are in the page
footer these are automatically added for
us because we created this report with
the report wizard however you can also
add them manually by going to either
layout view or design view and then
clicking page numbers or date and time
on the design tab now one thing that
will make this report look much more
complete is a company logo
so I'll click the logo command and then
you can select the picture that you want
and then click OK
ok now this may be hard to see but our
logo has been added in the report header
and it has an orange box around it I'm
just going to drag this corner to make
it larger and then I'll move it over to
the center of the page I'll
move the title to the center and I think
this title would look better if it just
said menu and finally you can change the
overall look of your report by selecting
a different theme a theme is a set of
colors and fonts that applies to your
entire database and that means it can
affect your other objects as well if you
want you can even mix and match colors
and fonts from different themes all of
these little details that we've added to
our report make a big difference and now
it actually looks like a real menu that
we can print and give to our customers