Microsoft Access 2000 Designing and Implementing Database Applications Part 4 - Debugging Applicatio

This is the fourth course in a five-part series that will provide IT professionals with the knowledge and skills necessary to design and implement database solutions using Microsoft Access 2000. At the completion of this course students will learn to manage data in tables by using ActiveX Data Objects (ADO) recordsets and SQL; identify code to create and manage stored procedures and triggers; and identify errors and code to create error handlers.

This is primarily online training This is an online eLearning or CBT training program Contact Serebra Learning Corporation for more information

Duration: 8 hours Training Presented in: English

Audience

This series is designed for database programmers and developers who want to design and implement database solutions using Microsoft Access 2000. Participants should have completed Microsoft Access 2000 End User Series (Course Series 72050 - 72052) and the first three courses in this series.

Objective

• Manage data in tables by using ActiveX Data Objects (ADO) recordsets and SQL.
• Identify code to create and manage stored procedures and triggers.
• Identify errors and code to create error handlers.

Topics Include

Unit 1: Working with Records

• Match ActiveX Data Objects (ADO) objects with their functions.
• Match ADO collections with their associated ADO objects.
• Identify the code to create an ADO recordset.
• Identify the code to open an ADO recordset for a table for a specified condition.
• Identify the code to move through an ADO recordset in a specified situation.
• Identify the code to add a record to a table by using an ADO recordset.
• Identify the code to delete a record from a table by using an ADO recordset.
• Identify the code to modify a record in a table by using an ADO recordset.
• Identify the code to add a record to a table by using SQL.
• Identify the code to delete a record from a table by using SQL.
• Identify the code to modify a record in a table by using SQL.
• Identify the code to retrieve records from a table by using SQL.
• Identify the code to combine records from multiple tables by using SQL joins.
• Identify the code to create a view that retrieves records from multiple tables.

Unit 2: Managing Stored Procedures and Triggers

• Identify the advantages of a stored procedure.
• Identify the code to create a stored procedure for enforcing a business rule.
• Identify the code to create a stored procedure for using input and output parameters.
• Identify the code to create a stored procedure for modifying the records in multiple tables.
• Call a stored procedure from an Access application.
• Identify the advantages of a trigger.
• Identify the code to create a trigger for implementing a specified business rule.
• Identify the code to create a trigger for enforcing data integrity.

Unit 3: Handling Run-Time Errors

• Match a specified code sample with the error type it contains.
• Match the properties of the an Error object with the information that they return.
• Identify the code to create an error handler for trapping type mismatch errors by using ADO Errors collection.
• Identify the code to create an error handler for trapping referential integrity errors by using ADO Errors collection.
• Identify the code to create an error handler for trapping locking errors by using ADO Errors collection.
• Identify the code to return control from an error handler to a specified location in a procedure.
• Insert an error-handling template in a procedure.

Unit 4: Debugging Using VBA Tools

• Create a breakpoint by using the menu bar.
• Match the navigation techniques in the break mode with their functions.
• Run specified code in the Immediate window.
• Modify the value of a variable in the Locals window.
• Add a watch expression to the Watch window.

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

• Microsoft Access 2000 Designing and Implementing Database Applications Part 1 - Database Design
• Microsoft Access 2000 Designing and Implementing Database Applications Part 2 - Handling Data
• Microsoft Access 2000 Designing and Implementing Database Applications Part 3 - Creating Application
• Microsoft Access 2000 Designing and Implementing Database Applications Part 5 - Completing Applicati