Microsoft® Access 2000 Designing and Implementing Database Applications Part 3- Creating Applications CBT Training CD

Rating:
Summary: Microsoft® Access 2000 Designing and Implementing Database
Review: Course Overview
This is the third 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 identify the basics of Access 2000 programming; identify the constructs that are used to control the flow of a program; write Sub and function procedures; and write event procedures for responding to user actions in an Access 2000 application.

Learn To

Identify the basics of Access 2000 programming.
Learn Visual Basic for Applications (VBA) fundamentals.
Identify the constructs that are used to control the flow of a program.
Write Sub and function procedures.
Identify the scope of variables and procedures in a program.
Write event procedures for responding to user actions in an Access 2000 application.
Set object properties and methods and call them to enable better navigation in the user interface.
Identify the reasons for using code-based validation.
Learn about the validation functions used to validate data entered by a user in an Access 2000 application.

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 two courses in this series.

Deployment Options
e-Learning

Accreditation
NASBA credits: 4 CPE Credits
ITCAP credits: 2.5 Credit Hours for Multiple Courses CEU credits: 0.70 CEUs

Language Options
US English

Total Learning Time
6 to 8 hours

Objectives
Unit 1: Application Programming: An Introduction 1 - 2 hours

Identify the features of an Access 2000 application.
Label the various components of the VBE with their functions.
Label the components of the Code window with their functions.
Identify the type of variable to be used in a specified scenario.
Identify the correct variable declaration in a specific program.
Identify the code to initialize a variable of a specified data type.
Write the statement to accept values into variables by using the InputBox function.
Write the statement to display values stored in variables by using the MsgBox function.

Unit 2: Writing a Program 1 - 2 hours

Identify the features of a procedure.
Create a Sub procedure in an Access 2000 application.
Complete the code to call a Sub procedure in an Access 2000 application.
Complete the code to pass arguments to a Sub procedure in an Access 2000 application.
Create a Function procedure in an Access 2000 application.
Complete the code to call a Function procedure in an Access 2000 application.
Identify the If Then construct that generates a specified result in a program.
Identify the If Then Else construct that generates a specified result in a program.
Identify the If Then ElseIf Else construct that generates a specified result in a program.
Identify the Select Case construct that generates a specified result in a program.
Identify the Do While Loop construct that generates a specified result in a program.
Identify the Do Loop While construct that generates a specified result in a program.
Identify the Do Until Loop construct that generates a specified result in a program.
Select the Do Loop Until construct that generates a specified result in a program.
Identify the output of a For Next construct used in a program.
Identify the variable scope that is used in a specified situation.
Identify the procedure scope that is used in a specified situation.

Unit 3: Customizing the User Interface 2 hours

Identify the features of event procedures.
Add an event procedure for a specified event to a form by using the Access 2000 menu bar.
Identify the event procedure code that generates a specified result.
Identify the statement to set a specified property of an object.
Identify the statement to call a specified method of an object.
Identify the statement that generates a specified result by calling a DoCmd object method.
Identify the piece of code used to set specific properties of a control.
Identify the statement to call a specified method for a control.
Add a specified ActiveX control to a form by using the Access 2000 menu bar.
Identify the code to implement an ActiveX control that generates a specified result.
Add a reference to a specified COM component by using the VBE menu bar.
Identify the code that is used to manipulate a specified COM component from an Access 2000 application.
Identify the error handler code that generates a specified result.
Identify the uses of specific properties of the Err object.
Identify the situations in which the methods of the Err object are used.

Unit 4: Validating Data 2 hours

Identify the situations in which code-level validation is used.
Identify the output of a piece of code that uses the IsNull function to check for a null value in a control.
Identify the function that is to be used to validate a string for specified criteria.
Identify the output of a program that uses the IsNumeric function to check whether an expression contains numbers.
Identify the statement that generates a specified result in a program that uses the IsDate function.