Looking for a good Access guide

I’ve been a programmer for many, many years–actually, ever since I still had dark hair and good joints–and I have a lot of experience in many things. One dark spot, however, is MS Access. I’m going to be supporting an area where the vast majority of the work is done in Access 2002. I’m looking for a good, comprehensive text/guide to Access that uses lots of examples, code snippets, and includes a syntax guide for VBA.

Thanks in advance for any insight, recommendations, and/or opinions.