74-137 : Developing Microsoft Office Solutions using XML with Office Professional Edition 2003

Preparation Guide for Exam 74-137

Developing Microsoft Office Solutions using XML with Office Professional Edition 2003

---

• Design a customized Office products client solution
  
  
  
  • Identify the business requirements
    
  • Choose the appropriate Office program(s). Considerations include Microsoft Office Excel, InfoPath, and Microsoft Office Word.
    
    Microsoft reboots Office
    
    Solution Architectures with Microsoft Office Professional
    
    Microsoft Ships Beta 2 Version of Microsoft Office System
    
    
  • Choose the appropriate technology. Considerations include XML, smart documents, and Research Pane.
    
    Choosing between InfoPath and Smart Document Solutions
    
    
  
  
  
• Create a Microsoft Office Word 2003 solution
  
  Understanding Office Development
  
  
  
  • Create and map a schema for a Microsoft Word 2003 document
    
    Create a rich Word document based on your own custom XML
    
    Word 2003: XML Toolbox for Microsoft Office Word 2003
    
    
    
    
    • Create a schema
      
    • Map the schema to documents
      
      Download details: Word 2003: XML Mapping Video
      
      
    
    
    
    
  • Identify a strategy for extracting external data for import into a Microsoft Word 2003 document
    
    Integrating Word, Excel, and InfoPath with SQL Server 2000
    
  • Insert an external data flow into a Microsoft Word 2003 document
    
    
    
    • Create a document that displays data from other data sources
      
    • Add formatting by using WordprocessingML transforms
      
    • Insert external data into the document by using the object model
      
    
    
    
  • Create WordprocessingML transforms
    
    Overview of WordprocessingML
    
    The WordprocessingML Vocabulary
    
    Microsoft Word 2003: WordProcessingML Transform Inference Tool
    
  • Create a user interface that supports the XML structure
    
  
  
• Create an Excel 2003 solution
  
  
  
  • Create XML maps to external data sources
    
  • Import and export XML data programmatically
    
  • Create a user interface that supports the XML structure
    
  • Customize list features
    
  
  
• Create an InfoPath 2003 Service Pack 1 solution
  
  InfoPath 2003 Training
  
  
  
  • Create a basic form
    
    
    
    • Create a data source for the basic form
      
    • Add controls to the basic form
      
    • Use data validation in the form
      
    • Create multiple views for a form
      
    
    
    
  • Create a form with advanced features
    
    
    
    • Add custom business logic and rules
      
    • Create custom submit capabilities
      
    • Create secondary data sources
      
    • Create a merge form
      
    • Use custom code for advanced form features. Features include: the editing environment; data validation; event handling; controls; error handling; security; data submission; business logic; and form integration
      
    • Use managed code or script
      
    • Add digital signature capabilities to a form
      
    • Create a custom task pane
      
    
    
  • Deploy and update InfoPath solutions
    
  
  
• Create a Word or Excel smart document solution by using the ISmartDocument interface
  
  Office 2003 Smart Document Software Development Kit (SDK)
  
  
  
  
  
  • Create a smart document DLL by using COM and/or managed code and the ISmartDocument API
    
    Create a smart document
    
    Smart Documents Development Overview
    
    Designing Smart Documents in Office 2003
    
    Smart documents
    
    
  • Implement smart document security
    
    Introduction to Security
    
    General Office Security
    
    Security for Smart Document DLLs, Add-ins, and Macros
    
    Security for Smart Documents That Use the .NET Framework
    
    
  • Deploy smart document solutions by using the XML expansion pack
    
    Introduction to Deploying Smart Documents
    
    
  
  
• Build a Research service
  
  Office 2003 Research Service Software Development Kit
  
  
  
  
  • Respond to registration requests
    
    Handling Registration Requests
    
    
  • Respond to queries
    
    Handling Queries
    
    
  • Add actions to query results
    
    Adding Actions to Query Results
    
    
  • Authenticate Research service users
    
    Authenticating Research Service Users
    
    
  • Install Research services
    
    Registering Research Services
    
    Frequently Asked Questions
    
  • Implement a discovery service
    
    Configuring Service Discovery
    
  • Build a Research service by using the Research service development extras
    
    Getting Started with the Research Service Development Extras Toolkit for Office 2003 Editions
    
    Research Service Development Extras
    
    Research Service Development Extras: Workspace Home
    
    Office 2003 Toolkit: Research Service Development Extras
    
    
  
  

Visão geral das tecnologias do desenvolvedor do Office 2003

Microsoft Office System and XML: XML in Action