Microsoft Learning:

Exam 74-137:

Developing Microsoft Office Solutions Using XML with Office Professional Edition 2003

Published:September 30, 2005
Language(s):English
Audience(s):Developers
Technology:Microsoft Visual Studio 2005
Type:Proctored Exam
Audience Profile
A candidate for this exam should have a minimum of three years of experience developing n-tier applications. Candidates develop applications that integrate with Microsoft Office Professional Enterprise Edition 2003, leveraging the XML capabilities in Microsoft Word 2003, Excel 2003, and InfoPath 2003. Candidates have a good understanding of XML, including XML schema, XPath and XSLT.
Note This preparation guide is subject to change at any time without prior notice and at the sole discretion of Microsoft. Microsoft exams might include adaptive testing technology and simulation items. Microsoft does not identify the format in which exams are presented. Please use this preparation guide to prepare for the exam, regardless of its format.
Skills Being MeasuredThis exam measures your ability to accomplish the technical tasks listed below.The percentages indicate the relative weight of each major topic area on the exam.
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.
  • Choose the appropriate technology. Considerations include XML, smart documents, and Research Pane.
Create a Microsoft Office Word 2003 solution
  • Create and map a schema for a Microsoft Word 2003 document
    • Create a schema
    • Map the schema to documents
  • Identify a strategy for extracting external data for import into a Microsoft Word 2003 document
  • 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
  • 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
  • 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
  • Create a smart document DLL by using COM and/or managed code and the ISmartDocument API
  • Implement smart document security
  • Deploy smart document solutions by using the XML expansion pack
Build a Research service
  • Respond to registration requests
  • Respond to queries
  • Add actions to query results
  • Authenticate Research service users
  • Install Research services
  • Implement a discovery service
  • Build a Research service by using the Research service development extras
Preparation Tools and ResourcesTo help you prepare for this exam, Microsoft Learning recommends that you have hands-on experience with the product and that you use the following training resources. These training resources do not necessarily cover all of the topics listed in the "Skills Measured" tab.
Classroom Training
Microsoft E-Learning There is no Microsoft E-Learning training currently available.
Microsoft Press Books There are no Microsoft Press books currently available.
Practice Tests There are no practice tests currently available.
Microsoft Online Resources
  • Partner Site: Designed for our partners, this site includes training, sales and marketing advice, events, and competency resources.
  • InfoPath Technical Articles: The latest InfoPath developer information.
  • InfoPath Tools and Code Samples: Get the latest tools, code samples, and more for InfoPath developers.
  • InfoPath Training: Training resources for InfoPath developers.
  • Microsoft Office Hands on Labs: In these labs, you will use Word, Excel, and InfoPath 2003 with industry standard XML, .NET Framework technologies, and the Visual Studio Tools for Office System 2003 (VSTO).
  • Research Service Development Extras: Provides a number of tools, white papers, and code samples to enhance your experience building research services for Microsoft Office 2003.
  • WordprocessingML Transform Inference Tool: The XSLT Inference tool helps you easily create XSL Transformations (XSLT) that quickly transform XML files into WordprocessingML with complex and rich formatting.
  • TechNet: Designed for IT professionals, this site includes How-tos, best practices, downloads, technical chats, and much more.
  • MSDN: The Microsoft Developer Network (MSDN) is a reference for developers, featuring code samples, technical articles, newsgroups, chats, and more.
  • Training & Certification Newsgroups: A newsgroup exists for every Microsoft certification. By participating in the ongoing dialogue, you take advantage of a unique opportunity to exchange ideas with and ask questions of others, including more than 750 Microsoft Most Valuable Professionals (MVPs) worldwide.
Have Questions? For advice about training and certification, connect with peers: For questions about a specific certification, chat with a Microsoft Certified Professional (MCP): To find out about recommended blogs, Web sites, and upcoming Live Meetings on popular topics, visit our community site:
Exam index

How To Get It

Schedule your exam through the following exam provider:

Related Services