Goodwill Community Foundation creating
opportunities for a better life
at some point you're probably going to
want to present some of your data to
another person and access lets you
create professional looking reports to
do this just like a query a report can
pull in information from one or more
tables or queries but it gives you a lot
more control over how the data looks on
the page in this video we're just going
to focus on making a simple report based
on a single query I'm going to open the
orders query but you can use any table
or query that you want and then in the
create tab click the report command and
your report should instantly appear now
it's probably not going to look perfect
so at this point you can clean up the
layout and to do this you'll need to
make sure that you're in layout view in
this report some of these columns are
too wide so I need to adjust them when
you click on a column a yellow border
will appear and you can drag the edge to
change the width and I'm adjusting each
column just enough to make everything
fit on the page if you make your columns
too narrow then you may cut off some of
your data you can also get rid of any
extra fields that you don't need we
probably don't need the zip code in this
report so I'll delete it by pressing the
Delete key and I'll also delete the
title and these empty cells
I'm going to scroll through the report
now to make sure that everything looks
right and if any elements are outside
this dotted line then they're going to
be off the page when you print it so I'm
going to drag this page number over to
the left now one thing you can't do
within report is edit records however
you can sort and filter them I want to
just show the orders from December so
I'll right-click the pickup date column
and then go to date filters all dates in
period and select December and I'd also
like these dates to be sorted I'll
right-click them again and choose sort
oldest to newest
when you're done changing the layout you
can switch to report view and this will
let you view it without the gridlines
and finally we should save this report
I'll call it December orders and now we
have a report that we can come back to
at any time if we want to make changes
or print it