Visual Basic for Access – VBA

Course Duration is 2 Days

£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. 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.

 

Measuring The Success

 

The purpose of your training is learning new skills and/or changing behaviour. We can help you measure this!

To evaluate how successfully the attendees are doing this, delegates can attend a Workplace Implementation session during the skills transfer period. The cost of the session is £595+VAT delivered virtually and 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.