Using the Table Analyzer Wizard
Even if you use good design techniques (see Article 1, “Designing Your Database Application” on the companion CD) 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 2007 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.
One of the key elements of good database design is the elimination of redundant data. The Table Analyzer Wizard is particularly ...
Get Microsoft Office® Access 2007 Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
