Visual Basic Training
 Now you can train for Visual Basic 6.0 programming on DVDs. Course material is presented in classroom style. Each course includes free
workbooks. Your instructor, Paul Sheriff, is a Microsoft Certified Visual Basic Instructor. There are 17 levels on DVD that comprise the Visual
Basic Training. Levels 1-8 cover fundamentals for anyone who needs a general understanding of programming in this language. Levels 9-17 cover training for the advance topics.
 Now Available!
Microsoft VB.NET is a complete and total rewrite of the Visual Basic compiler. CD's, Videos or Seminars are available.
Live Boot Camp Classes for MCAD and MCSD Certification
|
Visual Basic 6 Set of 17 Training DVDs
|
kyvb6mb
|
$695.00
|
|
Visual Basic 6 Training DVDs
Level 1 (1 Hour 51 Minutes)
1.0 Overview (19 Minutes)
1.1 What is Visual Basic?
1.2 History and Features
1.3 Advantages
1.4 Versions and Components
2.0 Windows (13 Minutes)
2.1 Overview of Windows
2.2 Versions and Computing Terms
3.0 The VB Environment (1 Hour 18 Minutes)
3.1 Overview of VB Environment
3.2 Setting up the VB Environment
3.3 Forms
3.4 Controls and 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 Hour 54 Minutes)
1.0 Events (33 Minutes)
1.1 Overview Event Procedures
1.2 Form and Control Events
2.0 Variables, Constants, Arrays and User Defined Types (56 Minutes)
2.1 Variables
2.2 Scope of Variables
2.3 Variable Declarations
2.4 Naming Variables and 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 Minutes)
3.1 If, Else, and ElseIf Statements
3.2 Select Case Statements
3.3 Conditional Compilation Statements
3.4 Looping
Level 3 (1 Hour 58 Minutes)
1.0 Procedures & Functions (47 Minutes)
1.1 Procedures
1.2 Creating and 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 Minutes)
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 Minutes)
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 Hour 51 Minutes)
1.0 Programming the ADO Data Control (39 Minutes)
1.1 The Recordset Property and 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 Minutes)
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 Minutes)
3.1 Stepping Through Code
3.2 Setting Break Points
3.3 Adding Watch Variables
3.4 Debug.Print
4.0 Error Handling (21 Minutes)
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 Hours)
1.0 Tips & Tricks (55 Minutes)
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 Hour 4 Minutes)
2.1 OOP Terminology
2.2 Uses of Classes
2.3 Differences between Procedural Coding and OOP
2.4 Advantages and 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 and Properties
Level 6 (1 Hour 48 Minutes)
1.0 System Objects (30 Minutes)
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 and Control Objects
2.0 Collections (27 Minutes)
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 Minutes)
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 Minutes)
4.1 Using the Data Form Wizard
4.2 Using the Application Wizard
Level 7 (1 Hour 48 Minutes)
1.0 Using ADO Objects (48 Minutes)
1.1 Properties and Methods of the Connection Object
1.2 Properties and 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 Minutes)
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 Minutes)
3.1 Speed Optimization Technique
3.2 Size Optimization Techniques
Level 8 (2 Hours 3 Minutes)
1.0 The Windows API (32 Minutes)
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 Minutes)
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 Active X Controls (1 Hour)
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 Visual Basic Topics (2 Hours 13 Minutes)
1.0 Package & Deployment Wizard (29 Minutes)
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 Hour 1 Minutes)
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, Directory, & File Controls
2.7 The Timer Control
2.8 The Animation & Multimedia Control
3.0 Creating Controls at Runtime (18 Minutes)
3.1 Add Method
3.2 Creating Controls at Design Time
3.3 Creating Menus at Run Time
4.0 HTML Help (24 Minutes)
4.1 Overview of Help
4.2 Creating an HTML Help System
Level 10 Visual Basic Techniques (2 Hours 5 Minutes)
1.0 Drag & Drop (20 Minutes)
1.1 Automatic Drag & Drop
1.2 Manual Drag & Drop
1.3 Putting it all Together
2.0 File & System Objects (34 Minutes)
2.1 Drives
2.2 Folders
2.3 Files
3.0 The Dictionary Object (15 Minutes)
3.1 Overview of Dictionary Object
3.2 Simple Dictionary Object
3.3 Using the Dictionary Object to hold Objects
4.0 Printing (55 Minutes)
4.1 Printer Object
4.2 Data Report Designer
4.3 Crystal Reports
Level 11 Component Development (2 Hours)
1.0 Introduction to ActiveX Technology (6 Minutes)
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 Minutes)
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 Minutes)
3.1 Registering
3.2 Versioning
3.3 Error Handling
4.0 Call-Backs and Events (22 Minutes)
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 and Instancing (21 Minutes)
5.1 Threads
5.2 Instancing
5.3 Example
5.4 Thread Pool
6.0 Visual Component Manager (13 Mintues)
6.1 Visual Component Manager Wizard
6.2 Searching for Components in the Repository
6.3 Adding a Component to a Project
6.4 Making the Repository SQL Server Based
Level 12 ActiveX Control Development (1 Hour 59 Minutes)
1.0 Creating ActiveX Controls (46 Minutes)
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 Minutes)
2.1 Creating an About Box
2.2 Adding a Property Page
2.3 Additional Topics
3.0 Data Aware Controls (10 Minutes)
3.1 Creating Data Aware Controls
4.0 Data Aware ActiveX Controls (21 Minutes)
4.1 Binding Active X Controls to Data controls
4.2 Binding an Address Control to an ADO Data Control
5.0 Data Repeater Control (7 Minutes)
5.1 Putting an Active X Control into the Data Repeater
6.0 Active X Documents (22 Minutes)
6.1 Overview
6.2 Active X Migration Wizard
6.3 Creating an Active X Document from Scratch
6.4 Passing Data from one Document to another
Level 13 Client/Server Techniques (2 Hours 15 Minutes)
1.0 What is Client/Server (18 Minutes)
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 and OLE DB Overview (6 Minutes)
2.1 What is ODBC?
2.2 ODBC Components
2.3 ODBC Architecture
2.4 OLE DB
3.0 ADO (51 Minutes)
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 and Get String Methods
3.9 Recordset Persistence
3.10 Cursor and Lock Types
3.11 Examining Database Structure
4.0 Command Objects (15 Minutes)
4.1 Command Objects
4.2 Command Object Example
4.3 Insert and Update Statements
4.4 Prepared vs. Non-prepared Statements
4.5 Executing Stored Procedures with Parameters
5.0 Client Server Applications (44 Minutes)
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 and Updating
5.7 The Delete Statement
5.8 Editing
5.9 Other Data Entry Form Techniques
Level 14 Automation Programming (2 Hours 14 Minutes)
1.0 Introduction to Automation Programming (5 Minutes)
1.1 What is Automation
1.2 How to use Automation
1.3 Programming the Server
2.0 Automating Microsoft Excel (26 Minutes)
2.1 Help on Excel
2.2 Excel Object Hierarchy
2.3 Declaring Excel
2.4 Looking at the Code
2.5 Printing and 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 Minutes)
3.1 Building your own Mail Merge Capabilities using Bookmarks
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 Minutes)
4.1 Creating a Presentation
4.2 Creating a Presentation from a Table
5.0 Automating Microsoft Outlook (22 Minutes)
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
5.8 Reports
6.0 Automating Microsoft SQL DMO (11 Minutes)
6.1 SQL Server DMO
6.2 Object Hierarchy
6.3 Databases
6.4 Tables
7.0 Automating the Visual Basic Design Environment (29 Minutes)
7.1 Add-ins Toolbar
7.2 Add-ins Manager
7.3 Extracting Data out of the Environment
7.4 Adding a Sub Menu
7.5 Replacing the Tools Procedures Attributes Menus
Level 15 - Multi-Tier Architecture – A (2 Hours 24 Minutes)
1.0 Introduction To Multi-Tier Architecture (9 Minutes)
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 Minutes)
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 Minutes)
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 and Copy Object
4.0 Building a Security System (12 Minutes)
4.1 Login
4.2 Security DLL
4.3 Designing the Security Form
5.0 Multi-Tier Application Template (1 Hour 2 Minutes)
5.1 Overview of Multi Tier Application Template
5.2 Sub Main
5.3 Config from INI and 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 Hour 31 Minutes)
1.0 Data Aware Classes (27 Minutes)
1.1 Overview
1.2 Data Source Class
1.3 Data Consumer Class
1.4 Data Object Wizard
2.0 Distributed Computing (15 Minutes)
2.1 Overview
2.2 COM Issues
3.0 Microsoft Transaction Server (48 Minutes)
3.1 What is MTS?
3.2 Why Use MTS?
3.3 Hardware and Software Requirements to Install MTS
3.4 Installation and 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 Hour 43 Minutes)
1.0 Internet Controls (22 Minutes)
1.1 Web Browser Control
1.2 Internet Transfer Control
2.0 DHTML Applications (38 Minutes)
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 and Disadvantages of DHTML
3.0 Building Internet Information Server Applications (42 Minutes)
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
|
