An easy way to learn VBA is by making macros in MS Access and convert them to VBA. As the making of macros is quite staight forward. For the macros of course you need to understand the expression builder which is quite similar to the formulas in Excel (for which you are well assisted by the fx wizard.
I would suggest taking a look at this ADO tutorial at a sister site.
"Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
"I have my standards. They may be low, but I have them!" - Bette Middler
"It's a book about a Spanish guy named Manual. You should read it." - Dilbert