Our Total Access Analyzer program performs extensive analysis on Access databases. It detects over 300 types of errors, design suggestions, and performance improvements. Among the things it detects are recommendations for improving tables and queries which may improve query performance.
A list of things it finds is here: http://www.fmsinc.com/MicrosoftAccess/Documentation/ErrorsList.html
with Performance Tips in this section: http://www.fmsinc.com/MicrosoftAccess/Documentation/ErrorsList.html#Performance_Tips
Beyond Total Access Analyzer, our consulting team often engages clients to improve the design and performance of their Access applications. Many issues can't be resolved by simply running it through a static documenter like Total Access Analyzer. It requires someone who understands Access to review the specific issue and try alternative approaches to improve it. We do this all the time.