Orange Coast Database Associates Database Training, Design and Programming Course Listing Page

Course Description

News and special offers from Orange Coast Database Associates
News

 Home-->Courses-->avb207

Related Courses

Group Training

Individual Training

Scheduled Classes

What's New!

FAQ's

Site Map

Free Catalogs

Special Offers

Request Information or Quote

Sales: 800-355-9855

Home

About Us

Catalog

Calendar

Contact Us

AVB207: Programming Microsoft Access using VBA

Book List | Course Links

Tuition: $295.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

 

Format this document for printing

Session 1Programming Basics3.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 2ActiveX, Debugging3.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.


Copyright(2001-2016) D.H.D'Urso & Associates

Contact Information | FAQ's | Site Map | Back | Home | Top