Skip to content

Integrating Excel and Access

Spend $50 to get a free DVD!

ISBN-10: 0596009739

ISBN-13: 9780596009731

Edition: 2005

Authors: Michael Schmalz

List price: $39.95
Blue ribbon 30 day, 100% satisfaction guarantee!
what's this?
Rush Rewards U
Members Receive:
Carrot Coin icon
XP icon
You have reached 400 XP and carrot coins. That is the daily max!

In a corporate setting, the Microsoft Office Suite is an invaluable set of applications. One of Offices' biggest advantages is that its applications can work together to share information, produce reports, and so on. The problem is, there isn't much documentation on their cross-usage. Until now. Introducing "Integrating Excel and Access, the unique reference that shows you how to combine the strengths of Microsoft Excel with those of Microsoft Access. In particular, the book explains how the powerful analysis tools of Excel can work in concert with the structured storage and more powerful querying of Access. The results that these two applications can produce together are virtually…    
Customers also bought

Book details

List price: $39.95
Copyright year: 2005
Publisher: O'Reilly Media, Incorporated
Publication date: 11/11/2005
Binding: Paperback
Pages: 236
Size: 7.25" wide x 9.25" long x 0.50" tall
Weight: 0.880
Language: English

Michael Schmalz works in financial services and performs business and technology consulting in a variety of industries. He has done technical editing for O'Reilly on several Microsoft Office books and authored "Integrating Excel and Access" and "C# Database Basics". Michael has a degree in Finance from Penn State. He lives with his wife and children in Pennsylvania.

Preface
Introduction to Access/Excel
Integration Communications Between Excel and Access
Automation Objects ADO and DAO
Tackling Projects Designing Applications
Using the Excel User Interface
Using External Data
Using Database Queries
Returning a PivotTable to Excel
Using Microsoft Query to Gather Data
Keeping the Query Updated with VBA
Data Access from Excel VBA Writing a Reusable Module for Data Access
Choosing Between ADO and DAO CopyFromRecordset Versus Looping Formatting Techniques
Formatting Techniques Example
Integration from the Access Interface Importing Excel Data
Linking Excel Data Using Export and Analyzing It with Microsoft Office Excel
Using Raw Exported Access Data in Excel Exporting an Access Report to Excel
Using Access VBA to Automate Excel High-Level Excel Objects
Other Excel Objects Writing and Using Queries in VBA Referencing Sheets, Ranges, and Cells Writing Excel Worksheet Functions from Access VBA
Using Excel Charts and Pivot Tables with Access Data Automating Pivot Tables
Building a Regular Chart Using an Array Formula Graphing Variables in a Model
Leveraging SQL Server Data with Microsoft Office
Pass-Through Queries Versus Linked Tables Creating a Connection
Using VBA Building the Connection in Access Pulling Data in with Excel Alone
Using DTS to Automate Excel Crosstab Queries on SQL Server
Advanced Excel Reporting Techniques Writing Flexible Formulas Changing Data in an Existing Report
Creating a Report from Scratch
Using an Access Table for Reporting
Using Access and Excel Data in Other Applications
Automating Microsoft Word Getting Information from Microsoft Word
Automating PowerPoint Using Data in MapPoint
Creating Form Functionality in Excel Working with the UserForm
Accepting Parameters Other Useful Items
Building Graphical User Interfaces Setting Up a Form Using Events
Using Data Adding Buttons Tab Order
Tackling an Integration Project
The Project Description Main Menu
Customer Information
Billing and Payment Information
Contact History
Services and Charges
Expense Entry
nvoices Letters
Income Statements
Excel Object Model
VBA Basics
Index