Call: 0118 3243000
Systematix Training Ltd
Home | Visual Basic | Visual Basic 6: Database Programming

Visual Basic 6: Database Programming

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..

We offer a range of Visual Basic training courses

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
 
Publisher: Microsoft
Version: 6
Length: 3 Days
Course-ID: 047504
Printer Friendly Version
Download Outline As PDF
Request A Quote Ask Us A Question

Related Courses

Systematix seemed genuinely interested in providing us with a course tailored to meet our specific needs

- Yell

Microsoft Registered Partner
BSI ISO 9000