Instructor-led training - Access VBA Training
Request a callback

We'll call during UK business hours

Name:
Number:
0207 987 3777

Microsoft Partner

Learning & Performance Institute - Accredited Training Provider

How to book

On-site / Closed company:

60 second quote

Need help or advice?

Enter your name/number and we will call you back

We'll call during UK business hours

Name:
Number:

Access 2010 VBA Training Courses London, UKAccess 2010 VBA Basics Training Course

Microsoft Access Intro Intermediate 2010

Syllabus here

2 day course

Instructor-led / Microsoft qualified trainers

Courses never cancelled: Guaranteed
Guarantee applies to Microsoft Desktop training and Management Skills Training.

Benefits

  • 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.
London & UK wide

Who is this course for?

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.

Prerequisites

A high proficiency of Microsoft Access is essential, or completion of our Microsoft Access Advanced course.

Benefits

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

Course Syllabus

Getting Started

Introduction to access programming
Understanding the development environment
Using VB help

Developing with Procedures and Functions

Understanding and creating modules
Defining procedures
Creating a sub-procedure
Calling procedures
Utilising the immediate window to call procedures
Making and naming a function procedure
Working using the code editor

Understanding Objects

Understanding classes and objects
Navigating the Access object hierarchy
Understanding collections
Using the object browser
Working with the application object
Understanding the form object
Working with properties
Using the with statement
Working with methods
Understanding the DoCmd object
Working with events
Understanding the order of events

Utilising Intrinsic Functions, Variables and Expressions

Defining expressions and statements
How to declare variables
Determining data types
Programming with variable scope
Harnessing intrinsic functions
Defining constants and using intrinsic constants
Adding message boxes and using input boxes
How to declare and use object variables

Controlling Program Execution

Understanding control-of-flow structures
Working with boolean expressions
Using the if...end if decision structures
Using the select case...end select structure
Using the for...next structure
Using the for each...next structure
Using the do...loop structure
Guidelines for use of branching structures

Working with Recordsets

Declaring and creating object variables
Working with the ADODB recordset object
Specifying a recordset cursor type
Locking records for updating
Specifying a recordset cursor location - optional
Using the cache size property - optional
Understanding recordset cursor properties - optional

Debugging the Code

Defining errors
Working with debugging tools
Determining breakpoints
How to step through code
Working with break mode during run mode
Identifying the value of expressions

Handling Errors

Understanding error handling
Understanding VBA's error trapping options
Trapping errors with the on error statement
Understanding the error object
Writing an error handling routine
Working with inline error handling

What you get

Training room

Training is held in our modern, comfortable, air-conditioned suites

Modern-spec IT, fully networked with internet access

"What do I get on the day?"

Learning tools

Breaks and TimingsBreaks and timing

Courses start at 9:30am.
Please aim to be with us for 9:15am.
Joining information (how to get to our venues)

In-course handbookIn-course handbook

Contains unit objectives, exercises and space to write notes

RefreshmentsRefreshments

Available throughout the day:

  • Hot beverages
  • Clean, filtered water
  • Biscuits
Reference materialReference material

Available online. 100+ pages with step-by-step instructions

LunchLunch

Lunch is provided at a local restaurant or pub. Browse the sample menus:

24 months forum access24 months access to Microsoft trainers

Your questions answered by Microsoft qualified trainers online.

Training Formats & Services

Training formats available

Some reasons why thousands of businesses trust us

Transparent quality control
Live 12 month schedule/bookings
Courses never cancelled: Guaranteed
Guarantee applies to Microsoft Desktop training and Management Skills Training.
Reschedule in seconds
Industry leading pricing model
Online quote
24 months training support

Testimonials

PwC
Senior Associate/Executive
Anna Decourcy
Access VBA
The trainer is a very clear and concise trainer. He was very patient with the varying levels of skill in the room and worked through the content with enthusiasm and related examples back to the delegates work places.

Would definitely recommend and will be using what I've learnt tomorrow!
Meridian ISE
Andrew S
Access VBA
Very good. Trainer able to give very useful help on real world issues.
UBS Global Asset Management

Access VBA
Good course. Very helpful trainer. Pace was a little bit slower today for me but understandable with different levels in the group. Having somewhere to go for lunch is also a very welcome addition to courses!

More testimonials

Some of our clients:

London 2012 Special Olympics Great Britain UK Sport
13 delegates 19 delegates 29 delegates
92% would
recommend us
100% would
recommend us
100% would
recommend us
Ricoh Europe plc Transport for London Virgin Media Television
12 delegates 35 delegates 19 delegates
100% would
recommend us
85% would
recommend us
100% would
recommend us
BBC Barclays PLC Home Office
17 delegates 83 delegates 61 delegates
100% would
recommend us
100% would
recommend us
100% would
recommend us
Rabobank Unilever Ocado
54 delegates 80 delegates 27 delegates
100% would
recommend us
96% would
recommend us
100% would
recommend us
HSBC Marriott International KPMG LLP (UK)
106 delegates 29 delegates 29 delegates
100% would
recommend us
95% would
recommend us
100% would
recommend us
Cancer Research UK IOM Lloyds Banking Group
16 delegates 85 delegates 124 delegates
100% would
recommend us
100% would
recommend us
97% would
recommend us
Marks and Spencer British Sky Broadcasting Ltd NHS 2
30 delegates 14 delegates 60 delegates
100% would
recommend us
100% would
recommend us
100% would
recommend us
Sony Europe Accor Group Shell UK Ltd
25 delegates 28 delegates 86 delegates
100% would
recommend us
100% would
recommend us
98% would
recommend us

Learn all about Procedures, Functions, and Objects in our VBA Basics Training Courses for MS Access. Three levels are available: Introduction, Intermediate and Advanced.

This basics course teaches control program execution, forms and working with the PivotTable object - a popular unit among most of our course attendees.

On-site and Closed company formats are available.



Access courses
Course rating:
4.8 stars - based on 4042 reviews
Microsoft Certified Partner Institute of Leadership and Management - Certified Courses Learning and Performance Institute - Accredited Training Provider Security Seal verified by visa, mastercard securecard

Connect with us: Facebook · Twitter · Google+ · LinkedIn · Pinterest

2nd Floor, CA House, 1 Northey Street
Limehouse Basin, London, E14 8BT
United Kingdom