Article ID: 140636 - View products that this article applies to.
This article was previously published under Q140636
This article has been archived. It is offered "as is" and will no longer be updated.
Novice: Requires knowledge of the user interface on single-user computers.
The Table Analyzer Wizard can help you create a relational database from a set of data. By using the Table Analyzer Wizard, you do not have to know relational database design principles. This article explains how the Table Analyzer Wizard deciphers a single-table database and proposes a way of splitting the original table into a set of related tables.
The Table Analyzer Wizard can automatically analyze a non-relational database and "normalize" it for you. Normalization is the process of taking a single-table database and breaking it into a set of smaller, related tables, with each table focused on a single topic or grouping of information.
A normalized, relational database has a number of advantages over a nonrelational one. First, updating information is faster and easier because fewer data changes are required. Second, only the minimum information is stored; therefore, the database is smaller in size. Finally, a relational database keeps data consistent automatically because data is stored once.
Although the Table Analyzer Wizard can help you create a relational database, if you have database experience, the Table Analyzer Wizard enables you to modify any suggestions it makes. You can split up tables, rearrange fields in tables, and create relationships between tables. You can modify Table Analyzer Wizard decisions during every step of the database-creation process.
How to Run the Table Analyzer WizardTo run the Table Analyzer Wizard, follow these steps:
How the Table Analyzer Wizard WorksIf you choose to let the Table Analyzer Wizard split a database, the Table Analyzer Wizard runs through the following process:
For more information about the Table Analyzer Wizard, search the Help Index for "Table Analyzer," or ask the Microsoft Access 97 Office Assistant.
Article ID: 140636 - Last Review: September 27, 2013 - Revision: 3.1