Listmania!
excellent Microsoft Access books
By an Amazon.com customer
Accessible Access 2003Accessible Access 2003 by Mark Whitehorn
Buy new: $34.16 / Used from: $10.72
should be everyone's first MS Access book
Inside Relational Databases with Examples in AccessInside Relational Databases with Examples in Access by Mark Whitehorn
Buy new: $37.96 / Used from: $17.35
required background material
Microsoft Access 2.0Microsoft Access 2.0
Buy used from: $71.00
excellent manuals back in the day when software actually had proper documentation.
Microsoft Jet Database Engine Programmer's Guide (Microsoft Professional Editions)Microsoft Jet Database Engine Programmer's Guide (Microsoft Professional Editions) by Dan Haught
Buy used from: $15.42
for programmers. Covers the older DAO object model but still very useful. There are some things that must be done in DAO because ADO lacks full features
Access 2002 Desktop Developer's HandbookAccess 2002 Desktop Developer's Handbook by Paul Litwin
Buy new: $37.79 / Used from: $1.17
an advanced book. any MS Access book by Litwin and Getz is bound to be excellent.
Access 2002 Enterprise Developer's Handbook(tm)Access 2002 Enterprise Developer's Handbook(tm) by Paul Litwin
Buy used from: $1.11
Access Cookbook, 2nd EditionAccess Cookbook, 2nd Edition by Andy Baron
Buy new: $32.97 / Used from: $25.94
co-authors are Litwin and Getz. read this book to generate ideas on how to use Access in new and interesting ways.
Case*Method: Entity Relationship ModellingCase*Method: Entity Relationship Modelling by Richard Barker
Buy used from: $0.01
more required background material
Access Database Design & Programming (3rd Edition)Access Database Design & Programming (3rd Edition) by Steven Roman
Buy used from: $5.89
written by a math prof. It provides the basic theory such as you'd find in a 300 level (ie junior) comp. sci course at university.
Access 2007 GuidebookAccess 2007 Guidebook by Maggie Trigg
Buy new: $91.40 / Used from: $55.00
a very good intro book. As opposed to most 'telephone' books on Access this one actually emphasizes the most important and relevant topics to get you started.
Access 2003 Guidebook for Office XP (5th Edition)Access 2003 Guidebook for Office XP (5th Edition) by Maggie Trigg
Buy used from: $14.00
previous edition
Fixing Access Annoyances: How to Fix the Most Annoying Things About Your Favorite Database (Annoyances)Fixing Access Annoyances: How to Fix the Most Annoying Things About Your Favorite Database (Annoyances) by Phil Mitchell
Buy new: $13.59 / Used from: $6.74
Microsoft Access Data Analysis: Unleashing the Analytical Power of AccessMicrosoft Access Data Analysis: Unleashing the Analytical Power of Access by Michael Alexander
Buy new: $26.39 / Used from: $18.95
for power users (i.e. non-programmers) on how to manipulate your data with queries. very important stuff
Access Data Analysis Cookbook (Cookbooks)Access Data Analysis Cookbook (Cookbooks) by Ken Bluttman
Buy new: $31.49 / Used from: $4.17
Implementing Databases in Oracle 9iImplementing Databases in Oracle 9i by John Day
Buy used from: $73.23
not an Access book. If you want to graduate to Oracle read this first. covers the basics very well.
Design and Use of Relational Databases in ChemistryDesign and Use of Relational Databases in Chemistry by TJ O'Donnell
Buy new: $121.39
OK, so it's not directly on the topic of MS Access. But if you have an interest in storing and searching for chemical structures in relational databases this is the only game in town (besides scientific journal articles).