|
What you need to know before starting this Visual Basic training
If you are new to computer programming, you should consider Visual Basic as your language of choice for learning how to develop computer programs. Another popular language used in teaching programming is Pascal. But Visual Basic is generally more popular than Pascal. Microsoft claims that there are over 3 million Visual Basic programmers. Whatever the number, Visual Basic is popular because it is easy to learn, fun to use, and has evolved into a very powerful development tool. But programming in Visual Basic or any other programming language is a challenging task. It is a little more complicated than learning how to use Microsoft Word or Excel. But if you want to become a computer programmer, you will find Visual Basic to be the easiest way to teach yourself programming. You can get the Visual Basic training series (above) that includes the complete set of 17 Multimedia CD-ROMs or Videos.
You will hear and see your trainer on your computer screen as he teaches you beginner to advanced level Visual Basic concepts. But most of the time, you will learn Visual Basic by seeing your trainer perform real world examples with Visual Basic 6 and by writing the example programs or your own programs and running them with the Visual Basic 6 software included in this package. The best way to learn Visual Basic is by examples, and that is what this course presents a lot of. If you are new to Visual Basic, you should start with the first 8 levels (i.e. Level 1 to Level 8). Then later as you build your skills, you can purchase the rest of the training if you want to become an advanced level Visual Basic Developer. If you spend about 1 to 2 hours each day training with Visual Basic, you should become proficient in about 3 months. The rule to becoming a good or competent programmer is practice, practice, practice! If you want tips on how to become more productive with Visual Basic very quickly, especially if you are new to programming, please do not hesitate to contact us toll free at 1-888-797-4040 (or 301-589-3349) and a technical support person with development experience will assist you. Remember, the best programmers are those who enjoy programming; so just relax and program for fun and treat programming as a hobby. You will be amazed at the progress you will make and success you will have as a developer.
Detailed Course Outline: Video/CD-ROM Training
VB 6 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
VB 6 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
VB 6 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
VB 6 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
VB 6 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
VB 6 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
VB 6 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
VB 6 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
VB 6 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
VB 6 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
VB 6 Level 11 Component Development (2 Hrs)
"Microsoft COM (Component Object Model) technology in the Microsoft Windows-family of Operating Systems enables software components to communicate. COM is used by developers to create re-usable software components, link components together to build applications, and take advantage of Windows services. The family of COM technologies includes COM+, Distributed COM (DCOM) and ActiveX® Controls." - Microsoft Corporation
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 Searching for Components in the Repository
6.3 Adding a Component to a Project
6.4 Making the Repository SQL Server Based
VB 6 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
VB 6 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
VB 6 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
VB 6 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.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
VB 6 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
VB 6 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
|
Multimedia CD-ROM Based Training:
