Introducing VBA in Access 2007
o VBA versus VB
o VBA code
o VBA and embedded macros
o Running VB editor
o Switching between Access and VB editor
o VBA building blocks
o Getting Help with VBA
Access 2007 Programming Objects
o Sub procedures
o Event procedures
o Functions
o Procedure scope and visibility
o Procedure scope and visibility
o Standard Modules
o Class Modules
Variables & Constants
o Declaring variables
o Variant variables
o Variable scope and visibility
o Assigning values to variables
o System-defined constants
o Intrinsic constants
o Symbolic constants
User Inputs & Program Outputs
o Parameters and arguments
o The MsgBox function
o Coding VBA against controls
o The InputBox function
VBA and Database Objects
o Properties, methods and events
o Working with the Object Browser
o Coding VBA against controls
o Changing properties at run-time
o With statement
o DoCmd property
o Converting macros to VBA code
Conditional & Repetitive Operations
o If statements
o Select Case statement
o Loop statements
o Exit statement
Advanced VBA Techniques
o Handling VBA errors
o Debugging VBA code
o Domain Aggregate Functions
o Object Variables
o VBA and SQL
o Introducing DAO in Access 2007
Case Study: Test Engine Program
o Case explanation
o Building the back-end
o Building and programming the front-end
