Chapter 9. Presenting Data with Access Reports


  • Looking at the different types of Access reports

  • Creating reports with a Report Wizard

  • Creating a report from scratch

  • Improving the form's appearance

It's hard to underestimate the importance of reports in database applications. Many people who never work with an Access application in person use reports created by Access. A lot of maintenance work on database projects involves creating new and enhancing existing reports. Access is well known and respected for its powerful reporting features.

Reports provide the most flexible way of viewing and printing summarized information. They display information with the desired level of detail, while enabling you to view or print your information in many different formats. You can add multilevel totals, statistical comparisons, and pictures and graphics to a report.

In this chapter, you learn to use the Report Wizard as a starting point. You also learn how to create reports and what types of reports you can create with Access.


In this chapter, you create new reports using the Report Wizard and by creating a blank report without using a wizard. You use tables created in previous chapters. The Chapter09.accdb database file on the book's CD-ROM contains the completed reports described in this chapter.

Introducing Reports

Reports present a customized view of your data. Report output is viewed on-screen or printed to provide a hard copy of the data. Very often reports provide summaries of ...

Get Access® 2010 Bible now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.