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.
Follow these steps to check and correct your load behavior:
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.