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

Helen Feddema

  • 出版商: Wiley
  • 出版日期: 2007-05-07
  • 售價: $1,380
  • 貴賓價: 9.5$1,311
  • 語言: 英文
  • 頁數: 720
  • 裝訂: Paperback
  • ISBN: 047004702X
  • ISBN-13: 9780470047026
  • 相關分類: Excel






  • 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
  • Examines a number of non-Office applications that are useful when working with Office components, because they either add extra functionality or eliminate annoyances


Table of Contents


Author Biographies.


1. Storing and Displaying Data in Access.

2. Creating Word Documents from Access.

3. Analyzing Data with Excel.

4. Organizing and Communicating with Outlook.

5. Working with Access Data.

6. Working with Word Documents and Templates.

7. Working with Excel Worksheets.

8. Working with Outlook Items.

9. Working with Files and Folders.

10. Working with External Data.

11. Synchronizing Access and Outlook Contacts.

12. Going Beyond the Basics.

13. Creating COM Add-ins with Visual Basic 6.

14. Creating Access Add-ins.

15. Customizing the Ribbon with XML in Access Databases and Add-ins.

16. Customizing the Access Ribbon with a Visual Studio 2005 Shared Add-in.

17. Creating Standalone Scripts with Windows Script Host.

18. Working with SQL Server Data.