PTR - People, Training ResultsPeople, Training, Results

Independent Technical IT Computer Training Courses

   

Visual Basic Course Index & Training Schedule


More Visual Basic Courses

Introduction to Programming using Visual Basic 2005 CourseMicrosoft Visual Basic 2005: Developing Applications Part 1 CourseMicrosoft Visual Basic 2005: Developing Applications Part 2 CourseIntroduction To Object Oriented Programming CourseLearning To Program In Visual Basic 2005 CourseFundamentals of Visual Basic .NET: Level 1 CourseProgramming Visual Basic .NET: Level 2 CourseAdvanced Visual Basic .NET Programming: Level 3 CourseADO.NET using VB.NET CourseWeb Services Using VB.NET & ASP.NET CourseEnterprise Development In Visual Basic .NET CourseProgramming Fundamentals of Visual Basic - Level 1 CourseProgramming Visual Basic 6.0 Applications - Level 2 CourseAdvanced Visual Basic 6.0 Programming Concepts - Level 3 Course


Late Availability Courses:


Training Course Subjects:

Applications Training Courses C Programming Courses C# Programming Courses Cisco Courses Citrix Courses CIW Courses CompTia Courses Database Courses Exchange Server Courses Fortran Courses Internet Courses ITIL Service Management Courses Java Courses Linux Courses Microsoft Courses Microsoft .NET Courses Microsoft Access Courses Microsoft Excel Courses Microsoft Outlook Courses Microsoft Powerpoint & Visio Courses Microsoft Project Courses Microsoft Server Products Courses Microsoft Word Courses Networking Courses Oracle Courses Perl Courses Programming Courses Security Courses SQL Courses SQL Server 2005 Courses SQL Server 2008 Courses Unix Courses VBA Courses Visual Basic Courses Visual Basic 2008 Courses Visual Studio Courses Visual Studio 2008 Courses Visual Studio 2010 Courses VMWare Courses Web Design Courses Windows Server 2003 Courses Windows Server 2008 Courses Windows 7 Courses Windows Vista Courses Windows XP Courses XML Courses

Online e-Learning Courses

Scheduled Classroom based Training Courses

Visual Basic 6.0 Database Programming Course

Course Description

This course is no longer scheduled to run. Please refer to schedule for current course titles.

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

5 day course

Scheduled Dates:

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 = £   (excl.VAT)



    Scheduled course dates



    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