Overview

Our Access programming course concentrates on the creation of modules. It shows users how to use Visual Basic for Applications (VBA) to control and manipulate the objects and data in their database solutions.

Course Outline

Fundamentals

Benefits of VBA, Modules and procedures, Standard modules and form modules, Subroutines and functions, Procedure calls, Creating procedures, Variables, VBA data types

Programming structures

Setting properties, Creating command buttons, Using ActiveX controls, Pop-up forms , Objects and collections , Manipulating objects, Properties and methods, Manipulating collections, Using object variables, Understanding events

Error handling

Overview of error handling, Errors in design/logic, Compile errors, Run-time errors, Getting feedback on errors, Replacing standard error messages

Debugging

Stepping through code, Using breakpoints, Stepping through procedures, Examining variables