COURSEWARE | TRAINING |

Providing instructor-led courseware  
for your training efforts  

Search for


BY TOPIC

Microsoft Office
Access, Excel, Outlook, PowerPoint, Visio, Word...

  As a book
  As a license
  As a Downloadable

 

Train the Trainer
CTT+, MCT, Presentation Skills...

 

QUICK LINKS
Shipping/Handling
Credit Application
Request a Title
Rent our Facilities
About Us

All rights reserved. Products and brand names mentioned are trademarks of their respective companies.

 

Visual Basic Data Access Programming
Version 6.0

Prerequisites  
Visual Basic Introduction or a comfortable working knowledge of all the topics in that course is required. Access Introduction or equivalent experience is strongly recommended. SQL Introduction is suggested.
Duration    2 day(s)

Understanding Data Access
  • Working with Relational Databases
  • Comparing Data Providers and Data Consumers
  • Connecting to Data Providers
  • Working with the Data View Window
Accessing Data with a Data Environment
  • Adding a Data Environment to a Project
  • Adding a Connection
  • Creating a Command
  • Binding Controls to a Data Environment Automatically
  • Programming with Data Environment Objects
Working with Recordsets
  • Binding Controls to a Data Environment Manually
  • Using an OLE DB DataCombo Control
  • Using an OLE DB DataGrid Control
  • Working with ActiveX Data Objects (ADO)
  • Understanding the ActiveX Data Object Model
  • Creating a Connection Object
  • Creating a Command Object
  • Creating a Recordset Object
Binding Controls to a Recordset Object
  • Specifying a Recordset Cursor Type
  • Executing SQL Statements
  • Modifying Data Using ADO
  • Locking Records for Updating
  • Editing Data Using Bound Controls
  • Editing Data without Binding Controls
  • Adding New Records
  • Handling Data Access Errors
Managing Transactions
  • Using the ADO Data Control (ADODC)
  • Adding the ADODC to a Project
  • Adding the ADODC to a Form
  • Setting a Data Source and Record Source
  • Binding Controls to the ADODC
Designing Data Reports
  • Adding a Data Report to a Project
  • Connecting to a Data Source
  • Adding Fields to a Data Report
  • Displaying the Report
Accessing Data on SQL Server
  • Connecting to an SQL Server Database
  • Running Stored Procedures
  • Comparing Client-Side and Server-Side Cursors
  • Using a Disconnected Recordset
Packaging and Deploying a Data Access Application
  • Using a Resource File
  • Compiling an Application
  • Packaging an Application
  • Distributing MDAC 2.0 and DCOM

WVBD60 ONLINE - 8/27/1999 0:00:00


HOME ABOUT ORDERING CONTACT US VIEW CART
www.technologycourseware.com © 2010, Online Consulting, Inc.