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

Carphonewarehouse
Paul B
Access VBA
Knew the subject matter, had good exercises to do and also good practices.
Meridian ISE
Andrew S
Access VBA
Very good. Trainer able to give very useful help on real world issues.
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!

More testimonials

Some of our clients:

London 2012 Special Olympics Great Britain Transport for London
13 delegates 19 delegates 35 delegates
92% would
recommend us
100% would
recommend us
85% would
recommend us
Virgin Media Television Ricoh Europe plc UK Sport
19 delegates 12 delegates 29 delegates
100% would
recommend us
100% would
recommend us
100% would
recommend us
BBC Macmillan Publishers Ltd Barclays PLC
17 delegates 41 delegates 83 delegates
100% would
recommend us
98% would
recommend us
100% would
recommend us
Legal & General BP plc Vax Ltd
25 delegates 86 delegates 16 delegates
100% would
recommend us
100% would
recommend us
100% would
recommend us
Betfair Home Office Marks and Spencer
15 delegates 61 delegates 30 delegates
100% would
recommend us
100% would
recommend us
100% would
recommend us
DHL Ocado Live Nation Entertainment
42 delegates 27 delegates 15 delegates
94% would
recommend us
100% would
recommend us
100% would
recommend us
Vue Entertainment J Sainsburys PLC Carphone Warehouse
15 delegates 11 delegates 10 delegates
100% would
recommend us
100% would
recommend us
100% would
recommend us
Marriott International Accor Group The Capita Group Plc
29 delegates 28 delegates 61 delegates
95% would
recommend us
100% would
recommend us
100% 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: Google+ · Facebook · Twitter · LinkedIn · Pinterest

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