skip navigationUniversity of WyomingUniversity of Wyoming
UW Home  |  WyoWeb  |  UW A-Z Index  |  UW Directory  |  Search UW  
Information Technology
Information Technology Hot Page: system status    IT Home                  A to Z Index            Ask IT     Search IT:
  

Self-Paced Training


Training on CD Subjects:

Access 2007

Access 2003

Excel 2007

Excel 2003

Outlook 2007

Outlook 2003

PowerPoint 2007

PowerPoint 2003

Publisher 2007

Word 2007

Word 2003

Visual Basic 6.0: Database Access

Windows Vista

InDesign CS

Photoshop CS

Dreamweaver CS3 Basic

Dreamweaver CS3 Advanced

Flash CS3

Illustrator CS3 Basic

Illustrator CS3 Intermed.

Illustrator CS3 Advanced

Photoshop CS3 Basic

Photoshop CS3 Intermed.

Photoshop CS3 Advanced

 

 

Instructor-Led Virtual Training on CD from Makau Corp.

Visual Basic Database Access

Visual Basic Database Access Part I

Introduction to Databases

  • Database Concepts
  • Accessing and Manipulating Data
  • Database Interoperability
  • Practice

Introduction to SQL

  • Introduction to SQL
  • QL Programming Essentials
  • Retrieving Database Data
  • Modifying Database Data
  • Practice

Using Data Controls in Visual Basic

  • Understanding Data Controls
  • Connecting to a Database
  • Creating Commands
  • Displaying Recordsets in Forms
  • Practice

Visual Basics 6.0 Database Access Part II

Programming with Active X Data Objects

  • The ADO Object Model
  • The Connection Object
  • The Command object
  • The Recordset Object
  • ADO Errors
  • Practice

Updating and Editing Data Records with ADO

  • ADO Properties and Methods
  • Modifying Data Records
  • Disconnected Recordsets
  • Practice

Advanced Data Access with ADO

  • Working with SQL Server Security
  • Using ADO Cursors
  • Maintaining Data Integrity Through ADO
  • Running Stored Procedures with ADO
  • Practice

 


Contents © 1998-2009 by the University of Wyoming Division of Information Technology • All rights reserved.

Contents © 1998-2009 by the University of Wyoming Division of Information Technology. All rights reserved.