6. Microsoft Access 2016 Basics: Many To Many Relationships

Поділитися
Вставка
  • Опубліковано 28 лис 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!

  • @GaryWilsonDigital
    @GaryWilsonDigital 4 роки тому +5

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

  • @captainkeyboard1007
    @captainkeyboard1007 2 роки тому

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

  • @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 :-)

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

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

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

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

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

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

  • @joycemaxfield7758
    @joycemaxfield7758 2 роки тому

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

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

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

  • @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... 😲

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