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

Helen Feddema

Language: English

Publisher: Wiley

Published: May 6, 2007

Description:

From the Back Cover

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.

About the Author

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.