Normalizing Data in Microsoft Access Databases. 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?

Silver Members and up get access to an Extended Cut of this video. 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.

MEMBERS VIDEO:
   • Normalizing Microsoft Access Data - M...  

BECOME A MEMBER:
YouTube:    / @599cd  
or My Site: https://599cd.com/THMember

LEARN MORE:
https://599cd.com/Normalizing

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:
Access Expert 1: https://599cd.com/ACX1
Access Expert 2: https://599cd.com/ACX2
Relationships: https://599cd.com/RelationshipSeminar

OTHER COURSES:
FREE Access Beginner Level 1: https://599cd.com/Free1
$1 Access Level 2: https://599cd.com/1Dollar

FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: https://599cd.com/THFree
Blank Template: https://599cd.com/Blank
Contact Management: https://599cd.com/Contacts
Order Entry & Invoicing: https://599cd.com/Invoicing
More Access Templates: https://599cd.com/AccessTemplates

ADDITIONAL RESOURCES:
Donate to my Tip Jar: https://599cd.com/TipJar
Get on my Mailing List: https://599cd.com/YTML
Contact Me: https://599cd.com/Contact
TechHelp: https://599cd.com/TechHelp
Consulting Help: https://599cd.com/DevNet
Twitter:   / learningaccess  
https://en.wikipedia.org/wiki/Microso...
https://products.office.com/en-us/access
https://microsoft.com/en-us/microsoft...

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

QUESTIONS:
Please feel free to post your questions or comments below. Thanks.