Page 64 - ModularV1.1 _c8_flipbook
P. 64
Report created
Using Report Design
The Report Design command allows you to design a report manually by using the controls
provided by MS Access or fields from an existing table. Follow the given steps to create a
report by using the Report Design command:
Step 1 Click on the Report Design command from the Reports group of the Create tab. The
Report Design window appears.
Step 2 Click on the Add Existing Fields command from the Tools group of the
Design tab. The Field List pane appears at the right-side of the MS Access
window.
Step 3 Click on the Show all tables link. All the existing tables will appear in the Field List pane.
Step 4 Click on the + icon in front of the table name. All the fields of the table appear.
Field List pane
Step 5 Drag the fields from the Field List pane in the Detail section of the report. In this case,
we have dragged all the fields of the Items table.
Step 6 Click on the Logo command Header/Footer group of the Design tab to add the logo on
the report. The Insert Picture dialog box appears. Select the logo and click on the Open
button. The selected logo will get inserted in the Report Header section automatically.
Step 7 Click on the Page Numbers command from the Header/Footer group of the Design
tab to add the page number. The Page Numbers dialog box appears.
Step 8 Click on the OK button. The ="Page "& [Page] label appears in the Page Header section.
You can drag the page label in the Page Footer section.
62 Modular (Ver. 1.1)-VIII

