FR
EN
Details
Goals
Being able to program with Visual Basic (VBA) in Access.
Prerequisite
Working experience with Microsoft Access.
Contents
Introduction
- Introduction to VBA
- Terminology
- Objects
- Collections
- Properties
- Methods
- Events
- Modules
- Sub Procedures
- Functions
- The Visual Basic Editor
Modules
- General modules
- Concepts and uses
- Forms and report modules
- Concepts and uses
Variables
- Definition
- Variable declaration and Data Types
- Local and global variables
Controlling Program Execution
- Conditional structures
- If
- Select Case
- Loop structures
- For & For Each
- Do Loop
- Interactivity
- Inputbox
- Msgbox
DAO
- Concepts
- Object hierarchy
- Recordsets
- Read, update, add and delete records
VBA Debugging Tools
- Errors in Code
- Debugging Techniques
Handling Runtime Errors
- Understanding error handling
- Understanding VBA's error trapping options
- Trapping errors with the On Error statement
Sign up
Next session(s)
Need a custom training?
None of the trainings fit your requirements? You have specific needs? Key Job trainers are versatile and flexible. Contact us!