Access Training
Access VBA Training Course
£695 + VAT for most venues (£850 + 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 (or consider an onsite Access training course).
Course Contents
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
Why Choose Us?
No more than 6 people per class- Proper restaurant lunch included
- 491 references viewable online
- Free USB stick containing course files
- Genuine Wise Owl trainers only
- Unbelievably good courseware
Sample customer feedback
Mitalee Pisavadia (Public Health England)
Julie Truong (Symphony EYC)
Gemma Wood (Loftware)
Chris Chandler (Trafford Housing Trust)
Bob Hurst (Bishop Grosseteste University)
There are lots more where these came from (or just refresh this page to change the quotes shown).
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.
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 skills assessment
You can test how well you know Access VBA using one of the tests at our separate skills assessment site.
View Test your Access skills skills assessment tests
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