6. Microsoft Access 2016 Basics: Many To Many Relationships

แชร์
ฝัง
  • เผยแพร่เมื่อ 2 ธ.ค. 2024

ความคิดเห็น • 29

  • @goldilocks714
    @goldilocks714 4 ปีที่แล้ว +8

    This video saved my brain! I really appreciate all of the details you've given about good database construction. Many tutorials I've come across have just focused on the mechanics of how to use Access, and I think that the context you give is very important. This series is looking like a very valuable refresher on database construction in general for me, alongside its instruction in Access 2016. Thanks for making these!

  • @captainkeyboard1007
    @captainkeyboard1007 2 ปีที่แล้ว

    That was a fine show. I like to see other people take advantage of computer technology.

  • @GaryWilsonDigital
    @GaryWilsonDigital 4 ปีที่แล้ว +5

    This is the best example I’ve seen of the many to many relationships. Great job!

  • @farinatty
    @farinatty 5 ปีที่แล้ว +2

    Hey Steve your access database tutorials are the best. Would be good to see a few more in this series.

  • @Jaden334
    @Jaden334 ปีที่แล้ว

    Lifesaving content

  • @hyoga2407
    @hyoga2407 11 หลายเดือนก่อน

    Thanks very much for this it works like magic

  • @castor448
    @castor448 3 ปีที่แล้ว

    A great way also to show how to construct a telephone directory with multiple numbers. Thank you :-)

  • @deholovi
    @deholovi ปีที่แล้ว

    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?

  • @bryanmarquez5318
    @bryanmarquez5318 6 ปีที่แล้ว +1

    Hi Steve, any tutorial on how to handle Data Entry/Editing/Deletion, with the many to many relationship on Forms & Subforms etc?

  • @matthewb5235
    @matthewb5235 2 ปีที่แล้ว

    The problem I see with this video is that when we are referencing people we reference them by name not by number, and we select phonetype not by number but by type. Presumably we are working in forms so we want to see the related field phonetype (string) and person (string) . How does that side work? Is it a subform? Or can the related fields just be dropped into the form?

  • @garycurtis
    @garycurtis 3 ปีที่แล้ว

    Excellent video, I have a question. Do you use VBA code to update these tables simultaneously for the join table? Or do you update them one at a time using VBA or other means?

  • @KMANWEBER
    @KMANWEBER 6 ปีที่แล้ว

    Thanks Steve. Can you please create a video that demonstrates how to update a many to many relationship through a form/queries? Thanks

  • @guillermoperez1845
    @guillermoperez1845 3 ปีที่แล้ว

    Hi Steve: A question(s). Why did you make the fields in the People_Phonenumbers table a Primary Key? Could you just have left them as Foreign Keys? It sort of breaks the rule of linking Primary to Foreign Keys. In your example, you linked Primary to Primary.

  • @joycemaxfield7758
    @joycemaxfield7758 2 ปีที่แล้ว

    How can I transfer aDatabase from my laptop to a flash drive

  • @Mechrank
    @Mechrank 4 ปีที่แล้ว

    Great tutorial, i want to model a database structure by seeking your help.
    The basic information that i’d like to store in this new database will be:
    1- Machinery (manufacturer, model, water flow rate requirement)
    2- Connection to an existing pipe network
    Can i do this using MS access database?

  • @robinbrown8721
    @robinbrown8721 5 ปีที่แล้ว

    Good morning Steve, after viewing your videos regarding erd several times due to inheriting an access database, I am totally confused since I did not create the database. I tried to use one of the templates that access has to offer, but that made me even more confused
    Training_ID (AutoNumber)
    Student_ID - (Number) and other attributes
    2018 A Training Day
    2018 B Training Day
    2018 C Training Day
    2018 D Training Day
    2018 E Training Day
    etc...
    Student can go to class anytime during the year, but the training is not complete until all 5 days are complete and the training happens every three years.
    After viewing your videos I understand that the database does not contain any normalization and the training days should not be listed as a field, but I am not sure what I should do.
    Not sure if you have a video that would help me with one of the problems that I see with this database.

  • @D33Arts
    @D33Arts 5 ปีที่แล้ว

    Hi Steve - I have been following along with your video's and would like to take your many to many example to create a query to update data in my employee and phone number tables. I am also using the Phone types table and have set them up as per your video. Can you show how to create a proper query so that updates are possible to both the employee table and phone number table? I keep getting the ambiguous outer join error from access.

  • @AN-oo5hg
    @AN-oo5hg 5 ปีที่แล้ว +1

    Thanks a lot👏👏👏

  • @behindthescene2727
    @behindthescene2727 3 ปีที่แล้ว

    kamaal !!

  • @roxinnjeru5837
    @roxinnjeru5837 5 ปีที่แล้ว +1

    When i try creating a relationship between the the PhoneTypes and PhoneNumbers i get a message that reads"Relationship must be on the same number of fields with the same data types" How should i solve this?

    • @robinbrown8721
      @robinbrown8721 5 ปีที่แล้ว

      Try going to the datasheet view Phone Types and see what dataType you designated to the field name "PhoneTypes" is it a number or short Text, did you change the field size located at the bottom of the datasheet to another number other then the 255 that is set as a default number. Do the same process for the "PhoneNumbers" make sure that both dataTypes are the same and both field sizes are the same. If that does not work Mr. Bishop will have to assist you, that is what I learned from his videos

  • @nancyd4918
    @nancyd4918 5 ปีที่แล้ว

    He released a memo... not the transcript...

  • @chevxphone1126
    @chevxphone1126 4 ปีที่แล้ว +1

    Thumbs up for saying Data and not Daaaaataaaaaa :D

  • @unicockboy1666
    @unicockboy1666 5 ปีที่แล้ว +2

    So you´re telling me that a 1 year-old has a 50k salary??

    • @TitansMedia
      @TitansMedia 3 ปีที่แล้ว +2

      Actually this is an example where he obviously did not use real people or real qualifications. I'd imagine a simpleton like you would easily fall for such obvious exaggerations

  • @arete_
    @arete_ 2 ปีที่แล้ว

    This is a horrible way to manage data. Just because you remember the phone number ID from the top of your head does not mean you will remember that next time. So now you will have to check the ID everytime... 😲