Have you ever wished for an expert to come along and take a look at your work to offer suggestions for improvement? That's the concept behind the analysis tools in Access. They include:
Table Analyzer Wizard Analyzes your table, and splits it into related tables if needed.
Performance Analyzer Checks any object (or multiple objects) in your database that you specify, and recommends suggestions for improving the object. You can implement most suggestions by just clicking a button.
Documenter Provides detailed information about any or all objects in the database.
If you are wondering whether you have too much information in a table, or if you are sure you want to split a table, use the Table Analyzer. ...