Office 2000 Application Development -
(coming soon) |
Microsoft® Office is the world's most popular productivity suite with over 40 million end users. And as over 2.6 million developers have
discovered, it's also a powerful development platform with an equally strong development environment. These developers have recognized that solutions built with Office result in shorter development cycles and
satisfied end users. Also, these users require little training because they are already familiar with the applications and because they benefit from the customization of Office to fit their specific needs. Developers
creating solutions with Office need tools for building and deploying these solutions. Microsoft Office 2000 Developer is the edition of Office designed specifically for developers building and deploying these
solutions. Office Developer includes Microsoft Office Premium as well as professional productivity tools, documentation and sample code for quickly building solutions with Microsoft Office.
- Build Office 2000 solutions faster with developer productivity tools including automatic error handling, code commenting, and code transfer. Get up to speed more
quickly with thousands of lines of sample source code and printed documentation.
- Easily integrate Office 2000 with organizational data using the Data Environment Designer to visually create reusable data-access components for integrating any data source
with Visual Basic® for Applications (VBA).
- Simplify deploying and managing Office solutions with tools for creating professional set up routines. In addition, Office 2000 Developer includes the royalty-free Access Run Time
for distributing Access 2000 solutions.
Level 1 |
$89.95 |
kyof2d1 |
Coming soon |
Level 2 |
$89.95 |
kyof22 |
Coming soon |
Level 3 |
$89.95 |
kyof2d3 |
Coming soon |
Level 4 |
$89.95 |
kyof2d4 |
Coming soon |
Level 5 |
$89.95 |
kyof2d5 |
Coming soon |
Level 6 |
$89.95 |
kyof2d6 |
Coming soon |
Level 7 |
$89.95 |
kyof2d7 |
Coming soon |
Level 8 |
$89.95 |
kyof2d8 |
Coming soon |
Set of all 8 Videos |
$599.95 |
kyof2da |
Coming soon |
Office 2000 Application Development -
(coming soon) |
Office 2000 Development Level 1 (2 Hours 6 Minutes) 1.0 Getting Started (6 Minutes)
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 Minutes)
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, The Toolbox & Saving
2.6 Running the Application
2.7 Import/Export
2.8 Env. Options
3.0 VBA Basics (8 Minutes)
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 Office 2000 Development Level 2 – Intermediate Topics (2 Hours 4 Minutes) 1.0 Debugging (44 Minutes)
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 Minutes)
2.1 Objects
2.2 Object Models, Properties, Object Methods, & Events
2.3 PPT/Word/Excel Object Models
3.0 Forms (45 Minutes)
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 Minutes)
4.1 Message Box
4.2 Input Box
5.0 ActiveX Controls (10 Minutes)
5.1 Adding to a Form
5.2 Modifying Properties & Writing Code
Office 2000 Development level 3 – Advanced Techniques (2 Hours 5 Minutes) 1.0 Advanced VBA Techniques (29 Minutes)
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 Minutes)
2.1 Creating the Assistant Object
2.2 Animating the Assistant
2.3 Adding Balloon Help
3.0 Command Bars (19 Minutes)
3.1 Command Bar Objects & Controls
3.2 Working with Menu Bars & Toolbars
4.0 Data Access Objects (35 Minutes)
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 Minutes)
5.1 Creating a Connection
5.2 Opening a Recordset
5.3 Traversing a Recordset
5.4 Updating Data
5.5 Practical Example Office 2000 Development Level 4 – Excel Development (2 Hours 5 Minutes) 1.0 Getting Started (36 Minutes)
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 Minutes)
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, Active Sheet & Active Cell
3.0 User Defined Functions (4 Minutes)
3.1 Creating & Using User Defined Functions
4.0 Excel Events (16 Minutes)
4.1 Workbook Events
4.2 Worksheet Events
4.3 Class Modules & Application Events
4.4 Enabling & Disabling Events
5.0 Practical Examples (28 Minutes)
5.1 Chart Options
5.2 Loan Calculator
5.3 Entering & Validating Data
Office 2000 Development Level 5 (2 Hours 7 Minutes) 4.0 Word VBA Programming (28 Minutes)
1.1 Recording and 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 and Collections (1 Hour 27 Minutes)
2.1 Reviewing the Word Object Model
2.2 The Word Application Object
2.3 The Document Object
2.4 The Range and 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 Minutes)
3.1 The Document & Application Objects & Events Office 2000 Application Development Level 6 – PowerPoint and Outlook (1 Hour 51 Minutes)
1.0 Getting Started with PowerPoint VBA Programming (19 Minutes)
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 and Collections (50 Minutes)
2.1 Reviewing the PowerPoint Object Model
2.2 The PowerPoint Application Object
2.3 The Presentation Object
2.4 The Slides Collection and Slide Object
2.5 The Shapes Object
3.0 Important PowerPoint Events (17 Minutes)
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 Minutes)
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 Minutes)
5.1 The ItemSend Event
5.2 The NewMail & Reminder Events Office 2000 Application Development Level 7 – Special Topics (2 Hours 10 Minutes) 1.0 Building Classes (48 Minutes)
1.1 OOPs Basics
1.2 Creating a Class Module & Methods
1.3 Creating and 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 Minutes)
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 Minutes)
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 Minutes)
4.1 Optimizing Hardware and Software Configurations
4.2 Modifying Code to Improve Performance
4.3 Optimizing Database Access Office 2000 Application Development Level 8 – Integration and Deployment (2 Hours 12 Minutes) 1.0 Automation (1 Hour 6 Minutes)
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 Minutes)
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 and 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 Minutes)
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 |
