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: 
msac03vba
Prerequisites: 

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 hours
Prices
Public: 
1400 GBP per delegate

Public Course Dates

Datesort iconTraining OutlineVenueDetails/Book
2008-05-19 09:00 - 2008-05-22 17:00Access VBA112/114 North Acton Road, NW10 6QH, LondonDetails/Book
2008-08-11 09:00 - 2008-08-14 17:00Access VBA112/114 North Acton Road, NW10 6QH, LondonDetails/Book
2008-11-03 09:00 - 2008-11-06 17:00Access VBA112/114 North Acton Road, NW10 6QH, LondonDetails/Book
2008-12-15 09:00 - 2008-12-18 17:00Access VBA112/114 North Acton Road, NW10 6QH, LondonDetails/Book