How Windows Works
- Windows as an Event-Driven,
  Object-Oriented System
- Windows Versions

Creating a Visual Basic Application
- The Visual Basic Environment
- How Visual Basic Programming is
  radically different to conventional 
  programming and initial rules for
  good design

Forms, Controls & Properties
The components of a Visual Basic
application and our first use of its
object-oriented mechanisms.

Events
Handling general input as well as
system events such as Form Load
Control interaction and focus

Controls, Control Arrays & Methods
- Menus, the basic control set and 
  the use and benefits of control 
  arrays
- Modal and modeless forms
  and the use of 'Me'
- Producing an Elegant and
  Foolproof User Interface

The Visual Basic
Programming Language
- Variable Types, Scope and 
  Lifetime, including Variants and 
  Application
- Defined Types
- Arrays and collections
- Control flow; If, For Next, Do 
  While/Until, For Each, Select Case
- Other Language Features

Timers, Now & Format$
- The Timer Control - its 
  importance and limitations
- Using, manipulating and 
  displaying dates and times

Subs, Functions & Error Handling
- Subroutines and functions
- Argument passing mechanisms,
- named and optional arguments
- Public, Private and the use of 
  modules
- Error handling and using a 
  general error handling routine
- The Err object

MDI Applications
- The use of Multiple Document 
  Interface - for single and multiple 
  document types
- Dynamic forms and controls

Picture Boxes, Graphics & Printing
- Takes a more detailed look at 
  output on forms, controls and 
  the printer.

The Professional & Enterprise Toolboxes
The additional controls provided by the Professional edition. Several are covered in detail, such as the common dialog
and List View controls.

The Database Object Models
& Technologies
The acronyms and what they 
mean - SQL, JET, DAO, RDO, ODBC, ODBC Direct and ADO.

ActiveX Data Objects - ADO
- ADO and OLEDB
- Providers and Consumers
- ADO as the future

The Data Control & the Wizards
The data control and its associated data bound controls provide the simplest way of interfacing an application to a database and tools like the Data Form Wizard can simplify this even further.
- Discusses what can be 
  achieved and the limitations

A Quick Guide to SQL
- Where Structured Query 
  Language has come from and 
  how it is used
- The Basic Syntax for SELECT
  and Action Queries
- Joins and Aggregates

Using ADO & SQL
- Using a Data Environment and 
  using the ADO Object Model 
  directly
- Recordset manipulation
- The SQL Builder Utility
- Commands, Queries and
- Parameter Passing
- Dynamic SQL

The Report Designer
- How the Designer works
- Creating sophisticated Reports 
  from your Database 
  information using the Report 
  Designer and SQL

Drag & Drop
- A useful and straightforward 
  subject that we use to 
  conclude the course.