Added this based on a tip from Maurice Loucel on my YouTube channel. I had "Remove 3rd Party Controls" on there, but I forgot that misbehaving programs could replace Office DLL files:

Sometimes software that you have installed from other 3rd party vendors may replace DLL files that Microsoft Office needs to run properly. This is usually a problem with "independent" software authors, shareware, etc. Try removing any non-Microsoft software from the machine. You may need to reinstall Office after removing the offending program to put the proper DLL back. If you are going to go so far as reinstalling Windows (see below) then I would suggest install a fresh copy of Windows and then a fresh copy of Office (Access) before you install anything else. This will definitely determine if it's a 3rd party software conflict.