|
Microsoft Excel and Access Integration: With Microsoft Office 2007 |  | Authors: Michael Alexander, Geoffrey Clark
Publisher: Wiley
Category: Book
List Price: $39.99
Buy New: $22.56
as of 9/6/2010 20:10 EDT details
You Save: $17.43 (44%)
New (39) Used (17) from $21.06
Seller: supermoviedeals
Rating:  8 reviews
Sales Rank: 62648
Media: Paperback
Pages: 408
Number Of Items: 1
Shipping Weight (lbs): 1.3
Dimensions (in): 9.2 x 7.4 x 0.9
ISBN: 0470104880
Dewey Decimal Number: 005.5
EAN: 9780470104880
ASIN: 0470104880
Publication Date: April 30, 2007
Availability: Usually ships in 1-2 business days
| |
| Features:
| • | ISBN13: 9780470104880 | | • | Condition: New | | • | Notes: BUY WITH CONFIDENCE, Over one million books sold! 98% Positive feedback. Compare our books, prices and service to the competition. 100% Satisfaction Guaranteed |
|
| Also Available In:
|
| Similar Items:
| |
| Editorial Reviews:
Product Description
Although many people rarely go from Excel into Access or vice versa, you should know that Microsoft actually designed these applications to work together. In this book, you’ll discover how Access benefits from Excel’s flexible presentation layer and versatile analysis capabilities, while Access’s relational database structure and robust querying tools enhance Excel. Once you learn to make the two work together, you’ll find that your team’s productivity is the real winner.
|
| Customer Reviews:
Showing reviews 1-5 of 8
 Another great contribution by Michael Alexander June 4, 2010
Mark J. Nigrini (Pennington, New Jersey)
This book has some great tips on how to get these two programs to work together for even more sophistication and productivity. Excel is one of those programs where the average user uses perhaps 15 percent of its capabilities. The same is probably true of Access. Alexander and Clark show some great ways to get the programs to work together. Even as a seasoned user, I found some neat sections that opened my eyes. For me the best sections were those on Microsoft Query, getting Excel reports to look professional (by feeding them to Access Reports), the introduction to VBA, and the very clever sections on integration with Word and PowerPoint. This book will be a valuable addition to every Excel and Access user's bookshelf (and it won't get dusty there, I regularly use it as a reference).
Great resource! December 21, 2008
Excel User
1 out of 1 found this review helpful
I found this book to be a great resource. It's perfect for an Excel user who wants to start using the power of Access, Queries, and VBA to take their data analysis to the next level. I highly recommend this book. It was well worth the money.
Terrific! May 13, 2008
Lana Wood (Houston, TX USA)
This book is terrific. It is for the intermediate Excel user. It spring boards you into the world of MS Query! MS Query provides your spreadsheets excellent real time information from your MS Access database. The book states there is web material to work through the exercises. It was a bit difficult to find the materials on wiley.com. Go to h[...]
There are two files with the description of "Sample Files", but they are really the materials for the book.
 It was just what I was looking for. March 23, 2008
Travis Morien (Perth, Western Australia)
13 out of 13 found this review helpful
I got a fair bit of value out of this book because there were just a few things I'd been trying to figure out to migrate my Excel apps to using an Access back end, so for me it was something of a Rosetta stone.
I agree with all the reviews given for this book so far, including the really negative one. For the Excel power-user like me wanting to interface with Access it was very useful and provided a reasonable introduction. However, it took me only a short time to get through all of it because I skimmed much of it.
It is a book which many power users will need only to skim read to pick up a few gems, bypassing a lot of basic material on report writing and the like which is dealt with in a myriad of Access books. The book really does deliver what it says on the cover, talking about the integration of Excel and Access. It turns out though that this isn't all that hard to do, so most of the good stuff in this book is contained in just a couple of chapters.
I needed a little push in the right direction, so I found this book really valuable. I know Excel really well, I knew a bit about Access, but I didn't have any idea how to really integrate them and few of the books I've read on VBA really did a good job explaining how... especially with Office 2007. To actually start writing good integrated apps though you'll need good VBA books for both Excel and Access, because the book makes little attempt to go beyond its title's subject.
 Shallow and Disappointing Book January 29, 2008
nexusstone (Short Hills, NJ / Houston, TX)
5 out of 20 found this review helpful
Speaking for myself, I found this to be a pretty basic, shallow and disappointing book. I (started to read, but then) skimmed the book for in-depth stuff -- only to find out that it barely touched the primary topics where I was seeking to augment my skills with & between the two applications (which was the WHOLE point of buying the book). There was little or no IN-DEPTH development of areas that I would consider of interest / value. For ME, there was NO 'treasure trove' here. [Notwithstanding the foregoing, I will say: The areas that the book does cover, imo, are covered quite clearly, lucidly, understandably and well.]
Showing reviews 1-5 of 8
|
|
|
CERTAIN CONTENT THAT APPEARS ON THIS SITE COMES FROM AMAZON SERVICES LLC. THIS CONTENT IS PROVIDED ‘AS IS’ AND IS SUBJECT TO CHANGE OR REMOVAL AT ANY TIME. Thank you for browsing ExcelBookstore.com! | |
