Microsoft Access A to Z: Designing Table Relationships

Поделиться
HTML-код
  • Опубликовано: 7 ноя 2024

Комментарии • 56

  • @bluesmaster1005
    @bluesmaster1005 3 года назад +12

    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.

    • @lfriedrichsen
      @lfriedrichsen  3 года назад +3

      Well thank YOU for taking the time to leave such a positive and encouraging comment. Sincere gratitude is highly underrated!! :)

    • @Corbandallasyo
      @Corbandallasyo 3 года назад +2

      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!

  • @Aixatem
    @Aixatem 2 года назад +3

    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!

  • @greenhoodie
    @greenhoodie 3 года назад +7

    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
    @zachbiderman1115 Год назад +1

    Lisa you are making me better at my job and I appreciate you!!!

    • @lfriedrichsen
      @lfriedrichsen  Год назад +2

      Thank you! See all of my RUclipss organized at learncs.w3spaces.com

  • @emmieHD
    @emmieHD 3 года назад +2

    Great video! It explained relationships clearly and concisely with great examples that answered the question I had. Thank you!

  • @FirstLast-cb2jr
    @FirstLast-cb2jr Год назад +1

    Another excellent video: I’m glad That RUclips found you for me!!

    • @lfriedrichsen
      @lfriedrichsen  Год назад +2

      Tysm. See all of my RUclipss organized at learncs.w3spaces.com

  • @aftabsmerchant1
    @aftabsmerchant1 3 года назад +1

    We are looking forward for more on Acces from you, Especially explain the making of Northwind

    • @lfriedrichsen
      @lfriedrichsen  Год назад

      I just started a new playlist based on the northwind database!

    • @lfriedrichsen
      @lfriedrichsen  Год назад

      See all my youtubes organized at learncs.w3spaces.com/

  • @kunxuan92
    @kunxuan92 Год назад +1

    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
      @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

  • @deholovi
    @deholovi 11 месяцев назад +1

    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?

    • @lfriedrichsen
      @lfriedrichsen  11 месяцев назад +1

      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.

    • @lfriedrichsen
      @lfriedrichsen  11 месяцев назад +1

      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.

    • @deholovi
      @deholovi 11 месяцев назад +1

      thank you for replying

  • @mividalocastudio9366
    @mividalocastudio9366 2 года назад +3

    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

    • @lfriedrichsen
      @lfriedrichsen  2 года назад +1

      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.

    • @mividalocastudio9366
      @mividalocastudio9366 2 года назад +1

      @@lfriedrichsen Oh ok that’s very cool. Thank you for sharing your knowledge!

    • @tOnK666
      @tOnK666 7 месяцев назад

      I was about to ask :) thanks

  • @harrynickel8691
    @harrynickel8691 2 года назад +1

    Thanks. This video helped fill in some holes.

  • @coldguy
    @coldguy Год назад +1

    This guy is legend

    • @lfriedrichsen
      @lfriedrichsen  Год назад

      Ty! See all of my RUclipss organized at learncs.w3spaces.com

    • @coldguy
      @coldguy Год назад +1

      Thanks

  • @s9malik
    @s9malik 3 года назад +2

    thank you so much this helps me a lot 💖🤝

    • @lfriedrichsen
      @lfriedrichsen  Год назад +1

      You're welcome! You can find all of my RUclipss organized at learncs.w3spaces.com/

    • @s9malik
      @s9malik Год назад

      @@lfriedrichsen Okay

  • @johnnychin9598
    @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
      @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
      @lfriedrichsen  Год назад

      My RUclipss on table relationships should be of value here. All of my RUclipss are organized at learncs.w3spaces.com

  • @kawtheralateeq8264
    @kawtheralateeq8264 3 года назад

    If I have questions where can I ask you ?

    • @lfriedrichsen
      @lfriedrichsen  3 года назад

      If it's a short question that I can answer here, I will.

  • @easyspeak101
    @easyspeak101 3 года назад

    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.. ?

    • @lfriedrichsen
      @lfriedrichsen  3 года назад +2

      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 RUclips 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.

  • @sheikhraisulislam4483
    @sheikhraisulislam4483 2 года назад +1

    thank u mam. it was really helpful

    • @lfriedrichsen
      @lfriedrichsen  Год назад

      You are welcome! See a listing of all of my RUclipss at learncs.w3spaces.com

  • @mehranbarahouei2346
    @mehranbarahouei2346 3 месяца назад

    Very helpful ❤❤❤

    • @lfriedrichsen
      @lfriedrichsen  3 месяца назад +1

      Thanks for the nice comment!! See all of my RUclipss organized at learncs.w3spaces.com

  • @moodkn
    @moodkn 2 года назад +1

    Great way
    Thank you Madam!

    • @lfriedrichsen
      @lfriedrichsen  Год назад

      You're welcome! You can find all of my RUclipss organized at learncs.w3spaces.com/

  • @usmanyousaf9102
    @usmanyousaf9102 3 года назад

    i want some information about Ms access

    • @lfriedrichsen
      @lfriedrichsen  3 года назад +2

      www.microsoft.com/en-us/microsoft-365/access/?rtc=1

  • @erinkavanagh3553
    @erinkavanagh3553 Год назад +1

    Thank you

    • @lfriedrichsen
      @lfriedrichsen  Год назад

      You're welcome! You can find all of my RUclipss organized at learncs.w3spaces.com/

  • @kawtheralateeq8264
    @kawtheralateeq8264 3 года назад +1

    Thank you .. ❤️❤️👍🏼

    • @lfriedrichsen
      @lfriedrichsen  Год назад

      You're welcome! You can find all of my RUclipss organized at learncs.w3spaces.com/

  • @sureshsivaram4689
    @sureshsivaram4689 Год назад

    Your pace is too fast for learners.

    • @lfriedrichsen
      @lfriedrichsen  Год назад +1

      You can pause it, rewind it, or watch it over again. You are in control of the pace.