Tech Tip: Attach a different Word template/Analyze Excel's XML data/Caption property in Access

Learn how to attach a different Word template to your document, analyze XML data with Excel 2002, and save time with the Caption property.

Attach a different template to your document

When you need to reformat a document according to a new custom template, you don't have to start over. You can make Word reformat it for you by replacing the document's template with the custom template.

Follow these steps:

  1. Open the document, and go to Tools | Templates And Add-Ins.
  2. Select the Automatically Update Document Styles check box.
  3. Click the Attach button, and browse to the appropriate template.
  4. Select the template, click Open, and click OK.

Word automatically replaces each style in the document with a style of the same name in the new template; you may have to manually change other styles. Word also replaces AutoText, macros, and custom command settings available in the original template with those of the custom template.

Analyze XML data with Excel 2002

Excel 2002 lets you open and analyze an XML file as a native Excel file. You can use all of Excel's analysis tools, including pivot tables and pivot charts, with XML data.

To open an XML file, go to File | Open, and select XML Files from the Files Of Type drop-down list. Navigate to the XML file you want to open, and click Open.

Excel displays XML tags as column headings and lists the data in the rows below the appropriate column headings. For example, in an XML Orders file, every Orders element may have Ship Region as a child element. In the worksheet, Excel represents the child element as the column header /Orders/Ship Region/.

Excel opens XML files as read-only files, so users can't make changes to the original file while analyzing it in Excel.

Save time with the Caption property

Access uses the Caption property to designate a field in Datasheet view, reports, and forms. You should define the Caption property for every field in a table.

If you leave the Caption property blank, Access uses the field name to label the field. For example, when a wizard creates a form or report, and the caption property is blank, the result displays the field names used in the table, such as Employee_Num or Addr1. Field names aren't appropriate as labels in data entry forms or printed reports; consider relabeling them to make them easier to read.

If you define the Caption property when creating fields, you won't need to change the field labels each time you create a new form or report. Using the same captions across all forms and reports in an organization not only saves time, but it also helps ensure data accuracy.