|
|
|
|
COURSE TITLE:
Microsoft Access VBA Training UK
LEVEL:
Introduction : Advanced
COURSE LENGTH:
2 days
COURSE PRICES:
*All prices quoted exclude VAT
COURSE OVERVIEW:
This course is designed to introduce experienced Access users to the Visual Basic for Applications (VBA) programming language. It will show how to use VBA to extend the capabilities of Access forms, and how to use data in Access database files from other Office applications. |
| |
|
The course outlines below set out the full range of topics you can choose to cover during your on-site training course, and you can build your course around your exact training requirements, or any specific projects you or your staff are working on at present.
You will find that this approach makes our courses the most effective and productive use of your training budget available today. |
Training Modules
The visual basic programming environment in Access
When to use VBA rather than macros
The object browser
The Visual Basic editor
Visual Basic modules
Editor options
Editor views
The concepts of object-oriented programming
Visual Basic syntax
The structure of procedures
The declaration section
Comments
Keywords
Indenting code
Navigating code using the keyboard
Bookmark
The last position command
Getting assistance from the editor when entering code
Declaring variables
Variable scope
Variable type
Type conversion functions
Constants
Arrays
|
Training Modules
The with statement
If statements
Select Case
Do.Loop
For.Next Loops
The Msgbox statement
The inputbox function
Pausing code execution
Locating errors in code
Handling run-time errors
Getting bookmarks
Setting breakpoints
Tracing the execution path using
the call stack
Setting watches
Viewing variable and array values
in break mode
Compiling program code
Manipulating recordsets with VBA
Finding records in a recordset
Creating and deleting tables or queries with VBA
Using ActiveX data objects (ado) to open and Work with databases from other office programs such as Word or Excel
|
|
|
BACK TO TOP |
|
|
|
"I would just like to say how pleased we were with the way in which ABC Dee Training handled our training requirements....." Vicky Farrow, Kent Fire & Rescue
"My experience with this company has been a positive one and
I would happily recommend ABC Dee Training to others."
Anna Faithfull, London Film
|
| |
