Access 2007 VBA Bible: For Data-Centric Microsoft Office Applications

Tap the full potential of Access 2007

Transfer Access data seamlessly between Microsoft Office applications—and that's just for starters! In this all-new, comprehensive guide by well-known Access expert Helen Feddema, you'll learn to write Visual Basic® code that automates Access database tasks, creates standalone scripts, extracts and merges data, and allows you to put together powerful solutions that increase your efficiency across the Office family. Whether you're a beginner or a power user, this is the book you need to succeed with Access 2007.

• Manipulate and share Access data across Word, Excel®, and Outlook®

• Create Word documents from Access

• Write VBA code to automate many database tasks

• Create an Access form as a control panel for data exchange

• Add functionality with COM and Access add-ins

• Work with SQL Server data

• Customize the Access 2007 Ribbon with XML

Companion Web site

Visit the companion Web site for all the VBA code, spreadsheets, and databases you'll need to do the projects in the chapters.

This guide provides tutorials and practical applications, in addition to reference and background information, on writing VBA code to exchange data among the main Microsoft Office applications, using Access as the central application for storing data. Written for the Access/Office developer or power user who is familiar with Office applications and VBA code, it covers Access, Word, Excel, and Outlook components and selecting a specific one for a task; working with Access data, Word documents and templates, Excel worksheets, Outlook items, files and folders, external data, and synchronization; and creating COM add-ins, Access add-ins, customizing the ribbon, creating standalone scripts, and working with SQL server data. Feddema, an independent developer specializing in Microsoft Office applications, has written several books on Microsoft Access and is the editor of Access Watch. Annotation ©2007 Book News, Inc., Portland, OR (booknews.com)

* Examines a number of non-Office applications that are useful when working with Office components, because they either add extra functionality or eliminate annoyances

Learn how to tap the full potential of Access 2007 Transfer Access data seamlessly between Microsoft Office applications—and that's just for starters. In this all-new, comprehensive guide by well-known Access expert Helen Feddema, you’ll learn to write Visual Basic code that automates Access database tasks, creates standalone scripts, extracts and merges data, and allows you to put together powerful solutions. Whether you’re a beginner or a power user, this is the book you need to succeed with Access 2007.

Tap the full potential of Access 2007

Transfer Access data seamlessly between Microsoft Office applications—and that's just for starters! In this all-new, comprehensive guide by well-known Access expert Helen Feddema, you'll learn to write Visual Basic® code that automates Access database tasks, creates standalone scripts, extracts and merges data, and allows you to put together powerful solutions that increase your efficiency across the Office family. Whether you're a beginner or a power user, this is the book you need to succeed with Access 2007.

• Manipulate and share Access data across Word, Excel®, and Outlook®

• Create Word documents from Access

• Write VBA code to automate many database tasks

• Create an Access form as a control panel for data exchange

• Add functionality with COM and Access add-ins

• Work with SQL Server data

• Customize the Access 2007 Ribbon with XML

Companion Web site

Visit the companion Web site for all the VBA code, spreadsheets, and databases you'll need to do the projects in the chapters.

Helen Feddema is one of the most highly respected experts on Microsoft Access. She is the author of several leading books on Microsoft Access, including the bestselling Microsoft Access Version 2002 Inside Out and Expert One-on-One Microsoft Access Application Development. She is the editor of Access Watch, for which she writes the Access Archon column. She is also an independent Access consultant.

About the Author.

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.