Audience | Any data base user or manager |
Prerequisites | Windows - User or equivalent Following training: Access - Data structuring and normalization |
Objectives | - Understand the distinction between Selection and Action requests
- Able to define globally the possibilities offered by Action queries
- Able to design and execute an Action query
|
Teaching method | Presentations - Demonstrations - Guided and Individual Exercises |
Contents | Chapter 1 - Setting up a Query |
Chapter 2 - Manipulating records with Action Queries - Create a Query Add
- Use the Delete query
- Make a Create a Table Query
- Make an Update Query
|
Chapter 3 - Customizing the Database - Create groups of objects
- Define operating options
- Perform automatic correction of object names
|
Chapter 4 - Automating Object Management - Create a macro and discover the macro editor
- Differentiate between command macros and built-in macros
- Execute a macro
- Associate a macro with a command button
- Open and close a form with a macro
- Associate the macro with a trigger event
|
Chapter 5 - Automating Printing - Print specific records
- Attach the print macro to the right event
|
Chapter 6 - Interacting with the User - Use message boxes
- Use conditional macros
|
Chapter 7 - Automating the Search - Filter records
- Perform a search
|
Chapter 8 - Using Table Events - Choose the appropriate table event
- Create a table event
- Delete a table event
|
Chapter 9 - Defining Startup Options - Access the configuration options
- Create a main menu
- Use the AutoExec macro
|