To change report view:
- Click the View button on the Home tab
MS Access - Lesson 13: Creating Reports (report) Picture 1 Create a Report
To create a white report:
- Click the Blank Report button on the Create tab
MS Access - Lesson 13: Creating Reports (report) Picture 2 - Click the Add Existing Fields button
- From the list of schools, click and drag the fields to the report
MS Access - Lesson 13: Creating Reports (report) Picture 3
Report Wizard
To create a report using the Report Wizard:
- On the Create tab, click the Report Wizard button
MS Access - Lesson 13: Creating Reports (report) Picture 4 - Choose the Tables / Queries you want to have on the report
- Select the fields you want to give the report and then press the> button (if you select each field) or press the >> button (if you select all schools).
- Click Next
MS Access - Lesson 13: Creating Reports (report) Picture 5 - Choose to arrange for the report
- Click Next MS Access - Lesson 13: Creating Reports (report) Picture 6
- Select the layout ( Layout ) and the horizontal or vertical orientation ( Orientation ) for the report
- Then click Next MS Access - Lesson 13: Creating Reports (report) Picture 7
- Select the type for the report
- Click Next
MS Access - Lesson 13: Creating Reports (report) Picture 8 - Create a title for the report
- Choose how you want to open the report ( Preview the report ) or edit the report ( Modify the report's design )
- Click Finish
MS Access - Lesson 13: Creating Reports (report) Picture 9 Calculation field
You can create reports including the calculation field. These reports will display the information you want with an arithmetic operation. To add a calculation field to the report:
- Open the Report you want to create additional calculation fields
- Click the View button
- Click Design View
- Click the Design tab
- Click the Text Box button
MS Access - Lesson 13: Creating Reports (report) Picture 10 - Click on the section on the report where you want to locate the textbox
- Click the Property Sheet button
MS Access - Lesson 13: Creating Reports (report) Picture 11 - Click the Data tab
- Click on the button on the right of Control Source with three dots
MS Access - Lesson 13: Creating Reports (report) Picture 12 - Insert the fields you want to have in the calculation
- Click OK. MS Access - Lesson 13: Creating Reports (report) Picture 13