We Make it Easy to Learn Microsoft Word, Excel, Outlook and More - No Matter What Your Skill Level ...
Visual Basic 6


Course Outline

Course Description
This course will help you create applications for workstations and networks. Learn API, ActiveX Controls, automation programming and much more. Levels 1-8 are introduction level courses. Levels 9-16 cover requirements for MCSD exams 70-175 and 70-176.

About Trainer
Paul D. Sheriff is the owner of PDSA Inc., a Microsoft Solutions Provider for Visual Basic and SQL Server. Paul has 10 years experience and is Visual Basic certified. He is one of the top instructors on Visual Basic and speaks at Advisor Developer Conferences and Microsoft TechEd every year. He is also the author of over 25 articles in major publications.

Course Sets - Single User License *

(*) Please Email sales@computrainsolutions.com if you have question regarding to our multi-user licensing for this course or check our FAQ on the left menu.

Detailed Course Outlines:
Level 1 (1 Hr 51 Mins)
1.0

Overview (19 mins)
1.1

What is Visual Basic?
1.2

History & Features
1.3

Advantages
1.4

Versions & Components
2.0

Windows (13 mins)
2.1

Overview of Windows
2.2

Versions & Computing Terms
3.0

The VB Environment (1 Hr 18 mins)
3.1

Overview of VB Environment
3.2

Setting up the VB Environment
3.3

Forms
3.4

Controls & Labels
3.5

Setting Project Properties
3.6

Command Buttons
3.7

The Frame Control
3.8

Inserting Images
3.9

The ListBox Control
3.10

Combo Box
3.11

Menus
3.12

Creating an Executable
Level 2 (1 Hr 54 Mins)
1.0

Events (33 mins)
1.1

Overview Event Procedures
1.2

Form & Control Events
2.0

Variables mins)
2.1

Variables
2.2

Scope of Variables
2.3

Variable Declarations
2.4

Naming Variables & Relational Operators
2.5

Operator Precedence
2.6

Constants
2.7

The Variant Data Type
2.8

Arrays
2.9

User-Defined Types
3.0

Conditional Logic (24 mins)
3.1

If, Else and Elself Statements
3.2

Select Case Statements
Level 3 (1 Hr 58 Mins)
1.0

Procedures & Functions (47 mins)
1.1

Procedures
1.2

Creating & Calling Procedure
1.3

Sub Main
1.4

Functions
1.5

Parameters/Arguments
1.6

Call by Reference
1.7

Built-in Functions
1.8

Methods
2.0

Dialog Boxes (30 mins)
2.1

What is a Dialog Box?
2.2

Message Box
2.3

Input Box Dialog
2.4

Common Dialog
2.5

Building a Custom Dialog
3.0

ADO Data Control (39 mins)
3.1

Methods of Getting Data
3.2

Universal Data Access
3.3

ADO Data Control
3.4

Setting up an ODBC Datasource
3.5

Using the Data Control
3.6

Data List Control
3.7

The Data Grid
Level 4 (1 Hr 51 Mins)
1.0

Programming the ADO Data Control (39 mins)
1.1

The Recordset Property & Data Control Events
1.2

Order of Events
1.3

Adding Features
1.4

Deleting Data
1.5

Canceling Changes
1.6

Data Validation
1.7

The Error Event
1.8

Displaying Records
1.9

Finding Records
2.0

MDI (35 mins)
2.1

Overview of MDI
2.2

Adding a Project to MDI
2.3

Positioning the Project
2.4

Listing open Child Windows
2.5

Right Mouse Click Menu
2.6

Unloading an MDI Application
3.0

Debugger (14 mins)
3.1

Stepping Through Code
3.2

Setting Break Points
3.3

Adding Watch Variables
3.4

Debug.Print
4.0

Error Handling (21 mins)
4.1

Visual Basic Errors
4.2

Adding our own Error Handling
4.3

Error Object
4.4

Listing the Errors
4.5

OnError Resume Next
4.6

The Resume Statement
4.7

The Call Stack
4.8

Global Error Handler
Level 5 (2 Hrs)
1.0

Tips & Tricks (55 Mins)
1.1

Searching
1.2

Jumping around VB
1.3

Bookmarks
1.4

Form Tips & Tricks
1.5

Formatting Your Controls
1.6

The Property Window
1.7

Customizing the Windows Environment
1.8

Using Add-ins
1.9

Creating Templates
1.10

Toolbox Tricks
2.0

Object Oriented Programming (1 Hr 4 mins)
2.1

OOP Terminology
2.2

Uses of Classes
2.3

Differences between Procedural Coding & OOP
2.4

Advantages & Disadvantages
2.5

Step by Step creation of an Employee class module
2.6

Class Initialization
2.7

Class Builder Utility
2.8

Methods
2.9

Using Forms as Objects
2.10

Creating a TextStream Class
2.11

Default Methods & Properties
Level 6 (1 Hr 48 Mins)
1.0

System Objects (30 mins)
1.1

What is an Object?
1.2

Object Types
1.3

The App Object
1.4

The Screen Object
1.5

The Clipboard Object
1.6

Creating New Forms at Runtime
1.7

Using Form & Control Objects
2.0

Collections (27 mins)
2.1

What is a Collection?
2.2

Using the Forms Collection
2.3

Using the Controls Collection
2.4

Using the Printer Collection
2.5

Creating Your Own Collections
2.6

Creating a Collection Class
3.0

Tips & Tricks (22 mins)
3.1

Handling Keystrokes & Testing for Certain Input Data
3.2

Validating Data
3.3

Finding Values in Combo Boxes
3.4

Data Format Property
3.5

Third Party Controls
4.0

Wizards (28 mins)
4.1

Using the Data Form Wizard
4.2

Using the Application Wizard
Level 7 (1 Hr 48 Mins)
1.0

Using ADO Objects (48 mins)
1.1

Properties & Methods of the Connection Object
1.2

Properties & Methods of the Recordset Object
1.3

Recordset Types
1.4

Creating a Data Entry form Using ADO
1.5

Error Handling
1.6

Multi-User Concepts
2.0

Visual Database Tools (43 mins)
2.1

Data Environment
2.2

Data View Window
2.3

Query Designer window
2.4

SQL Editor
2.5

Database Diagram Window
2.6

Visual Data Manager
3.0

Optimization (14 mins)
3.1

Speed Optimization Technique
3.2

Size Optimization Techniques
Level 8 (2 Hrs 3 Mins)
1.0

The Windows API (32 mins)
1.1

What is the Windows API?
1.2

Uses of the Windows API
1.3

Declaring Windows API Functions
1.4

Calling Windows API Functions
1.5

Send Message
1.6

GetDriveType32
1.7

Retrieving System Information
2.0

Storing User Information (30 mins)
2.1

INI Files & Using API Calls
2.2

Creating an INI Class
2.3

What is the Registry
2.4

Using GetSetting & SaveSetting
2.5

Deleting a Registry Entry
3.0

ActiveX Controls (1 Hr)
3.1

ImageList Control
3.2

Toolbar
3.3

Coolbar
3.4

Status Bar
3.5

ImageCombo
3.6

DateTimePicker
3.7

Month View
3.8

Progress Bar
3.9

Slider
3.10

UpDown
3.11

Tab Strip
3.12

SSTab
Level 9 (2 Hrs 13 Mins)
1.0

Package & Deployment Wizard (29 mins)
1.1

What is a Setup
1.2

Steps to Distribution
1.3

VB Runtime Files
1.4

Setup Runtime Files
1.5

Types of Setups
1.6

Creating a Package
1.7

Deploying the Package
1.8

Testing the Setup
2.0

Advanced Common Controls (1 Hr 1 mins)
2.1

Flex Grid Control
2.2

Hierarchical Flex Grid Control
2.3

Tree View & List View Controls
2.4

Rich Text Box Control
2.5

Flat Scrollbar
2.6

Drive
2.7

The Timer Control
2.8

The Animation & Multimedia Control
3.0

Creating Controls at Runtime (18 mins)
3.1

Add Method
3.2

Creating Controls at Design Time
3.3

Creating Menus at Run Time
4.0

HTML Help (24 mins)
4.1

Overview of Help
4.2

Creating an HTML Help System
Level 10 (2 Hrs 5 Mins)
1.0

Drag & Drop (20 mins)
1.1

Automatic Drag & Drop
1.2

Manual Drag & Drop
1.3

Putting it all Together
2.0

File & System Objects (34 mins)
2.1

Drives
2.2

Folders
2.3

Files
3.0

The Dictionary Object (15 mins)
3.1

Overview of Dictionary Object
3.2

Simple Dictionary Object
3.3

Using the Dictionary Object to hold Objects
4.0

Printing (55 mins)
4.1

Printer Object
4.2

Data Report Designer
4.3

Crystal Reports
Level 11 Component Development (2 Hrs)
1.0

Introduction to ActiveX Technology (6 mins)
1.1

COM
1.2

DCOM
1.3

Compound Documents
1.4

In-Place Activation
1.5

Active X Container
1.6

Active X Server Components
1.7

Active Automation
2.0

Creating ActiveX Components (39 mins)
2.1

Types of Components
2.2

Building an Active X DLL
2.3

Compiling the DLL
2.4

Debugging the DLL
2.5

Function: Create Object
2.6

Binding
2.7

Creating an Active X EXE
2.8

Running the DLL from Excel
2.9

Differences between an Active X DLL & EXEs
3.0

Active X Components (18 mins)
3.1

Registering
3.2

Versioning
3.3

Error Handling
4.0

Call-Backs & Events (22 mins)
4.1

What is a Call Back
4.2

The Server Side
4.3

The Client Side
4.4

Disconnecting
4.5

Raising Events
5.0

Threads & Instancing (21 mins)
5.1

Threads
5.2

Instancing
5.3

Example
5.4

Thread Pool
6.0

Visual Component Manager (13 Mins)
6.1

Visual Component Manager Wizard
6.2

Visual Component Manager Wizard
6.3

Adding a Component to a Project
6.4

Making the Repository SQL Server Based
Level 12 ActiveX Controls (1 Hr 59 Mins)
1.0

Creating ActiveX Controls (46 mins)
1.1

What are ActiveX Controls?
1.2

Steps in ActiveX Control Creation
1.3

Creating an ActiveX Control
1.4

Properties
1.5

Lifetime Events
1.6

The ActiveX Control Wizard
1.7

Events
1.8

Methods
1.9

Using the Control
2.0

Advanced ActiveX Control Topics (11 mins)
2.1

Creating an About Box
2.2

Adding a Property Page
2.3

Additional Topics
3.0

Data Aware Controls (38 mins)
3.1

ActiveX Control Examples
3.2

Creating Data Aware Controls
3.3

Binding Active X Controls to Data Controls
3.4

Binding an Address Control to an ADO Data Control
3.5

Putting an Active X Control into the Data Repeater
4.0

Active X Documents (22 mins)
4.1

Overview
4.2

Active X Migration Wizard
4.3

Creating an Active X Document from Scratch
4.4

Passing Data from one Document to Another
Level 13 Client/Server Techniques (2 Hrs 15 Mins)
1.0

What is Client/Server (18 mins)
1.1

Concepts
1.2

Network File Server
1.3

Splitting the Application
1.4

Where do you put the Logic
1.5

Dead Vs Live Data
1.6

Multi-User Considerations
1.7

Cursors
1.8

Lock Types
1.9

Cursor Limitations
2.0

ODBC & OLE DB Overview (6 mins)
2.1

What is ODBC?
2.2

ODBC Components
2.3

ODBC Architecture
2.4

OLE DB
3.0

ADO (51 mins)
3.1

Asynchronous Connections
3.2

Asynchronous Recordset Operations
3.3

Asynchronous Samples
3.4

Submitting an SQL Statement Asynchronously
3.5

Transaction Processing
3.6

Long Text Fields
3.7

Multiple Result Sets
3.8

Get Rows & Get String Methods
3.9

Recordset Persistence
3.10

Cursor & Lock Types
3.11

Examining Database Structure
4.0

Command Objects (15 mins)
4.1

Command Objects
4.2

Command Object Example
4.3

Insert & Update Statements
4.4

Prepared vs. Non-prepared Statements
4.5

Executing Stored Procedures with Parameters
5.0

Client Server Applications (44 mins)
5.1

Creating a Client Server Application
5.2

Benefits of List Approach
5.3

The Sub Main Routine
5.4

Logging on
5.5

Data Entry Form Techniques
5.6

Saving & Updating
5.7

The Delete Statement
5.8

Editing
5.9

Other Data Entry Form Techniques
Level 14 Automation Programming (2 Hrs 14 Mins)
1.0

Introduction to Automation Programming (5 mins)
1.1

What is Automation
1.2

How to use Automation
1.3

Programming the Server
2.0

Automating Microsoft Excel (26 mins)
2.1

Help on Excel
2.2

Excel Object Hierarchy
2.3

Declaring Excel
2.4

Looking at the Code
2.5

Printing & Loading Data from an Access Database
2.6

Building a Graph
2.7

Shutting down your VB Application
2.8

Hidden Instances of Excel
3.0

Automating Microsoft Word (28 mins)
3.1

Building your own Mail Merge Capabilities using Bookmark
3.2

Using the Word Mail Merge Facility
3.3

Running it from Visual Basic
3.4

Using the Documents Collection to Find a Document
3.5

Using the Word Spell Checking Feature in our VB Application
3.6

Using Word as a Report System
3.7

Closing our Document in Word
4.0

Automating Microsoft PowerPoint (12 mins)
4.1

Creating a Presentation
4.2

Creating a Presentation from a Table
5.0

Automating Microsoft Outlook (19 mins)
5.1

Help on Outlook
5.2

Outlook Object Hierarchy
5.3

Displaying folders
5.4

Displaying the Explorer Window
5.5

Bringing up the Create Appointment Window
5.6

Creating the Appointment Programmatically
5.7

Sending an E-mail
6.0

Automating Microsoft Access (3 mins)
6.1

Reports
7.0

Automating Microsoft SQL DMO (11 mins)
7.1

SQL Server DMO
7.2

Object Hierarchy
7.3

Databases
7.4

Tables
8.0

Automating the Visual Basic Design Environment (29 mins)
8.1

Add-ins Toolbar
8.2

Add-ins Manager
8.3

Extracting Data out of the Environment
8.4

Adding a Sub Menu
8.5

Replacing the Tools Procedures Attributes Menus
Level 15 - Multi-Tier Architecture A (2 Hrs 24 Mins )
1.0

Introduction To Multi-Tier Architecture (9 mins)
1.1

What is Multi-Tier
1.2

Client/Server Multi Tier
1.3

Why Use Multi Tier
1.4

Examples of MT Services
2.0

Creating Reusable Classes (20 mins)
2.1

Overview of Reusable Classes
2.2

Registry Class
2.3

INI Class
2.4

Database Connection Class
2.5

Preferences Class
3.0

Building Data Access Classes (39 mins)
3.1

Overview of Data Access Classes
3.2

Looking at the Data Access Class
3.3

Populating the Class with Data
3.4

Move next & Find
3.5

Inserting the Business rules into the Class
3.6

Update Method
3.7

Delete Method
3.8

Close Record Set & Copy Object
4.0

Building a Security System (12 mins)
4.1

Login
4.2

Security DLL
4.3

Designing the Security Form
5.0

Multi-Tier Application Template (1 Hr 2 mins)
5.1

Overview of Multi Tier Application Template
5.2

Sub Main
5.3

Config from INI & App config get
5.4

Preferences Class
5.5

Data Entry Forms
5.6

Editing
5.7

Writing Keystroke Handlers
5.8

Prompting the User to Save or undo when Closing the App
5.9

Solving List Problems
Level 16 - Multi-Tier Architecture B (1 Hr 31 Mins )
1.0

Data Aware Classes (27 mins)
1.1

Overview
1.2

Data Source Class
1.3

Data Consumer Class
1.4

Data Object Wizard
2.0

Distributed Computing (15 mins)
2.1

Overview
2.2

COM Issues
3.0

Microsoft Transaction Server (48 mins)
3.1

What is MTS?
3.2

Why Use MTS?
3.3

Hardware & Software Requirements to Install MTS
3.4

Installation & Setup Procedures for MTS?
3.5

Developing an Application to run Under MTS?
3.6

MTS Component Framework
3.7

MTS DLL Graphic Explorer
3.8

Stepping through the Client Side
Level 17 Internet Topics (1 Hr 43 Mins)
1.0

Internet Controls (22 mins)
1.1

Web Browser Control
1.2

Internet Transfer Control
2.0

DHTML Applications (38 mins)
2.1

What is DHTML?
2.2

Development Environment
2.3

Deploying your Application
2.4

Creating a DHTML Application
2.5

Events
2.6

Design Considerations
2.7

Advantages & Disadvantages of DHTML
3.0

Building Internet Information Server Applications (42 mins)
3.1

Overview
3.2

Creating IIS Applications in VB 6
3.3

Active Server Pages Object Model
3.4

Creating an IIS Application from Scratch
3.5

Adding HTML Templates to the Application
3.6

Replaceable Tokens
3.7

Building a Data Environment with a Command Object
Computrain Solutions is a member of the Better Business Bureau
Copyright ©2004. Computrain Solutions. All Rights Reserved.