Just a quick post as I don't have much time:
I don't see that there are any pros and cons when comparing them to each other.
I see Access as a data storage and reporting tool, Excel as an analysis tool, and VB as a development tool. Each incorporates aspects of the other but it depends on what you are ideally looking to produce as an end result.