I am currently trying to add a connection to my existing access database that I have in place which contains all of the data that I need. When I am attempting to add multiple tables the joining process is very cumbersome. All of the joins are already incorporated when I review the relationships in Access. Is there an easier way to import the data that I am missing?
Unless you create a view in Access which contains all your joined tables and import that into Tableau, you'll have to tell Tableau what to join and how to join it. Personally , I'd just bite the bullet, go the "multiple tables" route, and redefine the joins.