© AFI Expertise inc. |
| Audience | Any data base user or manager |
Prerequisites | Windows - User or equivalent Following training: Access - Data structuring and normalization |
Objectives | - Identify the role of forms in the database.
- Identify the role of forms and reports in the database
|
Teaching method | Presentations - Demonstrations - Guided and Individual Exercises |
Contents | Chapter 1 - Creating Forms - Using the form creation wizard
- Creating a blank form
- Accessing the form's operating modes
- Manipulating form sections
- Changing the way records are displayed
- Setting the tab order
- Changing the appearance of a form window
- Displaying history in memo fields
|
Chapter 2 - Changing the Location, Size and Appearance of controls - Manipulating controls
- Manipulating the organization of controls in creation mode (Tabular, Stacked)
- Identifying types of controls
- Adding a control
- Modifying the organization parameters of Tabular controls
- Controlling access to dependent controls in a form
- Modifying the value of a control
- Modifying the value of a control's property
|
Chapter 3 - Managing Form Styles and Templates - Creating a template
- Using, creating, and modifying automatic layouts with themes
- Reproducing the layout
- Using conditional formatting
- Adding images to continuous forms
- Using margins and verticality in a control
- Using tooltips
- Controlling access to dependent controls in a form
|
Chapter 4 - Creating Nested and Independent Forms - Using forms based on a multi-table query
- Using the sub form
- Modifying the sub form
- Creating Pivot Tables
|
