If I was allowed only one book about Microsoft Access, This is the one, Fixing Access Annoyances by Phil Michell and Evan Callahan. Just their discussion about Access’ workgroup security is worth the price of the book. They cover mostly Access 2000-2003, with a few notes regarding Access 97. The book includes a fair amount of VBA code, which can also be downloaded from their web site.
The book covers a lot of ground and includes internet resources. One of the best of these remains the community web site, UtterAccess.