Microsoft® Office Access 2003 Inside Out

Using the Table Analyzer Wizard

Even if you follow all the recommendations in Chapter 3, and build a normalized database, you might not arrive at the best design. In fact, you often cannot fully evaluate a database design until you use the database and store data. Access includes the Table Analyzer Wizard that can examine data in your tables (or data you import from another source) and recommend additional refinements and enhancements to your database design.

You’ll recall from Chapter 3 that one of the key elements of good database design is the elimination of redundant data. The Table Analyzer Wizard is particularly good at scanning data in your tables, identifying data repeated in one or more columns, and recommending alterations to your design ...