Creating Reports Automatically
You create a report the same way that you create other objects in your database. Follow these steps:
- Display the Create tab of the Ribbon by clicking it.
- Select the method you want to use to create the report by clicking one
of the buttons on the Reports group of the Create tab on the Ribbon.
Table-1 lists the choices on the Reports group of the Create tab.
Warning Don't click New on the Microsoft Office Button menu - doing that makes a new database!
| Option | When to Use it | Where to Find More Info |
|---|---|---|
| Design View | When you want to design your report from scratch in Design view | |
| Report Wizard | When you want Access to create a report, using the fields, grouping, and sorting that you provide | See the next section in this tutorial. |
| Report | When you want to create a simple report based on the table or query that is currently selected. You can customize the report later. | Just click the button and Access 2007 automatically creates a report based on the currently selected table or query. |
| AutoReport: Tabular | When you want to create a report from one table or query and arrange the fields in a table, with field names at the tops of the columns and data from each record displayed as a row in the table (as in a datasheet). | See "Creating Simple Reports," later in this tutorial. |
| Chart Wizard | When you want to create a chart from data stored in one table or query. | |
| Label Wizard | When you want to print data from one table or query on labels. | See "Creating Mailing Labels," later in this tutorial. |
In this tutorial:
- Creating and Editing Reports
- What are Forms and Reports
- Creating Reports Automatically
- Running the Report Wizard
- Creating Simple Reports
- Editing Reports in Design View
- Adding page headers, footers, and numbers
- Adding sections that group your records
- Sorting the records in your report
- Calculating group subtotals and report totals
- Formatting Tips and Tricks
- Copying Forms to Reports
- Adding and Formatting Subreports
- Displaying Empty or Long Fields
- Creating Mailing Labels