Visual Basic Database Programming
Outline
Aims of the Five-Day Course
This course has been designed for existing users to learn how to develop
databases in Visual Basic. The course is 100% hands-on, with exercises
to help delegates practice the new skills they learn.
Course Content
- 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 From 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
|
Prerequisites
Trainees should have some application experience and ideally have done
the Visual Basic Introduction course or have equivalent knowledge.
Course Duration
Thirty hours - 9.30am to 12.30pm and 1.30pm to 4.30pm on each day.
Please contact
us for prices for this course
|
