Summary

The chapter has three major sections. In the first section, you gain exposure to core concepts for XML documents, XSD schemas, and XSLT—particularly as they relate to Access data and built-in Access XML capabilities. The next section explores manual techniques for processing Access data with XML. The section begins with a series of demonstrations showing you how to represent an Access table as an XML document. You also learn how to import that table into another Access database file or Access project. In addition, you learn how to show the data in a browser. The chapter also notes that you can attach .xml and .xsd files to e-mail messages for transport over the Internet instead of downloading them from a Web server. The second section further illustrates how to prepare data from related tables in Access databases, as well as the data from behind Access forms, for transport over the Internet. The third section demonstrates how to program selected examples presented in the second section, as well as how to perform tasks with XML documents not possible through the Access UI. For example, you learn how to select a subset of the elements from an XML document and how to update element values in an XML document.