VBA for Access 2010 (Intelligent Programming with VBA Access)

Introduction

This course is intended for people who wish to improve their knowledge and skills in the use of Visual Basic for Applications to program applications in Microsoft Access 2010.

Outcomes

At the completion of this course, participants will be able to:

• be familiar with the basics of developing applications in Access 2010
• create and convert macros into VBA
• make Access start up with the form you select
• create subroutines
• understand how to use variables to generate an output
• understand and create input boxes and message boxes
• create and use decision-making programs
• create and use programming loops
• understand and use the DoCmd object
• recognise and understand many ADO techniques
• use ADO to work with forms and recordsets
• apply a range of debugging tools to your application
• replace obscure error messages with meaningful ones