Microsoft Excel and Access Integration: With Microsoft Office 2007 | 
 enlarge | Authors: Michael Alexander, Geoffrey Clark
Publisher: Wiley
Category: Book
List Price: $39.99
Buy New: $17.75
You Save: $22.24 (56%)
New (38) Used (16) from $17.75
Avg. Customer Rating:  6 reviews
Sales Rank: 41468
Media: Paperback
Number Of Items: 1
Pages: 408
Shipping Weight (lbs): 1.3
Dimensions (in): 9.1 x 7.3 x 1.1
ISBN: 0470104880
Dewey Decimal Number: 005.5
EAN: 9780470104880
ASIN: 0470104880
Publication Date: April 30, 2007
Availability: Usually ships in 1-2 business days
Condition: Brand new, never opened, in stock in our warehouse, and ships right now.
|
| 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: Read 1 more reviews...
 Terrific! May 13, 2008
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
4 out of 4 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
3 out of 11 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.]
Good introduction to using the two packages together. May 30, 2007
9 out of 9 found this review helpful
The back cover of this book starts out saying: 'Excel users. Access users. You're probably among the majority, living in one camp or the other but rarely crossing between the two.' That's a pretty good description of me. I have used Access for many years. I speak Access SQL, I know about Access input forms and output reports. I have seen Excel users who do much better looking presentations, have powerful tools to summarize and analyze data (such as charts), but I had no idea how to take information from an Access table and feed it into Excel.
I started in this book with Chapter 5 - Getting Access Data into Excel. There are several different ways to get the data from simple drag and drop to using SQL for more powerful approaches. The examples use the new 'Ribbon' from Excel 2007, but many of the same features were in previous versions. The short section on SQL is elementary, if you really want to use SQL, you'll want a specialized book on Access SQL (note Access SQL - it's different than other SQLs).
If you want to go the other direction, Chapter 1 is 'Getting Excel Data into Access.'
The first half of the book is on using Excel and Access in their traditional ways, the second half gets more advanced with chapters on VBA, Automation, XML and with integrating Excel with other Office applications including Word, PowerPoint and Outlook.
I'd rate this an intermediate level book. It's really intended for the Excel or Access user to teach them about the other package.
I just knew it! May 20, 2007
11 out of 11 found this review helpful
I'm an intermediate user with some experience using both Excel and Access. I've always hacked my way into integration, and have always had the sense that there are better ways to make Excel and Access work together. It turns out I was right. Within 30 minutes of receiving this book, I've found three techniques that have exponentially improved my processes. I particularly appreciate the fact that the authors start simple and build gradually to more complicated techniques. Five stars for this extremely valuable addition to my library!
|
|
|
