VBA and Macros

VBA and Macros.Answer each of these questions below. EACH answer MUST be 250 words or more.

1.What situations do you think it would be better to choose Visual Basic for Applications over macros? In conjunction with that, in what situations would you think it would be better to use macros over VBA??
2. Concerning Visual Basic Edition,what are the 2 different types of modules you can create for Access with VBE and where would you use them?