Page 43 - Code & Click - 8

2. On the Create tab, click the Report button in the Reports group.
Access creates a simple report based on the table or query you selected. The Report Layout
Tools – Report Layout Design, Arrange, 4
Format, and Page Setup tabs appear
on the Ribbon.
3. Use the options in the Report Layout
Design and Format tabs to modify the
layout of the report, and format the
report title and headings.
4. Click the Save button on the Quick
Access Toolbar to save the report.

Access saves the report as a database
object.

Using the Report Wizard
The Report Wizard provides an easy way to create a customised report with selected fields. The
wizard guides you through a series of steps and generates a report based on your specifications.

To create a report using Report Wizard: 1
1. On the Create tab, click the Report Wizard button in the

Reports group.
The Report Wizard screen appears.

2. Click the Tables/Queries drop-down list arrow and select the required table.

3. Add the desired fields to display in the report using the and buttons.
4. Click the Next button.
5. Select the field on the basis of which you want to group the records.

5

7
2
3

4 6 8

6. Click the Next button.
7. Select the sort field and sorting order for the data in the report.

8. Click the Next button.

9. Select an option for the layout and orientation of the report.

41