Analyze a Table

Prev Show Me Step-By-Step Next

Get Ready
Determine the name of the table you want to analyze.
Decide if you will let the wizard create the new tables or if you would rather create them yourself.

Begin
Point to Analyze on the Tools menu and then click the Table command.
In a few moments, the Table Analyzer Wizard will display.
Click the Next > button after reading each of the two introductory screens.
Select your table from the list and then click the Next > button.
To let the wizard define values:
Click the Yes, let the wizard decide option.
Click the Next > button.
If necessary, drag and drop fields to modify the wizard’s choices.
To create tables yourself:
Click the No, I want to decide option.
Click the Next > button.
Drag and drop fields to create new tables and to move fields between the tables.
Click each new table and then click the button to define names.
Click the Next > button when you’re done.
Make sure the wizard has correctly identified primary keys. Use the buttons along the top to make any changes.
Click the Next > button when you’re done.
Click the query option that matches your needs.
Click the Finish button.