|
|
AVB207: Programming Microsoft Access using VBA
|
Book List |
Course Links
|
|
Tuition: $195.00 per student |
Length: 1 day |
|
Synopsis:
One day introduction to programming Access databases using VBA. Covers, modules, subs, VBA GUI, Collections, Active X and debugging.
|
Formats:
Custom scheduled corporate groups (min. 2 students) at your facility or via Remote Learning. Single individuals may arrange a private online session.
|
Scheduling:
Custom scheduled to suit your needs.
|
Group
Discounts:
2-4 students 20%, 5-8 30%, >8 quote
|
|
|
|
Session 1 | Programming Basics | 3.0 Hours | |
- 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 | 3.0 Hours | |
- 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
|   |
Materials:
Complete student manual, Training Certificate.
|
Location:
Classes are normally taught on-site at your facilities or at our studio in San Juan Capistrano, Orange County, California. We may also be able to host the class in a rented university classroom near you. Please see FAQs if interested.
|
Related Services |
Need
help with a project? We may also provide programming
and consulting services covering the above material. See
Programming and Consulting for more information.
|
|
|
|