Back to Search Results

Training Course Summary:

This course will teach developers how to build solutions that access data and automate business processes by using Microsoft Office 2000.

Pre-Requisites:

Use basic features of the Microsoft Word and Excel applications.
Record simple macros by using Macro Recorder and invoke them.
Demonstrate familiarity with the Visual Basic development system and event-driven programming concepts including:
Writing a Function procedure and a Sub procedure.
Handling an event procedure.
Retrieving and validating information from a user.
Building a user interface by using forms and controls.
Describing the relationship among objects, properties, and methods.
Adding run-time error handling to an application.
Running an application and using debug mode within the Visual Basic environment.
Define basic database concepts such as tables and queries, and use SQL syntax to create database queries
Define basic concepts of the Internet, intranets, and Web browsing.
Completing either of the following courses satisfies the Visual Basic-related prerequisite skills listed above:

Course 1300, Mastering Microsoft Access 2000 Programming
Course 1303, Mastering Microsoft Visual Basic 6.0 Fundamentals

Training Course Overview/Content:

At the end of the course, students will be able to:

Describe design considerations and deployment scenarios when building a custom solution by using Microsoft Office 2000.
Determine whether Microsoft Visual Basic® for Applications code should be part of a specific document, a document template, or a component object model (COM) add-in.
Use Visual Basic Editor to write and run Visual Basic for Applications code and manage files.
Customize the user interface of Office 2000 applications by using command bars and forms.
Connect to data sources and retrieve data by using ActiveX® Data Objects (ADO).
Use the Office 2000 applications to access data in a relational or nonrelational database, and manipulate and present the data.
List and describe some of the more commonly used objects in the Office 2000 object models.
Use the Microsoft Excel object model to programmatically navigate, format, present, and analyze data.
Use the features in Office 2000 Developer to build a COM add-in, use digital signatures to enhance security, and deploy your applications.
Use the Microsoft FrontPage® 2000 Web site creation and management tool to create a Web site and display documents created in other Office 2000 applications.

Qualifications:

This course will help the student prepare for the following Microsoft Certified Professional exam:

Exam 70-091: Designing and Implementing Solutions with Microsoft Office 2000 and Microsoft Visual Basic for Applications