What Normalization Means. How To Fix Bad Tables.

In this video we're going to learn about database normalization for Microsoft Access. This is, in a nutshell, making sure that your tables hold the correct types of data to form proper relationships. We will go over some database theory, and then I'll show you how to take a table that holds both customer and order data and normalize it by splitting it into two tables with a proper relationship between them.

Leslie from Harrisonburg, Virginia (a Platinum Member) asks: I'm trying to move my data from Excel to Access. I've watched your video on importing, it was very helpful. Thank you. But what do I do if I've got data mixed together that shouldn't be? For example, I've got one sheet in Excel that mixes customer and order data together. Is there a way to separate it?

Members

Members will look at three more examples of normalizing data. We'll separate customer data by like address fields, we'll take a table that has a parent and multiple children listed together and split that into two tables, and we'll do the same thing for customers with multiple addresses and phone numbers.

•  Extended Cut Video - Silver
•  Database Download - Gold

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today!

Links

• Relationships: https://599cd.com/Relationships
• Importing Data: https://599cd.com/Import
• Append Queries: https://599cd.com/Append
• Separate Names: https://599cd.com/SeparateFirstName
• Separate Emails: https://599cd.com/SeparateEmail
• Text to Columns: https://599cd.com/TextToColumns
• Aggregate Queries: https://599cd.com/Aggregate
• Concatenation: https://599cd.com/Concat
• Helper Data: https://599cd.com/HelperData
• ABCD: https://599cd.com/ABCD

Suggested Courses

• Fixing Non-Relational Data in Access Expert 22: https://599cd.com/ACX22
• Access Expert 1: https://599cd.com/ACX1
• Access Expert 2: https://599cd.com/ACX2
• Relationships: https://599cd.com/RelationshipSeminar

See Also

• Advanced users may be interested in: Denormalize

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, normalization, normal forms, standard, normalized, relationships, key fields, how to normalize data in access, step by step normalization example, separate customers from orders