Microsoft Office 2000 Development and VBA


Microsoft Office 2000 and VBA, Level 1

This two module course is valuable for individuals who need to build integrated applications using the Microsoft Office Suite and the VBA language.  Students who require an understanding of how to effectively use the myriad of objects, properties and methods in these products.

Level 1

Cost: $399 + GST

Set of 3 CD's

Both levels
Cost: $795 + GST

Set of 5 CD's

This course provides complete coverage of developing integrated office applications using the Microsoft Office products Word, Excel, Access, Outlook and PowerPoint. The Visual Basic for Applications language (VBA) is emphasized to build sophisticated applications quickly and effectively. Automate Office applications and understand the full power of the integrated Office products using ActiveX Automation. It covers all development issues including using the objects and object models built into the Microsoft Office Applications.

CD-ROM 1
1.0 Getting Started with VBA
What Is VBA?
What Products Host VBA?
What Does a VBA Application Look Like?
Working with VBA in a Host Product
How Do You Make VBA Code Happen?
Starting with VBA by Recording Macros

2.0 Writing VBA Procedures
Overview of the Visual Basic Editor
Working with the Project Explorer
Creating Simple Procedures
Understanding the Code Window
Customizing the Visual Basic Editor

3.0 Working with Variables and Constants
What Is a Variable?
Data Types
Using Constants

4.0 Visual Basic Editor Techniques
Writing Code Efficiently
Taking Advantage of IntelliSense
Optional and Named Arguments

CD-ROM 2
5.0 Mastering VBA Control Structures
Branching Structures
Looping Structures

6.0 Investigating Built-In VBA Functions
VBA’s Built-In Functions
Using the Object Browser to Find VBA Functions
Testing Functions in the Immediate Window
VBA Functions You’ll Probably Need

7.0 Creating Reusable Procedures
Design Before Code
Writing the Same Code Once

8.0 Creating User Forms
Working with User Forms
Adding Controls to a User Form
Formatting Controls
Setting Properties at Design Time
Introducing Events
Setting Properties at Run Time
Working with Methods

9.0 Handling Errors
Recognizing a Run-Time Error
The Error-Handling Standard
Exiting the Error Handler
Inline Error Handling
Combining Types of Error Handling

CD-ROM 3

10.0 Debugging Your VBA Code
Debugging Your Code
Setting a Breakpoint
Stepping Through Code
Checking Values at Run Time
Watch Expressions
The Call Stack
The Debugging Process

11.0 Understanding Object Models
Defining the Terms
Using the Object Browser
Working with Object Models in VBA
Object Variables
Special VBA Control Structures for Objects
Working with the Office Object Models

12.0 Understanding Events
Events and Event Procedures
Which Objects Have Events?
User Form Events
Control Events
Product-Specific Events
Is There More?

13.0 Putting It All Together
Assembling the Pieces
Building a Solution in Excel
Using the Solution in Word
Where Are You Going From Here?