Welcome
Umpire!
here are 2 more links you can add:
Access Basics
http://www.accessmvp.com/strive4peace
Free 100-page book that covers essentials in Access
Learn VBA
http://www.accessmvp.com/strive4peace/VBA.htm
However, as mentioned, VBA itself isn't difficult -- learning the object model is what takes a lot of time!
press F2 in a code window to View the Object Browser
or, from the menu --> View, Object Browser
change the library to "VBA" (for instance, instead of <all libraries>) and look at the classes (categories) of functions -- click on a class and then click on a function in the right pane. To get the help for that function, press F1
The VBA library is the most basic library and a great place to start exploring.
to lookup properties and methods for different objects like forms, tabledefs, etc, change the library to Access
for recordsets, try the DAO library
explore the different libraries you have to pick from and see what is available in each
when you are in the Object Browser window, the library that each function/class is a member of is shown in the lower left corner of the window
the Object Browser is a GREAT way to learn
when you have an object selected, press F1 to get help. (also when you press F1 in code on a keyword, you go to Help)
~~~
The VBA code posted here has explanations and links to relevant Microsoft help, so it also would be a good way to learn.
http://msaccessgurus.com/code.htm
I started using Access almost 3 decades ago ... and am still learning! It is a powerful application you can do a lot with!