Recall that a report is a database object that displays the fields and records from a table or a query in an easy-to-read format suitable for printing. Reports are created to summarize information in a database in a professional-looking manner.
Use the Report Wizard when you need flexibility and want to control the report content and design. The Report Wizard is similar to the Form Wizard; it creates a report by asking you a series of questions and then designs the report based on your answers.
The purpose of the Fundraiser database is to see how much money is raised for this years charity fundraising event at Lake Michigan City College. Each club competes to raise the most money. Based on the data that has been collected, James Smith would like a report that shows how much money has been collected for each club by each student.
On the Objects bar, click Queries, and then double-click Pledges by Club to open this query. Compare your screen with Figure 3.34.
This query shows the pledges made to each club, the name of the student who collected the pledge, and the name of the donor. In this format, there is duplication of some information, such as the students names and the club names. Using a report, you can group information so that it is easier to read and understand.
Close the query window, and then on the Objects bar, click Reports. To the right of the Objects bar, double-click the command Create report by using wizard.
Click the Tables/Queries arrow, and then click Query: Pledges by Club. Click the All Fields button to move all of the fields to the Selected Fields list on the right. Compare your screen with Figure 3.35, and then click Next.
The Report Wizard displays its second question. Here you decide how you want to group the information. The box on the right is a preview of how the data will be organized.
With Club Affiliation selected, click the One Field button .
Click Next, and then compare your screen with Figure 3.36.
In box 1 on the right, click the arrow, and then click Last Name.
Click the Summary Options button, and then compare your screen with Figure 3.37.
To the right of Pledge Amount, select the Sum check box. Under Show, be sure the Detail and Summary option button is selected, and then click OK. Click Next.
Click each Layout option button and view the options, and then click the Stepped option button to select it as the layout for your report. On the right side of the dialog box, under Orientation, be sure Portrait is selected, and at the bottom be sure the Adjust the field width so all fields fit on a page check box is selected.
Click Next. In the displayed list of styles, click Formal. Notice the preview to the left, and then click Soft Gray to view its preview. Click to view each of the remaining styles, and then click Corporate.
With Corporate selected as the style, click the Next button. In the What title do you want for your report? text box, accept the default name Pledges by Club by clicking the Finish button.
Use the vertical scroll bar to examine the data in the report and compare your screen with Figure 3.38.
More Knowledge: Choosing the Best Method for Creating a Form or a Report
There are various methods you can use to create a form or a report. You can start on the Forms or Reports object and use one of the displayed commands. You can also click the New button, and then select from the methods listed in the New Form or New Report dialog box. Here you have more choices for creating your object, including some specialized designs that you would not otherwise see. You can also start by clicking the table or query that you want to use as the basis for your form or report and then click the New Objects button arrow. The displayed list offers AutoForm or AutoReport options which are the quickest method for creating a simple form or report that includes all fields but very limited formatting. Using the Form Wizard or Report Wizard offers the best combination of design control and assistance. After your object is created, you can always modify it in the Design view.
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)
PostgreSQL(c) The comprehensive guide to building, programming, and administering PostgreSQL databases
Lean Six Sigma for Service : How to Use Lean Speed and Six Sigma Quality to Improve Services and Transactions