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 grey 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
okay 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 also 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 like what you just
saw great it add a comment subscribe to
our Channel
the freedom to learn
what you want when you want absolutely
free
GCF learn free.org