I've used three Access books:
Beginning Access 2000 VBA by Smith and Sussman - this just concentrates on
VBA and I found it really useful. If it's mainly VBA that you want then I'd
definitely recommend it.
The Access 2000 Developers' Handbook - this must be the best Access book
around, and includes several code examples that you can include in your own
databases.
Access 2000 Development Unleashed. This is aimed at Access developers and
assumes a fair bit of prior knowledge.
I would recommend the first two of these books without hesitation. The third
is OK, but the Access Developers Handbook is aimed at a similar audience and
I felt that it went into more detail and was better written. The one that's
right for you will depend on your current knowledge