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

Introduction

Welcome to the Access 2007 VBA Bible. Like all books in the Bible series, you can expect to find both hands-on tutorials and real-world practical application information, as well as reference and background information that provides a context for what you are learning. This book is a fairly comprehensive resource on writing VBA code to exchange data among the main Office applications (Access, Word, Excel, and Outlook), using Access as the central application for storing data, and using the other applications for producing attractively formatted documents of various types. By the time you have completed the Access 2007 VBA Bible, you will be well-prepared to write VBA Automation code that uses your Access data to produce Word letters, mailing labels and other documents (without the overhead of mail merge), to create Excel worksheets and PivotCharts, and to create Outlook appointments, mail messages, contacts, and journal items, with or without attachments. Additionally, you will be able to synchronize contact data (both ways) between Access and Outlook.

Who Should Read This Book

The book is written for the Access/Office developer or power user who is familiar with working with Office applications (particularly Access) in the interface, and has at least a basic familiarity with writing VBA code, but needs more information on how to write Automation code to work with Word, Excel, and Outlook objects, so as to be able to use each Office application for creating the documents ...