Access 2016 - Create a Query Report & Form - How to Make Queries Reports Forms in Microsoft Tutorial

[@khaya8493]

literally one day before my test, this saved my life i tell ya

[@ChromeDonutGaming]

Same here

[@paen8547]

Same

[@whitebeardpirates1261]

Same mate!

[@koshyvaidian7662]

Lmao same here

[@musicalworld2703]

really actually what are you doing here before one day of your test ???? literally this is interesting ahhahahahah ooh please i am just joking

[@TinaxVale]

In less then 10 minutes you explained more then 10 hours of video course!!!! great!!!!

[@sabrinasamreen3861]

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

[@ProfessorAdamMorgan]

No problem Sabrina, best of luck with your exam! Funny comment, thanks! Have a nice day.

[@aidanturner2309]

Sabrina Samreen A

[@omiiirifle1858]

Sameeee lmao

[@KOORAVIKINGS]

same here tmrw is my exam🌚💔

[@ProfessorAdamMorgan]

Good luck with your exam Koora!

[@ITACHI_QUOTEZ]

This is very helpful thank you for saving me from my exam

[@ricsellang2481]

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!

[@caraid3957]

This dude is the best, thank you for saving me before the assignments due

[@cheezydrownedatmc5692]

God bless you Caraid. Thanks for watching my video .

[@cosmin4510]

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!

[@teefit3102]

i passed my exam becuase of you.. you legendary beast !!!!!!!

[@ProfessorAdamMorgan]

Hey Tebogo, congratulations! The Access MOS is not an easy exam to pass, way to go!

[@snoopy9292]

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.

[@ProfessorAdamMorgan]

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: kzbin.info/www/bejne/pqSve32vg9GFjrs

[@vaughanbogran2156]

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 !!!

[@ProfessorAdamMorgan]

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.

[@kmunson007]

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!

[@ProfessorAdamMorgan]

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.

[@urbestie4396]

1 hour before The exam u saved my Life thank u

[@iNeelamSingh]

Oh damn… tomorrow is my computer practical, 😮 you literally saved me i never practiced access but now I know a lot about it.

[@welcometowatchmojo6152]

I have a practical exam tomorrow this really helps !! Thank you

[@ProfessorAdamMorgan]

I hope you did well on your exam, iiwonderr womanii. Thank you for watching!

[@welcometowatchmojo6152]

@@ProfessorAdamMorgan yes sir I got a 50 in practical and 45 in theory ! Total 95/100 . Thank you 🙏🏼

[@ProfessorAdamMorgan]

Congratulations, I am glad you did well on your exam, great job!

[@lavinmohammad7716]

I’m here because of a test tomorrow (which I will Ace)! My lecture is nothing compared to this Prof. So effortlessly explained.

[@lisacaravello1086]

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!!

[@ProfessorAdamMorgan]

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: kzbin.info/www/bejne/pqSve32vg9GFjrs

[@GoniSiromare-ol1ce]

very precise information ,short ,sharp and straight to the point. I love it. thank you for sharing this !

[@gonzaloasegurado5429]

this guy deserves millions of subs

[@ProfessorAdamMorgan]

Hey thanks Gonzalo, maybe I'll get there one day. I appreciate you watching this video, have a nice day.

[@FresitaDM]

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.

[@ProfessorAdamMorgan]

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!

[@FresitaDM]

Thank you very much. I am taking this class and I havent learned much until I watched your video!!

[@ProfessorAdamMorgan]

That is great to hear, thank you Desire! Best of luck learning Access and have a great weekend!

[@FresitaDM]

@@ProfessorAdamMorgan thank you, and you have a wonderful weekend as well!!

[@bloodhound000]

I was having a hard time understanding these concepts but they way you explained them helped immensely, thank you!

[@ProfessorAdamMorgan]

Hey I'm glad to hear that this video helped you out, NeoSeylum. Thank you for watching!

[@karimallam4757]

holy crap, my test is tomorrow and u saved my life. thanks !

[@adelenatashabemberry5505]

I am using your videos for my revision for my finals. Ty!!!

[@ProfessorAdamMorgan]

I'm glad to hear that, Adele. Thanks for watching and good luck with your finals!

[@upandenergy]

Short, sweet, and descriptive with examples. This was perfect for me as an absolute beginner

[@ProfessorAdamMorgan]

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: kzbin.info/www/bejne/pqSve32vg9GFjrs

[@josephmanoj45]

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.

[@ChromeDonutGaming]

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👍🙏

[@LT-st8rf]

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!

[@ProfessorAdamMorgan]

Hey thank you Linh! I appreciate you watching and letting me know it was helpful for you. Have a nice day!

[@pranishrubixcube4595]

The other comments given below by others like me are very correct. He's made learning Access more Easier!

[@HamzaMohamed-xj9tz]

The second you said let's get started at 0:09.... I just gave a straight sub and like 👏🏽👏🏽👏🏽👏🏽 my man

[@ProfessorAdamMorgan]

I'm not trying to waste anyone's time Hamza, thanks for subscribing I really appreciate it! Have a great day!

[@OS-qd5wo]

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 🙏🙏

[@ProfessorAdamMorgan]

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!

[@OS-qd5wo]

@@ProfessorAdamMorgan Thanks you too

[@kaunapawamulokoshi9266]

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👌👌

[@ProfessorAdamMorgan]

I'm glad you passed your exam Kaunapawa, thank you for watching and have a great day!

[@najmasalum4663]

Woow this help me soo much sir, as am revising for my exam.And praying for grade A 🙏

[@ProfessorAdamMorgan]

I hope you were able to earn an A Najma, thank you for watching. I am glad this was helpful for you.

[@kanshashiteiru6552]

Man you saved my life, i didn’t know that making query is that simple. My teacher is jerk💔

[@c23rik3]

All of them are

[@naylianas8159]

Tq Prof, really helfull. Short but clear

[@Anime_Apostle]

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. :)

[@admondtonu5756]

thank you brother.i am watching form Bangladesh.very helpful vedio.

[@ProfessorAdamMorgan]

No problem, Admond. Thank you for watching from Bangladesh!

[@bensonmophakedi9159]

learnt 3 concept in under 10 minutes. thats awesome

[@unitedcleaning1876]

great job man! i like your fast, concise and button-lined tutorials

[@ProfessorAdamMorgan]

Hey thank you United Cleaning, I appreciate the comment. Have a good one and let me know if you have any questions.

[@darkprince0012]

Better than my lecturer🎉 u won my sub bro keep up

[@VishalPatel-gb2ri]

Thanks Professor Adam really great video and for saving me before my assignment is due Thanks

[@upshawconsulting2024]

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.

[@ProfessorAdamMorgan]

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!

[@chloeliu6642]

Easy to understand and very informative. Thank you for making this video!

[@ProfessorAdamMorgan]

No problem Chloe, I am glad it was helpful for you. Thank you for watching!

[@nettahandika7075]

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

[@ProfessorAdamMorgan]

Thanks so much, Netta. I appreciate you watching.

[@rietta1166]

Thanku prof, u SAVED my life🙏🙏🙏one thumb is not enough👍👍👍👍

[@OrbZo-n6x]

Test....! This man just saved me at work! Thank you!

[@nicksrandom3277]

Great Video Professor Morgan! I just finished my project using access for the first time ever with your help!

[@SoloMomJourney]

I have a final project coming up for a class and this was extremely helpful. Thank you so much!!

[@NancyOlague-rw7ot]

Thank you for a simple and easy to understand explanation!

[@shaunakdeshpande9408]

thanks, sir! this video really helped me out for my computer exam 👍

[@navyasingh__1081]

Because of I completed my computer practice by my self...❤️❤️

[@sunitakurre4604]

Thanks it helped me the most

[@joysetbeforeme]

Very helpful. Short and sweet. Thank you!

[@ProfessorAdamMorgan]

I’m glad this video was helpful for you, Peter. Thank you for watching!

[@gopinath6765]

Thank you for this amazing explanation professor Adam

[@ProfessorAdamMorgan]

Glad it was helpful!

[@anjalisahani1345]

Ohh.. Thank god and thank to you too.. I paased my exam successfully 🙏

[@mammenjohn2179]

Very nice presentation. Thank you very much.

[@ProfessorAdamMorgan]

Glad you liked it! Thanks for watching, Mammen.

[@vishaladhithiya2884]

Thank you Professor, this has been very helpful for my hands-on computer test.

[@RakeshKumar-rz6eh]

Short and crisp. Thanks.

[@ProfessorAdamMorgan]

You're welcome!

[@armanlakha9200]

You're one hell of a life saver! LOVE IT MAN!!!!

[@ProfessorAdamMorgan]

I'm glad this helped you, Arman. Thank you for watching!

[@anbarasankannan4740]

I really enjoyed learning access with you. Thank you sir

[@simranpreetkaur1087]

Thanx for such a amazing helpful easy method video. I could not get these things from my teacher but you explained it so simply☺️☺️

[@CristinaFrank]

Thanks so much, Professor Adam! This had helped me tremendously with my Accounting! 👍

[@ProfessorAdamMorgan]

No problem Cristina, I'm glad this helped you out. Best of luck with Accounting and have a nice day!

[@abdurrafay2955]

I had practical tommorow and it is helping alot thank you

[@ProfessorAdamMorgan]

I hope you did well on your practical, Abdur. Thank you for watching!

[@abdurrafay2955]

I did well and Thankyou for this great video

[@ProfessorAdamMorgan]

No problem problem, have a nice day!

[@khulekaniclive2091]

You are the best broe you just bailed me out im writing tomorrow 🤞🏽🤝🏽

[@nicyshiko2563]

Thanks Prof, this is really helpful.

[@bostonplayroom1]

Your videos are incredibly helpful. You make Access easy to understand. Do you have a video on how to sort reports?

[@jaquelinejane798]

It was very helpful . Thank you so much !

[@ProfessorAdamMorgan]

Glad it was helpful! Thanks for watching, Jaqueline!

[@tolasamson8238]

Thank you so much! The video helped me with my assignment.

[@joel117-cge]

I learn more in this video than a 3 hour college class man

[@ProfessorAdamMorgan]

I'm glad to hear that, thanks for watching, Joel.

[@sharathkoshy9002]

Hi Adam you the best!! simple and well taught, I dont know why others make it complicated. Please make a video of VBA.

[@CJII269]

Clutch! I appreciate you. Searching for your property sheet video now

[@valarierono3458]

The video was awesome.quite helpful .Be blessed.thankyou

[@arriaga11]

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 😀

[@ProfessorAdamMorgan]

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.

[@donnakessler48]

Such a great tutorial with easy to follow directions. Thank you so much!

[@carmenrichey4841]

I wish I could put more then 1 thumb up! This video helped me so much!

[@gisellehorne3961]

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!

[@arianazara6794]

Can u help me? Do u have Instagram or Facebook

[@abyiyeshigeta3058]

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!

[@ProfessorAdamMorgan]

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 KZbin.

[@bennyaustin3169]

​@@ProfessorAdamMorganThank you for being a BLESSING 🙏❤

[@kanavsabharwal6125]

Hey thanks!!! This helped me doing my project ..... Thank u so much

[@ProfessorAdamMorgan]

Glad it helped! Thank you for watching!

[@kanavsabharwal6125]

@@ProfessorAdamMorgan u are really very good......

[@ProfessorAdamMorgan]

Thank you! Have a nice day.

[@brenanguyen8]

Thank you for helping me with my assignment! You're the best =P

[@ProfessorAdamMorgan]

Hey I'm glad it helped you out Brena, thank you for watching! Have a nice day.

[@StellaRelaxingStation]

This tutorial was very helpful thank you Professor Adam well done!👍👏🎉

[@ProfessorAdamMorgan]

Hey thanks Christelle, I appreciate you watching the video. Have a nice day!

[@sisonkewani1975]

I was never exposed to Microsoft access. it helped loads

[@ProfessorAdamMorgan]

Hi Sisonke, I'm glad you're enjoying it now. Thanks for watching my videos, let me know if you have any questions.

[@madhumithabala6152]

Tomorrow for me activity Actually I think I will fail but you help me Thank you so much ❤️

[@ProfessorAdamMorgan]

I hope that you didn't fail your exam, Madhumitha! Thank you for watching and have a nice day.

[@madhumithabala6152]

Thanks sir

[@boonaawakshumaa9281]

thank you professor i am understand many things.this is they have close relationship with my department

[@takudzwamicheal991]

Thanks fam and it was awesome. You are very intelligent😍😍😍

[@ProfessorAdamMorgan]

Hey thank you Takudzwa, I appreciate that. Thank you for watching.

[@natalieargote4744]

thank you. ur videos r helping me w my project

[@aishiteru-od4im]

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 😭😭😭😭

[@ProfessorAdamMorgan]

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!

[@sonupatel-rc8ms]

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

[@ProfessorAdamMorgan]

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

[@malinasarkar5099]

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.

[@ProfessorAdamMorgan]

Thank you for watching, Malina I am glad this helped you. I will make more videos soon, thanks for subscribing!

[@exc70]

Thanks man. It is gonna help with my assignment.

[@kerridak]

You are a great teacher.

[@ProfessorAdamMorgan]

Thank you for saying that Kerridak. Have a great day!

[@maryjaneaihevba4689]

This video was acc so helpful. Thank you so much

[@ProfessorAdamMorgan]

You're so welcome!

[@21desember1992]

Great explanation and easy to understand, thanks..

[@ProfessorAdamMorgan]

No problem Garnita, glad it was helpful for you!

[@21desember1992]

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

[@ProfessorAdamMorgan]

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.

[@21desember1992]

I see, understood.. thank you very much, it help a lot :)

[@ProfessorAdamMorgan]

No problem Garnita, I am glad it was helpful for you!

[@kumaransv114]

Thank you ! Informative presentation.

[@TOMRYANLUKE]

Thank you sir, really appreciate the effort and help.

[@missboom07]

Just an amazing easy and clear explanation, thanks professor 👍🏻

[@davegoodo3603]

Thanks Adam, very well done. Easy to follow and informative. I'll subscribe for some more of your Access content.

[@odix76057573]

Simplified. Thanks for the video

[@ProfessorAdamMorgan]

I'm glad this was helpful for you, Raphael. Thanks for watching!

[@ektaralh5558]

Thanks a lot. Your video really helped me.

[@shimlagarg5747]

You made my day Thank you very much sir

[@nehemaihndimloh3241]

Thank you so much for this Sir, it helped a lot in my project work.

[@SoSoSeriousAB]

This was so helpful. Thanks a lot bro

[@ProfessorAdamMorgan]

No problem 👍