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

Description

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. 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.