Visual Basic 6: Database Programming

3 days

Overview

Students will learn how to use Visual Basic 6 for database programming.

Prerequisites

Visual Basic 6 Introduction to Programming or equivalent knowledge.

Benefits

Students will learn how to use the Visual Basic 6 programming language to access and manipulate a database.

Target student

This course is intended for application developers and other computer professionals who will use Visual Basic 6 to manage data. Students should have some application experience, ideally in object-oriented programming, but no prior knowledge of data management or querying is assumed..

Database Basics

What is a Database?
Using the Visual Basic Database Tools to Manage Your Data
Relational Database Structures

Overview of SQL

What is SQL?
Optional Clauses
Advanced Statements and Resource Management

The ActiveX Data Object (ADO) Model

Universal Data Access (UDA)
The ADO Model
Introduction to Data Access

The ADO Data Control

Properties, Methods, and Events of the ADODC
Bound Controls
The Data Form Wizard

The ADO DataEnvironment

The DataEnvironment (DE)
Creating Command and Recordset Objects in the DE
Using Bound Controls and Data Designing in the DE

Working with ADO Code

The Connection Object
The Recordset Object
The Command Object

Data Reporting

Printing From Within Visual Basic
Using the Data Report Designer in the DataEnvironment (DE)
Using ADO Code to Display Data Reports
Advanced Topics

The Data Access Objects (DAO) Model and Data Control

The Data Access Objects (DAO) Model
Comparing DAO and ADO
Intrinsic Controls and DAO

Working with DAO Code

Writing Code to Store Data
Creating a New Database with DAO Code
Coding the Project
Data Manipulation with DAO Code

Migration

Making the Decision to Migrate
Legacy Upgrade Compatibility Issues
Migration Dos and Don'ts