Access 2007 Visual Basic for Applications (VBA)
**Please note that CompuWorks will only accept students registering through a company or organization. Please click here for more information**
Description: This course is designed for experienced Access 2007 users who want to learn ActiveX Data Objects, control structures, and the basics of VBA programming.
Days: 1
Prerequisites: Successful candidate does not need experience in programming language. Candidates should possess advanced skills in Access.
Unit 1: Visual Basic Editor
Topic A: Objects
· Discussing objects
· Examining the Properties window
· Modifying the object properties
· Writing code to change object properties
· Using a method
· Associating code with an event
Topic B: Object Browser
· Examining the Object Browser window
· Searching in the Object Browser
Topic C: Collections
· Understanding collection objects
· Using the Controls collection
Unit 2: Programming basics
Topic A: Working with data
· Examining data types and variables
· Declaring variables explicitly
· Using operators
· Using the interaction functions
Topic B: Scope
· Observing modules and procedures
· Examining procedure- and module-level scope
· Understanding public scope
· Creating a Sub procedure
· Calling a Sub procedure
· Creating a Function procedure in a standard module
· Calling a Function procedure
Unit 3: Control structures
Topic A: Decision structures
· Using the If…Then statement
· Using the If…Then…Else statement
· Using the If…Then…ElseIf statement
· Using the Select Case statement
Topic B: Loop structures
· Using the For…Next loop
· Using the For Each…Next loop
· Using the Do While…Loop
Unit 4: ActiveX Data Objects
Topic A: Getting started with ActiveX Data Objects
· Discussing ADO
· Discussing ADO collections
Topic B: Working with ActiveX Data Objects
· Connecting to a database
· Creating a Recordset object
· Navigating a Recordset
· Saving and canceling changes
Unit 5: VBA debugging tools
Topic A: Errors in code
· Discussing types of errors
Topic B: Debugging techniques
· Discussing debugging tools
· Setting a breakpoint
· Adding a watch expression
· Using Step Into
· Deleting a watch expression
· Working with the Immediate window
· Using the Locals window
Topic C: Handling runtime errors
· Writing error-handling code
Price: $425
