Link to home
Start Free TrialLog in
Avatar of Patrick Matthews
Patrick MatthewsFlag for United States of America

asked on

Book recommendations for Access 2010

All,

I still have on my bookshelf the 2-volume Access 2002 Developers Handbook by Litwin, Getz, and Gunderloy, and while it is excellent it is also now, um, very dated :)

What Access 2010 books do my fellow Experts recommend?

Thanks!

Patrick
ASKER CERTIFIED SOLUTION
Avatar of DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I just went through 10 pages on Amazon on A2010.  A LOT of books by a LOT of peeps I've never heard of ... and I've heard of ... a lot of people.

No matter what, I would head down to B&N (et.al.) and do a touch and feel ... look at real books, see how much time is spent on the subjects you are interested in ... then make a choice(s).  In fact, I might just to that this afternoon.

Aside from A2010 ... fwiw ... these are my favorite books ... that I have found VERY useful - and of course a large % still applies in A2010.


The defacto standard:
http://www.developershandbook.com   Must have.

VBA Developers Handbook:
http://www.amazon.com/VBA-Developers-Handbook-2nd-Getz/dp/0782129781

"Fixing Access Annoyances"
Phil Mitchell and Evan Callahan
O'Reilly

In the back ... there is a great reference appendix ...with functions, macro actions etc.

PLUS ... the book itself is VERY cool  
list price $20

Also ... another cool book ...

"Access Hacks"
Ken Bluttman
O'Reilly

SQL Queries for Mere Mortals - Second Edition
http://my.safaribooksonline.com/9780321444431
by John L. Viescas; Michael J. Hernandez

And Finally:
"Microsoft Jet Database Engine Programmer's Guide "
http://www.amazon.com/Microsoft-Database-Programmers-Professional-Editions/dp/1572313420

mx

One last comment.
The book MUST have a cool looking cover lol.
But seriously, the layout inside to books matters to me.  Some books are VERY hard to read because of they way they are laid out ... toooooo much text and not enough images, etc.

Anyway ... good luck.

mx
Avatar of Patrick Matthews

ASKER

MX,

Thanks for those!  I'll leave this open for a bit to see if anyone else feels inclined to opine :)

Patrick
I'm sure you will get more response ... I would be interested to see if anyone has a book they LOVE!

mx
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Check out Access for Excel Dummies :-)

mx
Update.
So, I looked at about 20 of the A2010 books on Amazon, reading table of contents, reviews, 'Look Inside', etc.

Personally, based on this exercise, I probably would not buy any of these books.  The 'negative' reviews generally indicate that ... the books really do not go into enough depth on any one particular subject ... certainly not subjects I would be interested in (your results may vary). This has been my experience in the past, except for the Getz books, and the ones I listed above.
Also, many of the very positive reviews are clearly by 'friends' of the author ...

I feel most of the info I would need is available on line, either here on EE or elsewhere, like Allen Browne's site for example (et.al.)

I will however ... still make the trip to the local Barnes & Noble

But, I am probably coming from a different place that you ... so, you may still find one or more of the books useful.

Other example of on line references - in this case that give specifics (to some degree) of what is new in A2010 ... are:

Access 2010 Developer Reference
http://msdn.microsoft.com/en-us/library/ee861519.aspx

Access 2010 Technical Articles
http://msdn.microsoft.com/en-us/library/ff604970.aspx

Access 2010 Visual How Tos
http://msdn.microsoft.com/en-us/library/ff604969.aspx

Microsoft Office 2010
http://msdn.microsoft.com/en-us/library/cc313152%28v=office.12%29.aspx

mx
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
The Missing Manual does look interesting, and I'm going to check it out this afternoon, but two of the reviews on Amazon concerned me ....

"I picked this up a few weeks back so haven't read it completely. Still I think not the best book for anyone experienced with MS Access. There's lots of basics but not a good balance of depth. I recommended taking a read through before you pick it up."

"Maybe I have unrealistic expectations - but so much of the book is devoted to very basic items and so little of the book is devoted to software development. Almost no discussion of Access classes or calling API's; only a token consideration of programming in Access. In my opinion, this book would be excellent for someone not very familiar with Access 2010 that wants to build a database and use standard features to enter data, query it, and produce reports. This book is not quite right for the experienced software developer that wants to use an underlying programming methodology to have precise control and develop professional-looking applications that require no user training."

So ... an up close and person inspection is in order ...

mx
Avatar of Mitch Schwartz
Mitch Schwartz

I can confirm what was said earlier: All of the "Access Developers Handbook" editions are career-makers, regardless of the Access version you are using. I have solved more challenges by referring to these books, than any other way.

I was so impressed with them that I dropped a personal note to Ken Getz (one of the authors) complimenting him on the fine book. Alas, he has stated that further editions of the book are not in his plans.

Thanks to the other experts for the additional recommendations.

Mitch
If  I could only purchase on book about Access  the only one I would buy is the "Access Developers Handbook". I have lots of Access books.  I still  grab the Developer's Handbook first. The only time I look else where is when I need to work with the new Ribbon.


I would supplement the Developer's Handbook with good  book on the new Ribbon. I jsut have not found on yet.
So, I went to Barnes and Noble.
I looked at all the A2010 books there - not that many compared to web site and Amazon.
Now, clearly my comments are subject.

I'm not a fan of tech books w/o color ... just plain boring. Only two books are in color:
Access 2010 Plain & Simple
Access 2010 Quick Steps.

I looks like these books might have some good tips ... and the presentation is outstanding - lots of screen shots, etc.  I may pickup one of these on Amazon - just to cruise through and look for tips.

But ... as in even the other books, including the ones I already mentioned ... there a lot of basic material - each subject covered briefly - as usual.  Pretty much the only exceptions to this has been the Getz books (including the VBA Handbook).

I looked in each book for a couple of new properties (starting in A2007 I guess)
Order By On Load
Filter On Load
In A2010 Help, there is virtually no information on these properties - no surprising.

I found one very short sentence in the Henning book ... that told me absolutely nothing.  Could not find in the Missing Manual at all.

So, not sure what level you are after Patrick ... but for me, until one comes out with the quality of the Getz books ... probably going to skip it ...  and just find the info I need online ... with the possible exception of the book(s) in color.

mx

Oh ... I did by Microsoft Outlook 2010 Plain & Simple, again because of the color and nice layout.

And as I noted, at least at this store, a lot of the books that were on the site were not in the store, for example:

Microsoft Access 2010 VBA Macro Programming (and VBA)

mx
Actually, I bought the Outlook 2010 Quick Steps, not Plain & Simple.

btw  ... there were at least ... 3x Excel books compared to Access !

mx

there were at least ... 3x Excel books compared to Access !

That makes sense.  From my experience Access in not used near as much as either  Word and Excel.
Yeah, that's because Excel is so much easier than Access  ha ha
And everyone thought they could build a database in Excel!

mx
I ended up purchasing the WROX Access 2010 Programmer's Reference.

There may other purchases in the future :)