Normalizing Data in Microsoft Access Databases. What Normalization Means. How To Fix Bad Tables.

[@JamesOkelloOkowa]

Thank you so much. Very Informative video.

[@599CD]

You're very welcome

[@darrenbarson3828]

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?

[@599CD]

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.

[@9856CB]

I agree the Customer name can be both F & L, but recommend a drop-down (able to add name) field in an entry form

[@599CD]

Cool

[@rahezashareen5198]

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?

[@599CD]

Garbage in, garbage out

[@jackgray4777]

Can u please make videos about reports

[@599CD]

Got lots of them... 599cd.com/search/?Q=report

[@abdulhamidalhaddadi2255]

THANK YOU

[@599CD]

Welcome, again

[@akterhossain9548]

Liked. How to use google translate in ms access

[@scottaxton2513]

Sorry - That is not supported between the two programs.

[@599CD]

Haven't tried

[@heynid]

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.

[@599CD]

Sorry dude... TLDR... I get thousands of comments. Shorten it up.