Microsoft Office Tutorials and References
In Depth Information
Note The development of custom XML schemas for business
applications—as well as the creation and enhancement of XML
applications using tools such as smart documents, smart tags, and
InfoPath technology—provide a huge opportunity for solutions
developers. We are just now beginning to see how XML can streamline the
use of data and communications in business, and solutions
developers will be key in expanding our understanding of what’s
possible and providing the means to fully apply the power of XML in our
XML: A Common Denominator
Because XML stores data independently of the format used to display the data,
it provides a common denominator for information storage and exchange.
Businesses that are equipped to work with XML have a key to unlocking the
supply of out-of-reach data stored in antiquated systems and software formats.
If they can convert the data to XML, they can put the data to use in any number
of other applications and resources.
XML is supported in the new versions of Word, Excel, and Access in an
unprecedented way. Although Microsoft Excel version 2002 previously offered
some support for XML, and Word 2002 users were able to save their files in XML
format if they wanted to, the level of XML support now built into Office 2003
enables users to do all kinds of tasks previously unavailable in the program:
Use XML for data analysis. In Excel you can use the XML features
to work with structured, tabular data for calculations and analyses.
Author, edit, and manage content. You can use the XML features
in Word to work with large areas of text or mixed content, creating
flexible layouts and formatting with XML markup.
Store and report on data. The XML features in Access enable you
to store data in relational database tables and create reports based on
that data. You can also use Access to transform files from other
formats into XML and Access-supported forms.