VBA using Access

Course Type

Scheduled:

Date	Location	Duration	Cost
24 Jul 2012 (Tue) 25 Jul 2012 (Wed) 26 Jul 2012 (Thu) 27 Jul 2012 (Fri)	Washington	4	£ 975
19 Nov 2012 (Mon) 20 Nov 2012 (Tue) 21 Nov 2012 (Wed) 22 Nov 2012 (Thu)	Washington	4	£ 975
All prices exclude VAT

Private:

This outline is available as a private course. Please contact us to arrange this course at a venue and date of your choice.

Private courses can be held at your site or one of our training venues, and can be customised to fit your requirements.

You can choose to have a private course based on an existing outline or you can choose the most applicable lessons from a number of different outlines and consolidate them into one course.

We can also write bespoke courses to fit your specific requirements, whether you require training on a standard application or a bespoke inhouse system.

Please contact us to discuss this further on 0191 377 8377.

Course Overview

This course is aimed at those who would like to develop their skills and knowledge of VBA programming in Access application development.

Prerequisites

Delegates should have attended Access Level 2 and/or Level 3 courses or have equivalent knowledge.
Delegates should be currently working with an Access database application that they have built themselves.
Delegate should also understand table, query, form, report and macro design and function, as well as data normalization and table relationships.

Objectives

Delegates will be able to:

Explain the difference between sub and function procedures in VBA code
List 3 common events and in where they might use them in application design
Write professional VBA code segments with error checking to carry out tasks as defined by your tutor
Use the AccessObject object to create an intelligent report selection form
Build a browse form for quick navigation to a specific record
Create a flexible report such that people may choose its content at run-time
Describe how to debug VBA code

Other courses in this series

Related courses

Course Content

Designing Applications

Introduction to Event Driven Programming

Creating Code

Controlling the Program

Using Access Objects

Using DAO

Reports

Advanced Programming Techniques

Error Handling and Debugging

Using Classes

Libraries and Add-Ins

Multi-User

The Internet (Optional as time permits)

Optimising Your Application

Training Options

Scheduled public courses at one of our training venues
Private course at your company office throughout the UK, at one of our training venues (Durham, Newcastle or Washington) or at an independent location, convenient to you
Bespoke course written to your specific needs, at your company office throughout the UK, at our training venue or at an independent location, convenient to you
For further information please contact us on 0191 377 8377

What's Included

1 delegate per computer
Relaxed refreshment area at our training venues
Lunch and refreshments when training is delivered at our training venue
Comprehensive course manual and exercises

Microsoft Access and Visual Basic for Applications are registered trademarks of the Microsoft Corporation

VBA using Access training courses in North East England, Durham, Washington, Visual Basic for Applications (VBA) using Access training courses in Newcastle, North East

"Trainer was excellent and very approachable"
L.C. CLRN - VBA Using Excel

"Excellent as always"
S.W. National Grid - PhotoShop Level 1

"The trainer was excellent, he listened to what we wanted to gain from the course and didn’t waste time trying to teach us things we would never use, he explained in simple terms..."
P.C. Northumbria Police - Excel Level 2

"Great, exactly what I wanted at a level I could understand"
P.A. Straughans - Access Level 1

"Having one-on-one training was unexpected but was a tremendous bonus. Could not fault the day"
D.R. UK Asset Resolution - PowerPoint Level 2

"This is my second course and I have enjoyed both and have another booked for February so I wouldn't change anything"
T.S. Bell Truck and Van - Excel 2007 / 2010 Level 2

"This is my third course and I have enjoyed them all"
T.S. Bell Truck and Van - PowerPoint Level 2

"Knowledge and professionalism of the trainer was excellent, questions encouraged and answered knowledgeably"
J.M. The Cyrenians - VBA using Excel

"I enjoyed the course and was pleased with the speed it progressed"
G.J. NCFE - HTML Level 1

"Very good way to teach. Nice mix of theory and practice"
K.F. Durham University - Access Level 2

View More | Hide