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