Integrating Excel and Access Combining Applications to Solve Business Problems

Name: Integrating Excel and Access Combining Applications to Solve Business Problems
Price: 2.54 USD
Availability: InStock
ISBN: 9780596009731

ISBN-10: 0596009739

ISBN-13: 9780596009731

Edition: 2005

Authors: Michael Schmalz

List price: $39.95

30 day, 100% satisfaction guarantee!

Buy new: $30.42

Marketplace

4 new & used from $2.54

what's this?

Rush Rewards U
Members Receive:

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…

Book details

List price: $39.95
Copyright year: 2005
Publisher: O'Reilly Media, Incorporated
Publication date: 11/22/2005
Binding: Paperback
Pages: 232
Size: 7.01" wide x 10.20" long x 0.63" tall
Weight: 1.892

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