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 a 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
you