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
we'll 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