| 
 enlarge | Author: Michael Schmalz
Publisher: O'Reilly Media, Inc.
Category: Book
List Price: $39.95
Buy New: $6.00
You Save: $33.95 (85%)
New (24) Used (14) from $4.00
Rating:  14 reviews
Sales Rank: 25752
Format: Illustrated
Media: Paperback
Pages: 232
Number Of Items: 1
Shipping Weight (lbs): 0.9
Dimensions (in): 9.1 x 6.9 x 0.7
ISBN: 0596009739
Dewey Decimal Number: 005.7565
EAN: 9780596009731
ASIN: 0596009739
Publication Date: November 1, 2005
Availability: Usually ships in 1-2 business days
Shipping: Expedited shipping available
Shipping: International shipping available
|
| Customer Reviews:
 This book is useless. December 27, 2006
Bo Zhang
2 out of 24 found this review helpful
Although the sevice was pretty good, item arrived on time, etc. The book is almost useless.
 Great for Office Automation November 3, 2006
M. Copeland (N. Bellmore, NY USA)
9 out of 12 found this review helpful
I code in Access VBA but need to push data to excel spreadsheets and format the results. This book has the answers.
Would have gotten 5 stars but I didn't find a single reference to the Access TransferSpreadsheet function which pushes data to Excel Named ranges.
 Finally, someone puts the pieces together. May 21, 2006
Christopher T. Fennell (Fullerton, CA United States)
13 out of 16 found this review helpful
I have spent the past ten years making my living developing integrated & automated financial systems using Excel, Access, and VBA for accounting and finance departments. That said, I literally have dozens of Excel, Access, and VBA books on my bookshelf. This is the only book that I have ever seen that integrates Excel and Access. It of course uses VBA to accomplish much of this.
Why it has taken so long for someone to put the pieces together in one book I am not sure. What I am sure of is how useful this book is. If you use Excel and Access this book is a must. This should be your primary reference for integrating and automating Excel and Access. You will learn better ways to do what you are already doing. You will also learn ways to do things that you never knew were possible. As a result, your applications will be more efficient, more powerful, more accurate, more reliable, and finally, you will be a better programmer/developer.
My work as a consultant puts me in a position to help others learn new ways to use Excel, Access, and VBA on a daily basis. When I show users what is possible, things that are covered in this book, they are not only impressed, they are amazed. They now do things that they never dreamed possible.
Integrating the two object models using VBA allows you to fully automate your applications/models. You can now do it minutes, if not seconds, what used to take you hours or days. You remove the possibility of the user making errors because the user is no longer manually manipulating the data (copying, pasting, etc.) You are not changing formulas, expressions, or criteria. You are allowing the computer to do all of that for you. This book, combined with advanced VBA makes true automation possible.
Even if you only desire to be an intermediate user, this book will make using Excel data in Access so much easier. It will of course also make it easier for you to get data from Access into Excel, and I am not talking about copying the results from a select query into an Excel worksheet. I am talking about using either the ODBC connection, or using SQL in VBA, to filter the data coming out of Access into Excel. As such, you get only the records that you want, with the click of a button.
In a nutshell, this book is a must for anyone that uses Excel and Access for a common task. I have read thru this book twice already, and it is my number one reference book. Once you open this book, you too will be asking, why it has taken so long for someone to put using the two programs together in one book.
Christopher T. Fennell
Microsoft Office Application Developer
EXCELLENT!!!!! May 14, 2006
John R. Vacca (Pomeroy, Ohio)
7 out of 11 found this review helpful
Do you use Microsoft Office to handle data? If you do, then this book is for you! Author Michael Schmalz, has done an outstanding job of writing a book that will show you how Access and Excel can work together to improve your reporting and data analysis.
Schmalz, begins by introducing the general topics in the book and explains some of the thought process that goes into integrating the applications. Then, the author covers the tasks that you can complete using only the Excel GUI, as well as discussing some VBA topics. He continues by covering the use of ADO and DAO along with VBA to pull data into Excel. Next, the author covers the use of Excel data in Access and exporting Access data into Excel from features in the Access GUI. Then, he covers controlling Excel from Access and pushing data into Excel. He also covers building charts and pivot tables in Excel using data that originates in Access. Next, the author covers using SQL Serer Data, as well as using DTS and ActiveX scripts to automate Office applications from SQL Server. Then, he covers using VBA from Access to automate reporting in Excel. The author continues by covering data integration and automation from Access and/or Excel in Word, PowerPoint, and MapPoint. He then covers how to build forms in Excel similar to those in Access. The author also covers some basic topics to help you build a functional GUI in Access. Finally, the author covers a project, complete with source code, that requires integration of Access and Excel.
In this excellent book is organized to build on topics in a logical sequence. After practicing the skills this book illustrates, you will have the necessary knowledge to tackle some of your most demanding reporting issues.
Shows how to combine the two programs to get the best from both May 2, 2006
Midwest Book Review (Oregon, WI USA)
1 out of 4 found this review helpful
Michael Schmalz's shows how to combine the two programs to get the best from both. All too often Excel and Access users remain separate; yet user interfaces exist which allow Access databases to be integrated with Excel's analytical features for maximum results. Chapters cover everything from VBA applications and graphs to working across desktops with package applications.
|
|
|
