One reason your Access tab may not appear is down to your load behavior. You want to make sure that your load behavior is set to three.
To do this:
Click Start then search Run.
Click Enter then enter regedit.
Click OK then click Yes.
Select HKEY_CURRENT_USER then select Software.
Select Microsoft then select Office.
Select Excel then select Addins.
Select Access Office Integration For Microsoft Excel <Office Version>.
Check LoadBehavior is set to three.
If not, select LoadBehavior then right-click and select Modify.
In Value Data, enter 3 then click OK.
Click Microsoft Excel and check the Access tab is present.