INTRODUCTORY MICROSOFT ACCESS Lesson 5 – Reports and Macros

1. INTRODUCTORY MICROSOFT ACCESSLesson 5 – Reports and Macros

2. Objectives • Create a report using a Report Wizard. • Modify a report. • Create and run a macro.

3. Terms Used in This Lesson • Database report • Grouping • Macro

4. Create a Report Using a Report Wizard • Database reports allow you to organize and print database records. Reports are compiled by creating a report object. The easiest way to create a report object is to use the Report Wizard. • To create a report, click Reports on the Objects bar, and click the New button. • In the New Report dialog box, choose Report Wizard and select the table Access will use to create the report.

5. Create a Report Using a Report Wizard (cont.) • Next, choose the fields for the report in the Report Wizard dialog box. • You can also group, sort, and specify summaries for fields in the report.

6. Create a Report Using a Report Wizard (cont.) • Choose the layout and orientation for the report in the Layout options dialog box.

7. Create a Report Using a Report Wizard (cont.) • Choose the style for the report in the Style options dialog box.

8. Create a Report Using a Report Wizard (cont.) • The last step is to name the report. Use a name that gives an indication of the report’s output. • After Access creates the report, you can preview the report or modify the report’s design. • When finished, Access will save the report automatically with the name that you entered.

9. Modifying a Report • Reports are modified in Design view. A report in Design view is divided into sections. Each section controls a part of the report and can be modified.

10. The Toolbox has tools that you can use to modify reports. Modifying a Report (cont.)

11. Modifying a Report (cont.) REPORTSECTIONS

12. Creating a Macro • Macros automate tasks that you perform often. It is a collection of one or more actions that Access can perform on a database. • To create a macro, click Macros on the Objects bar and click the New button.

13. Creating a Macro (cont.) • In the Macro window, specify the actions to be performed by the macro.

14. Summary • Database reports allow you to organize, summa- rize, and print data in a database. Database reports are compiled by creating a report object. • The easiest way to create a report object is to use the Report Wizard. When using the Report Wizard, first choose the table on which you want to base the report and the fields of that table you want to include in the report. You can also choose to group, sort, or summarize the records in the report.

15. Summary (cont.) • The Report Wizard also allows you to choose a layout, orientation, and style for your report. The style can give a report a casual or formal look. • Reports are modified using Design view. Each report is divided into sections. Each section controls a different part of the report and can be modified.

16. Summary (cont.) • Macros automate tasks that you perform often. The Macro window allows you to create a macro object.