Creating Reports

Reports can be created in Design mode one control at a time but this is time consuming and the detail associated may seem overwhelming, but as with form creation, Access provides short-cuts to produce a report. There are two options:

AutoReport

  1. Select a Table or a Query, for example the Property table.
  2. Choose the AutoReport icon on the toolbar.
  3. When the box illustrated below appears, select Autoreport: Columnar

Access creates a simple report with report and page headers and footers and controls for the fields and labels as illustrated below. These are in a row but can be dragged into a column order in design view. Experiment by moving these controls around 'previewing' the report.

The Report Wizard
The AutoReport does not provide a summary or field totals. To produce these, an Access Wizard is used. A Wizard is a feature, which asks questions about what you require and then produces the item. There are Wizards for database, form, report and graph, etc.

  1. Create and save a new query with ID, Address Line 1 and Price based on Property table.
  2. Select the Query in Design view.
  3. Choose the Report icon on the Toolbar.
  4. Then choose the Report Wizard as illustrated below.

  5. Choose the three fields to be included on the report and click on the Next button.
  6. Choose No Grouping by clicking on the Next button.
  7. Choose Sort on ID and click on the Next button.
  8. Choose presentation style - choose Tabular for your layout - Portrait orientation and click on the Next button.
  9. Choose a Style and click on the Next button.
  10. Give your report a title and Finish.
  11. Report should list records in ID order. Go to Design Mode for your report and drag out the Report footer, about half an inch, so that you can fit in a text field.
  12. Click on Text box and drag out a box in the Footer directly below the price field as shown below:

  13. Then type in the label 'Total Value' and the equation =Sum([Price]) as shown below:

  14. With the text box selected go to Properties and format the field as Currency as illustrated below. When you close this view and preview the report you will see that there is a now a total value at the foot of your report. You could amend this new field for many different functions - eg. Average, Max, Min etc.

Contents: Databases

Skill Check: Databases