Access 2007 VBA 宝典：对数据中心Microsoft Office的应用 Access 2007 VBA Bibl 下载 pdf 百度网盘 epub 免费 2025 电子书 mobi 在线

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 *s, 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.

作者简介：

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.

About the Author

Acknowledgments

Introductiom

Part Ⅰ: The Office Components and What They Do Best

Chapter 1 : Storing and Displaying Data in Access

A Brief History of Office Data Exchange

Storing Data in Access

Displaying Data in Access Forms and Reports

Creating Access Form Letters

Creating Worksheet-type Reports in Access

Plain Datasheet Reports

PivotTables

PivotCharts

Summary

Chapter 2: Creating Word Documents from Access

Filling Word Documents with Access Data Using the TypeText Method

Using Word Templates for Creating Formatted Word Documents

Bookmarks

Document Properties

Form Field Documents

Summary

Chapter 3: Analyzing Data with Excel

Exporting Access Data to an Unformatted Worksheet

Using Excel Templates to Create Formatted Worksheets Filled with Access Data

Formatting Excel Worksheets in VBA Code

Summary

Chapter 4: Organizing and Communicating with Outlook

Exporting Appointments and Tasks to Outlook

Exporting Journal Information to Outlook

Creating Emails from an Access Table

Summary

Part Ⅱ Writing VBA Code to Exchange Data between Office Components

Chapter 5: Working with Access Data

Working with Older Format Databases in Access 2007

Disambiguating References to Object Model Components

The DAO Object Model (Old and New)

New Objects in the Access 2007 DAO Object Model

Hidden Objects in the Access 2007 DAO Object Model

Databases

Recordsets

QueryDefs

TableDefs and Fields

The ADO Object Model

Connection

Command

Recordset

Record

Stream

Converting DAO Code to ADO Code

Summary

Chapter 6: Working with Word Documents and Templates

Built-in Word Export in Office 2007

Exporting Access Data to Word Using Automation Code

The Word Object Model

Creating a New, Blank Word Document

Creating a Word Document Based on a Template

Using a Query to Concatenate Data for Export

Choosing a Method for Merging Access Data to Word

Working with Word Document Properties

Word Bookmarks

The TypeText Method

Word Mail Merge

Summary

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 Ⅲ Adding More Functionality to Office

Chapter 13: Creating COM Add-ins with Visual Basic 6

Chapter 14: Creating Access Add-ins

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

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

Chapter 17: Creating Standalone Scripts with Windows Script Host

Chapter 18: Working with SQL Server Data

Index

暂无相关内容，正在全力查找中

暂无出版社相关信息，正在全力查找中！

暂无相关书籍摘录，正在全力查找中！

在线阅读地址：Access 2007 VBA 宝典：对数据中心Microsoft Office的应用 Access 2007 VBA Bibl在线阅读

在线听书地址：Access 2007 VBA 宝典：对数据中心Microsoft Office的应用 Access 2007 VBA Bibl在线收听

在线购买地址：Access 2007 VBA 宝典：对数据中心Microsoft Office的应用 Access 2007 VBA Bibl在线购买

暂无原文赏析，正在全力查找中！

书籍介绍

Learn how to 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. Whether you’re a beginner or a power user, this is the book you need to succeed with Access 2007.