Analyzing your table for redundant structure


show more Analyzing your table for redundant structure provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Power Shortcuts show less
please wait ...

Analyzing your table for redundant structure

If you're new to Databases and are just beginning to understand how to construct a Relational Database, you may have created a table that has what's called redundancy, in other words, you may be unnecessarily having to type in the same data repeatedly, instead of creating relationships between separate tables. Let me show you what I mean. Open up this Order table. In it I see multiple orders from the same customer and I've had to type in their address repeatedly, this even opens me up to typos. If I scroll over to the right hand side, I can see my Orders and the Product IDs, but then I've written in the Product name and the Size many times.

If you watch our Access 2010 Essential Training course, we go to detail into how to properly design your Database to prevent this, but at the moment, here I am with redundancy, and I want to fix it. This process is called Normalization. To normalize my database, go to the Database tools ribbon and then click on Analyze Table. This wizard ...

Analyzing your table for redundant structure
Video duration: 5m 50s 3h 43m Intermediate

Viewers:

Analyzing your table for redundant structure provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Power Shortcuts

Subject:
Business
Software:
Access
Author:
please wait ...