The FunctionX site posted by orange is the site I always give, in answer to this type of question about learning VBA. It is well written and divided into 25 or 30 clearly titled chapters.
As to the 2007 vs 2010 thing, VBA code, per se, has really changed very little over the years. The differences between versions primarily relates to new functionality/features, rather than VBA code.
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007