Working with XML Data in Access 585 Q&A Q1: A1: In addition to Access, do other Office System 2003 applications use XML? Yes. Office applications such as Word and Excel can both consume and export XML data. Data that is exported as XML from Word can be imported into a set of Access tables. Can I link to an XML document through Access and update the data in the document as I would with any other linked table? No. Access allows you only to import the XML document. Once the document is imported, there is no relationship between the table based on the document and the document itself. To publish updated data in XML format, the table containing the new data must be ex- ported as XML. What Access objects can be exported as XML? Access can export tables, queries, views, datasheets, forms, and reports as XML along with the corresponding .xsd and .xsl files. See the preceding major section, "Exporting Other Access Objects as XML," for more information. Q2: A2: Q3: A3: On Your Own Try these exercises to learn more about XML: 1. Using Notepad, create a simple XML document using your personal information as the field elements, and import that document into Access. (Note: if you don't want your personal infor- mation shared, make sure you import into a private database.) For example, you can create an XML document with a root element named <Names>. You can then have a tag like <first- name>[your first name here]</firstname>, <lastname>[your last name here]</lastname>, etc. Then import that table into Access, and see what the new table looks like. See the section "Importing an XML Document into Access" for guidance. Using an existing XSLT, add or remove formatting tags and try to modify a text element in various ways. For example, modify an XSLT so that a normal text element will be both bold- faced and italicized. 2. After you complete this chapter: · You should know how to use Microsoft Access to generate XML and HTML templates that can display Access data in a Web browser. You can also use an Extensible Stylesheet Language Transformation (XSLT) to transform the data that you view in a Web browser. In Chapter 17, "Using Visual Basic to Manage Data," you'll learn how to use Visual Basic in Access to work with and manage your data.