|
Provided by: Serebra Learning Corporation Microsoft Visual Basic 5.0: Working with Databases - Part 2Microsoft Visual Basic (VB) |
 |
This is the fourth course in a seven part series for application developers who intend to design build and implement business solutions by using Microsoft Visual Basic 5.0. The series aims to enable the professionals to pass Microsoft exam 70-165 Developing Applications with Microsoft Visual Basic 5.0.
|
|
||||||||||
Audience
The course is intended for application developers who will use Visual Basic 5.0 to create sophisticated business applications. This series assumes that the learner has experience with Microsoft Windows operating system 3.1 or later and a knowledge of word processing and spreadsheet applications. Participants should also have the knowledge of Basic or another procedural language including experience using variables control structures like if-then-else statements and also looping structures like for and while loops. Participants should have taken Microsoft Visual Basic 5.0: Programming Fundamentals (Courses 71591 and 71592) and have taken the first course in this series.
Objective
- Use data access objects and manipulate the Recordsets.
- Manipulate databases using data access objects.
- Use the techniques of the advanced database applications.
Topics Include
Unit 1: Using Data Access Objects
- Identify the features of the data access object collection.
- Identify the features of the DBEngine objects.
- Identify the features of Workspace object.
- Enter the code to open a database.
- Select the features of the Recordset objects.
- Enter the code to create a Recordset.
- Enter the code to access data in a Recordset.
Unit 2: Data Manipulation Using Data Access Objects
- Enter the code to move through a Recordset using the MoveNext and MoveLast methods.
- Enter the code to find records.
- Enter the code to locate a record in a table-type Recordset.
- Enter the code to update records.
- Enter the code to add records in a database.
- Enter the code to delete records.
- Complete the code to use DAO with the data control applying the Fields value.
- Enter the code to loop through a Recordset.
- Complete the code to loop through a Recordset.
- Identify the features of predefined queries.
- Enter the code to execute the Select query.
- Enter the code to execute an action query.
- Enter the code to manage records using SQL statements.
Unit 3: Advanced Database Development
- Enter the code to display rules.
- Complete the code to determine the rule-violation.
- Enter the code to trap rule-violation errors.
- Identify the definition of referential integrity.
- Enter the code to trap the referential integrity violations.
- Enter the code to update records in a workspace using transactions.
- Identify the possible problems encountered when multiple users access data.
- Enter the code to open a table for exclusive use applying the OpenRecordset method.
- Identify the features of the locking mechanism provided by Visual Basic.
- Enter the code to trap edit errors on locked records using the error numbers.
- Enter the code to trap update errors.
- Complete the code to delete the entry of the records that have been deleted from the database.
- Identify the types of external databases.
- Identify the features of the data access methods.
- Identify the features of data access systems.
- Enter the code to access ISAM databases using the TableDef objects.
- Enter the code to access ODBC database using the Connect property of a data control.
- Enter the code to execute SQL passthrough on a database.
- Enter the code to connect to a datasource.
Duration
8
Minimum Requirements
The CDROM version of this course requires:
- At least a 486DX 33Mhz CPU.
- Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
- At least 8MB RAM.
- At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).
- At least a double speed CDROM drive.
- An MPC compliant sound card with attached speakers or headphones is recommended (Currently only the CDROM version supports audio).
- At least a 486DX 33Mhz CPU.
- Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
- At least 8MB RAM and 22MB available hard disk space or file server space.
- At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).
Media
Serebra Learning Corporation 119 - 7565 132nd Street Surrey BC V3W 1K5 Canada
