Designing and Implementing Desktop Applications with Microsoft® Visual Basic® 6.0- Part 3 CBT Training CD

Rating:
Summary: Designing and Implementing Desktop Applications...
Review: Course Overview
This is the third course in a five part series that will provide students with the knowledge to write a Microsoft Visual Basic-based application that accesses data from a database. In this course, students will learn to use ActiveX Data Objects to access and manipulate data sources. This course also addresses advanced database issues, such as data integrity and referential integrity.

Learn To

Use ActiveX Data Objects to access and manipulate data sources.
Understand SQL Server security implementations.
Implement an appropriate cursor for a recordset object.

Audience
This course is designed for programmers who need to create basic applications with Microsoft Visual Basic 6.0. Participants should have completed the first two courses in this series.

Deployment Options
e-Learning

Accreditation
NASBA credits: 4 CPE Credits
CEU credits: 0.70 CEUs

Language Options
Chinese, Japanese, US English

Total Learning Time
6 to 8 hours

Objectives
Unit 1: Using ActiveX Data Objects (ADO) 3 - 4 hours

Identify the characteristics of ADO.
Identify the components of the ADO object model.
Identify methods of handling data access errors.
Connect to a database using ADO.
Connect to a data source.
Identify connection object events.
Identify database connections.
Identify the uses of the Command object.
Identify the uses of the Recordset object.
Identify ways of presenting data to the user.
Identify the properties and methods that allow navigation through a recordset.
Identify code to sort records.
Identify code to filter and search records.
Update data using the Execute method.
Update data using a recordset.
Create a disconnected Recordset object.
Identify the methods used in data persistence.
Identify how much connection information is required to reconnect to a data source.
Identify issues related to the performance of batch updates.
Create a dynamic recordset.

Unit 2: Advanced Data Access Issues 3 - 4 hours

Identify the guidelines for incorporating user ID and user password values in SQL Server security.
Select a cursor type for a Recordset object.
Select a cursor location for a Recordset object.
Create a cursor.
Select a LockType property for a Recordset object.
Identify the features of implicit and explicit transactions.
Identify SQL Server data integrity features.
Identify guidelines for handling referential integrity errors.
Identify the guidelines for executing statements directly.
Identify the features of stored procedures.
Call a stored procedure.