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!
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!
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!!
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.
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 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.
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.
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 you for keeping the instruction to-the-point. I tried watching videos by another TH-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.
يا رفاق ادعوا لي أجيب درجة ممتازة في الاختبار💗 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 💗💗
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.
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
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! th-cam.com/video/psLJJyNlRXY/w-d-xo.html
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 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.
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... 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
This is like the 10th tutorial on relationships, and the first one presented in a way I can understand. THANK YOU!
currently studying for my access midterm and this is amazing!! you’re a true legend
Good luck!!
lol...same here
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.
Thank you so much for your tutorials! My class went online recently and your lessons are a tremendous help!
Glad I could help!
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.
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🙏🙏
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!
Thank you so much. Watching your tutorial help me so much, better than the current instructor I have now.
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!
I can’t express how much I appreciate you bro!
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!
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!
excellent tutorial. had to watch this to do my assignment because my lecturer made this seem so complicated. Thank you!
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
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!
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 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.
Legend and saviour, your channel is gonna help me ace my course
Good luck in your course, Callan. Thank you for watching!
Man u saved my tomorrow's IGCSE exam, thanks a lot
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!
You are a very good teacher. Cheers!
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.
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.
best and simpleste explanation ever made
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!
Nicely done! Your presentation is very clear. Thanks
Glad you enjoyed it! Thanks for watching, Peter!
I was having a hard time with access, this tutorial helped me a lot, thanks
Thank you ! I have my AS IT exam in a few days and this really helped
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 so much! I am new to Microsoft access and I needed to complete an assignment for my business class. This was extremely helpful!
IVE BEEN TRYNA FIGURE THIS OUT FOR MY CLASS THANKKK YOUUUU
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!
Thank you for keeping the instruction to-the-point. I tried watching videos by another TH-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!
يا رفاق ادعوا لي أجيب درجة ممتازة في الاختبار💗
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 so much!! I HV an exam on access in less than 2 hrs and this is def going to save me..
Thanks for such a clear and concise explanation! It really clarified the concept for me.
THANK YOU VERY MUCH I needed so much help other youtube chnnels were very complicated
Thanks for this. I passed my long test because of this video.🎉
You did a good job. I’m completely spasticated with computers, and this helped. Thanks.
Thanks Adam, I'm confident I'll ace my exams now, Subscribing!
Thank you so much. It sure has helped my gradual understanding of the relationship between tables in ACCESS.
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.
This video was so helpful in order to submit an assignment on time. Five stars from me *****.
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!
thank you so much.....this helped me and cleared all the confusion i had thank you so much may god bless you
Thank you straight and to the point with valid information
No problem Philip, thanks for watching!
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
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!
th-cam.com/video/psLJJyNlRXY/w-d-xo.html
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.
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!
Sir, Your teaching is amazing and very understandable! You are Amazing and I just subscribed and looking forward to your videos.
Very well explained ! Simplified a complex activity
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!
you made it so simple thank you so much!!!
No problem YasminMProductions, thank you for watching!
excellent Explanation , thanks a lot please continue to provide more lesions
Excellent Explanation, I love you.
I'm glad it worked for you Dun Raksmey, thanks for watching! Have a nice day!
Terrific explanation. Thank you!
Thank you TigerLily, I appreciate you watching. Have a nice day!
this helped a lot professor thank you, I just subscribed
this super helpful even today
Awesome videos! Thanks!
Thanks for watching!
Thanks man! This was really helpful
a giant thanks for explaining this mystery!
Very clear explanation, help me a lot. Thank you.
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.
Video was very helpful. Thank you
Thanks alot, this session really helps
Excellent explanation.
This video was awesome! Thank you so much!
Excellent explanation- thank u
I'm glad this worked for you Nadeem, thanks for watching!
Great overview. The thing that would make this perfect is to discuss the primary key.
thanks bro u have helped me with my KCSE computer project in Kenya 2020
Great 👍
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.
Well explained! Thanks for your help!
You're welcome!
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!
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
Very good video. Helped me a lot!
That's great to know, Anna. Thank you for watching and let me know if you have any other questions. Have a nice day.
Good video, very helpful and well executed.
Thank you Jim, I appreciate that. Have a nice day.
Thank you The way you explain it very good
Thank you...keep up the good work.
Nicely done! Thank you.
thank you!!! This was very helpful!
Glad it was helpful!
Thank you, Professor Adam Morgan! Your tutorial has a great pace and your teaching is SO clear! Subscribe!
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!
Great explanation
this video is super helpful!!
I'm glad to hear that, Jennifer. Thank you for watching and have a nice day!
nice work dear friend , i like , nice share , stay connected
Thank you! This helped alot.
Fantastic vide + explanation. Tx
another amazing video sir.
As always, thank you Kazi. I appreciate the comments.
OMG. You are amazing . Thanks
Fantastic thanks so much
You are very welcome
Good stuff right plain and simple, straight to the point cheers!
SO HELPFUL I ALREADY LOVE YOU
I'm glad it helped you out Mae, thank you for watching!
Awesome video. Thank you.
Glad it worked for you James. Have a nice day!
Yoo thank you so much for this vid! Just helped me with a final step in my database exam!
Thanks! Very help full
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