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.
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.
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.
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
- 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 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