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 like
what you just saw greatest add a comment
subscribe to our chill the freedom to
learn
what you want when you want absolutely
free
GCF learn free.org