|
Provided by: Computer Training Source, Inc. Microsoft Access VBAAccess |
 |
In this class you will learn how to Work with objects, use Object Browser, identify collection objects, and use the Controls collection. Manipulate data by declaring variables, combine data by using expressions, get user input, create Sub and Function procedures, and call one procedure from another. Use decision structures and use loop structures. Identify ActiveX Data Objects (ADO) architecture and collections, connect to a database, work with a Recordset, and create a parameter query. Identify compile-time, run-time, and logical errors; use the debugging tools; and write error-handling code. Our classes are all instructor-led, hands-on learning. Each student has their own computer and is given a student manual with practice files to take home. A freerepeat, within six months, is included as well as thirty days of technical support. Class is usually one day from 9am to 4pm (unless it& 39;s an evening class or an accelerated class). Click on any class date below to view a class outline.
|
|
||||||||
Training
Provided by Computer Training Source, Inc.
- M asked: Hi, I'm an intern in a wine distributing company in Elk Grove Village, IL. I finished coding for the forms, controls, tables... When it comes to debugging the codes, I can't figure out what the underlying problems are. I need someone who can go over the codes with me and help me solve those problems. If you help me, I'll be very happy. Thank you
- L asked: Is this course available in Naperville? What is the schedule? What is the cost? Thank you.
Microsoft Access VBA
Unit 1: Visual Basic Editor
Topic A: Objects
Topic B: Object Browser
Topic C: Collections
Unit 2: Programming basics
Topic A: Data
Topic B: Scope
Unit 3: Control structures
Topic A: Decision structures
Topic B: Loop structures
Unit 4: ActiveX Data Objects
Topic A: Getting started with ActiveX Data Objects
Topic B: Working with ActiveX Data Objects
Unit 5: VBA debugging tools
Topic A: Errors in code
Topic B: Debugging techniques
Topic C: Handling run-time errors
Appendix A: Office integration
Topic A: Automating Office 2003
Topic B: Working with Word from Access
Topic C: Working with Excel from Access
Topic A: Objects
Topic B: Object Browser
Topic C: Collections
Unit 2: Programming basics
Topic A: Data
Topic B: Scope
Unit 3: Control structures
Topic A: Decision structures
Topic B: Loop structures
Unit 4: ActiveX Data Objects
Topic A: Getting started with ActiveX Data Objects
Topic B: Working with ActiveX Data Objects
Unit 5: VBA debugging tools
Topic A: Errors in code
Topic B: Debugging techniques
Topic C: Handling run-time errors
Appendix A: Office integration
Topic A: Automating Office 2003
Topic B: Working with Word from Access
Topic C: Working with Excel from Access
About The Training Provider: Computer Training Source, Inc.
Computer Training Source, Inc. - Computer Training Source, Inc. has offered computer training classes in Chicago, Il since 1991. We specialize in instructor-led training in all the popular desktop software applications. Training can be held at our training centers, at your location, or via the Internet. We have training rooms in the Chicago area (downtown, Naperville, Northbrook, and Schaumburg). Instructor-led distance...
