View Basket
Recover Basket
Microsoft Access 2007 Programming (2 days)
Designed for experienced Access users wishing to use VBA for database application development.
The Visual Basic Editor
Using the Project Explorer window
Using the code window
The Property window
Using the Immediate window
Setting user options
VBA Fundamentals
Benefits of VBA
Modules and procedures
Standard modules and form modules
Understanding Access objects
Using the Object Explorer
Understanding object properties
Understanding object methods
VBA Programming
Creating sub procedures
Defining variables
VBA data types
Conditional statements
Using If statements
Using Select Case statements
Looping structures
Using For Next loops
Using While Wend loops
Calling a subroutine
Supplying parameters
Calling a funciton and supplying parameters
Returning a value
Objects and collections
Creating command buttons
Using ActiveX controls
Pop-up forms
Manipulating objects
Properties and methods
Manipulating collections
Using object variables
Understanding events
Programming forms
The Me keyword
Opening and closing forms
The form module
Form and control properties
Form events
Selection controls
Populating a list control
Working with option groups
Programming reports
An Introduction to the report module and events
Opening and closing reports
Passing arguments Using OpenArgs
Populating the report
Handling report-level errors
Working with subreports
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