|
Course Outline - Office 2000 Development Training
Time: Approx 2 hours training per video
Level 1 Introduction - VBA (2 Hrs 6 Mins)
1.0 Getting Started (6 Mins)
1.1 What is VBA?
1.2 VBA vs. VB
1.3 Selecting a Host
1.4 Elements of a VBA Project
2.0 Working with the VBE (51 Mins)
2.1 Creating a VBA Project
2.2 Using the Project Explorer
2.3 The Properties Wind
2.4 Code Window
2.5 Building a Form 2.6 Running the Application
2.7 Import/Export
2.8 Env. Options
3.0 VBA Basics (8 Mins)
3.1 Terminology
3.2 Subs & Functions
3.3 Commenting
3.4 Variables
3.5 Scope of Procedures
3.6 Control Structures
3.7 Parameters & Return
3.8 Built-in Functions
3.9 Navigation
Level 2 Intermediate Topics - VBA (2 Hrs 4 Mins)
1.0 Debugging (44 Mins)
1.1 Immediate Window
1.2 Stepping through Code
1.3 Setting Next Statement
1.4 Calls Window
1.5 Break Points
1.6 Locals
1.7 Step Over
1.8 Step Out
1.9 Watch Expression
2.0 Obj/Props/Meth/Event (15 Mins)
2.1 Objects
2.2 Object Models
2.3 PPT/Word/Excel Object Models
3.0 Forms (45 Mins)
3.1 Adding Controls
3.2 Aligning/Sizing
3.3 Tab Order
3.4 Textbox
3.5 Command Button
3.6 Listbox
3.7 Combo Box & Check Box
3.8 Option Buttons/Frame
3.9 Updown Control
4.0 Dialog Boxes (9 Mins)
4.1 Message Box
4.2 Input Box
5.0 ActiveX Controls (10 Mins)
5.1 Adding to a Form
5.2 Modifying Properties & Writing Code
Level 3 Advanced Techniques - VBA (2 Hrs 5 Mins)
1.0 Advanced VBA Techniques (29 Mins)
1.1 Named Parameters
1.2 Optional Parameters
1.3 Passing by Ref & by Value
1.4 Constants
1.5 Arrays
2.0 Office Assistant (13 Mins)
2.1 Creating the Assistant Object
2.2 Animating the Assistant
2.3 Adding Balloon Help
3.0 Command Bars (19 Mins)
3.1 Command Bar Objects & Controls
3.2 Working with Menu Bars & Toolbars
4.0 Data Access Objects (35 Mins)
4.1 Opening a Database
4.2 Creating a Recordset
4.3 Traversing a Recordset
4.4 Updating Data
4.5 Practical Example
5.0 ActiveX Data Objects (ADO) (28 Mins)
5.1 Creating a Connection
5.2 Opening a Recordset
5.3 Traversing a Recordset
5.4 Updating Data
5.5 Practical Example
Level 4 Excel Development - VBA (2 Hrs 5 Mins)
1.0 Getting Started (36 Mins)
1.1 Recording & Running a Macro
1.2 Assigning to a Command Button
1.3 Viewing Modules
1.4 Recording Options
1.5 Hot Keys
1.6 Editing
1.7 Project Options
2.0 Exploring Excel Objects & Collections (40 Mins)
2.1 Review Object Model
2.2 Application Object
2.3 Workbook Collection
2.4 Workbook Object
2.5 Worksheet Collection & Worksheet Object
2.6 Range Object
2.7 Active Workbook
3.0 User Defined Functions (4 Mins)
3.1 Creating & Using User Defined Functions
4.0 Excel Events (16 Mins)
4.1 Workbook Events
4.2 Worksheet Events
4.3 Class Modules & Application Events
4.4 Enabling & Disabling Events
5.0 Practical Examples (28 Mins)
5.1 Chart Options
5.2 Loan Calculator
5.3 Entering & Validating Data
Level 5 Word Development - VBA (2 Hrs 7 Mins)
1.0 Word VBA Programming (28 Mins)
1.1 Recording & Running a Macro
1.2 Viewing Modules
1.3 Assigning to a Toolbar
1.4 Assigning Hot Keys
1.5 Editing an Existing Macro
1.6 Project Options
2.0 Objects & Collections (1 Hr 27 Mins)
2.1 Reviewing the Word Object Model
2.2 The Word Application Object
2.3 The Document Object
2.4 The Range & Selection Objects
2.5 The Characters Object
2.6 The Words Object
2.7 The Sentences & Paragraph Object
2.8 Modifying Word Commands
3.0 Important Word Events (10 Mins)
3.1 The Document & Application Objects & Events
Level 6 PowerPoint and Outlook - VBA (1 Hr 51 Mins)
1.0 Getting Started with PowerPoint VBA Programming (19 Mins)
1.1 Recording a Macro & Viewing Modules
1.2 Running a Macro
1.3 Assigning to a Toolbar
1.4 Editing an Existing Macro
1.5 Project Options
2.0 Objects & Collections (50 Mins)
2.1 Reviewing the PowerPoint Object Model
2.2 The PowerPoint Application Object
2.3 The Presentation Object
2.4 The Slides Collection & Slide Object
2.5 The Shapes Object
3.0 Important PowerPoint Events (17 Mins)
3.1 The Presentation New Event
3.2 The Presentation Open Event
3.3 The Presentation Save Event
3.4 The Presentation Close Event
3.5 The Presentation New Slide Event
3.6 The Presentation Print Event
3.7 The Presentation Slide Show Begin & End
4.0 Exploring Outlook's Important Objects and Collections (17 Mins)
4.1 The NameSpace Object
4.2 The Explorer Object
4.3 The Inspector Object
4.4 The MAPIFolder Object
4.5 Working with Items
5.0 Important Outlook Events (6 Mins)
5.1 The ItemSend Event
5.2 The NewMail & Reminder Events
Level 7 Special Topics - VBA (2 Hrs 10 Mins)
1.0 Building Classes (48 Mins)
1.1 OOPs Basics
1.2 Creating a Class Module & Methods
1.3 Creating & Using Properties
1.4 Working with Multiple Instances
1.5 A Practical Example Building a Class That Extracts Parts of a File Name
2.0 Error Handling (33 Mins)
2.1 On Error Goto
2.2 The Error Object
2.3 On Error Resume Next
2.4 The Resume Statement
2.5 The Resume Next Statement
2.6 The Cascading Error Effect
2.7 Building a Generic Error Handler
3.0 Client/Server Techniques (33 Mins)
3.1 Understanding the Client Server Model
3.2 Defining an ODBC Data Source & Using a DSN
3.3 Using the ODBC OLEDB Provider
3.4 Using Native OLEDB Providers
3.5 Using Data Link Files
3.6 Retrieving Multiple Recordsets
3.7 Executing Stored Procedures
4.0 Optimizing Your Applications (13 Mins)
4.1 Optimizing Hardware & Software Configurations
4.2 Modifying Code to Improve Performance
4.3 Optimizing Database Access
Level 8 Integration and Deployment - VBA (2 Hrs 12 Mins)
1.0 Automation (1 Hr 6 Mins)
1.1 The Basics of Automation
1.2 Creating a Reference to an Automation Server
1.3 Declaring an Object Variable to Reference an Application
1.4 Working with a Server's Object Model & Running an Access Report from Excel
1.5 Creating a PowerPoint Presentation from an Excel Workbook
1.6 Creating Mailing Labels from an Outlook Contact List
2.0 The Windows API (35 Mins)
2.1 What is the Windows API
2.2 Declaring an External Function to the Compiler
2.3 Important Notes about the Win32 API
2.4 Passing by Reference vs. Passing by Value
2.5 Aliasing a Function
2.6 Working with Constants & Types
2.7 The Windows API Text Viewer
2.8 A Practical Example Determining Drive Types and Disk Space Free
3.0 The Microsoft Office Developer (29 Mins)
3.1 What is the Office Developer Edition (MOD)
3.2 Working with the ActiveX Controls Included in the MOD
3.3 Working with Tools Included in the MOD
3.4 Packaging Your Solution
|
Video Tape Based Training:
