MS Office 2000 Application Development Visual Basic Videos Training Tutorials
 Now Available Microsoft Office XP Training
Microsoft® Visual Basic development system is the most productive tool for creating fast business solutions for Windows® and the Web. A
comprehensive, rapid application development environment helps developers quickly create and deploy client/server applications, plus easily program for
the Internet using familiar Visual Basic programming tools and techniques.
|
Save on All Eight Videos VBA
|
kyo2ada
|
$549.95
|
|
Microsoft Office 2000 Application Development Videos Visual Basic - VBA - Training Tutorials
Level 1 Training (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 Microsoft Office 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
Level 2 Training– 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
Level 3 Training– Microsoft Office 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
Level 4 Trainng– Microsoft 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
Level 5 Training (2 Hours 7 Minutes)
4.0 Microsoft 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
Level 6 Training – Microsoft 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
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
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
|
