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

Chapter 5. Working with Jet Databases an... > Using the Table Analyzer Wizard

Using the Table Analyzer Wizard

Access 2003’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 the Lookup Wizard, described in Chapter 11 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. So, you need not change the references to TableName in your Access application objects.

The Lookup table must have a valid primary-key field to provide unambiguous association of a single record in the Lookup table with a foreign key field in the NewName table. One of the problems associated with repetitious data is data-entry errors, such as occasional misspelling of a company name or an address element in Lookup. The Table Analyzer Wizard detects and displays instances of minor mismatches in repeated cell values, such as a missing apostrophe, for correction. If such errors aren’t corrected, the Lookup table includes spurious, almost-duplicate entries that violate the rules of table normalization.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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