An exploration of the relationship between XML and Office 2003, examining how the various products in the Office suite both produce and consume XML. Beginning with an overview of the XML features included in the various Office 2003 components, it provides guidance on how to import or export information from Office documents into other systems.

* Edit standard XML files with all the tools of Word and Excel (like formulas and the spell checker) * Take existing Word or Excel documents, transform all or part of them into XML, and "plug" them into business processes. * Mine the data in an Office document, using custom macros or applications—on any platform. * Create rich Word or Excel documents programmatically, without even needing to have Office installed. * Create smart documents that have built-in user guidance and validation rules to prevent errors.

While it has always been possible to create customized Word solutions, Word 2003 offers new functionality that allows documents to be truly interactive. Word 2003 Document Automation with VBA, XML, XSLT, and Smart Documents explains how to use a variety of technologies that change the ways users interact with documents. Learn how to automate documents with a minimum of programming by using Word's native functionality; use Visual Basic for Applications to create document automation solutions; record macros, create automated templates, format and manipulate files using Word, and build documents dynamically; create, edit, and format XML documents; develop smart document solutions to guide users through a variety of repetitive tasks; transform XML using WordprocessingML, XSLT, XPath, smart documents, and web services technologies.

* Builds real applications that can be customized and used commercially. * Provides real-world examples, each of which offers a fundamental lesson in approaching data structure and code. * Friendly, open and targeted chapters that can be absorbed one lesson at a time.

This book is designed to take Microsoft Access users to the next step in programming. Its five parts cover an intro-duction to VBA programming, manipulating databases with ADO, using DDL, event programming, and using ASP and XML. With more than 300 hands-on examples and 11 custom projects, users can quickly build the toolset required for developing their own database solutions. Learn how to write and debug your programming code with the Visual Basic Editor, and understand and use common VBA programming structures such as conditions, loops, arrays, and collections. Learn how to create and manage databases with ActiveX Data Objects (ADO), and perform database tasks with Jet/Access Structured Query Language (SQL) and its Data Definition Language (DDL) component. Learn how to query and manipulate your database from a web browser with Active Server Pages (ASP) and export and import Access data to and from XML both manually and programmatically.

In Microsoft's Office 2003, users experience the merger of the power of the classic Office suite of applications with the fluidity of data exchange inherent in XML. With XML at its heart, the new version of Microsoft's desktop suite liberates the information stored in millions of documents created with Office software over the past fifteen years, making it available to a wide variety of programs.

Validate your expertise and get the attention of employers with Microsoft Office Specialist certification. This comprehensive guide is what you need to prepare for certification in Excel 2003, both the Specialist and Expert levels. Carefully planned by a seasoned Microsoft Office Specialist instructor, this invaluable study guide uses real-world scenarios to teach the full range of Excel 2003 skills you need-not only to prepare for the certification exams, but also to increase your ability and productivity in the workplace. Covering twenty-four Specialist exam objectives and thirty-three Expert exam objectives, the book progresses through the functions and features of Excel software. Even entry-level Excel users can rapidly build their skills. Excel 2003 Specialist Certification Skill Sets * Creating Data and Content * Analyzing Data * Formatting Data and Content * Collaborating * Managing Workbooks Excel 2003 Expert Certification Skill Sets * Organizing and Analyzing Data * Formatting Data and Content * Collaborating * Managing Data and Workbooks * Customizing Excel Plus, you'll find additional career preparation tools, including: * Solutions for real-world scenarios * Structured learning for quick productivity * Full glossary of terms Go to www.sybex.com/go/mosexcel2003 for downloadable sample files from the exercises in the book. Practice what you've learned on your own. Visit www.sybex.com for all of your professional certification needs.

This is a practical guide that distills years of ingenious XML hacking into a complete set of tips, tricks and tools for those who want to leverage the untapped power of XML. It includes many real-world projects that illustrate how to define, create, read and manipulate XML documents.

This reference for programmers and web developers covers all of XML along with related protocols and technologies. It is assumed that the reader has a basic understanding of XML. The authors are both with DevelopMentor's technical staff. c. Book News Inc.

The definitive guide to developing applications with Microsoft Excel, this book is written by four authors who are Excel MVPs and run their own companies developing Excel-based applications.