 |
|
There are many excellent online courses. This has been hugely beneficial in my day to day work.
|
|
- Louise Nolan
|
|
|
|
|
Microsoft Visual Basic 5.0 Introduction featuring Database Development
Course Aims
This course teaches the skills required to develop database applications for Windows 95 or Windows NT using Visual Basic 5.0 Enterprise Edition. |
Assumed Knowledge
A working knowledge of a Windows environment and the ability to launch applications from Explorer, manipulate the desktop and it's menus. Some experience in a programming language is also desirable. |
Course Audience
Application Developers, Prototypes, and Analysts who want to learn the essentials of database development using Visual Basic.. |
|
Table of Contents
|
Introduction to Visual Basic 5.0
|
Learning, Professional and Enterprise Edition Differences
|
|
Essentials of Visual Basic 5.0 Development
|
|
Features of Visual Basic 5.0
|
|
|
|
Creating an Application
|
Adding and Manipulating Controls
|
|
Setting and Changing Control Properties
|
|
|
|
Responding to Events
|
Adding Code to Controls and Forms
|
|
How to Approach Event Driven Programming Design
|
|
|
|
Introduction to Relational Databases
|
Structured Query Language (SQL)
|
|
Microsoft Jet Engine and ODBC
|
|
|
|
Accessing Databases
|
Accessing a Database using Data Control
|
|
|
|
Elements of the Visual Basic Language
|
Functions and Procedures - Public and Private
|
|
The Variant and Other Data Types
|
|
If, While and Select Control Structures
|
|
Hungarian Naming Conventions
|
|
|
|
|
Forms
|
|
|
Application Windows vs. Form Properties
|
Application Windows vs. Form Properties
|
|
|
|
Menus and Toolbars
|
Enabling and Disabling Menu Options
|
|
Short Cut Keys and Mnemonics
|
|
Creating and Using Toolbars
|
|
|
Programming Databases
|
Creating and Manipulating Recordsets
|
|
Adding, Deleting and Updating Records
|
|
|
|
Creating a Larger Application
|
Managing Multiple Forms to Create more Complex Database Applications
|
|
Adding an Icon to an Application
|
|
Communication between Forms
|
|
|
|
Controls
|
Responding to Command Buttons
|
|
Using Text Boxes, Option Buttons, Check Boxes, List Boxes and Combo Boxes
|
|
|
|
Printing
|
Controlling the Printer for Text and Graphics Output
|
|
Font Selection and Control
|
|
Twips, Pixels and other Scale Models
|
|
|
|
Debugging
|
Design Time, Run Time and Break Mode Explained
|
|
Using the Debug Window with Watch Values
|
|
The Call Tree and Instant Watch
|
|
|
|
Classes
|
Classes in Visual Basic Explained
|
|
|
|
OLE Automation
|
Introduction to OLE Automation
|
|
In Process and Out of Process Servers
|
|
Using an OLE Automation Object
|
|
Introduction to the Three Tier Database Architecture
|
|
|
|
|
|