Management Sales Technology training courses, Dublin Belfast Cork Ireland, Beckinridge
Management Sales Technology training courses, Dublin Belfast Cork Ireland, Beckinridge

Visual Basic 6 Programming

Course Code - GN-201 Duration - 4 Days

This is a 4-day course covering general application development in Visual Basic as well as its use for accessing and manipulating databases. It is a hands-on course with many practical examples of using Visual Basic to produce useful applications and emphasises good style for producing robust, maintainable code.

Prerequisites

Delegates should be familiar with the use of Windows and the fundamental concepts of programming. The current course covers Visual Basic version 6, however previous versions can also be accommodated.

Course Content

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.

« Back to last page

Why Choose Us?

ILM Qualifications

Beck-Bites

Team Building

Public Schedule


© web design by redrhino

Privacy Policy