Goodwill Community Foundation creating
opportunities for a better life
in this example I'd like to create a
menu that we can print for our bakery
that shows a list of our products and
their prices we're going to need to
create a report that uses multiple
tables and the easiest way to do that is
by using the report wizard first we'll
go to the create tab and in the reports
group select report wizard
we'll start by choosing the fields that
we want in our report if you click the
drop down arrow you'll see a list of all
of the tables and queries in your
database and we're going to add fields
from several different tables from the
categories table we're going to need the
product types field and you can either
double click it or click the right arrow
button to add it next we'll choose the
products table and here we'll add the
product name and description from the
sales unit table we'll add the product
name which in this case is just Dozen
half-dozen or single
and finally from the menu items table
will need the price so all of these
fields are going to be placed into our
report
now click next since we're using
multiple tables we need to decide how we
want the tables to be organized on the
page if we had just used a single table
or query then it would have skipped this
step in this case we want it to be
organized by the categories table and to
the right you can see a kind of outline
which shows where each field will go now
we'll go on to the next step
here you can change the way that the
records are grouped by adding a grouping
level much of the time you won't need to
do anything in this step but if you have
a very specific idea of how you want the
report to be organized then you can add
a grouping level for example if we
wanted the products to be grouped into
dozen half-dozen and single units then
we would add sales unit and then use the
arrows to change the priority but we
don't really want that here so I'll
remove this and then click Next here we
can sort the records by up to four
fields I'm going to sort by price and
I'll also change this to descending so
it will start with the highest price and
then click Next there are a few
different layout options that you can
choose from I'm going to select block
because it'll tend to keep things on the
same line I'm going to leave the
orientation as portrait and I'll also
leave the auto adjust option checked so
we won't have to do quite as much
adjusting at the end
and in the final step you can type in a
name I'm going to call it menu report
and here you can choose whether you want
it to open in print preview or design
view but this won't actually affect the
report when you click finish it will
create the report and you won't be able
to go back into the wizard to edit your
report but you can always go to layout
view to make any adjustments that you
want
and here's our finished menu