Visual Basic 6: Database Programming

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