AutoReport creates a report automatically based on a single table or query. AutoReport incorporates all the information, both the field names and the individual records, from a selected object and then creates the report for you. There are two layout options for the report, tabularthe records display in a table layout, or columnarthe records display in a column.
In this activity, you will create a report for James Smith that lists the club members who are participating in the fundraiser.
With your 3A_Fundraiser database open, on the Objects bar click Reports.
On the Database window toolbar, click New .
From the list, click AutoReport: Tabular. To the right of Choose the table or query where the objects data comes from, click the arrow, and then click Club Members. Compare your screen with Figure 3.32.
Click OK, and then compare your screen with Figure 3.33.
The Club Members report is created and displays in print preview. A report displays the data as it is currently entered in the database. You cannot use a report to edit the data in the database. The mouse pointer displays as a magnifying glass so you can zoom in and out on the report.
Do not be concerned if your report displays a different style from the one shown in the figure. The last style that was applied to a report, using the Access program installed on your computer, is the style that is applied when an AutoReport is created.
Click once to change the magnification so you can see the entire report on the screen.
Point to the last record in the report and click once.
If you have been instructed to submit your file electronically, skip this step. Otherwise, on the Print Preview toolbar, click the Print button to print the report.
On the menu bar, click the Close Window button .
Click Yes. In the displayed Save As dialog box, accept the default nameClub Membersand then click OK.
Chapter One. Creating Documents with Microsoft Word 2003
Chapter Two. Formatting and Organizing Text
Chapter Three. Using Graphics and Tables
Chapter Four. Using Special Document Formats, Columns, and Mail Merge
Chapter One. Creating a Worksheet and Charting Data
Chapter Two. Designing Effective Worksheets
Chapter Three. Using Functions and Data Tables
Chapter One. Getting Started with Access Databases and Tables
Chapter Two. Sort, Filter, and Query a Database
Chapter Three. Forms and Reports
Chapter One. Getting Started with PowerPoint 2003
Chapter Two. Creating a Presentation
Chapter Three. Formatting a Presentation
Chapter One. Using Access Data with Other Office Applications
Chapter Two. Using Tables in Word and Excel
Chapter Three. Using Excel as a Data Source in a Mail Merge
Chapter Four. Linking Data in Office Documents
Chapter Five. Creating Presentation Content from Office Documents
GO! with Microsoft Office 2003 Brief (2nd Edition)