By Richard Rost 22 months ago
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 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.
Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the database template from class plus get access to the Code Vault. If you signed up on YouTube you have to register on my YouTube Find User page so I can set up your account here on my web site. If you're not a member, Join Today!
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
Subscribe to Normalizing Data
Get notifications when this page is updated