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 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 will
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.