Article ID: 292799 - View products that this article applies to.
This article was previously published under Q292799
Novice: Requires knowledge of the user interface on single-user computers.
This article applies only to a Microsoft Access database (.mdb) or a Microsoft Office Access 2007 database (.accdb).
For a Microsoft Access 2000 version of this article, see 208679
For a Microsoft Access 97 version of this article, see 140636
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. 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: