VBA is much preferred over macro's; best way would be to get a book on the subject. I have Sams "Teach Yourself Access 2002 Programming" which is a good introduction. Once you have started, and know the basics, you will find it much easier to find answers to your questions in this forum, rather than starting with no knowledge.
However, as a start now, you can play with macros (very easy, its all in drop down lists) and then convert to modules to see how they work.