MOC-2380 Developing Collaborative Solutions Using Microsoft Office XP Developer

TEMARIO Y CONTENIDOS

Developing Collaborative Solutions Using Microsoft Office XP Developer
Moc 2380

Introduction

The goal of this course is to provide students with the knowledge and skills to use Microsoft Office XP Developer, Microsoft Office Web Components, smart tags, the Simple Open Access Protocol (SOAP) Toolkit 2.0 SP2, and SharePoint™ Team Services from Microsoft to build solutions that access structured data in Microsoft SQL Server™ 2000, and then to share code and package and deploy these Office solutions.

Audience

This course is intended for corporate developers, solution providers, IT Web developers, and IT database developers who are responsible for building knowledge management solutions that provide data analysis, reporting, presentation, and workflow.

At Course Completion

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

• Explain the concepts and advantages of a collaborative approach to business problems and describe the main development tools of Office XP.
• Use the Microsoft Code Librarian to reduce application development time.
• Use SOAP to access remote objects from Office XP applications.
• Describe the workflow process, describe the architecture of a workflow solution, and design a workflow process.
• Use the Microsoft development environment to create workflow solutions based on SQL Server.
• Create a digital dashboard by using the Microsoft SQL Server Digital Dashboard download.
• Use the Microsoft development environment to create a Web Part.
• Use SharePoint Team Services to present and organize data in a collaborative application.
• Add workflow to a SharePoint Team Services list.
• Build a custom Office XP smart tag.
• Use Office Web Components to interactively analyze data.

Microsoft Certified Professional Exams

There is no MCP exam associated with this course.

Prerequisites

Before attending this course, students must have:

• Knowledge of intranets and the Internet including browser operation and server-side scripting using Active Server Pages (ASP).
• Knowledge of database concepts and common online transaction processing (OLTP) use of SQL Server version 7.0.
• Knowledge of object models and their properties, methods, and events.
• Familiarity with the Microsoft Office 2000 suite of applications and their associated object models.
• Familiarity with high-level object-oriented programming languages, such as Microsoft Visual Basic® and Microsoft Visual Basic Scripting Edition (VBScript).

Student Materials

The student kit includes a comprehensive workbook and other necessary materials for this class.

Course Outline;

Module 1: Introduction to Collaborative Solution Development and Office XP Developer

The following topics are covered in this module:

• Introduction to Collaborative Solution Development
• Traditional Tools for Collaborative Solution Development
• New Tools for Collaborative Solution Development
• The Office XP Developer Tools
• Solving Business Problems by Using Collaborative Solutions

After completing this module, you will be able to explain the concepts and advantages of a collaborative approach to business problems and describe the main development tools of Office XP. This includes:

•  Explaining the concept of collaborative solutions, describing the skill set required to successfully develop collaborative solutions, and describing the advantages of using existing applications to develop collaborative solutions.
•  Describing the traditional products and technologies that you can use to create collaborative solutions.
• Describing the new products and technologies that you can use to create collaborative solutions.
• Describing the tools in Office XP Developer.
• Analyzing business problems and the collaborative solutions that you can use to solve those problems.

Module 2: Examing the Microsoft Development Environment and the Code Librarian

The following topics are covered in this module:

• Introduction to the Microsoft Development Environment
• Working with the Microsoft Development Environment
• Introduction to the Code Librarian

After completing this module, you will be able to use the Code Librarian to reduce application development time. This includes:

• Describing the main components of the Microsoft development environment.
• Using the Microsoft development environment to create an Office XP Developer solution.
• Describing the main features of the Code Librarian, and using the Code Librarian to manage code snippets in an Office XP Developer solution.

Module 3: Using XML Web Services in an Office XP Developer Solution

The following topics are covered in this module:

• Introduction to the Microsoft .NET Platform
• Using XML Web Services
• Using the SOAP Toolkit 2.0 SP2 in an Office XP Developer Solution

After completing this module, you will be able to use SOAP to access remote objects from Office XP applications. This includes:

• Describing the function of .NET and describing the components of the .NET platform.
• Describing the benefits of Extensible Markup Language (XML) Web services, describing how applications access XML Web services by using SOAP, explaining the purpose of Universal Description, Discovery, and Integration (UDDI) and how to use the UDDI Business Registry to locate an XML Web service, and explaining the function of SOAP.
• Describing the purpose, components, and features of the SOAP Toolkit 2.0 SP2, installing the toolkit, explaining how the SoapClient object and mssoapinit method are used to send SOAP requests to the server, and explaining how to use the toolkit to integrate XML Web services into an Office application.

Module 4: Introduction to a Business Process Workflow

The following topics are covered in this module:

• Introduction to a Business Process Workflow
• Designing a Business Process Workflow

After completing this module, you will be able to describe the workflow process, describe the architecture of a workflow solution, and design a workflow process. This includes:

• Describing a business process workflow, describing the two layers in the workflow architecture, and describing the elements that a workflow solution uses.
• Designing a business process workflow. This process includes documenting states that are involved in the workflow, documenting transitions between states, and documenting roles that are involved in the workflow.

Module 5: Creating Workflow Applications for SQL Server

The following topics are covered in this module:

• Setting up the Environment for Creating Workflow Applications
• Creating a SQL Server Database, a Table, and Table Relationships
• Creating a Workflow Application Using the Microsoft Development Environment
• Using Script in a Workflow Application
• Using the Workflow Manager for SQL Server
• Testing a Workflow Application Using SQL Server Enterprise Manager
• Migrating Applications Created Using Access Workflow Designer for SQL Server to Office XP Developer

After completing this module, you will be able to use the Microsoft development environment to create workflow solutions based on SQL Server. This includes:

• Setting up the server, developer, and client environments for creating workflow applications that are based on SQL Server.
• Using Microsoft Access 2002 to create the required tables in SQL Server and to define table relationships for building workflow applications.
• Creating a workflow application by using the Microsoft development environment.
• Adding scripts to an application to enhance workflow functionality.
• Using the Workflow Manager for SQL Server to manage installed workflow applications.
• Testing a workflow application by using SQL Server Enterprise Manager.
• Migrating a workflow application that is created by using the Access Workflow Designer for SQL Server to Microsoft Office XP Developer.

Module 6: Introduction to Digital Dashboards and Workflow User Interfaces

The following topics are covered in this module:

• Introduction to Digital Dashboards
• Digital Dashboard Architecture
• Introduction to SQL Server Digital Dashboard
• Implementing Digital Dashboard Security
• Other Workflow User Interface Clients

After completing this module, you will be able to create a digital dashboard using the Microsoft SQL Server Digital Dashboard download. This includes:

• Explaining the function and benefits of digital dashboards and Web Parts and describing the three platforms that can be used to develop and deploy digital dashboards.
• Describing the three tiers in the digital dashboard architecture.
• Describing Microsoft SQL Server Digital Dashboard, installing the dashboard, and explaining how to create and customize a personal SQL Server-based dashboard.
• Configuring digital dashboard authentication.
• Describing the options other than digital dashboards for providing a user interface to a workflow solution.

Module 7: Developing Web Parts

The following topics are covered in this module:

• Examining Web Part Schema Properties
• Determining the Types of Web Parts to Develop
• Tools for Creating Web Parts
• Best Practices for Publishing Web Parts
• Using the Digital Dashboard Services Component
• Using the Microsoft Development Environment to Create Digital Dashboards and Web Parts

After completing this module, you will be able to use the Microsoft development environment to create a Web Part. This includes:

• Describing the four categories of Web Part schema properties.
• Determining whether to create Web Parts with embedded, linked, or XML content.
• Describing the various tools that are used to create Web Parts.
• Designing effective Web Parts based on best practices.
• Describing the purpose of the Digital Dashboard Services Component (DDSC) and how to use the services that it provides.
• Using the Microsoft development environment to create digital dashboards and Web Parts.

Module 8: Presenting and Organizing Data Using SharePoint Team Services

The following topics are covered in this module:

• Introduction to SharePoint Team Services
• Creating Web Pages on a SharePoint Team Services Site
• Installing SharePoint Team Services
• Administering the SharePoint Team Web Site

After completing this module, you will be able to use SharePoint Team Services to present and organize data in a collaborative application. This includes:

• Describing the features and functionality of SharePoint Team Services and identifying the ways in which the use of SharePoint Team Services supports team collaboration.
• Creating your own pages on a Web site based on SharePoint Team Services.
• Describing the system requirements for installing SharePoint Team Services, and then installing SharePoint Team Services on the Web server.
• Adding new users, configuring permissions, and customizing a SharePoint team Web site.

Module 9: Adding Workflow to a SharePoint Team Services List

The following topics are covered in this module:

• The SharePoint Team Services Database
• Customizing Web Sites Based on SharePoint Team Services
• Adding Workflow to a SharePoint Team Services List

After completing this module, you will be able to add workflow to a SharePoint Team Services list. This includes:

• Describing the SharePoint Team Services database structure and schema, and identifying the tables in the SharePoint Team Services database.
• Identifying the tools and the programming techniques that you can use to customize a Web site that is based on SharePoint Team Services.
• Using the Microsoft development environment to add workflow to a SharePoint Team Services list.

Module 10: Creating Office XP Smart Tags

The following topics are covered in this module:

• Introducing Smart Tags
• SmartTag Architecture
• Using the Smart Tag List Tools
• Creating a Smart Tag Recognizer DLL
• Creating a Smart Tag Action DLL
• Deploying a Custom Smart Tag Solution

After completing this module, you will be able to build a custom Office XP smart tag. This includes:

• Defining smart tags and describing the benefits of using smart tags.
• Describing the components that make up the smart tag architecture.
• Using the Microsoft Office Smart Tag List tool to build smart tag XML list files and using the Smart Tag List Builder tool to build smart tag XML list files and list update files.
• Creating the smart tag recognizer dynamic-link library (DLL) to flag appropriate data in a host application.
• Creating the smart tag action DLL to provide actions on the data identified by the smart tag recognizer.
• Deploying smart tag DLLs by using the Microsoft Visual Studio® Installer, Internet Component Download system service, and a customized Office XP deployment.

Module 11: Interactively Analyzing Data Using Office Web Components

The following topics are covered in this module:

• Introducing Office Web Components
• Office Web Component Object Models
• Generating Interactive Web Pages from Office XP Applications
• Creating an Office Web Component in the Microsoft Development Environment
• Licensing and Installing Office Web Components
• Using Office Web Components with Earlier Versions of Browsers

After completing this module, you will be able to use Office Web Components to interactively analyze data. This includes:

• Describing the Office Web Components-Spreadsheet Component, PivotTable® Component, Chart Component, and the Microsoft Data Source control-and the purpose of each.
• Identifying the components of the Office Web Components object model and using them in scripts to manipulate the component.
• Generating interactive Web pages from Office applications.
• Creating a Web page that contains an Office Web Component by using the Microsoft development environment.
• Installing Office Web Components, and ensuring that the licensing requirements are met.

Describing the features of Office Web Components that are available when you work with earlier versions of browsers.