Microsoft Access VBA

Microsoft Access VBA

Introduction to Microsoft Access VBA

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.

Aims

• To create and edit VBA code to automate elements of MS Access.

Content

An Introduction to VBA

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

VBA Language, Syntax and Code Compilation

• VBA Coding
• Variables and expressions
• Branching and Looping Comments and Indents

Preparation of User/Database Interface

• Event Handling
• Error Handling in VBA
• Trapping Errors
• Writing Useful Error Handlers

Form-Event Procedures

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

Manipulating Data through Data Access Objects

• 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

Course Includes: Lunch/refreshments and course materials.