|
|||
|
Designing and Implementing Desktop Applications using Microsoft Visual Basic 6.0 (70-176) |
| Designing and Implementing Distributed Applications using Microsoft Visual Basic 6.0 (70-175) |
| Solutions Architecture - Analyzing Requirements and Defining Solution Architectures (70-100) |
|
|
Visual Basic 6 Database Access Part I
This course provides an introduction to Visual Basic's capabilities relating to database access and manipulation in an online environment. It explains how databases are organized, how information is retrieved and manipulated in databases, and what technologies are available to ensure cross-platform and uniform access to database information. This course describes the fundamentals of viewing and modifying information in databases using the industry standard Structured Query Language (SQL). It explains how SQL is used with client tools built in Visual Basic, to create powerful queries and statements for a server-side database. The course describes how you can use data controls to access database information. It explains how you can use the Data Environment Designer to create connections, commands, and data-bound forms. Also described are the Data Form Wizard and the ADO Data Control.
Database Access Part I training covers such topics as:
Introduction to Databases
Introduction to SQL
Using Data Controls in Visual Basic
This course is designed for intermediate to advanced Visual Basic application
programmers. Completion of this course and other course titles from this curriculum
prepares the learner for the Microsoft Exam #70-175: Designing and Implementing
Distributed Applications with Visual Basic 6.0
Visual Basic 6 Database Access Part II
This course provides a detailed look at the ActiveX Data Object (ADO) that acts as the bridge between your application and a database.
Database Access Part II training covers such topics as:
Programming with Active X Data Objects
Updating and Editing Data Records with ADO
Advanced Data Access with ADO
Learn exactly what you need to know about creating and destroying connections
to data sources, create commands that build queries or access queries, tables,
or stored procedures in a database. You will learn how to create recordsets
and use the ADO Error collection, and how to sort and filter records. Learn
to search records, insert, delete, and update record data, and how to connect
to a secured database system.
This course is designed for intermediate to advanced Visual Basic
application programmers Database administrators, Database analysts,
and Database developers who are working toward the Microsoft
Certified Database Administrator (MCDBA) credential.