First you need to learn the basics and. The following site offers an online
tutorial for beginners that is quite good. It has 23 easy to understand
lessons and also will take you thru designing a number of basic databases.

http://www.functionx.com/vbaccess/index.htm

You also need to go to your local bookstore and buy a basic primer in Visual
Basic for Applications (VBA.) Be sure and note the "A!"  Visual Basic (VB)
and Visual Basic for Applications (VBA) are not the same!

Once you get your feet wet, come back here and post questions on specific
things you're trying to do or problems you're having, and we'll be glad to
help. Pay special attention to learning the terms and their definitions in
Access. Some of the biggest problems we see here repeatedly are questions
from posters who do not even know enough terminology to state their questions
clearly or understand the answers they get. And always give us an idea of
exactly what it is you're trying to accomplish.

Good Luck!