Office 97 Application Development
|
Order All Six Videos Levels 1- 6
|
kymsoda
|
$449.95
|
|
Programming with Microsoft Office 97 Application Development Training Videos
Programming with Microsoft Office 97 Training Videos
 Level 1 Video (2 hrs)
1.0 Getting Started (5 min)
1.1 What is VBA
1.2 VBA Versus Visual Basic
1.3 Selecting a Host
1.4 The Elements of a VBA Project
2.0 Working with the VBA Editor (33 min)
2.1 Creating a VBA Project
2.2 The IDE
2.3 Using the Project Explorer
2.4 The Properties Window
2.5 The Code Window
2.6 Building a Form
2.7 The Toolbox
2.8 Saving Your Work
2.9 Running the Application
2.10 Importing/Exporting Objects
2.11 Important Environment Options
3.0 VBA Basics (1 hr 8 min)
3.1 Important Terminology
3.2 Creating Subroutines & Functions
3.3 Commenting Your Code
3.4 Variables
3.5 Scope of Procedures
3.6 Control Structures
3.7 Passing Parameters & Returning Values
3.8 Built-In Functions
3.9 Navigation Tricks & Tips
4.0 Objects, Properties, Methods & Events (11 min)
4.1 What are Objects?
4.2 Understanding the Object Models
4.3 Working with Properties
4.4 Executing Methods
4.5 Event Basics
4.6 Exploring the Object Models
Level 2 Video (2 hrs 9 min)
1.0 Working with Forms (35 min)
1.1 Adding Controls to a Form
1.2 Aligning & Sizing Controls
1.3 The TextBox Control
1.4 The Label Control
1.5 The CommandButton Control
1.6 The ListBox Control
1.7 The ComboBox & CheckBox Control
1.8 The Options Button & Frame Control
1.9 The SpinButton Control
2.0 Dialog Boxes (9 min)
2.1 MsgBox
2.2 ImputBox
3.0 Using Active X Controls (9 min)
3.1 Adding an Active X Control to a Form
3.2 Modifying Properties of an Active X Control
3.3 Writing Code to Control an Active X Control
4.0 Programming the Office Assistant (13 min)
4.1 Creating & Specifying an Assistant Character
4.2 Adding Balloon Help
5.0 Working with Command Bars (13 min)
5.1 The Command Bar Object & Manipulating Command Bar Controls
6.0 Debugging (28 min)
6.1 The Immediate Window
6.2 Stepping Through Code
6.3 Setting the Next Statement to Execute
6.4 Using the Calls Window
6.5 Setting Break Points
6.6 Working with the Locals Pane
6.7 The Step Over Feature
6.8 The Step Out Feature
6.9 Adding Watch Expressions
7.0 Advanced VBA Techniques (20 min)
7.1 Named Parameters
7.2 Optional Parameters
7.3 Constants
7.4 Arrays
Level 3 Video (2 hrs 11 min)
1.0 Getting Started with Excel VBA Programming (30 min)
1.1 Recording & Running a Macro
1.2 Assigning a Macro to a Command Button
1.3 Viewing Modules
1.4 Recording Options
1.5 Assigning Hot KEYSTONE
1.6 Editing an Existing Macro
1.7 Project Options
2.0 Exploring Excel's Important Objects & Collections (43 min)
2.1 Reviewing the Excel Object Model
2.2 The Application Object
2.3 The Workbooks Collection
2.4 The Workbook Object
2.5 The Worksheets Collection & The Work Object
2.6 The Range Object
2.7 ActiveWorkbook, ActiveSheet & ActiveCell
3.0 Developing User-Defined Functions (5 min)
3.1 Writing & Implementing a User-Defined Function
4.0 Important Excel Events (18 min)
4.1 Workbook Events
4.2 Worksheet Events
4.3 Class Modules & Application Events
4.4 Enabling & Disabling Events
5.0 Practical Examples Using Excel VBA (33 min)
5.1 Selecting Chart Options
5.2 Building a Loan Calculator
5.3 Entering & Validating Data
Level 4 Video (1 hr 44 min)
1.0 Programming with Word (56 min)
1.1 The Word Object Model
1.2 Recording a Word Macro
1.3 Viewing a Word Macro
1.4 The Word Application Object
1.5 The Document Object
1.6 The Range & Selection Objects
1.7 Modifying word Commands
2.0 Programming with PowerPoint (25 min)
2.1 The PowerPoint Object Model
2.2 Recording a PowerPoint Macro
2.3 Viewing a PowerPoint Macro
2.4 The PowerPoint Application Object
2.5 The Presentation Object
2.6 The Slides Collection & Slide Object
3.0 Programming with Outlook (22 min)
3.1 The Outlook Object Model, Creating an Outlook Form & Adding Objects
3.2 Working with Script Events
3.3 Saving an Outlook Form
3.4 Using a Custom Form
3.5 Managing Outlook Forms
3.6 Outlook & Automation
Level 5 Video (2 hrs 12 min)
1.0 Building Classes (42 min)
1.1 OOPs Basics
1.2 Creating a Class Module
1.3 Creating & Using Methods & Instances
1.4 Creating & Using Properties
1.5 Multiple Instances & Practical Example of Class Modules
2.0 Data Access Objects (30 min)
2.1 Databases & Recordsets
2.2 Traversing a Recordset
2.3 Updating Data
2.4 A Practical Example - Producing Invoices Using Microsoft Access Data
3.0 Client/Server Techniques 28 min)
3.1 Understanding the Client / Server Model Data Source
3.2 Defining an ODBC Data Source
3.3 Working with Linked Tables
3.4 ODBC Direct – Working Directly with ODBC Data
4.0 Error Handling (30 min)
4.1 On Error Goto & Error Object
4.2 On Error Resume Next
4.3 The Resume Statement
4.4 The Resume Next Statement
4.5 The Cascading Error Effect
4.6 Building a Generic Error Handler
Level 6 Video (2 hrs 11 min)
1.0 Automation (51 min)
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
1.5 Running an Access Report from Excel
1.6 Creating a PowerPoint Presentation from an Excel Workbook
1.7 Creating Mailing Labels from an Outlook Contact List
2.0 The Windows API (34 min)
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 - Obtaining System Information
2.9 A Practical Example - Determining Drive Types & Disk Space Free
3.0 The Office 97 Developer Edition Tools (44 min)
3.1 What is the Office Developer Edition (ODE)?
3.2 Working with the ActiveX Controls Included in the ODE
3.3 Packaging Your Solution
3.4 Distributing Your Solution with the Setup Wizard
3.5 Optimizing Your Applications
|
