This course has been specially designed for the advanced Access user who wishes to make use of the more powerful facilities of MS Access made available by VBA. This course explores the VBA language introducing features and functionality that will encourage confidence, control and creative use of MS Access. The course is aimed at those with little or no previous programming background, although experienced programmers wishing to learn VBA will find it a quick and valuable introduction to the language. Throughout the course the theme of adopting good programming practices will be encouraged and advice will be given on planning applications systematically, efficiently and economically.

 

Intended for: Those requiring a good understanding of the features available in the MS Access VBA language.

Pre-requisites: A sound knowledge of Windows and MS Access including, table creation, query and report writing functions, macro development and relational database concepts gained from practical experience or by prior attendance on an "Access Advanced User" course is essential.

 

 

 

 

Macros versus Visual Basic for Applications
Visual Basic for Applications’ Development Environment
VBA Objects and the Browser
VBA Procedures

 

VBA Coding
Variables and expressions
Branching and Looping

Comments and Indents

 

 

Trapping Errors
Writing Useful Error Handlers

 

Using Form Events
Code Behind Forms
Changing Form Properties
Tying Forms/Reports Together

 

Data Access Objects (DAO)/
ActiveX Data Objects (ADO)
Handling Databases

Database, Recordset and Dynaset Objects
VBA Methods and Properites

Finding and Editing Records in a Recordset

Lunch/refreshments and course materials.

Comment: Excellent notes,venue and trainer. Perfect for what I needed. Thanks. [JC API]

MS Access VBA