The Microsoft Press Step-by-Step books are a good starting point for
complete beginners. Beyond that, for comprehensive books that cover just
about everything about Access, look for books by John Viescas and Roger
Jennings. For books specifically about programming, start with the Wrox
Press book already mentioned. I have the Access 97 edition and liked it a
lot. I have not read the Access 2000 edition, but it is by the same authors.
The Access 2003 edition is by a different author, I don't know about that
one. For more advanced programming books, look for books by Rick Dobson (I
prefer his Access 2002 book, the Access 2003 book is a different book not
just a new edition) and the Access 2002 Developers Handbook, by Ken Getz et
all. For database design, look for Access Database Design and Programming,
by Steven Roman. For database design, user interface design, requirement
analysis and lots of other good stuff, look for 'Designing Effective
Database Systems', by Rebecca Riordan.
Elsewhere in this thread you mentioned that you are interested in learning
to automate other Office apps. If you're interested in learning to program
Excel, look for books by John Green and Stephen Bullen.