ACCC Seminars

Welcome
Database Concepts
Creating a Database
Working with Records
Creating Tables
Queries
Forms
Reports
Related Links

Handout (PDF)
ACCC Seminars
Rev. Oct 3/2001

Access 2000 Introduction


 

Reports

Once you have entered records or drawn particular data using a query, it often becomes necessary to give others a printed copy of that information. For example, a department store may want a list of transactions organized by individual departments to analyze sales. Perhaps a person needs a list of their appointments for a particular day to organize themselves. These can be accomplished by creating a REPORT, which can organize and even summarize your information.

Clicking on the New Object button will allow you to create a report using the Report Wizard. (NOTE: Creating an AutoReport will create a report that simply lists the records in a column with no formatting.)

Click on the thumbnail image to see the full size image.

Step 1 of the Wizard allows you to insert whatever fields you wish into the report.
Step 2 lets you set grouping levels, where the records would be organized by a particular field based on the data in that field
Step 3 lets you sort the records in each group by any of the remaining fields
Step 4 lets you choose the type of layout and whether the report should appear in Portrait or Landscape
Step 5 lets you choose the style of the report
Step 6 is the final step, where you can preview the report or modify the report's design.

Here is a sample report.


Back to TopForms Forms-Design View Reports-Design View Related Info
   

Seminar materials: <http://www.accc.uic.edu/seminars/access2000-intro>
Last Modified: October 3, 2001 — pjm