Access Training - Advanced automation using VBA
Access training for delegates that need to develop Access applications for third party use with a high degree of automation. This course is dedicated to the use of Visual Basic for Applications (VBA) within Microsoft® Access.
Course content
- Using VBA for graphical user interface automation
- Using VBA for table level record manipulation
- Creating custom functions
- String manipulation
- Populating multiple tables from unbound forms
- Error handling
- Event procedures
- Controlling program flow
- Using message boxes and Input boxes
- Access Object Model
- Data Access Objects (DAO)
- The VBA development Environment
- Debugging
Course prerequisites:
Delegates are expected to be fully conversant with designing relational databases using Microsoft® Access. No previous knowledge of Visual Basic or VBA required.
