|
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
168 Access events in the next 12 months, live dates & pricing here |
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.
Objectives
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 Developing with Procedures and Functions Understanding and creating modules Understanding Objects Understanding classes and objects Utilising Intrinsic Functions, Variables and Expressions Defining expressions and statements | Controlling Program Execution Understanding control-of-flow structures Working with Recordsets Declaring and creating object variables Debugging the Code Defining errors Handling Errors Understanding error handling |
|
||||||||
| Date | Location | Places available |
Book | Next place rate (£) | List price |
|||
|---|---|---|---|---|---|---|---|---|
| Pay by Card |
Pay by Invoice |
|||||||
| Mon 22 + Tue 23 Jul 2013 | Bloomsbury | 9 | ![]() |
£380 | £390 | £650 | ||
| Wed 23 + Thu 24 Oct 2013 | Bloomsbury | 10 | ![]() |
£275 | £285 | £650 | ||
| Wed 11 + Thu 12 Dec 2013 | Bloomsbury | 10 | ![]() |
£650 | £650 | £650 | ||
| Thu 30 + Fri 31 Jan 2014 | Southwark | 10 | ![]() |
£275 | £285 | £650 | ||
| Mon 10 + Tue 11 Mar 2014 | Bloomsbury | 10 | ![]() |
£650 | £650 | £650 | ||
| Tue 22 + Wed 23 Apr 2014 | Southwark | 10 | ![]() |
£275 | £285 | £650 | ||
| Thu 5 + Fri 6 Jun 2014 | Bloomsbury | 10 | ![]() |
£650 | £650 | £650 | ||
| Mon 28 + Tue 29 Jul 2014 | Bloomsbury | 10 | ![]() |
£275 | £285 | £650 | ||
What you get
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 |
Courses start at 9:30am. |
Contains unit objectives, exercises and space to write notes |
Available throughout the day:
|
Available online. 100+ pages with step-by-step instructions |
Lunch is provided at a local restaurant or pub. Browse the sample menus: |
Your questions answered by Microsoft qualified trainers online. |
Training Formats & Services
|
Some reasons why thousands of businesses trust us
|
|




























