Acknowledgments.

Introduction.

Part I: The Office Components and What They Do Best.

Chapter 1: Storing and Displaying Data in Access.

Chapter 2: Creating Word Documents from Access.

Chapter 3: Analyzing Data with Excel.

Chapter 4: Organizing and Communicating with Outlook.

Part II: Writing VBA Code to Exchange Data between Office Components.

Chapter 5: Working with Access Data.

Chapter 6: Working with Word Documents and Templates.

Chapter 7: Working with Excel Worksheets.

Chapter 8: Working with Outlook Items.

Chapter 9: Working with Files and Folders.

Chapter 10: Working with External Data.

Chapter 11: Synchronizing Access and Outlook Contacts.

Chapter 12: Going Beyond the Basics.

Part III: Adding More Functionality to Office.

Chapter 13: Creating COM Add-ins with Visual Basic 6.

Chapter 14: Creating Access Add-ins.

Chapter 15: Customizing the Ribbon with XML in Access Databases and Add-ins.

Chapter 16: Customizing the Access Ribbon with a Visual Studio 2005 Shared Add-in.

Chapter 17: Creating Standalone Scripts with Windows Script Host.

Chapter 18: Working with SQL Server Data.

Index.