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 For 70-543 Exam.

• Setup

• Group Policy


Deploy a VSTO document-level customization to a server For 70-543 Exam.

• 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 For 70-543 Test.

• Administrative installations

• Customize the default setup project.


Deploy a VSTO solution by using the Bootstrapper For 70-543 Test.

Working with data in a VSTO solution For 70-543 Test (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 Exam (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.