yeah i was sleeping throughout the whole course and just 2 days before the exam God blessed me with this video. bro this was amazing on a whole new level. thanksss :))
Thank you very much, Adam! This was the most useful video I've ever seen regarding Basic Access aspects. Straight to the point unlike other 2-hour tutorials and very well-explained. Keep up the good work, mate!
Thanks!! this type of teaching really feels better than reading text and trying to figure out some black and white blurred picture of instructions! much appreciated!
Just stumbling upon these videos and wow !!! They are detailed enough to get the info across but short enough to where I don't loose interest. VERY GOOD !! Keep it up !!!
Hi Vaughan, I'm glad you're enjoying the videos. I try to keep them relatively short since I typically cover one or two topics per video. Glad it working for you. Thanks for taking the time to comment! Have a nice day.
This is very helpful! I asked my boss for Access because the survey analysis I need is a bit sophisticated for Excel but then got a little scared trying to learn it on my own. Thank you!!
Hi Lisa, I hope this video helped you out. I have a playlist for Access beginners that covers the basics in order of difficulty. It is linked below: ruclips.net/video/psLJJyNlRXY/видео.html
Thank you so much for this great video Professor Morgan. I just randomly found this video. You did a fantastic job of explaining everything and making Access feel much more welcoming and intuitive. Thanks again.
Hey no problem snoopy9292, I am glad this was helpful for you. I have an Access playlist as well that follows the same format if you're learning Access. Thanks a bunch for the comment and for watching the videos: ruclips.net/video/psLJJyNlRXY/видео.html
Prof Adam, I want to thank you so much. Thanks to your videos I passed my Accounting Analytics class which includes to build the physical aspect of my REA data model on Access. This is a very hard class, but thank you to your videos I got an A on building my system successfully. I will recommend your videos to my friend who is talking the same class next semester.
Hi Desire, Thank you for writing this to me, I am glad these videos have been helpful for your Accounting Analytics class. Congratulations on passing with an A, and thank you so much for recommending my videos to your friend. Have a great summer!
WHO TF? would give this video a thumbs down. Thanks this is got to be one of the best Access Database videos I've seen it's simple and to the point and I can't thank you enough for that 🙏🙏
I gotta admit. I have never seen your channel before but I knew you deserved that subscribe button. Also tmrw is my exam. Guess I joined the studying 1 day before exam crew.
just getting into the Tutorial now and it seems interesting cause I want to be able to do all of this stuff properly without instructions ( but if I do Get stuck I can come here and figure out how to do it properly without failure) and it is also Really Awesome that i can watch some one and Learn step by step to Make Sure that i am always on point with my work and it has helped me a lot very helpful thank you professor for the knowledge. :)
Man I wish I would have found your channel sooner but I LOVE it. Thank you fore explaining so well, I am in college and this computer stuff is unknown to me.
I'm so glad that you're enjoying my channel, Jameelah. I am glad you're finding it useful. Thanks for letting me know and best of luck learning about computers!
I'm writing finals and today is the last paper (Principles of computer programming.. I'm studying IT and computer science) I missed acess lessons in class and because we were closed during lock down we didn't have much class time Thanks alot this tutorial explained everything well👍🙏
Hey I'm glad the video style worked well for you, upandenergy! Thanks for watching. If you want to learn more, here is my Access Playlist, sorted by difficulty: ruclips.net/video/psLJJyNlRXY/видео.html
wonderful, i like how you deliver the word in order to make it viewer understand, you got it, i became more understand from your clear explanation, hopefully your vidio is usefull for everyone who need the information about mc. access
Wow!!!!! I have seen many channels Wich are "Professionals" but after watching the videos I feel kind of lost. But you Sr.!!!! Really like your videos , direct to the point . Thanks and keep the good work. I hope to see more complicated stuff 😀
Hey Michael, Thanks a bunch for this comment. Yeah, my channel is low budget but I try to get to the point of the video quickly, and present in a way that is easy to understand. Most of my classes cover the basics of Access, but I occasionally get questions about the MOS Exam so I touch on more complicated concepts. If their is anything you want to know, let me know in any comment section.
Thank you! You did a fantastic job! I was finally able to figure out how queries work together with reports. You filled in all the blanks (in my brain) that I needed to get the job done. Liking and subscribing!
Excellent tutorial videos Sir! Very helpful, kinda surprised you're not on Udemy or any of the other edcuational platforms. Keep up the excellent work!
Hi Abyi, I'm glad you enjoy them! I've considered it, but I prefer to give my content on a free platform that can reach the most amount of people possible. Right now, that's RUclips.
my subject is all about database (DATAMAN database management) this semester. all of these tutorial you were teaching was everything that we discussed throughout the semester from making tables down to reports..and i honestly didnt get and understand my instructor becausw he talks very fast and most of the time i was absent. 😂 I viewed this video but its already our final examination and were done with this subject. haha too late i only got low low grade. 😭😭 if only i have watched this video early 😭😭😭😭
Hey Mary, I wish you would've found my channel earlier! Well, if you need to retake the class, do it and let me know if you have any questions and I will try to help. Have a nice day!
It was a very awesome video. I am a student and I me too have understood this video . Keep it up with more videos. I also gave a like and subscribed your channel.
Steps to Design a Bank Costumer with the following tables in Microsoft access Personal Table, Address Table, Deposit Table and Withdrawal Table. create a query that can display costumer from his state and Generate a report
Can i ask few questions Prof? 1. For primary key, does it have to be an ID/code number? Can i use "supplier name" as the primary key cuz i don't wanna put ID/code for supplier table 2. Once primary key been set and relationship been made with other table, can i change the primary key to a different field on the table? 3. Can i adding data straight on the table or it can only be by form? If it's possible what's the different? Thank you...
Hi Garnita, 1. The primary key doesn't need to be an ID/code number, it only needs to be unique. You can type a supplier name no problem, as long as you don't have 2 suppliers with the same name. 2. As long as the primary key is not the field that the relationship is based off, then changing the primary key field should be fine. 3. You can add data straight on the table. Some people prefer typing on a form, but it's only a matter of preference.
I'm still prepping for the MOS Access exam and most of my issues are with creating objects. I'm comfortable with the basics, but when there are lots of in-depth "extras" to the requirements of the object, I have trouble. Is there a "trick" to know when it's best to use the wizard versus just using design mode?
Hi Amy, Most of the exam deals with creating and editing objects. Usually the exam will tell you to use a Wizard if it wants you to use the Wizard. I recommend not using the Wizard unless it asks for it. I also recommend completing tasks that you know 100% first, then returning to the difficult ones at the end of the exam.
Hi thank you Soo much for such informative and short video. Could you create video about importing data from web that is json data into access table auto run every 15 min . Thank you . you could give some hints on how to address this scenario. Looking forward to you
Hi Sonu, I am glad you enjoyed the video. I am actually not making any additional Access videos at this time. Here is a link that could help you get going though, I hope it helps: stackoverflow.com/questions/30510570/parsing-json-feed-automatically-into-ms-access
literally one day before my test, this saved my life i tell ya
Same here
Same
Same mate!
Lmao same here
really
actually what are you doing here before one day of your test ???? literally this is interesting ahhahahahah
ooh please i am just joking
yeah i was sleeping throughout the whole course and just 2 days before the exam God blessed me with this video. bro this was amazing on a whole new level. thanksss :))
No problem Sabrina, best of luck with your exam! Funny comment, thanks! Have a nice day.
Sabrina Samreen A
Sameeee lmao
same here tmrw is my exam🌚💔
Good luck with your exam Koora!
In less then 10 minutes you explained more then 10 hours of video course!!!! great!!!!
Thank you very much, Adam! This was the most useful video I've ever seen regarding Basic Access aspects. Straight to the point unlike other 2-hour tutorials and very well-explained. Keep up the good work, mate!
This dude is the best, thank you for saving me before the assignments due
God bless you Caraid. Thanks for watching my video .
Thanks!! this type of teaching really feels better than reading text and trying to figure out some black and white blurred picture of instructions! much appreciated!
Just stumbling upon these videos and wow !!! They are detailed enough to get the info across but short enough to where I don't loose interest. VERY GOOD !! Keep it up !!!
Hi Vaughan,
I'm glad you're enjoying the videos. I try to keep them relatively short since I typically cover one or two topics per video. Glad it working for you. Thanks for taking the time to comment! Have a nice day.
Oh damn… tomorrow is my computer practical, 😮 you literally saved me i never practiced access but now I know a lot about it.
This video was awesome. It was awesome because there wan't a lot of extra bologna like most other Access tutorials videos have. Thanks for posting!
I'm glad you enjoyed the video kmunson007. Glad the style of this tutorial worked well for you! Thank you for watching and have a nice day.
This is very helpful thank you for saving me from my exam
This is very helpful! I asked my boss for Access because the survey analysis I need is a bit sophisticated for Excel but then got a little scared trying to learn it on my own. Thank you!!
Hi Lisa,
I hope this video helped you out. I have a playlist for Access beginners that covers the basics in order of difficulty. It is linked below:
ruclips.net/video/psLJJyNlRXY/видео.html
Thank you so much for this great video Professor Morgan. I just randomly found this video. You did a fantastic job of explaining everything and making Access feel much more welcoming and intuitive. Thanks again.
Hey no problem snoopy9292, I am glad this was helpful for you. I have an Access playlist as well that follows the same format if you're learning Access. Thanks a bunch for the comment and for watching the videos:
ruclips.net/video/psLJJyNlRXY/видео.html
i passed my exam becuase of you.. you legendary beast !!!!!!!
Hey Tebogo, congratulations! The Access MOS is not an easy exam to pass, way to go!
The second you said let's get started at 0:09.... I just gave a straight sub and like 👏🏽👏🏽👏🏽👏🏽 my man
I'm not trying to waste anyone's time Hamza, thanks for subscribing I really appreciate it! Have a great day!
Prof Adam,
I want to thank you so much. Thanks to your videos I passed my Accounting Analytics class which includes to build the physical aspect of my REA data model on Access. This is a very hard class, but thank you to your videos I got an A on building my system successfully. I will recommend your videos to my friend who is talking the same class next semester.
Hi Desire,
Thank you for writing this to me, I am glad these videos have been helpful for your Accounting Analytics class. Congratulations on passing with an A, and thank you so much for recommending my videos to your friend. Have a great summer!
Wow!! Your 9 min video really wraps up a 3 hour lecture in my accounting info system class. Thanks so much for the video professor!
Hey thank you Linh! I appreciate you watching and letting me know it was helpful for you. Have a nice day!
WHO TF? would give this video a thumbs down. Thanks this is got to be one of the best Access Database videos I've seen it's simple and to the point and I can't thank you enough for that 🙏🙏
Hi Oscar,
Hey that's a great comment, thank you for that. I am glad this video helped you out, thank you for watching and have a great day!
@@ProfessorAdamMorgan Thanks you too
very precise information ,short ,sharp and straight to the point. I love it. thank you for sharing this !
I’m here because of a test tomorrow (which I will Ace)! My lecture is nothing compared to this Prof. So effortlessly explained.
I gotta admit. I have never seen your channel before but I knew you deserved that subscribe button. Also tmrw is my exam. Guess I joined the studying 1 day before exam crew.
I have a practical exam tomorrow this really helps !! Thank you
I hope you did well on your exam, iiwonderr womanii. Thank you for watching!
@@ProfessorAdamMorgan yes sir I got a 50 in practical and 45 in theory !
Total 95/100 . Thank you 🙏🏼
Congratulations, I am glad you did well on your exam, great job!
I was having a hard time understanding these concepts but they way you explained them helped immensely, thank you!
Hey I'm glad to hear that this video helped you out, NeoSeylum. Thank you for watching!
Thank you very much. I am taking this class and I havent learned much until I watched your video!!
That is great to hear, thank you Desire! Best of luck learning Access and have a great weekend!
@@ProfessorAdamMorgan thank you, and you have a wonderful weekend as well!!
holy crap, my test is tomorrow and u saved my life. thanks !
just getting into the Tutorial now and it seems interesting cause I want to be able to do all of this stuff properly without instructions ( but if I do Get stuck I can come here and figure out how to do it properly without failure) and it is also Really Awesome that i can watch some one and Learn step by step to Make Sure that i am always on point with my work and it has helped me a lot very helpful thank you professor for the knowledge. :)
this guy deserves millions of subs
Hey thanks Gonzalo, maybe I'll get there one day. I appreciate you watching this video, have a nice day.
Man I wish I would have found your channel sooner but I LOVE it. Thank you fore explaining so well, I am in college and this computer stuff is unknown to me.
I'm so glad that you're enjoying my channel, Jameelah. I am glad you're finding it useful. Thanks for letting me know and best of luck learning about computers!
Great Video Professor Morgan! I just finished my project using access for the first time ever with your help!
Woow this help me soo much sir, as am revising for my exam.And praying for grade A 🙏
I hope you were able to earn an A Najma, thank you for watching. I am glad this was helpful for you.
You just helped me pass my exam. I learned so much from your video and may god continue to be bless you....thank you again👌👌
I'm glad you passed your exam Kaunapawa, thank you for watching and have a great day!
I'm writing finals and today is the last paper (Principles of computer programming.. I'm studying IT and computer science)
I missed acess lessons in class and because we were closed during lock down we didn't have much class time
Thanks alot this tutorial explained everything well👍🙏
Short, sweet, and descriptive with examples. This was perfect for me as an absolute beginner
Hey I'm glad the video style worked well for you, upandenergy! Thanks for watching. If you want to learn more, here is my Access Playlist, sorted by difficulty:
ruclips.net/video/psLJJyNlRXY/видео.html
Man you saved my life, i didn’t know that making query is that simple. My teacher is jerk💔
All of them are
Better than my lecturer🎉 u won my sub bro keep up
wonderful, i like how you deliver the word in order to make it viewer understand, you got it, i became more understand from your clear explanation, hopefully your vidio is usefull for everyone who need the information about mc. access
Thanks so much, Netta. I appreciate you watching.
great job man! i like your fast, concise and button-lined tutorials
Hey thank you United Cleaning, I appreciate the comment. Have a good one and let me know if you have any questions.
I have a final project coming up for a class and this was extremely helpful. Thank you so much!!
Tq Prof, really helfull. Short but clear
I am using your videos
for my revision for my finals. Ty!!!
I'm glad to hear that, Adele. Thanks for watching and good luck with your finals!
The other comments given below by others like me are very correct. He's made learning Access more Easier!
1 hour before The exam u saved my Life thank u
Wow!!!!! I have seen many channels Wich are "Professionals" but after watching the videos I feel kind of lost. But you Sr.!!!! Really like your videos , direct to the point . Thanks and keep the good work. I hope to see more complicated stuff 😀
Hey Michael,
Thanks a bunch for this comment. Yeah, my channel is low budget but I try to get to the point of the video quickly, and present in a way that is easy to understand. Most of my classes cover the basics of Access, but I occasionally get questions about the MOS Exam so I touch on more complicated concepts. If their is anything you want to know, let me know in any comment section.
Thank you! You did a fantastic job! I was finally able to figure out how queries work together with reports. You filled in all the blanks (in my brain) that I needed to get the job done. Liking and subscribing!
Can u help me? Do u have Instagram or Facebook
Thanks Professor Adam really great video and for saving me before my assignment is due Thanks
I wish I could put more then 1 thumb up! This video helped me so much!
Thanku prof, u SAVED my life🙏🙏🙏one thumb is not enough👍👍👍👍
Easy to understand and very informative. Thank you for making this video!
No problem Chloe, I am glad it was helpful for you. Thank you for watching!
Excellent tutorial videos Sir! Very helpful, kinda surprised you're not on Udemy or any of the other edcuational platforms. Keep up the excellent work!
Hi Abyi,
I'm glad you enjoy them! I've considered it, but I prefer to give my content on a free platform that can reach the most amount of people possible. Right now, that's RUclips.
@@ProfessorAdamMorganThank you for being a BLESSING 🙏❤
Test....! This man just saved me at work! Thank you!
learnt 3 concept in under 10 minutes. thats awesome
Thanks it helped me the most
Thanks so much, Professor Adam! This had helped me tremendously with my Accounting! 👍
No problem Cristina, I'm glad this helped you out. Best of luck with Accounting and have a nice day!
Thanx for such a amazing helpful easy method video. I could not get these things from my teacher but you explained it so simply☺️☺️
You're one hell of a life saver! LOVE IT MAN!!!!
I'm glad this helped you, Arman. Thank you for watching!
Thank you for helping me with my assignment! You're the best =P
Hey I'm glad it helped you out Brena, thank you for watching! Have a nice day.
my subject is all about database (DATAMAN database management) this semester. all of these tutorial you were teaching was everything that we discussed throughout the semester from making tables down to reports..and i honestly didnt get and understand my instructor becausw he talks very fast and most of the time i was absent. 😂 I viewed this video but its already our final examination and were done with this subject. haha too late i only got low low grade. 😭😭 if only i have watched this video early 😭😭😭😭
Hey Mary,
I wish you would've found my channel earlier! Well, if you need to retake the class, do it and let me know if you have any questions and I will try to help. Have a nice day!
thank you brother.i am watching form Bangladesh.very helpful vedio.
No problem, Admond. Thank you for watching from Bangladesh!
thanks, sir! this video really helped me out for my computer exam 👍
Thank you for a simple and easy to understand explanation!
Your videos are incredibly helpful. You make Access easy to understand. Do you have a video on how to sort reports?
It was a very awesome video. I am a student and I me too have understood this video . Keep it up with more videos. I also gave a like and subscribed your channel.
Thank you for watching, Malina I am glad this helped you. I will make more videos soon, thanks for subscribing!
Thank you for this amazing explanation professor Adam
Glad it was helpful!
You are the best broe you just bailed me out im writing tomorrow 🤞🏽🤝🏽
I was never exposed to Microsoft access. it helped loads
Hi Sisonke,
I'm glad you're enjoying it now. Thanks for watching my videos, let me know if you have any questions.
Hi Adam you the best!! simple and well taught, I dont know why others make it complicated. Please make a video of VBA.
I really enjoyed learning access with you. Thank you sir
Short and crisp. Thanks.
You're welcome!
Such a great tutorial with easy to follow directions. Thank you so much!
I learn more in this video than a 3 hour college class man
I'm glad to hear that, thanks for watching, Joel.
Tomorrow for me activity
Actually I think I will fail but you help me Thank you so much ❤️
I hope that you didn't fail your exam, Madhumitha! Thank you for watching and have a nice day.
Thanks sir
Very helpful. Short and sweet. Thank you!
I’m glad this video was helpful for you, Peter. Thank you for watching!
Ohh.. Thank god and thank to you too.. I paased my exam successfully 🙏
Thank you Professor, this has been very helpful for my hands-on computer test.
Clutch! I appreciate you. Searching for your property sheet video now
Thanks Adam, very well done. Easy to follow and informative. I'll subscribe for some more of your Access content.
I had practical tommorow and it is helping alot thank you
I hope you did well on your practical, Abdur. Thank you for watching!
I did well and Thankyou for this great video
No problem problem, have a nice day!
Just an amazing easy and clear explanation, thanks professor 👍🏻
Thanks fam and it was awesome. You are very intelligent😍😍😍
Hey thank you Takudzwa, I appreciate that. Thank you for watching.
Thanks Prof, this is really helpful.
The video was awesome.quite helpful .Be blessed.thankyou
Very nice presentation. Thank you very much.
Glad you liked it! Thanks for watching, Mammen.
It was very helpful . Thank you so much !
Glad it was helpful! Thanks for watching, Jaqueline!
Because of I completed my computer practice by my self...❤️❤️
You are a great teacher.
Thank you for saying that Kerridak. Have a great day!
Thank you for the video!!!
Question...
Wich version of Visual Basic can I use to manipulate my Access 2016 Data Base?
Thanks.
Steps to Design a Bank Costumer with the following tables in Microsoft access
Personal Table, Address Table, Deposit Table and Withdrawal Table.
create a query that can display costumer from his state and Generate a report
This tutorial was very helpful thank you Professor Adam well done!👍👏🎉
Hey thanks Christelle, I appreciate you watching the video. Have a nice day!
Thank you so much! The video helped me with my assignment.
Thanks man. It is gonna help with my assignment.
This was so helpful. Thanks a lot bro
No problem 👍
Great explanation and easy to understand, thanks..
No problem Garnita, glad it was helpful for you!
Can i ask few questions Prof?
1. For primary key, does it have to be an ID/code number? Can i use "supplier name" as the primary key cuz i don't wanna put ID/code for supplier table
2. Once primary key been set and relationship been made with other table, can i change the primary key to a different field on the table?
3. Can i adding data straight on the table or it can only be by form? If it's possible what's the different?
Thank you...
Hi Garnita,
1. The primary key doesn't need to be an ID/code number, it only needs to be unique. You can type a supplier name no problem, as long as you don't have 2 suppliers with the same name.
2. As long as the primary key is not the field that the relationship is based off, then changing the primary key field should be fine.
3. You can add data straight on the table. Some people prefer typing on a form, but it's only a matter of preference.
I see, understood.. thank you very much, it help a lot :)
No problem Garnita, I am glad it was helpful for you!
I'm still prepping for the MOS Access exam and most of my issues are with creating objects. I'm comfortable with the basics, but when there are lots of in-depth "extras" to the requirements of the object, I have trouble. Is there a "trick" to know when it's best to use the wizard versus just using design mode?
Hi Amy,
Most of the exam deals with creating and editing objects. Usually the exam will tell you to use a Wizard if it wants you to use the Wizard. I recommend not using the Wizard unless it asks for it. I also recommend completing tasks that you know 100% first, then returning to the difficult ones at the end of the exam.
Hey thanks!!!
This helped me doing my project .....
Thank u so much
Glad it helped! Thank you for watching!
@@ProfessorAdamMorgan u are really very good......
Thank you! Have a nice day.
That was very helpful to learn that all in a short time.
Thank you very much.
Thank you, Professor. it helped alot in my studies.🙏🙏
This was super helpful, thank you!
I'm glad this was helpful for you, Briana. Thank you for watching and have a nice day.
Hi thank you Soo much for such informative and short video. Could you create video about importing data from web that is json data into access table auto run every 15 min . Thank you . you could give some hints on how to address this scenario. Looking forward to you
Hi Sonu,
I am glad you enjoyed the video. I am actually not making any additional Access videos at this time. Here is a link that could help you get going though, I hope it helps:
stackoverflow.com/questions/30510570/parsing-json-feed-automatically-into-ms-access
Thanks a lot man!
So clear and very helpful.
More grace bro keep up th good work👍
Unusually helpful.... U r incredibly awesome
Hey thanks Sadaf, I'm glad this was helpful for you. Thanks for watching!