| Item ID | Course Title and Description | Price | Per | Length |
| AVB207 | Programming Microsoft Access using VBA | 195.00 | Student | 6.0 hrs |
| | One day introduction to programming Access databases using VBA. Covers, modules, subs, VBA GUI, Collections, Active X and debugging. | |
| Session 1 | Programming Basics | |
| |
- 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
| |
| Session 2 | ActiveX, Debugging | |
| |
- 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
- Appendix A : Office integration
- Topic A:0 Automating Office 2007
- Topic B:0 Working with Word from Access
- Topic C:0 Working with Excel from Access
| |
