merger merger

Welcome to your new course portal!

On October 15th, moved to - which means you can now find all your favourite courses right here. Don't worry - you can still do all the things that you could do before.

All you need to do is search.

Show as: Mobile

Access VBA

Course summary
2 days
Corporate Training for Teams
STL courses

Access VBA

Courses never cancelled. Last minute rescheduling. 24 month delegate support forum. And more... At the end of the course the delegate will have covered the fundamentals of VBA, including working with procedures and functions, understanding objects, using expressions, variables and intrinsic functions.; They will have mastered how to control program execution, working with forms and controls, working with the PivotTable object.; Finally the course also includes modules on debugging code, handling errors to ensure minimal downtime while building and effecting the program.

STL virtual classroom training

We all have to accept our preferred face-to-face method just isn't an option right now. However, virtual classroom training that we have developed offers some benefits which can make it seem less of a compromise and more of a viable interim training solution. 

Our virtual classroom training is delivered by the same team responsible for achieving industry leading customer satisfaction ratings with face-to-face training, so rest assured you are in safe hands.

Suitability - Who should attend?

Advanced users of Microsoft Access responsible for managing very large and variable amounts of data, or teams, who want to learn how to program features and functions to improve the accessibility and usability of their data.

Training Course Content

Getting StartedIntroduction to access programmingUnderstanding the development environmentUsing VB helpDeveloping with Procedures and FunctionsUnderstanding and creating modulesDefining proceduresCreating a sub-procedureCalling proceduresUtilising the immediate window to call proceduresMaking and naming a function procedureWorking using the code editorUnderstanding ObjectsUnderstanding classes and objectsNavigating the Access object hierarchyUnderstanding collectionsUsing the object browserWorking with the application objectUnderstanding the form objectWorking with propertiesUsing the with statementWorking with methodsUnderstanding the DoCmd objectWorking with eventsUnderstanding the order of eventsUtilising Intrinsic Functions, Variables and ExpressionsDefining expressions and statementsHow to declare variablesDetermining data typesProgramming with variable scopeHarnessing intrinsic functionsDefining constants and using intrinsic constantsAdding message boxes and using input boxesHow to declare and use object variablesControlling Program ExecutionUnderstanding control-of-flow structuresWorking with boolean expressionsUsing the if...end if decision structuresUsing the select case...end select structureUsing the structureUsing the for structureUsing the do...loop structureGuidelines for use of branching structuresWorking with RecordsetsDeclaring and creating object variablesWorking with the ADODB recordset objectSpecifying a recordset cursor typeLocking records for updatingSpecifying a recordset cursor location - optionalUsing the cache size property - optionalUnderstanding recordset cursor properties - optionalDebugging the CodeDefining errorsWorking with debugging toolsDetermining breakpointsHow to step through codeWorking with break mode during run modeIdentifying the value of expressionsHandling ErrorsUnderstanding error handlingUnderstanding VBA's error trapping optionsTrapping errors with the on error statementUnderstanding the error objectWriting an error handling routineWorking with inline error handling


Prices from £579. Promotional rates often available the further ahead you book. Contact us for quote.

Be Inspired! Watch the Video

Provider: STL

STL - Microsoft Training

STL - Helping businesses deliver productivity and efficiency gains

Learning solutions from leadership and management training programmes to business intelligence and applications training. London based with a global reach....

Read more and show all courses with this provider

Request information - obligation free

Fill out your details to find out more about Access VBA.

  Contact the provider

  Get more information

  Register your interest

Customer Outreach Award


We believe that it should be easy for you to find and compare training courses. 

Our Customer Outreach Award is presented to trusted providers who are excellent at responding to enquiries, making your search quicker, more efficient and easier, too.

Contact information for STL


Greater London
STL, 2nd Floor, Cruising Association House
E14 8BT 1 Northey Street

 Show phone number

Request Information

Find out more about this Access VBA course - simply fill out your details:


There are no reviews available yet.

U.K. L&D Report: 2019 - Benchmark Your Workplace Learning Strategy

Are you curious about the L&D strategies of some of the U.K.'s top companies?

Find out what they're up to in's second annual U.K. L&D Report!


Learn more

Be Inspired - watch the videos

Similar Courses