Page 3 of 12PREVNEXT

Create reports for a new Access 2007 database

Layouts you can use when designing a report


So how do you make your asset data meaningful and easy to understand? With a design. Start by deciding on the data you need to include in the report, and then on the sections you want in the report. For example, all reports need a detail section, but do you need a header? How about grouping? From there, you decide on a layout. Access provides several basic layouts, but you can arrange your data in almost any way you want.

Callout 1 Tabular layouts resemble spreadsheets. Use them when you need to present your data in a simple list format.
Callout 2 Stacked layouts resemble the forms you fill out at a bank or when you buy something online. Use a stacked layout when your report contains too many fields to display in tabular form.
Callout 3 Mixed layouts use elements from tabular and stacked layouts. For example, you can place some of the fields in a record on the same row, and stack other fields from the same record.
Callout 4 Justified layouts use the full width of your report page and display information as compactly as possible. You use this layout when you need to display a large number of fields.

After you finish your design, you have several options for creating the report. We'll start with the Report tool.

Page 3 of 12PREVNEXT