Kurs 71594 - Microsoft Visual Basic 5.0: Working with Databases - Part 2
Ziele- Use data access objects and manipulate the Recordsets. - Manipulate databases using data access objects. - Use the techniques of the advanced database applications.
AnforderungenThe 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.
TitelKurs 71594 - Microsoft Visual Basic 5.0: Working with Databases - Part 2
InhaltCourse Description
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.
Deployment Options
Self-Study
Objectives
Unit 1: Using Data Access Objects 2 - 3 hours
- 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 2 - 3 hours
- 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 2 hours
- 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.
Course Access
Each student has access to the course for a period of 6 months from the day of enrollment in the course.
Ähnliche angebote die in bezug zu ihrer anfrage "visual basic (visualbasic)" stehen