Microsoft VBA for Access
Overview:
The Microsoft VBA for Access training course will teach users how to use Microsoft Access programming to automate processes and link together database objects.
Topics covered include:
– Introduction to VBA for Access
– Using forms and modules in VBA
– Creating subroutines and functions and working with variables
– Program structures using IF and CASE statements
– Repeating operations using programming loops
– Using DoCmd object
– Debugging in VBA
– Error handling routines
Course Details:
Duration: 2 Days
Level:
This course has only one level
Related Course:
Learning Outcomes:
At the completion of this courseware participants will be able to:
- Understand some of the aspects of developing applications in Access
- Use macros in Access
- Understand the programming environment and how forms and modules are used
- Create and work with subroutines and function procedures
- Create and work with variables
- Communicate with the user through input boxes and message boxes
- Program decision structures using IF and CASE statements
- Develop a variety of programming loops for repeating operations
- Use the DoCmd object to perform most of the operations associated with a database
- Use DAO to handle working with data in your programs
- Use ADO to handle working with data in your programs
- Use the debugging features of VBA to locate and identify errors
- Develop safeguards in your program and prevent unforeseen errors.
Prices:
| Trainees | Price | |
|---|---|---|
| 1-3 trainees | $1,650 | per day |
| 4-8 trainees | $1,980 | per day |
| Each additional trainee | $154 | per day |
