O'Reilly logo

Ten Minute Guide to Access 97 by Faithe Wempen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Introducing the Analysis Tools

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. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required