Objective 5. Create an AutoReport

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.

Activity 3.10. Creating and Printing an AutoReport

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.

[Page 1080]
Two command icons display, and currently there are no reports created for this database.


On the Database window toolbar, click New .

The New Report dialog box displays. Here you select the method you want to use to create a report, and the table or query on which you will base the report.


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.

Figure 3.32.

[Page 1081]


Click OK, and then compare your screen with Figure 3.33.

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.

NoteReport Style

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.

Based on the number of fields, Access created the report in a landscape orientation to ensure that all of the data for each record will display on one row.

[Page 1082]


Point to the last record in the report and click once.

Your name displays in the last record in the report. This is the information you added to the Club Members table using a form.


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 .

A message box displays asking if you want to save the changes to the design of Report1the default name of the new report until you save it with another name.


Click Yes. In the displayed Save As dialog box, accept the default nameClub Membersand then click OK.

[Page 1082 (continued)]

Windows XP

Outlook 2003

Internet Explorer

Computer Concepts

Word 2003

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

Excel 2003

Chapter One. Creating a Worksheet and Charting Data

Chapter Two. Designing Effective Worksheets

Chapter Three. Using Functions and Data Tables

Access 2003

Chapter One. Getting Started with Access Databases and Tables

Chapter Two. Sort, Filter, and Query a Database

Chapter Three. Forms and Reports

Powerpoint 2003

Chapter One. Getting Started with PowerPoint 2003

Chapter Two. Creating a Presentation

Chapter Three. Formatting a Presentation

Integrated Projects

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
GO! with Microsoft Office 2003 Brief (2nd Edition)
ISBN: 0131878646
EAN: 2147483647
Year: 2004
Pages: 448

Flylib.com © 2008-2020.
If you may any questions please contact us: flylib@qtcs.net