SQL is delicious (5/9/2014)
Years ago, there was a book about marrying SQL and Access database programming but it was written for the 2000 versions and I don't know if it was ever updated. It was a fantastic resource for me but perhaps a bit out of date for your needs
One of the most valueable I ever found is called "Hitchhicker's Guide to Visual Basic & SQL Server", by William R. Vaughn (Microsoft Press ISBN 1-57231-567-9) It's an old book (1997) but one full of info and tricks to marry VB/VBA and SQL Server that are still usable today.