Classroom Training
Access VBA
Available as classroom training course only
£950 + VAT for most venues (£1,095 + VAT for London)
2 days
Access supports two different programming languages:
- The painting-by-numbers macros, which you can use to perform basic functions;
- The far more powerful VBA (Visual Basic for Applicatons) programming language.
If you're going to be using Access, we think you should be learning VBA - it's far more powerful, and is compatible with the programming languages used by other MS Office applications such as Excel and Word. On this two-day course you'll learn about the DoCmd object, variables, handling form events, linking to recordsets and much more!
We don't have any dates scheduled for this course, but we may well consider adding them - it's always worth asking.
Alternatively, you could enquire about running the course in your office or even (if available) as a tailored online course.
Course Contents
The contents of this course are as follows:
The VBA code editor
- Two ways to create modules
- Using Project Explorer
- Basic subroutines and comments
Messages and variables
- The all-powerful DoCmd object
- Displaying messages
- Getting input from users
- Using variables
Creating functions
- Passing arguments
- Returning values
Visual Basic explained
- Objects and collections
- Methods and properties
- The Access object model
- Getting help in VBA
Attaching code to forms
- Attaching code to buttons
- Attaching code to events
- Manipulating form/control properties
- Making code not form-specific
Looping
- The four types of loop
- Looping over all open forms
- Looping over controls
- Looping over Access Objects
Recordsets
- Choosing ADO or DAO
- Adding data
- Editing data
- Deleting data
Debugging and error handling
- Stepping through macros
- Setting breakpoints
- Trapping for errors
Case studies
- Navigation buttons
- Creating a simple menu
- Validating forms
- Criteria forms
If time
Linking to Excel and Word
- Referencing other applications
- Manipulating Excel from Access
If time
Modifying queries
- Basic SQL statements
- Amending queries' SQL
Delegates should only attend this course if they have a good working knowledge of Access basics, and if they are proficient computer users. Experience of programming, while useful, is not essential.
Why Choose Us?
- No more than 6 people per class
- Proper restaurant lunch included
- 520 references viewable online
- Free USB stick containing course files
- Genuine Wise Owl trainers only
- Unbelievably good courseware
Sample customer feedback
Our thanks to everyone who agreed to share their thoughts (note that some of these reviews may be for our online courses).
Paul Roberts (SMC Pneumatics)
Paul Brown (Knight Frank)
Tom Stevens (Warner Bros Entertainment UK Ltd)
Adam Ratcliff (Whitemeadow Furniture Ltd)
Thomas Critchley (Department for Levelling Up, Housing and Communities (DLUHC, ex MHCLG))
There are lots more where these came from (or just refresh this page to change the quotes shown).
Related Courses
Other Microsoft Access training resources
Access exercises
If you're learning Access VBA, you may want to have a look at the course exercises before booking a place.
View Access VBA or Access 2010 exercises
Access blogs
We've published a range of blogs on Microsoft Access and Access VBA to help you learn this challenging subject.
View Access or VBA macros blogs