Normalizing Data in Microsoft Access Databases. What Normalization Means. How To Fix Bad Tables.
ฝัง
- เผยแพร่เมื่อ 10 ก.พ. 2022
- 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 ...
BECOME A MEMBER:
TH-cam: / @599cd
or My Site: 599cd.com/THMember
LEARN MORE:
599cd.com/Normalizing
LINKS:
Relationships: 599cd.com/Relationships
Importing Data: 599cd.com/Import
Append Queries: 599cd.com/Append
Separate Names: 599cd.com/SeparateFirstName
Separate Emails: 599cd.com/SeparateEmail
Text to Columns: 599cd.com/TextToColumns
Aggregate Queries: 599cd.com/Aggregate
Concatenation: 599cd.com/Concat
Helper Data: 599cd.com/HelperData
ABCD: 599cd.com/ABCD
SUGGESTED COURSES:
Access Expert 1: 599cd.com/ACX1
Access Expert 2: 599cd.com/ACX2
Relationships: 599cd.com/RelationshipSeminar
OTHER COURSES:
FREE Access Beginner Level 1: 599cd.com/Free1
$1 Access Level 2: 599cd.com/1Dollar
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: 599cd.com/THFree
Blank Template: 599cd.com/Blank
Contact Management: 599cd.com/Contacts
Order Entry & Invoicing: 599cd.com/Invoicing
More Access Templates: 599cd.com/AccessTemplates
ADDITIONAL RESOURCES:
Donate to my Tip Jar: 599cd.com/TipJar
Get on my Mailing List: 599cd.com/YTML
Contact Me: 599cd.com/Contact
TechHelp: 599cd.com/TechHelp
Consulting Help: 599cd.com/DevNet
Twitter: / learningaccess
en.wikipedia.org/wiki/Microso...
products.office.com/en-us/access
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.
Thank you so much. Very Informative video.
You're very welcome
Hi Richard, I consider myself an advanced user of Access, but I have learned so much more by watching your videos - very informative. I have one question though. Instead of making ID fields or calculated fields grey, why not just go to the property of the field and just make it "Enabled = No" this will automatically make it grey as well as stop people from clicking into it?
That's definitely one way to do it. I started making them gray because I can show that to an absolute beginner and they'll get it easier than if I have to explain enabled, locked, and those other properties.
I agree the Customer name can be both F & L, but recommend a drop-down (able to add name) field in an entry form
Cool
THANK YOU
Welcome, again
Hello, I have an exam tomorrow morning, but a quick question. Will my queries still work even if my relationships and normalization aren't correct?
Garbage in, garbage out
Can u please make videos about reports
Got lots of them... 599cd.com/search/?Q=report
Hi Richard,
I'm regular viewer of your channel, and it helps me know more about Access. Really appreciate, Thank you very much for your efforts.
Today, I have a question to you.
I'm working on a database which manages documents and its revisions.
I have number of tables that situated in the backend database file. And linked to Frontend database (Thanks again, I learned this from you)
"tblProjects" is one among them.
In the front-end database, when I try to add a existing field to a form (any form) I noticed that, there is a table in the "Field List" panel, its name start with ~. full name is ~TMPCLP552612.
It contain the same information from the table "tblProjects"
I couldn't see this in Back-end database file nor in the linked table list in Frontend database. Also couldn't delete this table.
The only thing I can able to do is to click on the "Edit Table" next to this table name (at "Field List" panel).
That will take me to a new window of datasheet view, there I can add new records, the same records then shows in the "tblProjects".
Also, when I try to enter "design view" there I a warning message says " Table ~TMPCLP552612 is a linked table whose design can't be modified... "
Also I noticed that, when we enter into "Linked Table Manager" and try to refresh the link, there is a warning message shows,
" tblProjects is not a valid name, Make sure that it dose not include invalid characters or punctuation and that it is not too long"
So, My question is, why this happened?
How this will affect my database in future?
How we can delete this without any problem?
Thanks Richard, Thanks my instructor.
Sorry dude... TLDR... I get thousands of comments. Shorten it up.
Liked. How to use google translate in ms access
Sorry - That is not supported between the two programs.
Haven't tried