training@nobleprog.com
tel: +44 20 7558 8274
Contact Form
Full Contact Details >>
Access VBA Training Course
Training Course Outline:
Introduction to VBA
Variables
Data types
Naming convention
Branching statements
Loops
Functions
Dealing with errors
Documenting code
Maintaining code
Access Object Model
Object, classes, properties and methods
Using collections
Tables, queries, indices
Accessing data
Using CurrentProject.Connection object
Using ADO
Data providers
Configuring ODBC Sources
Connection, Recordset objects
Transactions
Creating Microsoft Access Project
Code deployment
User libraries
Code:
msac03vbaPrerequisites:
Good practical knowledge of Microsoft Access.
Overview:
This course has been created for users who are already well acquainted with Ms Access databases.
During the course, participants will learn how to automate tasks, create full-featured applications and add new logic to forms and reports.
Certification:
NobleProg Certificate
Duration:
32 teaching hoursPublic Course Dates
| Date | Training Outline | Venue | Details/Book | ||
|---|---|---|---|---|---|
| 2008-05-19 09:00 - 2008-05-22 17:00 | Access VBA | 112/114 North Acton Road, NW10 6QH, London | Details/Book | ||
| 2008-08-11 09:00 - 2008-08-14 17:00 | Access VBA | 112/114 North Acton Road, NW10 6QH, London | Details/Book | ||
| 2008-11-03 09:00 - 2008-11-06 17:00 | Access VBA | 112/114 North Acton Road, NW10 6QH, London | Details/Book | ||
| 2008-12-15 09:00 - 2008-12-18 17:00 | Access VBA | 112/114 North Acton Road, NW10 6QH, London | Details/Book |