One reason the Access tab may not appear is that your load behaviour is not set correctly. You need to make sure your load behaviour 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.