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

Visual Basic 5.0: Database Programming

3 Day Course

Overview

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

Prerequisites

Visual Basic 5.0 Introduction to Programming or equivalent knowledge.

Benefits

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

Target student

Students attending this course should have some programming experience with Visual Basic.

Orientation to data access

• Introduction to database application development
• Orientation to Data Access objects and Remote data objects
• Using the Visual Data Manager

Database connections

• Selecting a database
• Registering a DataSource
• Creating the ODBC connect string
• Connecting to an ODBC database
• Directly accessing external databases

Using Data controls to maintain and navigate databases

• Data maintenance with Data controls
• Navigating records by using Data controls
• Updating, adding, and deleting data with Data controls

Other data bound controls

• The data bound list controls
• The data bound grid
• Other data bound controls
• Accessing DAO properties

Managing data with Recordsets and Resultsets

• Using Recordset objects
• Edit and Update methods
• AddNew and Delete methods
• Locating records
• Result set management

Validating data

• Data control recordset validation
• Validating Recordset object data
• Using the Visual Data Manager
• Form synchronisation

Debugging database applications

• Error handling with RDO
• RDO error log

Using SQL

• Overview of SQL statements
• Using SQL to create dynaset-type Recordset objects
• Rollup, crosstab, and table join queries

Reporting

• Printing from within Visual Basic
• Crystal Reports for Visual Basic
• Previewing a Crystal Report in Visual Basic

Deployment

• Distributing a database application

Multi-user applications