Microsoft Office Tutorials and References
In Depth Information
Creating Reports Automatically
2. Click the Report button in the Reports group on the Create tab of
Access creates a report in tabular format and displays it in Layout view,
as shown in Figure 1-1.
3. Customize the report as you would any other report.
Use Layout view or Design view to get rid of the unwanted fields, widen
the controls for the fields and field names you want to keep, or switch to
landscape printing (or all three).
Running the Report Wizard
Running the Report Wizard usually is a better way to start making a report,
especially if you want to create a report that groups data from one or more
fields, with headings or subtotals for each group. When the wizard finishes,
you can add your own formatting touches in Layout or Design view.
One big advantage of using the Report Wizard is that you can choose fields
for the report from more than one table or query; you don’t have to gather
all the data you want into one query. If you have an online store, for
example, you may want to create a report that lists all the orders for each
customer. The information for this report comes from several tables: Address
Book (which stores one record for each customer, including name and
address), Orders (with one record for each order, including the order date),
and Order Details (with one record for each item in an order, including the
quantity ordered and the price per item).
The Report Wizard asks different questions depending on the data in the
record source and on options you select, so don’t be surprised if you don’t
see every window each time you run it.
Follow these steps to create a report:
1. Click the Report Wizard button in the Reports group on the Create tab
of the Ribbon.