42

Creating Reports in Design View

The original report designer and traditional method for creating reports in Access is the Report Design View designer, and it has been around since the beginning of Access. The Report Design View designer allows the user to place controls of the report's design surface in a grid-based layout. Each report section provides a specific purpose in the report, such as a Header or Footer for the report. The Report Design View mode provides a number of tools and panes for working with reports, such as the Property Sheet, the Field List, the Group, Sort, and Totals Pane, the Navigation Pane, and all of the controls found on the Ribbon. The Report Design View designer is different than the Layout View designer in a number of ways, but most notably, the major difference is that the data from the data source is not shown at design time. This lesson discusses the basics of using the Report Design View designer to create reports for an Access database application.

LESSON SETUP

The lesson is designed to provide a basic overview of building Access reports as well as a step-by-step walk-through of how to create a report using the Design View designer. You should be familiar with opening and creating new objects in an Access database and be aware that reports are used to display the data contained in database tables.

CREATING A NEW REPORT IN DESIGN

Creating a new report in Design View mode is extremely easy to do in Access 2010. Complete the following steps to ...

Get Microsoft® Access® 2010 24-Hour Trainer now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.