| 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. Purchase of complete VB 6.0 course includes test preparation software. |
| Level 1 |
| Overview: What is Visual Basic?, History & Features, Advantages, Versions & Components |
| Windows: Overview of Windows, Versions & Computing Terms |
| The VB Environment: Overview of VB Environment, Setting up the VB Environment, Forms, Controls & Labels, Setting Project Properties, Command Buttons, The Frame Control, Inserting Images, The ListBox Control, Combo Box, Menus, Creating an Executable |
| Level 2 |
| Events: Overview Event Procedures, Form & Control Events |
| Variables: Variables, Scope of Variables, Variable Declarations, Naming Variables & , Relational Operators, Operator Precedence, Constants, The Variant Data Type, Arrays, User-Defined Types |
| Conditional Logic: If, Else and Elself Statements, Select Case Statements |
| Level 3 |
| Procedures & Functions: Procedures, Creating & Calling Procedure, Sub Main, Functions, Parameters/Arguments, Call by Reference, Built-in Functions, Methods |
| Dialog Boxes: What is a Dialog Box?, Message Box, Input Box Dialog, Common Dialog, Building a Custom Dialog |
| ADO Data Control: Methods of Getting Data, Universal Data Access, ADO Data Control, Setting up an ODBC Datasource, Using the Data Control, Data List Control, The Data Grid |
| Level 4 |
| Programming the ADO Data Control: The Recordset Property & Data Control Events, Order , f Events, Adding Features, Deleting Data, Canceling Changes, Data Validation, The Error Event, Displaying Records, Finding Records |
| MDI: Overview of MDI, Adding a Project to MDI, Positioning the Project, Listing open Child Windows, Right Mouse Click Menu, Unloading an MDI Application |
| Debugger: Stepping Through Code, Setting Break Points, Adding Watch Variables, Debug.Print
|
| Error Handling: Visual Basic Errors, Adding our own Error Handling, Error Object, Listing the Errors, OnError Resume Next, The Resume Statement, The Call Stack, Global Error Handler |
| Level 5 |
| Tips & Tricks: Searching, Jumping around VB, Bookmarks, Form Tips & Tricks, Formatting Your Controls, The Property Window, Customizing the Windows Environment, Using Add-ins, Creating Templates, Toolbox Tricks |
| Object Oriented Programming: OOP Terminology, Uses of Classes, Differences between Procedural Coding & OOP, Advantages & Disadvantages, Step by Step creation of an Employee class module, Class Initialization, Class Builder Utility, Methods, Using Forms as Objects, Creating a TextStream Class, Default Methods & Properties |
| Level 6 |
| System Objects: What is an Object?, Object Types, The App Object, The Screen Object, The Clipboard Object, Creating New Forms at Runtime, Using Form & Control Objects |
| Collections: What is a Collection?, Using the Forms Collection, Using the Controls Collection, Using the Printer Collection, Creating Your Own Collections, Creating a Collection Class |
| Tips & Tricks: Handling Keystrokes & Testing for Certain Input Data, Validating Data, Finding Values in Combo Boxes, Data Format Property, Third Party Controls |
Wizards: Using the Data Form Wizard, Using the Application Wizard
|
| Level 7 |
| Using ADO Objects: Properties & Methods of the Connection Object, Properties & Methods of the Recordset Object, Recordset Types, Creating a Data Entry form Using ADO, Error Handling, Multi-User Concepts |
Visual Database Tools: Data Environment, Data View Window, Query Designer window, SQL Editor, Database Diagram Window, Visual Data Manager |
| Optimization: Speed Optimization Technique, Size Optimization Techniques |
| Level 8 |
The Windows API: What is the Windows API?, Uses of the Windows API, Declaring Windows API Functions, Calling Windows API Functions, Send Message, GetDriveType32, Retrieving System Information |
Storing User Information: INI Files & Using API Calls, Creating an INI Class, What is the Registry, Using GetSetting & SaveSetting, Deleting a Registry Entry |
ActiveX Controls: ImageList Control, Toolbar, Coolbar, Status Bar, ImageCombo, DateTimePicker, Month View, Progress Bar, Slider, UpDown, Tab Strip, SSTab |
Level 9 |
Package & Deployment Wizard: What is a Setup, Steps to Distribution, VB Runtime Files, Setup Runtime Files, Types of Setups, Creating a Package, Deploying the Package, Testing the Setup |
Advanced Common Controls: Flex Grid Control, Hierarchical Flex Grid Control, Tree View & List View Controls, Rich Text Box Control, Flat Scrollbar, Drive, The Timer Control, The Animation & Multimedia Control |
Creating Controls at Runtime: Add Method, Creating Controls at Design Time, Creating Menus at Run Time |
HTML Help: Overview of Help, Creating an HTML Help System |
Level 10 |
| Drag & Drop: Automatic Drag & Drop, Manual Drag & Drop, Putting it all Together |
File & System Objects: Drives, Folders, Files |
The Dictionary Object: Overview of Dictionary Object, Simple Dictionary Object, Using the Dictionary Object to hold Objects |
Printing: Printer Object, Data Report Designer, Crystal Reports |
Level 11 |
Introduction to ActiveX Technology: COM, DCOM, Compound Documents, In-Place Activation, Active X Container, Active X Server Components, Active Automation |
| Creating ActiveX Components: Types of Components, Building an Active X DLL, Compiling the DLL, Debugging the DLL, Function: Create Object, Binding, Creating an Active X EXE, Running the DLL from Excel, Differences between an Active X DLL & EXEs |
| Active X Components: Registering, Versioning, Error Handling |
| Call-Backs & Events: What is a Call Back, The Server Side, The Client Side, Disconnecting, Raising Events |
Threads & Instancing: Threads, Instancing, Example, Thread Pool |
| Visual Component Manager: Visual Component Manager Wizard, Searching for Components in the Repository, Adding a Component to a Project, Making the Repository SQL Server Based |
Level 12 |
Creating ActiveX Controls: What are ActiveX Controls?, Steps in ActiveX Control Creation, Creating an ActiveX Control, Properties, Lifetime Events, The ActiveX Control Wizard, Events, Methods, Using the Control |
Advanced ActiveX Control Topics: Creating an About Box, Adding a Property Page, Additional Topics |
Data Aware Controls: ActiveX Control Examples, Creating Data Aware Controls, Binding Active X Controls to Data Controls, Binding an Address Control to an ADO Data Control, Putting an Active X Control into the Data Repeater |
| Active X Documents: Overview, Active X Migration Wizard, Creating an Active X Document from Scratch, Passing Data from one Document to Another |
Level 13 |
What is Client/Server: Concepts, Network File Server, Splitting the Application, Where do you put the Logic, Dead Vs Live Data, Multi-User Considerations, Cursors, Lock Types, Cursor Limitations |
| ODBC & OLE DB Overview: What is ODBC?, ODBC Components, ODBC Architecture, OLE DB |
| ADO: Asynchronous Connections, Asynchronous Recordset Operations, Asynchronous Samples, Submitting an SQL Statement Asynchronously, Transaction Processing, Long Text Fields, Multiple Result Sets, Get Rows & Get String Methods, Recordset Persistence, Cursor & Lock Types, Examining Database Structure |
| Command Objects: Command Objects, Command Object Example, Insert & Update Statements, Prepared vs. Non-prepared Statements, Executing Stored Procedures with Parameters |
| Client Server Applications: Creating a Client Server Application, Benefits of List Approach, The Sub Main Routine, Logging on, Data Entry Form Techniques, Saving & Updating, The Delete Statement, Editing, Other Data Entry Form Techniques |
Level 14 |
| Introduction to Automation Programming: What is Automation, How to use Automation, Programming the Server |
Automating Microsoft Excel: Help on Excel, Excel Object Hierarchy, Declaring Excel, Looking at the Code, Printing & Loading Data from an Access Database, Building a Graph, Shutting down your VB Application, Hidden Instances of Excel |
Automating Microsoft Word: Building your own Mail Merge Capabilities using Bookmark, Using the Word Mail Merge Facility, Running it from Visual Basic, Using the Documents Collection to Find a Document, Using the Word Spell Checking Feature in our VB Application, Using Word as a Report System, Closing our Document in Word |
| Automating Microsoft PowerPoint: Creating a Presentation, Creating a Presentation from a Table |
Automating Microsoft Outlook: Help on Outlook, Outlook Object Hierarchy, Displaying folders, Displaying the Explorer Window, Bringing up the Create Appointment Window, Creating the Appointment Programmatically, Sending an E-mail |
Automating Microsoft Access: Reports |
| Automating Microsoft SQL DMO: SQL Server DMO, Object Hierarchy, Databases, Tables |
| Automating the Visual Basic Design Environment: Add-ins Toolbar, Add-ins Manager, Extracting Data out of the Environment, Adding a Sub Menu, Replacing the Tools Procedures Attributes Menus |
| Level 15 |
Introduction To Multi-Tier Architecture: What is Multi-Tier, Client/Server Multi Tier, Why Use Multi Tier, Examples of MT Services |
| Creating Reusable Classes: Overview of Reusable Classes, Registry Class, INI Class, Database Connection Class, Preferences Class
|
| Building Data Access Classes: Overview of Data Access Classes, Looking at the Data Access Class, Populating the Class with Data, Move next & Find, Inserting the Business rules into the Class, Update Method, Delete Method, Close Record Set & Copy Object |
Building a Security System: Login, Security DLL, Designing the Security Form
|
Multi-Tier Application Template: Overview of Multi Tier Application Template, Sub Main, Config from INI & App config get, Preferences Class, Data Entry Forms, Data Entry Forms, Editing, Writing Keystroke Handlers, Prompting the User to Save or undo when Closing the App., Solving List Problems
|
Level 16
|
| Data Aware Classes: Overview, Data Source Class, Data Consumer Class, Data Object Wizard
|
Distributed Computing: Overview, COM Issues
|
Microsoft Transaction Server: What is MTS?, Why Use MTS?, Hardware & Software Requirements to Install MTS, Installation & Setup Procedures for MTS?, Developing an Application to run Under MTS?, MTS Component Framework, MTS DLL Graphic Explorer, Stepping through the Client Side
|
Level 17
|
| Internet Controls: Web Browser Control, Internet Transfer Control
|
DHTML Applications: What is DHTML?, Development Environment, Deploying your Application, Creating a DHTML Application, Events, Design Considerations, Advantages & Disadvantages of DHTML
|
Building Internet Information Server Applications: Overview, Creating IIS Applications in VB 6, Active Server Pages Object Model, Creating an IIS Application from Scratch, Adding HTML Templates to the Application, Replaceable Tokens, Building a Data Environment with a Command Object
|
|
