Building Knowledge Management Solutions with Microsoft Office 2000

Introduction

Return to top

At Course Completion

• Describe the concepts and advantages to a Knowledge Management approach to business problems.
• Create a solution to a business problem utilizing both BackOffice and desktop technologies.
• Develop and package solutions for Office 2000 (including COM Addins).
• Implement solutions using Microsoft Office 2000, Microsoft SQL Server and Microsoft Exchange Server.
• Be familiar with a number of the key object models used to link Office 2000 and other client side applications to BackOffice applications.

Microsoft Certified Professional Exams

Return to top

---

Prerequisites

• The Office 2000 suite of applications
• Visual Basic 5.0/6.0 or VBA
• Visual Basic Scripting Edition
• Object Models, their property, methods and events
• Database concepts and common OLTP use of SQL Server 7
• Concepts of Intranets and the Internet including browser operation and server side scripting using Active Server Pages
• It is recommended, but not essential that you have completed Course 1301, Mastering Microsoft Office 2000 Solution Development, or equivalent knowledge.

The course materials, lectures, and lab exercises are in English. To benefit fully from the instruction, students need an understanding of the English language and completion of the prerequisites.


Return to top

---

Course Materials and Software

The course materials are yours to keep.

Return to top

---

Course Outline

Day 1

Module 1: Introduction to Knowledge Management Solutions

Topics

Knowledge Management and the Knowledge Worker
Building Knowledge Management Solutions
Searching for Corporate Knowledge
Digital Dashboards

Labs

Searching and Delivering Knowledge


Skills

Students will be able to:

• Describe the main aspects of a KM solution.
• Understand the scenario on which the labs in this course are based.
• Be able to use Site Server as a search engine.
• Understand the concept of a Digital Dashboard.
• Be able to create a Digital Dashboard.
• Be able to configure the Outlook® 2000 messaging and collaboration client to display a Digital Dashboard.

Module 2: Empowering the Knowledge Worker with Microsoft Office 2000

Topics

Microsoft Office 2000
Creating COM Add-Ins


Labs

Creating COM Add-ins


Skills

Students will be able to:

• Describe the advantages of Office 2000 as a development platform.
• Describe how Office 2000 Integrates with Microsoft BackOffice.
• Create COM Add-Ins for Office applications.

Day 2

Module 3: Controlling Workflow

Topics

Introduction to Workflow
Workflow-Management Requirements
Issues with Existing Workflow Solutions
Microsoft® Access Workflow Designer

Labs

The Access Workflow Designer

Skills

Students will be able to:

• Explain why an application might need to use workflow management.
• Explain the key features of Access Workflow Designer, and how to integrate it with an existing business application.
• Build a workflow process using Access Workflow Designer.
• Be able to create a Data Access Page to examine workflow information.

Module 4: Developing Collaborative Features

Topics

Collaboration Scenarios and Technologies
Microsoft® Office Server Extensions
Outlook® 2000, Exchange Server, and Team Workspaces
Accessing Exchange Data Programmatically

Labs

Collaborative Features

Skills

Students will be able to:

• Identify the main collaboration scenarios and the Microsoft® technologies available for collaborative solutions.
• Describe the main features of collaborative development with Exchange Server and Outlook® 2000.
• Use the Team Folders Wizard to create a Team Workspace.
• Access Exchange data using Outlook Objects and CDO.

Day 3

Module 5: Integrating with Directory Services

Topics

Understanding Directory Services
Accessing Directory Data
ADSI Compared to Outlook® and CDO

Labs

Accessing Directory Data

Skills

Students will be able to:

• Understand the concept of a directory service.
• Use ADSI to access directory data.
• Use the ADSI OLE-DB Provider to access directory data.

Module 6: Analyzing Data

Topics

Knowledge Through Data Analysis
OLAP Concepts
Creating and Maintaining Cubes
Accessing OLAP Data with PivotTable® Views
Offline Data Analysis

Labs

OLAP Services

Skills

Students will be able to:

• Understand the choices available for data analysis.
• Understand the main concepts and terminology in OLAP solutions.
• Build an OLAP cube using OLAP Manager.
• Work with PivotTable® controls and create them programmatically.
• Add interactive data analysis features to Web pages.
• Understand the offline solutions available for Data Analysis.

Module 7: Extending your Knowledge Management Solution with XML

Topics

Introduction to XML
Reading XML Data

Labs

Using XML

Skills

Students will be able to:

• Understand the advantages of using XML to communicate data.
• Use the Document Object Model to retrieve data from an XML document.

Return to top