Exclusive
Office

Developing Collaborative Solutions using Microsoft OfficeXP Developer
(Microsoft Training Course: 2380) - 4 days - £2100 exc VAT



> Target Audience
THIS COURSE HAS NOW RETIRED. PLEASE SEE THE SUPPLEMENTARY INFORMATION FOR DETAILS OF ALTERNATIVE COURSES.
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
> Course outline
  1. Introduction to Collaborative Solution Development and Office XP Developer
  2. Examining the Microsoft Development Environment and the Code Librarian
  3. Using XML Web Services in an Office XP Developer Solution
  4. Introduction to a Business Process Workflow
  5. Creating Workflow Applications for SQL Server
  6. Introduction to Digital Dashboards and Workflow User Interfaces
  7. Developing Web Parts
  8. Presenting and Organizing Data Using SharePoint Team Services
  9. Adding Workflow to a SharePoint Team Services List
  10. Creating Office XP Smart Tags
  11. Interactively Analyzing Data Using Office Web Components

Supplementary InformationThis course has now retired and is no longer available. It is possible for us to run a closed Office 2007 course for more than two people. Please call for details.
Module 1: Introduction to Collaborative Solution Development and Office XP Developer
  • 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
Skills
  • Explain the concept of collaborative solutions, describe the skill set required to successfully develop collaborative solutions, and describe the advantages of using existing applications to develop collaborative solutions.
  • Describe the traditional and new products and technologies that you can use to create collaborative solutions.
  • Describe the tools in Office XP Developer.
  • Analyze business problems and the collaborative solutions that you can use to solve those problems.
top
Module 2: Examining the Microsoft Development Environment and the Code Librarian
  • Introduction to the Microsoft Development Environment
  • Working with the Microsoft Development Environment
  • Introduction to the Code Librarian
Skills
  • Describe the main components of the Microsoft development environment.
  • Use the Microsoft development environment to create an Office XP Developer solution.
  • Describe the main features of the Code Librarian, and using the Code Librarian to manage code snippets in an Office XP Developer solution.
top
Module 3: Using XML Web Services in an Office XP Developer Solution
  • Introduction to the Microsoft .NET Platform
  • Using XML Web Services
  • Using the SOAP Toolkit 2.0 SP2 in an Office XP Developer Solution
Skills
  • Describe the function of .NET and the components of the .NET platform.
  • Describe the benefits of Extensible Markup Language (XML) Web services, describe how applications access XML Web services by using SOAP, explain the purpose of Universal Description, Discovery, and Integration (UDDI) and how to use the UDDI Business Registry to locate an XML Web service, and explain the function of SOAP.
  • Describe the purpose, components, and features of the SOAP Toolkit 2.0 SP2, install the toolkit, explain how the SoapClient object and mssoapinit method are used to send SOAP requests to the server, and explain how to use the toolkit to integrate XML Web services into an Office application.
top
Module 4: Introduction to a Business Process Workflow
  • Introduction to a Business Process Workflow
  • Designing a Business Process Workflow
Skills
  • Describe a business process workflow, describe the two layers in the workflow architecture, and describe the elements that a workflow solution uses.
  • Design a business process workflow.
top
Module 5: Creating Workflow Applications for SQL Server
  • 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
Skills
  • Set up the server, developer, and client environments for creating workflow applications that are based on SQL Server.
  • Use Microsoft Access 2002 to create the required tables in SQL Server
  • Create a workflow application by using the Microsoft development environment.
  • Add scripts to an application to enhance workflow functionality.
  • Use the Workflow Manager for SQL Server to manage installed workflow applications.
  • Test a workflow application by using SQL Server Enterprise Manager.
  • Migrate a workflow application to Microsoft Office XP Developer.
top
Module 6: Introduction to Digital Dashboards and Workflow User Interfaces
  • Introduction to Digital Dashboards
  • Digital Dashboard Architecture
  • Introduction to SQL Server Digital Dashboard
  • Implementing Digital Dashboard Security
  • Other Workflow User Interface Clients
Skills
  • Explain the function and benefits of digital dashboards and Web Parts and describe the three platforms that can be used to develop and deploy digital dashboards.
  • Describe the three tiers in the digital dashboard architecture.
  • Describe SQL Server Digital Dashboard, install the dashboard, and explain how to create and customize a personal SQL Server-based dashboard.
  • Configure digital dashboard authentication.
  • Describe the options other than digital dashboards for providing a user interface to a workflow solution.
top
Module 7: Developing Web Parts
  • 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
Skills
  • Describe the four categories of Web Part schema properties.
  • Determine whether to create Web Parts with embedded, linked, or XML content.
  • Describe the various tools that are used to create Web Parts.
  • Design effective Web Parts based on best practices.
  • Describe the purpose of the Digital Dashboard Services Component (DDSC) and how to use the services that it provides.
  • Use the Microsoft development environment to create digital dashboards and Web Parts.
top
Module 8: Presenting and Organizing Data Using SharePoint Team Services
  • Introduction to SharePoint Team Services
  • Creating Web Pages on a SharePoint Team Services Site
  • Installing SharePoint Team Services
  • Administering the SharePoint Team Web Site
Skills
  • Describe the features and functionality of SharePoint Team Services and identify the ways in which the use of SharePoint Team Services supports team collaboration.
  • Describe the architecture of SharePoint Team Services, which is based on Microsoft FrontPage Server Extensions.
  • Create your own pages on a Web site based on SharePoint Team Services.
  • Describe the system requirements for installing SharePoint Team Services, and then install SharePoint Team Services on the Web server.
  • Add new users, configure permissions, and customize a SharePoint team Web site.
top
Module 9: Adding Workflow to a SharePoint Team Services List
  • The SharePoint Team Services Database
  • Customizing Web Sites Based on SharePoint Team Services
  • Adding Workflow to a SharePoint Team Services List
Skills
  • Describe the SharePoint Team Services database structure and schema, and identify the tables in the SharePoint Team Services database.
  • Customize a Team Web Site by using FrontPage 2002.
  • Identify the tools and the programming techniques that you can use to customize a Web site that is based on SharePoint Team Services.
  • Use the Microsoft development environment to add workflow to a SharePoint Team Services list.
top
Module 10: Creating Office XP Smart Tags
  • 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
Skills
  • Define smart tags and describe the benefits of using smart tags.
  • Describe the components that make up the smart tag architecture.
  • Use the Office Smart Tag List tool to build smart tag XML list files and use the Smart Tag List Builder tool to build smart tag XML list files and list update files.
  • Create the smart tag recognizer dynamic-link library (DLL) to flag appropriate data in a host application.
  • Create the smart tag action DLL to provide actions on the data identified by the smart tag recognizer.
  • Deploy smart tag DLLs by using the Microsoft Visual Studio Installer, Internet Component Download system service, and a customized Office XP deployment.
top
Module 11: Interactively Analyzing Data Using Office Web Components
  • 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
Skills
  • Describe the Office Web Components-Spreadsheet Component, PivotTable Component, Chart Component, and the Microsoft Data Source control-and the purpose of each.
  • Identify the components of the Office Web Components object model.
  • Generate interactive Web pages from Office applications.
  • Create a Web page that contains an Office Web Component.
  • Install Office Web Components.
  • Describe the features of Office Web Components.
top
> Pre-Requisites
Before attending this course, students must have the following pre-requisites:
  • Knowledge of intranets and the Internet including Active Server Pages
  • Knowledge of database concepts and common online transaction processing (OLTP) use of SQL Server version 7.0.
  • Knowledge of object models.
  • Familiarity with the Microsoft Office 2000 suite of applications.
  • Familiarity with high-level object-oriented programming languages
> Purpose
After completing this 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; use SOAP to access remote objects; 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 using the Microsoft SQL Server Digital Dashboard download; use the Microsoft development environment to create a Web Part; use SharePoint Team Services; add workflow to a SharePoint Team Services list; build a custom Office XP smart tag; use Office Web Components to interactively analyze data
> Supplementary Information
This course has now retired and is no longer available. It is possible for us to run a closed Office 2007 course for more than two people. Please call for details.