Visual Basic 6.0 Database Programming Course
Course Description
You will get the most out of this course if you want to learn how to develop database applications in Visual Basic 6.0. You should have some application experience, ideally in object-oriented programming, but no prior knowledge of data management or querying is assumed. This course is intended for application developers and other computer professionals who will use Visual Basic 6.0 to manage data.
Course pre-requisites:
Previous to taking this course, a student should take the Visual Basic 6.0: Introduction, or possess equivalent knowledge.
Topics covered on the 5 day Visual Basic 6.0 Database Programming course
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 Dont’s
Using SQL
SQL Overview
SELECT Statements
Cursors
Record-locking
Stored Procedures
Internet Applications
WebBrowser Control
What is an Active Document?
Appendix A: Applications Used in This Course
Appendix B: Physical Design of Applications
Course Classification:
Course Fee = £1475 (excl.VAT)
Scheduled course dates
| March 2010 | April 2010 | May 2010 | June 2010 | July 2010 |
| | | | |
Print / Download PDF Version of full course schedule
If you would prefer to run this course at your premises as you have several employees to place on the course perhaps, then we are also able to offer onsite Visual Basic Training and bespoke Visual Basic courses