Visual Basic 5.0: Database Programming

Course Description
Course Outline

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.

We offer a range of Visual Basic training courses

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

Publisher:	Microsoft
Version:	5
Length:	3 Days
Course-ID:	047501

	Printer Friendly Version
	Download Outline As PDF

Related Courses

The trainer is always very knowledgeable, not only about the subject being taught, but other related topics ... having the all round knowledge sets you apart. Thanks again

- Heart of England TEC