• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 422
  • Last Modified:

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
0
Patrick Matthews
Asked:
Patrick Matthews
  • 12
  • 2
  • 2
  • +3
3 Solutions
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Book(mark) >>>  www.experts-exchange.com silly !

I generally do not buy books any more, however this book does have contributions by many folks we know ...

      
Access 2010 Programmer's Reference
http://www.wrox.com/WileyCDA/WroxTitle/Access-2010-Programmer-s-Reference.productCd-0470591668.html

Probably ... IF ... I was going to buy one ... it would be:
Microsoft Access 2010 Inside Out by Jeff Conrad and John Viescas - 2 Access MVP's
http://www.amazon.com/Microsoft-Access-2010-Inside-Out/dp/0735626855/ref=sr_1_1?s=books&ie=UTF8&qid=1297549226&sr=1-1

btw ... the Getz book will never really be outdated ...
mx
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
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

0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
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
0
NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

 
Patrick MatthewsAuthor Commented:
MX,

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

Patrick
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
I'm sure you will get more response ... I would be interested to see if anyone has a book they LOVE!

mx
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
There's not a lot out there for 2010, of course. I too like the WROX book (got a copy of it, in fact). It should work pretty well, even for you Excel-type people :)

0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Check out Access for Excel Dummies :-)

mx
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
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
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Oh ... and you have probably seen this:

http://msdn.microsoft.com/en-us/library/ee658205.aspx  (excel)

mx
0
 
Richard DanekeCommented:
The web page base for exploring Access 2010 on the microsoft site is : http://msdn.microsoft.com/en-us/library/ff604965.aspx  and continues to some earlier references.   Of course, a good recommendation would take into account your background and knowledge.  You don't want a book to basic nor to complex for your current developments.
I have always loved the O'Reilly books.  The ...missing manuals, ...hacks, and Access Database: Design & Programming have helped me personally.  With the new features of 2010 using stored macros, working more with SharePoint, and even building WebPages, the new Access 201 Missing Manual explores some new territory.  It is at this link: http://oreilly.com/catalog/9781449382377/
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
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
0
 
ms3930Commented:
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
0
 
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPCommented:
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.
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
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

0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
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
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Actually, I bought the Outlook 2010 Quick Steps, not Plain & Simple.

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

mx
0
 
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPCommented:

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.
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Yeah, that's because Excel is so much easier than Access  ha ha
And everyone thought they could build a database in Excel!

mx
0
 
Patrick MatthewsAuthor Commented:
I ended up purchasing the WROX Access 2010 Programmer's Reference.

There may other purchases in the future :)
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

  • 12
  • 2
  • 2
  • +3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now