Access Module 4 - Automating Databases without Programming
This course is currently not scheduled on the open calendar, but can be organized on request.
Request CourseDuration
1 day(s)
MS Access: Module 4 – Automating databases without programming
Duration
1 day
Audience
The course is intended for all users who want to automate tasks in an existing database without having to write VBA code.
Prerequisites
Having followed the course " MS Access: Creating and using databases" or having the experience of using MS Access. Being able to create tables, relationships, queries, forms and reports. A good knowledge of working in a Windows environment and file management is necessary.
Objectives
Explore wizards, properties, conditional formatting and macros to automate tasks in an Access database.
Methods
Instructor-led classroom training, where to automate tasks in an existing database is the common thread throughout the course. Thanks to specific problems, the theory will be directly linked to practice.
Description
The students start by consulting an existing database with tables, relationships, queries forms and reports. First, wizards are used in various database objects. The properties of forms, reports and controls are also discussed in detail. Using Conditional Formatting, we apply automatic formatting in forms and reports. The database is further automated through the different types of macros and different types of macro actions.
Contents
- Introduction
- Tools to automate tasks
- Preparation (analysis of tasks to be automated)
- Use available Wizards
- Properties of forms, reports and controls
- Apply conditional formatting to forms and reports
- Macros
- Create independent macros
- Create embedded macros
- Add and manage macro actions
- Run independent and embedded macros
- Debug a macro
- Program flow in macros
- Add comment
- Conditions in macros
- Submacros
- Group macro actions
- Add error handling to a macro
- Data macros
- Introduction
- Create an event-driven data macro
- Create a named data macro