Preparation Guide for Exam 74-137

Developing Microsoft Office Solutions Using XML with Office Professional Edition 2003

On This Page

	Exam News
	Audience Profile
	Preparation Tools and Resources
	Skills Being Measured

Exam News

Exam 74-137 is a Technology Specialist exam.

Exam 74-137 became available September 30, 2005.

Top of page

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.

Top of page

Preparation Tools and Resources

We make a wealth of preparation tools and resources available to you, including courses, books, practice tests, and Microsoft Web sites. When you are ready to prepare for this exam, here's where you should start.

Instructor-led Courses for This Exam

Microsoft Online Resources

Top of page

Skills Being Measured

This exam measures your ability to develop Microsoft Office Solutions using XML with Office Professional Enterprise Edition 2003. Before taking the exam, you should be proficient in the job skills listed in the following matrix. The matrix shows which Official Microsoft Learning Products may help you reach competency in the skills being tested in the exam.

KEY:

= The course provides a general introductory overview of this task. You will need to supplement the course with additional work     = The course includes some material to prepare you for this task. You will need to supplement the course with additional work     = The course includes material to prepare you for this task

Skills measured by exam 74-137	Collection 2015	Collection 2016	InfoPath Training	Research Service Development Extras
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

Note: This preparation guide is subject to change at any time without prior notice and at Microsoft's sole discretion. Microsoft exams might include adaptive testing technology and simulation items. Microsoft does not identify the format in which exams are presented. Please use the exam objectives listed in this preparation guide to prepare for the exam, regardless of its format. Learn more, and download samples, on the Testing Innovations page.

Top of page