WOW! This is the BEST explanation of the "SO WHAT" for Access. I've been having a difficult time trying to figure out the Relational aspect, particularly in regards to the "Normalization" of the database. This is FANTASTIC.
@lfriedrichsen3 жыл бұрын
Well thank YOU for taking the time to leave such a positive and encouraging comment. Sincere gratitude is highly underrated!! :)
@Corbandallasyo2 жыл бұрын
I agree. Your videos are a fantastic resource for those of us who are just starting out. Thank you very much for taking the time out of your day to put these together!
@Aixatem2 жыл бұрын
I've been watching this video to understand access database better for my class. Now I'm giving my exam on it. Thanks to you, I feel more confident about it!
@lfriedrichsen2 жыл бұрын
Great to hear!
@greenhoodie3 жыл бұрын
This was very well explained, thank you. This has helped me understand the depth of thought needed when planning out a db before you even start!
@zachbiderman1115 Жыл бұрын
Lisa you are making me better at my job and I appreciate you!!!
@lfriedrichsen Жыл бұрын
Thank you! See all of my KZfaqs organized at learncs.w3spaces.com
@emmieHD3 жыл бұрын
Great video! It explained relationships clearly and concisely with great examples that answered the question I had. Thank you!
@lfriedrichsen3 жыл бұрын
You're very welcome!
@FirstLast-cb2jr Жыл бұрын
Another excellent video: I’m glad That KZfaq found you for me!!
@lfriedrichsen Жыл бұрын
Tysm. See all of my KZfaqs organized at learncs.w3spaces.com
@aftabsmerchant13 жыл бұрын
We are looking forward for more on Acces from you, Especially explain the making of Northwind
@lfriedrichsen Жыл бұрын
I just started a new playlist based on the northwind database!
@lfriedrichsen Жыл бұрын
See all my youtubes organized at learncs.w3spaces.com/
@harrynickel86912 жыл бұрын
Thanks. This video helped fill in some holes.
@lfriedrichsen2 жыл бұрын
Welcome!
@mehranbarahouei234627 күн бұрын
Very helpful ❤❤❤
@lfriedrichsen20 күн бұрын
Thanks for the nice comment!! See all of my KZfaqs organized at learncs.w3spaces.com
@s9malik2 жыл бұрын
thank you so much this helps me a lot 💖🤝
@lfriedrichsen Жыл бұрын
You're welcome! You can find all of my KZfaqs organized at learncs.w3spaces.com/
@s9malik Жыл бұрын
@@lfriedrichsen Okay
@kunxuan92 Жыл бұрын
Thanks so much for the succient yet clear explanation, i want to study the Northwind database, and checked the link, but it does not work, i could not download the file. can you please kindly share the file with me? 🥰
@lfriedrichsen Жыл бұрын
Thanks! This web page tells you how to download the Northwind database through the templates feature. learn.microsoft.com/en-us/dotnet/framework/data/adonet/sql/linq/downloading-sample-databases
@coldguy Жыл бұрын
This guy is legend
@lfriedrichsen Жыл бұрын
Ty! See all of my KZfaqs organized at learncs.w3spaces.com
@coldguy Жыл бұрын
Thanks
@erinkavanagh3553 Жыл бұрын
Thank you
@lfriedrichsen Жыл бұрын
You're welcome! You can find all of my KZfaqs organized at learncs.w3spaces.com/
@moodkn2 жыл бұрын
Great way Thank you Madam!
@lfriedrichsen Жыл бұрын
You're welcome! You can find all of my KZfaqs organized at learncs.w3spaces.com/
@mividalocastudio93662 жыл бұрын
Amazing video. However, I have a question... How is the ShipperID (primary) key in Shippers table linked to a ShipVia as a 1 to many relationship in the Orders Table, when the ShipID and ShipVia names do not match? I thought they always had to match like SupplierID (primary) in Supplies Table to SupplierID (many) in Products Table. What am I missing? LOL
@lfriedrichsen2 жыл бұрын
Very observant! The fields used in a one-to-many relationship do not have to have the same field name as you pointed out. It is common to give them the same name, but not technically required.
@mividalocastudio93662 жыл бұрын
@@lfriedrichsen Oh ok that’s very cool. Thank you for sharing your knowledge!
@tOnK6664 ай бұрын
I was about to ask :) thanks
@sheikhraisulislam44832 жыл бұрын
thank u mam. it was really helpful
@lfriedrichsen Жыл бұрын
You are welcome! See a listing of all of my KZfaqs at learncs.w3spaces.com
@kawtheralateeq82642 жыл бұрын
Thank you .. ❤️❤️👍🏼
@lfriedrichsen Жыл бұрын
You're welcome! You can find all of my KZfaqs organized at learncs.w3spaces.com/
@deholovi9 ай бұрын
I'm stuck with sub datasheet view! for example, I've 3 separate tables. wanna relate them with one junction table. say, number 2 table has a common field ( could be described as the master field ), which is related to two other fields. one from number 1 table and another from number 3 table. after creating the relationship, when u press the " + " sign of the sub datasheet view, " insert sub datasheet " dialogue box appears! why so? I just wanna see related fields to that particular field. why that doesn't happen?
@lfriedrichsen9 ай бұрын
Subdatasheets show the "many" records related to "one" record in the table you are viewing in Table Datasheet View. So only the table on the "one" side of the relationship will have the ability to show a subdatasheet.
@lfriedrichsen9 ай бұрын
If you're getting the "Insert Subdatasheet" dialog box it means that you're viewing a table on the "one" side of a "one-to-many" relationship to more than one other table...so you have to choose which table's records to view in the subdatasheet.
@deholovi9 ай бұрын
thank you for replying
@easyspeak1012 жыл бұрын
I thought the middle link table was the 1-side of the other two connecting tables. Creating effectively two joined many:1 tables that make up a many to many relationship.. ?
@lfriedrichsen2 жыл бұрын
No. If two tables have a many-to-many relationship then you model that with a junction table that is on the MANY side of a 1-to-many relationship with the two original tables in a many-to-many relationship. Go to the 4:12 minute mark in this KZfaq to see how many-to-many relationships are resolved with a junction table. Products and Orders have a many-to-many relationship that is resolved with the Order Details table. One product can be ordered many times and one order can have many products. Note that the Order Details table is on the MANY side of the relationship to both Products and Orders. Another example is the Customers and Shippers tables. They too have a many-to-many relationship that is resolved with their one-to-many relationships to the common Orders table.
@johnnychin9598 Жыл бұрын
i need help, i have item say tshirt size small, but the price varies with different customer. say customer A, the tshirt small is US2.0, IF customer B the price its US 3.0, and tshirt medium for customer A is US4.0 AND US5.0 FOR CUSTOMER B. how do i make the table for this scenario
@lfriedrichsen Жыл бұрын
You'll need a Sales table with a field for the actual price per sale. Customers table has a one-to-many with Sales. Inventory table has a one-to-many with Sales. And you can even have a suggested/regular sales price field in the Inventory table. But the Sales table must have a field to record the actual price given you're telling me that the price may be different for each sale.
@lfriedrichsen Жыл бұрын
My KZfaqs on table relationships should be of value here. All of my KZfaqs are organized at learncs.w3spaces.com
@kawtheralateeq82642 жыл бұрын
If I have questions where can I ask you ?
@lfriedrichsen2 жыл бұрын
If it's a short question that I can answer here, I will.