Exam Code: 70-543
Course Name: TS: Visual Studio 2005 Tools for the Microsoft Office System
Vendor: Microsoft
Passing Score: 700
Course Outline: TS: Visual Studio 2005 Tools for the Microsoft Office System For 70-543 Exam
Deploying and securing Visual Studio 2005 Tools for the Microsoft Office System (VSTO) solutions For 70-543 Exam (19 percent)
Configure a client to run VSTO solutions.
• Primary Interop Assembly
• VSTO runtime
Deploy a document-level customization to a client.
• Deploy the customization to a client running Office 2003.
• Deploy the customization document to a client running Office 2007.
Configure and deploy Code Access Security (CAS) Policy.
• Setup
• Group Policy
Deploy a VSTO document-level customization to a server.
• Publish a VSTO solution from Visual Studio.
• Configure the manifest for access to server-based templates.
• Configure the client environment for offline execution.
Deploy an add-in project.
• Administrative installations
• Customize the default setup project.
Deploy a VSTO solution by using the Bootstrapper.
Working with data in a VSTO solution For 70-543 Exam (21 percent)
Configure data sources in a VSTO solution.
Bind data to controls in Microsoft Office Excel.
• List object
• Named range
Bind data to controls in Microsoft Office Word.
• Bookmarks
• XML node
Manage data by using the document cache.
Access a data island in an Office document.
• Write to a data island from another solution.
• Read from a data island from another solution.
Manipulate data in an application from within another application.
Integrating XML in Office applications For 70-543 Test (16 percent)
Manipulate custom XML document parts outside the application.
• Delete a custom XML part.
• Insert a custom XML part.
Manipulate custom XML document parts within an application.
• Delete a custom XML part.
• Insert a custom XML part.
• Use event handlers with a custom XML part.
Connect to business data by using content controls.
• Delete a content control.
• Insert a content control.
• Link a content control to a node in a custom XML part.
• Use event handlers with a content control.
• Use locking on content controls.
• Manage schema validation for a document that contains XML-linked content controls.
Manipulate custom XML data in Word 2003 by using XML nodes.
• Mark up a document with XML nodes.
• Manage schema validation.
• Save and open a document that has XML data.
Manipulate custom XML data in Excel.
• Map cells to a schema.
• Import XML documents.
• Refresh XML data.
Developing application-level solutions For 70-543 Exam (24 percent)
Customize the ribbon.
• Design the ribbon interface.
• Configure the ribbon to respond to user actions.
• Customize the ribbon UI for different Microsoft Office Outlook inspector types.
Manage task pane behavior.
• Single document interface (SDI)
• Multiple document interface (MDI)
• Manage state of task pane data.
Troubleshoot errors in a VSTO add-in.
• Troubleshoot loading errors.
• Troubleshoot runtime errors.
• Handle exceptions in a VSTO add-in.
Create an Outlook add-in that manipulates Outlook items.
• Access folders.
• Access items and manipulate their data.
• Access collections.
Manipulate data in an Excel workbook by using the Range object.
• Tie a range to a chart.
• Access ranges across worksheets.
• Dynamically navigate through a worksheet.
Developing document-level solutions For 70-543 Test (20 percent)
Customize the actions pane.
• Create and display Microsoft Windows Forms controls on the actions pane.
• Activate and hide the actions pane.
• Respond to orientation change events.
Embed VSTO controls in a document.
• Manipulate control contents.
• Respond to control events.
• Access the host application's object model from the VSTO object.
Extend the document surface by using embedded Windows Forms controls.
Add a control programmatically.
Add smart tag capability to a document.
• Build a recognizer.
• Build an action handler.
Implement event handlers.
• Prevent the event handler from being reclaimed by garbage collection.
• Select an appropriate event handler interface.
Manipulate document customizations at run time.
• Attach a customization.
• Remove a customization.
|