Visual Basic for Access – VBA
£595.00 Plus VAT (per person)
Have more than 2 delegates? Talk to us about our closed group courses.
Delivery Method
Open Public Courses – Virtual Delivery Only Closed Group Courses – Face To Face and Virtual Delivery
Business Benefit
The use of Visual Basic in Access unlocks the true power of this application. Creat powerful yet user friendly applications that will be capable of running critical business processes.
Who Should Attend
Those who require the fundamental skills to create useful and powerful VB applications.
Learning Outcomes
Explore variables and objects
Create robust codes
Manipulate data
Work with Command and Function procedures
Understand Variables
Work with Objects
Create User Forms
Set options within Access
Observe event handling codes
Debug Code
Course Content
Introduction to the Access VBA environment
Using Variables
Objects
Decision Making Code
Code that repeats
Using VBA to display information
Manipulating Forms and Reports
Events
User defined menus & toolbars
Breakpoints and watches
The Immediate Window
Manipulating Data in Database Tables
How to Book
Dates below represent open public courses only. To book this course, please select an available date and click the book now button below to complete the booking by Credit Card or via Invoice. Have two or more people to train – you may consider a closed group course. Contact us on [email protected] to discuss specific date and delivery requirements.
The purpose of your training is learning new skills and/or changing behaviour. We can help you measure this!
Post-course, to evaluate how successfully the attendees are doing this, delegates can attend a Workplace Implementation session during the skills transfer period. This additional session lasts for 2.5 hours.
During the Workplace Implementation session the individuals will either on a 1-2-1 basis or as a group discuss the challenges and successes they have experienced during their skills transfer period.
This will include what they are doing differently as a direct result of the training and how this has positively impacted the organisation.
This is an excellent way to encourage the learning, support the skills transfer into the workplace and act as a measure to evaluate the training.
We compile this information into a report so that you have evidence of your return on investment.