• Visual Basic Course Provider Page
• Information On Other Visual Basic Courses

Visual Basic 6: Database Programming

3 Day Course

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