O'Reilly logo

Special Edition Using Access 97, Second Edition by Roger Jennings

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

Using Access 97's Table Analyzer Wizard

Access 97's Table Analyzer Wizard detects cells containing repeated data in table columns and proposes to create two new related tables to eliminate the repetition. This wizard uses Access 97's Lookup Wizard, described in Chapter 10, "Creating Multitable and Crosstab Queries," to create the relationship between the two new tables. After the wizard creates the new related tables, tblNewName and tlkpLookup, your original table is renamed to TableName_OLD, and the wizard creates a one-to-many INNER JOIN query named TableName to return a result set that duplicates Datasheet view of the original table. Thus, you need not change the references to TableName in your Access application objects.

◂◂ See "Using Lookup ...

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