Feddama's new text at wrox.com (&for me then amazon.com), have been great for me for about a month. It is tutorial, parallel, building on Northwind.
Also, Dobson's Core Reference @ Microsoft Press, but it is deep.
I'm real new to Access although ten years ago I did learn a good measure of "C" writing small Windows programs. So far I don't understand and am not bothering with all that macro nonsense.
Also, if you live near a good local library, check that out --it beats spending lots
on lots of books. (The two I mentioned ran $66 delivered)