What is the Table Analyzer in Access 2007, and how does it help cleaning up a previously owned Access database? The Table Analyzer Wizard is used to restructure and organize improperly designed tables with data, by creating new tables that adhere to normalization standards. Where Normalization is the breaking down of tables of data, down into the smallest, most meaning parts; and can be Normalized down into a three phase "Normal Form" process: First Normal Form, Second Normal Form and obviously last but not least Third Normal Form. You can see how simple this is by clicking on the link down below and purchasing or Certified Access 2007 training videos!

Purchase the training video and you can see this in action for yourself!