Hi Michael! There are a number of factors to consider. I've included links to a few great articles that will help you weigh the pros and cons:
Hope this helps,
In theory it doesn't matter whether you write a query in Access and connect to that, or construct everything directly in Tableau. In practice, the Access query engine can be a bit temperamental at times and you might see different performance each way. If you do everything in Tableau you can more easily change the visualization later.