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

✍ Scribed by Feddema, Helen

• Publisher: John Wiley & Sons
• Year: 2007
• Tongue: English
• Leaves: 721
• Category: Library

✦ Synopsis

Written by one of the leading authorities on Microsoft Access, this book provides numerous VBA code samples that illustrate how to transfer data among the various Office components.; In addition to gaining a clear understanding of the best features of Access, Word, Excel, and Outlook, readers will also get insightful advice on what they should not do-and why-in each program.; Includes details of writing VBA automation code to do the importing, exporting, and synchronizing of data between Office components, as well as creating an easy-to-use Access form as a control panel for the data exchange.;Access 2007 VBA Bible; About the Author; Credits; Contents; Acknowledgments; Introduction; Who Should Read This Book; How This Book Is Organized; What's on the Companion Web Site; Minimum Requirements; Where to Go from Here; Part I: The Office Components and What They Do Best; A Brief History of Office Data Exchange; 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.

✦ Table of Contents

Access 2007 VBA Bible
About the Author
Credits
Contents
Acknowledgments
Introduction
Who Should Read This Book
How This Book Is Organized
What's on the Companion Web Site
Minimum Requirements
Where to Go from Here
Part I: The Office Components and What They Do Best
A Brief History of Office Data Exchange
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 DataChapter 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.

✦ Subjects

Database management;Electronic books