Book your Microsoft Access VBA Introduction Training Course
This two day course is being run three times between Monday 2nd April 2012 and Monday 1st October 2012 in London,
Book this course with us today from as little as £495.00 + VAT and with our price guarantee you can be confident of getting great value. Our team of experienced independent booking administrators will make the joining process painless and by providing feedback on your experiences you’ll also influence the Coursebookers independent course ratings.
See all courses provided by 2-e-2Expert Help
If you would like
advice, or to book, call
one of our experts on
Open: 9am - 5:30pm
Monday- Friday
Locations/dates for this course
| Date | Location | Rating | Price | ||
|---|---|---|---|---|---|
| Monday 02 April 2012 | London |  | Save £55.00 | £495.00+VAT | |
| Monday 02 July 2012 | London | | Save £55.00 | £495.00+VAT | |
| Monday 01 October 2012 | London | | Save £55.00 | £495.00+VAT |
Book your course now with Coursebookers!
Making an enquiry to Coursebookers couldn't be easier, just fill out the form to the left or call 01920 460232 and our team will be in touch within 48 hours.
Remember:
- Not only are we great value, we can also boast no booking fees
- Human administrators make booking & coordination simple and painless
- Coursebookers is vendor neutral we can offer unbiased and independent advice
- If you have complex booking requirements we're happy to help! Call our team on 01920 460232 to discuss your needs
- We ensure all our courses meet our high standards, meaning you'll only ever see "the best of the best" on Coursebookers!
Download Course OutlineSummary:
The skills and knowledge acquired in Microsoft Access VBA Introduction are sufficient to be able to use and operate the software at an efficient level.
PreRequisites:
Microsoft Access VBA Introduction assumes the delegate has completed the Access Fundamentals and Access Specialised courses or has equivalent knowledge.
Audience:
Microsoft Access VBA Introduction is designed for users who are keen to extend their understanding and knowledge of the software.
Objectives:
At the completion of Microsoft Access VBA Introduction you should be able to:
- work with objects
- use the Object Browser
- identify collection objects
- use the Controls collection.
- manipulate data by declaring variables
- combine data by using expressions
- get user input
- create Sub and Function procedures, and call one procedure from another.
- use decision structures and loop structures.
- identify ActiveX Data Objects (ADO) architecture and collections, connect to a database, work with a
Recordset, and create a parameter query.
- identify compile-time, run-time, and logical errors
- use the debugging tools
- write error-handling code
Create powerful applications
Objects, Properties and Methods
Synchronising Forms
Storing Return Values
Learn basic programming structures
Working with Modules
Creating Sub Procedures
Calling Sub Procedures
Work with conditional statements and loops
The If Statement
The Do Command
Looping
Create custom message boxes
Evaluating a Message box
Responding to User
Selections
Create Custom functions
Using Built-in Functions
Creating Custom Functions
Calling Function Procedures
Interact with Excel or Word
Opening Other Applications
Destroying Object Variables
Adding Data
Write error-handling code
Stepping Through Code
Using the Intermediate Window
Setting a Watch on a Variable
Validating User Input
Checking for Null Values
Offering Choices
Description:
The skills and knowledge acquired in Microsoft Access VBA Introduction are sufficient to be able to use and operate the software at an efficient level.
2-e-2
2e2 Training offer superb courses in many IT training fields, and have done for over ten years.
Renowned for delivering engaging technical training in Cisco, Citrix, IBM Lotus, Linux, Microsoft, Novell, Oracle, UNIX and VMWare, 2e2 are proven leaders in delivering relevant course material that is easily digested.
Want to leave your own testimonial? click Here
No Testimonials have been left for this course.