What it Normalizing a Table in Access 2007? Normalizing is breaking a table down into it's smallest, most meaning table. For example, if you were handed a database by a less knowledgeable database administrator who lumped all of the data into one table including: Client's data, Orders, Shipping, Employees etc. then you'd want to breakdown, or Normalize the data from one table down into separate tables. For example, the Client's data including their name, address, phone, website would be listed all in one table. The opposite would be to Denormalize. Putting all unrelated data, including fields that may contain occasional blanks into one table.

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