Thanks a lot for the help. I was getting increasingly frustrated figuring out how to properly link two tables in a one to many relationship. It was easy to follow along with you here!
U just saved me from alot of headaches. My trouble was not putting the field as a primary key and then I noticed one of your fields as a primary key, Got it!
WISH I FOUND YOUR CHANNEL EARLIER. Haha I'm studying last minute for my exam and been going through videos all day, yours really have everything i need! Thank you so much!!
Hey thanks Sebastian. So the Access exam is one of the tougher MOS tests. Definitely learn about subforms and layout and design changes on reports. Not a bad idea to learn about database options in the File Tab too. Glad you like the videos, best of luck with your test. Let me know how you do!
Thank you so much for, quick, precise, to-the-point info. In under 8 minutes. A lot of the videos I click on for tutorials are hours long. That's just not practical and a lot of the times they mention things that I don't need to know, therefore making the video longer than it needs to be imho.
Thank you for keeping the instruction to-the-point. I tried watching videos by another UA-camr (Kirt Kershaw), and despite his thorough instruction, I found his videos to be intolerable because he tends to drag things out more than necessary.
OMG, could you be my professor you have helped me out from a teacher that does not teach at all and uses youtube as his teaching method. Your explanation got me an a on my report.
Thank you, very easy to understand, I was flying at first, then got unstuck with the primary key but your videos and playlists are helping loads. Really appreciated.
يا رفاق ادعوا لي أجيب درجة ممتازة في الاختبار💗 Thank for gad I found your channel I was confused about one to many relation sheep but now it is clear for me thank you so much for working hard and keep going 💗💗
Thank you for your video. I'm dating myself but I used to make DB's with DBase III as well DB Programs with Clipper. I am trying to get up to speed on this new format that MS uses and your tutorial really helped. Concepts are basically the same its just a new approach to getting things rolling. THANK YOU.
Broooo Thank you so much I'm a IT Major and one of my classes is computer applications and we have a Microsoft access assignment where we had to do all this bull and you helped 🎉🎉🎉🎉 you rock dude
This is a great video! The only thing that I would suggest is that you be careful with regards to how you refer to the “Cascade” option. It does not refer to adding a sub table in your table. It actually refers to cascading the changes that you make throughout child tables. I only point that out because you also checked the cascade delete which will delete, everything related with a record throughout your database (and cannot be undone) when you delete it as does making a change to something you cascades the changes down to all of the other records that it affects. Other than that is an awesome tutorial.
Thank you soooo much! I wish I found your channel 7 weeks ago when my course began! I am having trouble getting my short-text survey responses, imported from Excel, to translate into additional tables in Access. All of your videos have helped me tremendously, especially query writing and relationships! THANK YOU!
Hi Sarah, No problem, I am happy to help in your course, even if it's the end of the semester! I'm glad my Access playlist was helpful for you. Best of luck with your course and the end of the semester! Have a nice day.
@@ProfessorAdamMorgan Also, I would love to see how to update and delete data in queries (while preserving the original table and creating a new one, if possible), and how to join data from multiple tables in a query. Thanks again!!
Hi Sarah, Sure, I will add those to my list of video requests. Right now, I am pretty far behind on video requests and have to catch up with some videos for my students. As soon as I am done with that, I will get to adding different types of queries to this playlist.
This helps a lot bro this video was explained well, i have an exam this Monday so my knowldege has improved thanks a lot, i couldn't get access on mac so luckily i'm using my Dad's work laptop that has access on it to practise man i was so stressed thank god for this Channel and this video.
I'm glad this Access video was helpful for you Laura. Feel free to check out my Access playlist if you're learning more on your own. Have a nice day! ua-cam.com/video/psLJJyNlRXY/v-deo.html
thank you so much this helped me a lot, i kept forgetting how to make the infinity sign and the 1 appaired on the relationship, but now i understand how to do it. thank you very much sir.
Fantastic explanation, mate I’m lying in bed watching this at 6am and now I have the insatiable urge to migrate all the data from my expense logs and client spreadsheet into Access yep I’m that kind of weird
Thank you Adam, very clear and appreciated. I was wondering if you had an UNF table and wanted to go through 1NF, 2NF, 3NF (Normalized) - can you please show how this would work please regarding the relationships and how to implement it. Thanks again :)
This is amazing. I am currently working on a customer database and this video has given me more understanding. I have a question: I have customer table, transaction table, Bank information table and cheques table, how do I link these tables to my Customer table?
Hi Kingsley, Thanks for watching! Yes, you could do that. I recommend adding a primary key to your customer table. This could be something like a customer ID number. Then add that customer ID Number where necessary in the other tables. Then follow the steps shown in this video to link all of the tables using relationships. I hope this helps!
These videos are amazing and extremely helpful, thank you so much!! I'm preparing a database, and I was wondering if it would be possible to link two tables without using the primary ID. The "teacher name" field of one table (Student Information) is a lookup field taken from the teacher name field in the teacher information table. Unfortunately, the relationship was not created and is not visible when I click on the relationships tab, despite the lookup working fine. Can you please tell me if there's a way I could relate both tables without using the primary keys? Thank you, Angela
Wow that was really helped because I had an assignment today and I was stuck on that question so I can correctly done it a bunch of thanks really appreciated 🥰😍
In a professional database the PK should be a single column integer that is not updateable so update-cascade is not needed. There are reasons to use the same advice for intersection tables (that enable many to many relationships) as well.
hey - thank you for the tutorial. have learnt so many things here, though I still got a question, "is it possible to create a relationship between 2 fields which seem to have no direct linkage?" I have got a headache with my project documentation
Great video, thank you. I'm trying to link a 'Projects' table with a 'Tasks' table, where multiple tasks occur in a project. My tables are linked after following your instructions, however my Projects table shows all entries from the Tasks table, not just those with the linking ID. Any ideas?
Hi RD Gamer, I'm actually not teaching Access courses anymore so I am not planning on creating a new playlist anytime soon. Once I catch up on my other videos for my students, it'll definitely be something I look into doing though. Thanks for the suggestion, and for watching!
Great video 👍 I have a question for you. When i click create button error 3211 pops up and it says that the table is already in use by another person or process.. But I am the only one in my company who uses it at the moment
Can you help me create a relationship for a list of clients then under each client, a list of websites and sign on info? Very similar to what you did in this video I'm just hung up on the relationship part. I created a Client ID for a Client Table and Website Table but maybe I have the primary key messed up. thank you love your videos!
Hi Michele, Yes, you're probably right about it being an error with your Primary Key. I'd recommend linking the two based off of the Primary Key, which should be Client ID, since you won't have the same Client ID for more than 1 client. Here is a video I made on Primary Keys. Once they're assigned properly, you should be able to set up the One to Many Relationship without a problem: ua-cam.com/video/7lJS5tklOrE/v-deo.html
Hi Waheed, I am not sure on that one. My expertise is not in SQL, and I don't want to steer you in the wrong direction. Here is a link that might be helpful for you: support.office.com/en-us/article/access-sql-basic-concepts-vocabulary-and-syntax-444d0303-cde1-424e-9a74-e8dc3e460671
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?
Thank you so much... Access has been giving me headaches
😅😅😅😂
The thing looks challenging.
Thank you so much! Very clear, concise and to the point. Better explained than my teacher
Could not understand what my textbook was trying to say. Thank you so much for making this simple and easy to understand. Total lightbulb moment!
Great to hear! I appreciate you watching, Javachix.
currently studying for my access midterm and this is amazing!! you’re a true legend
Good luck!!
lol...same here
This is like the 10th tutorial on relationships, and the first one presented in a way I can understand. THANK YOU!
Thanks a lot for the help. I was getting increasingly frustrated figuring out how to properly link two tables in a one to many relationship. It was easy to follow along with you here!
I'm glad this video was helpful for you, Alfrendo! Thank you for watching and good luck with your database.
Thank you so much for your tutorials! My class went online recently and your lessons are a tremendous help!
Glad I could help!
U just saved me from alot of headaches. My trouble was not putting the field as a primary key and then I noticed one of your fields as a primary key, Got it!
That's a very common mistake C L. I am glad my video was able to help clear it up for you, thanks for watching!
WISH I FOUND YOUR CHANNEL EARLIER. Haha I'm studying last minute for my exam and been going through videos all day, yours really have everything i need! Thank you so much!!
Hey I'm glad my videos are helping you out for your exam, Maryam. Thank you for watching and best of luck with your exam!
Great video bro. I have a certification exam for Microsoft Access tomorrow and your videos are extremely helpful.
Hey thanks Sebastian. So the Access exam is one of the tougher MOS tests. Definitely learn about subforms and layout and design changes on reports. Not a bad idea to learn about database options in the File Tab too. Glad you like the videos, best of luck with your test. Let me know how you do!
Very helpful. Gracias!
No problem!
Ive got a finals exam in 2 hours this was really useful🙏🙏
IN A FEW MIN, I LEARNED MORE FROM YOU THAN FROM MY PROFESSOR
I'm happy you learned a lot, Timea. Thank you for watching!
Thank you so much for, quick, precise, to-the-point info. In under 8 minutes. A lot of the videos I click on for tutorials are hours long. That's just not practical and a lot of the times they mention things that I don't need to know, therefore making the video longer than it needs to be imho.
Glad it helped! I always try to keep my videos short and to the point. Thanks for watching, Michelle!
Thanks a lot professor Adam, I have my 8th grade computer practical exam tomorrow and it helped me a lot. Thanks
Sameee i was struggling with the enforce referencial integrity part it kept giving me an error but now ill try
@@Wufyiofkes oh nice! I literally didnt even have Access 2016 and literally memorized everything.
Thank you for keeping the instruction to-the-point. I tried watching videos by another UA-camr (Kirt Kershaw), and despite his thorough instruction, I found his videos to be intolerable because he tends to drag things out more than necessary.
No problem, Phoenix I am glad you enjoyed the video. I am happy my videos are working for you, thank you for watching!
Man u saved my tomorrow's IGCSE exam, thanks a lot
Thank you so much. Watching your tutorial help me so much, better than the current instructor I have now.
OMG, could you be my professor you have helped me out from a teacher that does not teach at all and uses youtube as his teaching method. Your explanation got me an a on my report.
Thank you, very easy to understand, I was flying at first, then got unstuck with the primary key but your videos and playlists are helping loads. Really appreciated.
Glad it helped! Good luck with Primary Keys, thanks for watching, Steven.
Thank you for this. You saved my life. Tomorrow I am appearing for my computer exam. Thank you
I'm glad this helped you Himanshi, thank you for watching and best of luck with your exam!
excellent tutorial. had to watch this to do my assignment because my lecturer made this seem so complicated. Thank you!
Great video. I'm taking an Access class for school, and I was a little lost. Your video really helped.
Hey I'm glad it was helpful and I hope it cleared some things up for you, John. Thank you for watching and have a nice day!
@@ProfessorAdamMorgan , thank you again. Guaranteed I'll be watching more!!!
I'm glad to hear that John, thank you.
I’m not even an English speaker but this video has really helped me! Thanks a lot
Hey I'm glad this was able to help you, Nadeen! Thank you for watching!
يا رفاق ادعوا لي أجيب درجة ممتازة في الاختبار💗
Thank for gad I found your channel
I was confused about one to many relation sheep but now it is clear for me
thank you so much for working hard and keep going 💗💗
Although my English is bad but I understand every point .
Thank you again
Hey I appreciate you watching my video, Deem! Thank you for watching and have a great day.
Thank you for your video. I'm dating myself but I used to make DB's with DBase III as well DB Programs with Clipper. I am trying to get up to speed on this new format that MS uses and your tutorial really helped. Concepts are basically the same its just a new approach to getting things rolling. THANK YOU.
Hey Gary,,
Thanks for watching, I am glad you're learning how to use Access and that my tutorial helped you out. Have a nice day!
Broooo Thank you so much I'm a IT Major and one of my classes is computer applications and we have a Microsoft access assignment where we had to do all this bull and you helped 🎉🎉🎉🎉 you rock dude
This is a great video! The only thing that I would suggest is that you be careful with regards to how you refer to the “Cascade” option. It does not refer to adding a sub table in your table. It actually refers to cascading the changes that you make throughout child tables. I only point that out because you also checked the cascade delete which will delete, everything related with a record throughout your database (and cannot be undone) when you delete it as does making a change to something you cascades the changes down to all of the other records that it affects. Other than that is an awesome tutorial.
Thank you soooo much! I wish I found your channel 7 weeks ago when my course began! I am having trouble getting my short-text survey responses, imported from Excel, to translate into additional tables in Access. All of your videos have helped me tremendously, especially query writing and relationships! THANK YOU!
Hi Sarah,
No problem, I am happy to help in your course, even if it's the end of the semester! I'm glad my Access playlist was helpful for you. Best of luck with your course and the end of the semester! Have a nice day.
@@ProfessorAdamMorgan Also, I would love to see how to update and delete data in queries (while preserving the original table and creating a new one, if possible), and how to join data from multiple tables in a query. Thanks again!!
Hi Sarah,
Sure, I will add those to my list of video requests. Right now, I am pretty far behind on video requests and have to catch up with some videos for my students. As soon as I am done with that, I will get to adding different types of queries to this playlist.
Hi Prof Morgan! Yes! Of course!! Thanks again, all of this is truly helpful. :-)
No problem Sarah, I appreciate that. Let me know if you have any other questions.
I can’t express how much I appreciate you bro!
Dude. You helped me solve a problem I have been trying to figure out for days! Thanks for the easy to follow instructions!
Hey I'm glad this helped you out nowmaria. Thanks for watching and for the comment. Have a nice day!
Thank you ! I have my AS IT exam in a few days and this really helped
Legend and saviour, your channel is gonna help me ace my course
Good luck in your course, Callan. Thank you for watching!
I was having a hard time with access, this tutorial helped me a lot, thanks
Thank you so much!! I HV an exam on access in less than 2 hrs and this is def going to save me..
love love love your no nonsense - lets get it done approach - you saved my life with this one lol
Hey thanks Julie, I'm glad you like the video. Glad it was helpful, let me know if you have any questions. Have a nice day!
thank you so much! I am new to Microsoft access and I needed to complete an assignment for my business class. This was extremely helpful!
This helps a lot bro this video was explained well, i have an exam this Monday so my knowldege has improved thanks a lot, i couldn't get access on mac so luckily i'm using my Dad's work laptop that has access on it to practise man i was so stressed thank god for this Channel and this video.
Thanks for this. I passed my long test because of this video.🎉
IVE BEEN TRYNA FIGURE THIS OUT FOR MY CLASS THANKKK YOUUUU
best and simpleste explanation ever made
Thanks Adam, I'm confident I'll ace my exams now, Subscribing!
You are a very good teacher. Cheers!
Thank you so much. It sure has helped my gradual understanding of the relationship between tables in ACCESS.
This video was so helpful in order to submit an assignment on time. Five stars from me *****.
You did a good job. I’m completely spasticated with computers, and this helped. Thanks.
Thanks for such a clear and concise explanation! It really clarified the concept for me.
Very helpful! I am new to Access and trying to learn on my own. This really helped make it clear.
I'm glad this Access video was helpful for you Laura. Feel free to check out my Access playlist if you're learning more on your own. Have a nice day!
ua-cam.com/video/psLJJyNlRXY/v-deo.html
Very helpful for someone That is Learning all of this but is also wanting to do it better so I can be successful with my Results
thank you so much this helped me a lot, i kept forgetting how to make the infinity sign and the 1 appaired on the relationship, but now i understand how to do it. thank you very much sir.
You really teach very well.. Thanks a lot, it helped for my exams
Glad to hear that
@@ProfessorAdamMorgan I have subscribed to you by the way, looking forward for more videos 😊
I appreciate that, Tiger. Thank so much, I'll have more videos coming soon!
Great overview. The thing that would make this perfect is to discuss the primary key.
Nicely done! Your presentation is very clear. Thanks
Glad you enjoyed it! Thanks for watching, Peter!
Fantastic explanation, mate
I’m lying in bed watching this at 6am and now I have the insatiable urge to migrate all the data from my expense logs and client spreadsheet into Access
yep I’m that kind of weird
THANK YOU VERY MUCH I needed so much help other youtube chnnels were very complicated
Thank you Adam, very clear and appreciated. I was wondering if you had an UNF table and wanted to go through 1NF, 2NF, 3NF (Normalized) - can you please show how this would work please regarding the relationships and how to implement it. Thanks again :)
This is amazing. I am currently working on a customer database and this video has given me more understanding. I have a question: I have customer table, transaction table, Bank information table and cheques table, how do I link these tables to my Customer table?
Hi Kingsley,
Thanks for watching! Yes, you could do that. I recommend adding a primary key to your customer table. This could be something like a customer ID number. Then add that customer ID Number where necessary in the other tables. Then follow the steps shown in this video to link all of the tables using relationships. I hope this helps!
Very well explained ! Simplified a complex activity
These videos are amazing and extremely helpful, thank you so much!!
I'm preparing a database, and I was wondering if it would be possible to link two tables without using the primary ID.
The "teacher name" field of one table (Student Information) is a lookup field taken from the teacher name field in the teacher information table.
Unfortunately, the relationship was not created and is not visible when I click on the relationships tab, despite the lookup working fine.
Can you please tell me if there's a way I could relate both tables without using the primary keys? Thank you, Angela
thank you so much.....this helped me and cleared all the confusion i had thank you so much may god bless you
Wow that was really helped because I had an assignment today and I was stuck on that question so I can correctly done it a bunch of thanks really appreciated 🥰😍
My IQ level is not high but I got the lesson thank you.
I usually don't comment
I should say your way of teaching is spatial.
You're beyond awesome! So grateful for your page.
I'm glad to hear that this video was helpful for you, theoriginalsafinette! Thank you for watching, have a great day!
This is actually a very helpful and great video sir...!!!!!
You are just great!!
I'm glad to hear that this video was helpful for you, Mansha. Thank you for watching and have a nice day!
thanks bro u have helped me with my KCSE computer project in Kenya 2020
Great 👍
excellent Explanation , thanks a lot please continue to provide more lesions
Sir, Your teaching is amazing and very understandable! You are Amazing and I just subscribed and looking forward to your videos.
Thank you straight and to the point with valid information
No problem Philip, thanks for watching!
Thank you so much for making this video, it helped me a lot for my bpc 110 class.
No problem Starr, I'm glad it helped you out for your class. Have a nice day!
a giant thanks for explaining this mystery!
Thank you, Professor Adam Morgan! Your tutorial has a great pace and your teaching is SO clear! Subscribe!
Terrific explanation. Thank you!
Thank you TigerLily, I appreciate you watching. Have a nice day!
you made it so simple thank you so much!!!
No problem YasminMProductions, thank you for watching!
Very clear explanation, help me a lot. Thank you.
I...I think I love you lol. Thank you soooo much for this video!!
Ha thanks Kisha! I appreciate you watching and I'm glad the video helped you out, have a nice day!
this super helpful even today
Good stuff right plain and simple, straight to the point cheers!
Excellent Explanation, I love you.
I'm glad it worked for you Dun Raksmey, thanks for watching! Have a nice day!
In a professional database the PK should be a single column integer that is not updateable so update-cascade is not needed. There are reasons to use the same advice for intersection tables (that enable many to many relationships) as well.
hey - thank you for the tutorial. have learnt so many things here, though I still got a question, "is it possible to create a relationship between 2 fields which seem to have no direct linkage?"
I have got a headache with my project documentation
Great video, thank you. I'm trying to link a 'Projects' table with a 'Tasks' table, where multiple tasks occur in a project. My tables are linked after following your instructions, however my Projects table shows all entries from the Tasks table, not just those with the linking ID. Any ideas?
This dude looks like a hardcore gamer.....but thnks dude...Your tutorial was *really* helpful
Hi Yolloo, thanks I am glad this was helpful for you. Have a good one!
HI PROF..I LIKE YOUR WAY TO EXPLAIN...PROF WOULD YOU PLEASE DO AD ADVANCE ACCESS TUTORIALS.
Hi RD Gamer,
I'm actually not teaching Access courses anymore so I am not planning on creating a new playlist anytime soon. Once I catch up on my other videos for my students, it'll definitely be something I look into doing though. Thanks for the suggestion, and for watching!
this helped a lot professor thank you, I just subscribed
Excellent explanation.
Video was very helpful. Thank you
Thanks alot, this session really helps
Thanks man! This was really helpful
Great video 👍 I have a question for you. When i click create button error 3211 pops up and it says that the table is already in use by another person or process.. But I am the only one in my company who uses it at the moment
Thank you The way you explain it very good
How did you change the vendor ID number if it required it to auto-generate since it is the primary key?
Can you help me create a relationship for a list of clients then under each client, a list of websites and sign on info? Very similar to what you did in this video I'm just hung up on the relationship part. I created a Client ID for a Client Table and Website Table but maybe I have the primary key messed up. thank you love your videos!
Hi Michele,
Yes, you're probably right about it being an error with your Primary Key. I'd recommend linking the two based off of the Primary Key, which should be Client ID, since you won't have the same Client ID for more than 1 client. Here is a video I made on Primary Keys. Once they're assigned properly, you should be able to set up the One to Many Relationship without a problem:
ua-cam.com/video/7lJS5tklOrE/v-deo.html
Yoo thank you so much for this vid! Just helped me with a final step in my database exam!
Awesome videos! Thanks!
Thanks for watching!
Excellent explanation- thank u
I'm glad this worked for you Nadeem, thanks for watching!
Can we make relationships using sql queries?
Hi Waheed,
I am not sure on that one. My expertise is not in SQL, and I don't want to steer you in the wrong direction. Here is a link that might be helpful for you:
support.office.com/en-us/article/access-sql-basic-concepts-vocabulary-and-syntax-444d0303-cde1-424e-9a74-e8dc3e460671
This video was awesome! Thank you so much!
Good video, very helpful and well executed.
Thank you Jim, I appreciate that. Have a nice day.
Thank you...keep up the good work.
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?
Well explained! Thanks for your help!
You're welcome!
I highly requested you make stock control tutorial video from product table, customer table and suppliers in Microsoft Access.
Hi Abdur,
I'm really behind on video requests right now. I will make one for you in the future though. Just tell me exactly what you'd like to see.