Hi,
I'll provide you with this link:
http://www.allenbrowne.com/links.html this could be your start page for looking what suites you most.
The second link is from the same site where you'll also find links to tutorials (by crystal) very good!
http://www.allenbrowne.com/tips.html
This is the link for the official step by step book (with practice labs on cd)
http://www.amazon.com/Microsoft-Office-Access-2007-Step/dp/0735623031/ref=sr_1_1?ie=UTF8&s=books&qid=1276669782&sr=8-1
and finally this is a link to all vba books about Access 2007 VBA - there's a lot to choose from but the 2007 inside out series is a good one to start.
http://www.amazon.com/s/ref=nb_sb_ss_i_1_12?url=search-alias%3Dstripbooks&field-keywords=access+2007+vba&sprefix=access+2007+
(also add the plus sign in the link)
Final comment: for MOS Certification you don't need to know VBA that exam is application based so no programming required!
hth
Maurice
