Introduction to Strings, Substrings - Mid$, Right$, Left$, Searching Strings, Reformatting and Generating String, The Format$ Function, Using Format$ With Dates and Times, Other Date and Time Functions, Quick Reference Table Of String Functions, Miscellaneous String Functions, Ansi Vs Unicode Strings, String Functions Exercise, Bonus Exercise: Working With Dates And Times.

Error Handling In Visual Basic, Error Handling Techniques, How To Continue After An Error, Coding Techniques Using The On Error Statement, Error Handling With Subs And Functions, Exercise With Error Handling, User-Defined Types, Arrays, Collections, Exercise With Arrays And Collections

Accessing Files, The Open Statement, Accessing Sequential Files, Comma-Delimited Files, Accessing Binary Files, Accessing Random Files, Common Dialog Box, How To Use The Common Dialog, How To Use Common Dialog To Select Files, Lab: Using Files And The Common Dialog

Mouse Events, Keyboard Events, Exercise Using Keypreview, Drag And Drop, Exercise: How To Create A Drag-And-Drop Application, Database Overview & Definition, Basic Concepts, Structured Query Language (SQL), Visual Basic Database Architecture, Three-Tier Client-Server Model, Visual Basic Connectivity Options, Features Of The Access Engine, ODBC Overview, Defining Databases, Exercise: Using The Data Manager

Overview, Exercise Using The Visual Layer (Data Control), The Data Control, Binding Controls To The Data Control, Additional Properties And Methods Of The Data Control, The Current Row And The Dynaset, Exercise With Move Methods, Using The Findfirst Method, Updating And Deleting Records, Exercise: Updating And Deleting Records, Adding Records, Exercise: Adding Records

Events Overview, The Validate Event, Exercise Using The Validate Event, The Reposition Event, Exercise With The Reposition Event, Handling Multiple Users, Exercise Dealing With Multiple Users, How Locking Is Handled, Exercise With Page Locking.

Grid Control, Combo Box Control, List Box Control, Exercise Combo Box And List Box Controls, Exercise Using The Data-Bound Grid Control

nThe Data Object Layer

The Data Object Variables, The Dbengine And Workspace Objects, The Database Object, The Recordset Objects, Working With Recordset Objects, Navigating Using The Move Methods, Locating Records In Recordsets, Adding And Updating Records In Recordset, Sorting And Filtering Data, Recordset Objects - Summary Of Methods & Properties, A Simple Table Example, Advanced Table Exercise Using The Grid Control

The Database Object Hierarchy,Exercise: How To List All The Tables In A Database, The Querydef Object, Running A Parameter Query, Exercise With Parameter Queries, How To List Queries In A Database, Bonus Exercise: Creating A Query Viewer

Overview, Creating Components Within VB, Walkthrough: Creating A Class Module, Creating An OLE Server, Setting The Class Module Properties, Walkthrough: Using Your OLE Server, Compiling Your OLE Server, Walkthrough: Compiling Your OLE Server, Bonus Lab: Creating A Calendar OLE Object

OLE Overview, The OLE Control, Exercise Using The OLE Control, Properties Of The OLE Control, Exercise: Creating An Object At Run Time, OLE Automation Overview, Creating And Accessing Objects, Manipulating Objects, Object Hierarchies And Collections, Exercise: Sending Data To Excel, Bonus Exercise

Crystal Reports Overview, Designing A Crystal Report, Linking Crystal Reports To Visual Basic, Sorting And Grouping In Crystal Reports, Filtering Records In Crystal Reports, Multi-Table Reports, Bonus Exercise, Multiple Document Interface, Multiple Document Interface, Steps To Create An MDI Application, MDI Child Forms, Exercise With Child Forms, Exercise - How To Create An MDI Toolbar, Exercise: Adding Code To The MDI Toolbar, Bonus Exercise

Overview, The Windows API, A Simple Dll Example, Declaring A Dll Procedure, Special Considerations When Declaring Dlls, Conditional Compilation, Passing By Value Or By Reference, Passing Strings To Dlls, Using Window Handles (Hwnds) With Dlls, Passing The Correct Data Types, Exercise: Getting The Windows Directory, Exercise: Getting And Putting Ini Entries, Bonus Exercise: Setting A Text Box To Read Only

DDE Overview, Components Of A DDE Link, Exercise: Creating A Source Application, Link Events, Link Methods, Link Properties Of A Destination Control, Exercise: Creating A Destination Application.

Return to Table of Contents