Article ID: 208679 - View products that this article applies to.
This article was previously published under Q208679
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.
This article applies only to a Microsoft Access database (.mdb).
For a Microsoft Access 2002 version of this article, see 292799
The Table Analyzer Wizard can help you create a relational database from a set of data. When you use 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 nonrelational 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, click Microsoft Access Help on the Help menu, type split a table into related tables using the table analyzer wizard in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.