© AFI Expertise inc. |
Audience | Any data base user or manager |
Prerequisites | Windows - User or equivalent Following training: Access - Data structuring and normalization |
Objectives | - Able to manipulate the comprised elements (sections, controls) of reports.
- Learn how to optimize the presentation and functionality of reports
|
Teaching method | Presentations - Demonstrations - Guided and Individual Exercises |
Contents | Chapter 1 – Modifying the Structure and Appearance of a Report - Access the creation mode of a report
- Manipulate the sections of a report
- Manage page breaks in a report
- Insert pagination and date codes in a report
|
Chapter 2 - Changing the Location, Size and Appearance of Controls - Manipulate controls
- Manipulate the organization of controls in creation mode (Tabular, Stacked)
- Identify the types of controls
- Add a control
- Modify the organization parameters of Tabular controls
- Control access to dependent controls in forms
- Modify the value of a control
- Modify the value of a control's property
|
Chapter 3 - Performing a Mailing - Create a report for printing labels
- Create a report for printing envelopes
- Create a sample letter
|
Chapter 4 - Creating Summary Reports - Perform grouping and sorting in a report
- Use calculated fields in group sections
- Use statistical functions
|
Chapter 5 – Representing Data Graphically - Add a graphic control to a report
- Modify the elements of the graph
|
Chapter 6 - Creating Nested and Independent Reports - Add sub-reports
- Create a compressed report of independent sub-reports
|
Chapter 7 - Using Command Buttons - Create an application form
- Use the command button wizard
- Manipulate event properties
- Create a start-up form
|