Access VBA
Duration - 2 days
Access Visual Basic
- Introduction to Programming
- What is Visual Basic for Applications?
- Event -driven procedures
- Modules and code behind forms
Modules & Procedures
- The module toolbar
- Sub and function procedures
- Databases and projects
User Defined Functions
- Creating user defined functions
- Arguments and returned values
- Access built in functions
- Using user defined functions in queries and forms
Events Procdures
- The code builder
- Form, report, control, and section events
- Referring to form and report controls
- Incorporating macro actions
Variables, Constants & Arrays
- Implicit and explicit declaration
- Scope of variables
- VBA data types
- Arrays and user defined data types
Branching & Looping Structures
- Branching - If.End If and Select Case Looping - Do Loop and For Next
Using Interaction
- The input box and message box
- The common dialog control
Debugging VBA
- Types of Error
- Using the immediate window setting
- Break points
- Correcting errors
Error Handling
- On error statement
- Trapping error code
Active X Data Objects
- DAO or ADO?
- Microsoft Access Architecture
- Open objects and collections
- Database engine objects
- Setting object variables
- Handling recordsets
- Locating and editing data
- Handling queries
- Adding and deleting objects to collections
- Using transactions
Creating Libraries
|
