What does it mean to normalize our Access 2007 database? Normalization means to break down a database, that was improperly built, into its smallest most meaning parts or tables. As Tables make up the foundation of any Access database. For example, a poorly designed database will have the person's name as one field, instead of normalizing the name into two field i.e. First Name and Last Name. In other words, having all your data in one field is very inefficient i.e. name, address, sales, order... Now think breaking that into separate fields and then breaking that out into separate tables i.e. a table for Orders, Customers, Order Details, Shipping and more!

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