London Training Courses

Microsoft Courses

Mac Office Courses

Adobe Courses

More Courses

Google Docs Courses

Get Expert Tailored Training Solutions

MS Access 2007 VBA Training Course in London

Our MS Access 2007 VBA course will provide users that have existing advanced level skills in Access to build on their knowledge. The Visual Basic course will focus on automating repitive tasks in Access using the VBA programming language. The course is designed for users who need to validate data, build complex Access routines for Importing, Exporting or Report Building.

To maximize the gain you receive from our MS Access 2007 VBA training course, it is recommended that you have attended our MS Access Advanced course or that you are at a similiar level.

Unlike training companies offering scheduled courses, we offer the alternative of your Microsoft Access Training Course delivered in central London on a date of your choice, either onsite or at our offices near Moorgate, Bank or Liverpool Street either 1 to 1 or as part of a group.

If this sounds like the training course you require, then please contact us on 020 7920 9500 or click the Contact Me Now button below. A member of our team will get back to you asap.

Microsoft Access 2007 VBA Training Course

Microsoft Access VBA (Visual Basic) Training Course

Duration - This is a 2 day course starting at 09:30 until 16:30 each day

Course Objectives -This course is designed to take your Access databases to the next level by using VBA.

Working with Macros

Creating Macros
Assigning Macros to Controls
Group Macros
Conditional Macros
The AutoExec Macro
The AutoKeys Macro

Synchronising Forms using Macros

Visual Basic For Applications

What is it, and Why use it?
The Environment
Working with Modules

Converting Macros to VBA

DoCmd

Event Driven Programming

VBA Syntax
Getting Help

Code Structures

Loop structures
Decision making structures

Subroutines and Functions

Calling
Availability

Variables and Constants

Option Explicit
Variable Type
Scoping a Variable
Testing Variable Contents

User Interaction

MsgBox
InputBox

Error Trapping and Debugging

Breakpoints
Stepping Code
The Immediate Window
Creating Error Traps

Data Access Objects (DAO)

The Workspace Session
Manipulating Recordsets
Creating Queries
Creating Tables

ActiveX Controls

VBA Menus and Toolbars

MS Access Training Courses - All versions and Levels

Access 2007 Introduction

Access 2007 Intermediate

Access 2007 Adavanced

Access 2007 VBA

Access 2003 Introduction

Access 2003 Intermediate

Access 2003 Advanced

Access 2003 VBA

Access 2002 Introduction

Access 2002 Intermediate

Access 2002 Advanced

Access 2002 VBA

Access 2000 Introduction

Access 2000 Intermediate

Access 2000 Advanced

Access 2000 VBA

Access 97 Introduction

Access 97 Intermediate

Access 97 Advanced

Access 97 VBA

How to book

Contact us via email or call us on 020 7920 9500
We agree a date and course outline with you
Confirmation takes place by email or phone
That's it!

Training Course Info

You can also download our MS Office Training Manuals for Microsoft Office 2000, 2002(XP) and 2003

Course Costs

1-to-1 training courses are charged at £450 per day. (Our offices or your venue)

All IT training courses at our offices are charged at a daily rate of £695 per day, for 2 to 8 delegates.

We also offer training at your venue for £595 per day. If required, laptops are available at an additional £150 per day.

For courses outside the M25, trainer travel and accomodation expenses are not included in the above prices but are charged at cost.

Build your course

With our course builder form, you can choose your own topics and build a course that suits your needs and your time scale. Select a application below to go to the Course Builder page