Product Description

This book offers you comprehensive, information on using the new version of Access. Not only updated for the latest version, new chapters have been added on application automation with Access macros and collaboration with Microsoft SharePoint Team Server, both of which are hot topics. All chapters are updated for the transition from Jet to the new Access database engine. Detailed, step-by-step instructions with icons guide you through Access through table design, data addition, importing data from external sources, query design and execution, and designing data entry forms and printed reports.

---

Product Details

Publisher	Que
ISBN	0789735970
Format	Paperback Deluxe Edition
Author	Roger Jennings
EAN	9780789735973
Label	Que
Dewey Decimal Number	005.7565
Studio	Que
Number Of Pages	1488
Title	Special Edition Using Microsoft Office Access 2007
Publication Date	2007-05-07
Manufacturer	Que

---

Customer Reviews

Very Happy With Purchase

Review by William H. Wall, Jr., 2010-08-02

The book arrived very promptly and in great shape. I already have several Que publications and they have never failed to be very informative on Microsoft software. I wouldn't change anything because everyting went so smoothly. I am extremely pleased with my purchase.

W. H. Wall

---

If you want to learn how to develop in Access, this is NOT the book for you.

Review by John R. Volters, 2010-03-08

I purchased this book for a project, based on the stellar reviews that had been posted. Unfortunately, well-meaning people provided the wrong types of reviews and I wasted money on this book!
So, to help you put into context my decidedly negative rating of this book, I will provide background on my roles here at work; I am primarily the chief data architect responsible for all things OLTP, OLAP and DSS related. That means I spend 90% of my time writing T-SQL and related code to manage and insert, update or delete rows into tables in databases on SQL Server systems.
The other 10% of my time is spent mostly on .NET development doing same - that means developing web based applications where data grids are populated with results from SELECT statements or, forms have been built that will insert, update or delete a row from a table based on input into the form.

Now that you know the context, my basic problem is this; we have departments that created Access 'applications' by this I mean they know enough to create a very simple application where a few dozen rows can be easily handled by the one person they deployed the 'application' to. Now, however, the application has outgrown the design, more powerful queries and forms management is required and most importantly, we need to move the tables to SQL for maintenance and performance considerations; breaking Access apart so multiple users can have the 'application' part and the 'database' part is on SQL Server.

Based on the book's title, and the stellar reviews, I purchased this book to help me tackle this project. That was 3 weeks ago, and while I admit I have not had the time to read the book cover to cover; that is precisely the point of this negative review. Because in order to know everything necessary to meet the title's claim to be the "only access book you will ever need" you have to thoroughly read and digest this book. You have to do this because unlike other books aimed at developer's, this book doesn't start with a 'basics' project and build out from there - it starts with the (in)famous Northwind and some templates to load - which I might do if there were lessons that would take me through the essential parts of what I need to know.

The layout of this book does not do this - so if you are looking for such a book; for example that would provide a section on "How to create a simple form, bind a combo box control to a table, and a query using a WHERE clause"; then this is not the book for you.

Go find another !!!

If on the other hand, your roles and responsibilities consist of a scope where you have say, 20 hours a week to just sit and read and learn and muse and play; then you might find this book quite handy. I find it a colossal waste of money and time trying to read through sections and glean enought to get anywhere.

And why would I even be looking for a book on Access development? Well, if Office had a decent BOL as does SQL Server, I probably wouldn't. But Office is sadly deficient in any useful how to instructions - either in help or online; instead, Office Product Management seems to believe, as does the author of the book if you just go through definitions and descriptions of what to do that is somehow sufficient... it decidedly is not.

Save your $$$ - look elsewhere !!!!

---

Always a good source of reference for Access

Review by BBQ King, 2010-03-08

I've used earlier editions of Jennings' Access Special Editions before and as usual find them packed with useful information and well structured for learning about the product. Sometimes I wish there was a manual that covered the top 25 things that most everyone needs to know to use Access in three chapters and a good index to find the details and in-depth usage in a separate 30 chapter section. This book has just gotten so very large that I can use it as a free weight instead of going to the gym.
Seriously though, my main complaint, as in previous editions is the index. Individual commands are not listed or referenced as such, you have to know where they are used as a group and maybe then you can find them. I have to add a separate index of my own when I finally find what I'm looking for. (Try to find IIf sometime.)

---

Useful

Review by M. Beheler, 2010-01-08

Learning Access and switching to Office 2007 at the same time was more than I could cope with. This helped a bunch.

---

Special Edition Using MS Access 2007

Review by TAG, 2009-01-23

This book provides a lot of detail but so far, the answers to my questions aren't always easy to find. I have to look at the index multiple times to review the material on one subject matter.

---