I'm looking to purchase a good book for beginner Access as well as more advanced features. I was curious if there were any recommendations? I'm looking for something besides the "Access for Dummies" suggestion.
I would recommend Access 2007 Inside/Out by Jeff Conrad and John Viescas. It is good for beginners as well as for more advanced and it has a wealth of reference material.
Also, for learning, I would suggest the Access and Access VBA tutorials on http://www.functionx.com