• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 22. Exploring Relational Databas... > Using Access 2000's Table Analyzer W...

Using Access 2000's Table Analyzer Wizard

Access 2000'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, NewName and Lookup, 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 the Datasheet view of the original table. Thus you need not change the references to TableName in your Access application objects.

See Using Lookup Fields in Tables.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint