Office 2003Post-Advanced Concepts

and Techniques

M i c r o s o f t

Access Project 7

Advanced Report and Form Techniques

2Access Project 7: Advanced Report and Form Techniques

Objectives

• Create a report in Design view

• Create queries for reports

• Add fields to a report

• Add a subreport to a report

3Access Project 7: Advanced Report and Form Techniques

Objectives

• Modify a subreport

• Add a date

• Add a page number

• Create and print mailing labels

4Access Project 7: Advanced Report and Form Techniques

Objectives

• Add command buttons to forms

• Modify VBA code associated with a command button

• Add a combo box to a form

• Modify properties of a combo box

5Access Project 7: Advanced Report and Form Techniques

Creating an Initial Report

6Access Project 7: Advanced Report and Form Techniques

Creating an Initial Report

7Access Project 7: Advanced Report and Form Techniques

Adding Fields to the Report

8Access Project 7: Advanced Report and Form Techniques

Saving the Report

9Access Project 7: Advanced Report and Form Techniques

Adding a Subreport

10Access Project 7: Advanced Report and Form Techniques

Modifying the Subreport

11Access Project 7: Advanced Report and Form Techniques

Adding a Date

12Access Project 7: Advanced Report and Form Techniques

Adding a Page Number

13Access Project 7: Advanced Report and Form Techniques

Creating Labels

14Access Project 7: Advanced Report and Form Techniques

Adding Command Buttons to a Form

15Access Project 7: Advanced Report and Form Techniques

Adding a Combo Box to a Form

16Access Project 7: Advanced Report and Form Techniques

Modifying the Add Record Button

17Access Project 7: Advanced Report and Form Techniques

Modifying the Combo Box

18Access Project 7: Advanced Report and Form Techniques

Summary

• Create a report in Design view

• Create queries for reports

• Add fields to a report

• Add a subreport to a report

19Access Project 7: Advanced Report and Form Techniques

Summary

• Modify a subreport

• Add a date

• Add a page number

• Create and print mailing labels

20Access Project 7: Advanced Report and Form Techniques

Summary

• Add command buttons to forms

• Modify VBA code associated with a command button

• Add a combo box to a form

• Modify properties of a combo box

Office 2003Post-Advanced Concepts

and Techniques

M i c r o s o f t

Access Project 7 Complete