Creating Powerful Reports


  • Customizing reports
  • Using subreports
  • Giving users greater control
  • Adding professional polish to reports


The code downloads for this chapter are found at www.wiley.com/go/proaccess2013prog.com on the Download Code tab. The chapter download file includes five database files:

  • 2013Team.accdb
  • ReportExamples.accdb
  • ReportExamplesNW.accdb
  • PDFDemo.accdb
  • PDFDemo.mdb

Also included are the code snippets for this chapter, which are all located in the file named 850832_ch18_CodeSnippets.txt. You will also find PDFDemo.pdf to use with the PDF examples.

NOTE As with most downloaded files, you may need to specifically trust and enable these files and their location for them to function properly. To display some of the images, you will also need to store the image folder as directed or update the links to their location on your computer. For more information, please read the “What you Need” section in the book's Introduction.

The built-in report writer in Access has always been one of the most powerful and popular features of Access. In addition to the powerful wizards that can create formatted reports in a matter of minutes, Access has an easy-to-learn interface used to create, revise, and customize reports. You can use built-in Macros and VBA, or a combination thereof to modify reports on the fly at run time, either from user input or from values within the database.

Whether you have been working ...

Get Professional Access 2013 Programming now with the O’Reilly learning platform.

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