I just had a look around at some Access VBA books. I would recommend some human interaction, tuition so that you get the “inside story” on why one would use one approach or another as supplement to these books though.
Access 2007 VBA Programmer's Reference (Programmer to Programmer) (Paperback) seems to be a well documented reference.
Automating Microsoft Access with VBA (Business Solutions) (Paperback) by Mike Gunderloy and Susan Sales Harkins is probably Mike’s last book on Access. Comprehensive.
Beginning Access 2007 VBA (Paperback) by Denise Gosnell is more brief.
Access 2007 VBA Programming For Dummies (For Dummies (Computer/Tech)) (Paperback) should have a fair number of tips, but it is not intending to school you in VBA.
Helen Feddema’s Access 2007 VBA Bible: For Data-Centric Microsoft Office Applications (Paperback) appears not so much about Access and VBA but about invoking Outlook, Word, Excel and making them play with Access.
Expert Access 2007 Programming (Programmer to Programmer) (Paperback) is for more esoteric manipulations.