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!
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?
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?
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.
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.
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.
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?
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?
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?
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
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
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... 😲
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!
Thank you for watching!
That was a fine show. I like to see other people take advantage of computer technology.
This is the best example I’ve seen of the many to many relationships. Great job!
Hey Steve your access database tutorials are the best. Would be good to see a few more in this series.
A great way also to show how to construct a telephone directory with multiple numbers. Thank you :-)
Thanks very much for this it works like magic
Lifesaving content
Thanks Steve. Can you please create a video that demonstrates how to update a many to many relationship through a form/queries? Thanks
Hi Steve, any tutorial on how to handle Data Entry/Editing/Deletion, with the many to many relationship on Forms & Subforms etc?
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?
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?
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.
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.
kamaal !!
Thanks a lot👏👏👏
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.
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?
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?
How can I transfer aDatabase from my laptop to a flash drive
Thumbs up for saying Data and not Daaaaataaaaaa :D
He released a memo... not the transcript...
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?
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
So you´re telling me that a 1 year-old has a 50k salary??
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
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... 😲