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!

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

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

[@ITACHI_QUOTEZ]

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

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

[@iNeelamSingh]

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

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

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

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

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

[@GoniSiromare-ol1ce]

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

[@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

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

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

[@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

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

[@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

[@lavinmohammad7716]

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

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

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

[@karimallam4757]

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

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

[@naylianas8159]

Tq Prof, really helfull. Short but clear

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

[@darkprince0012]

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

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

[@pranishrubixcube4595]

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

[@urbestie4396]

1 hour before The exam u saved my Life thank u

[@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

[@nicksrandom3277]

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

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

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

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

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

[@bensonmophakedi9159]

learnt 3 concept in under 10 minutes. thats awesome

[@VishalPatel-gb2ri]

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

[@carmenrichey4841]

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

[@SoloMomJourney]

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

[@OrbZo-n6x]

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

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

[@sunitakurre4604]

Thanks it helped me the most

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

[@NancyOlague-rw7ot]

Thank you for a simple and easy to understand explanation!

[@rietta1166]

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

[@anjalisahani1345]

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

[@admondtonu5756]

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

[@ProfessorAdamMorgan]

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

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

[@shaunakdeshpande9408]

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

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

[@khulekaniclive2091]

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

[@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

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

[@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

[@anbarasankannan4740]

I really enjoyed learning access with you. Thank you sir

[@armanlakha9200]

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

[@ProfessorAdamMorgan]

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

[@nicyshiko2563]

Thanks Prof, this is really helpful.

[@CJII269]

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

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

[@Musteasanimande_ingawa]

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

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

[@gopinath6765]

Thank you for this amazing explanation professor Adam

[@ProfessorAdamMorgan]

Glad it was helpful!

[@joysetbeforeme]

Very helpful. Short and sweet. Thank you!

[@ProfessorAdamMorgan]

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

[@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 🙏❤

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

[@donnakessler48]

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

[@davegoodo3603]

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

[@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☺️☺️

[@valarierono3458]

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

[@bostonplayroom1]

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

[@vishaladhithiya2884]

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

[@mammenjohn2179]

Very nice presentation. Thank you very much.

[@ProfessorAdamMorgan]

Glad you liked it! Thanks for watching, Mammen.

[@navyasingh__1081]

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

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

[@RakeshKumar-rz6eh]

Short and crisp. Thanks.

[@ProfessorAdamMorgan]

You're welcome!

[@sharathkoshy9002]

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

[@takudzwamicheal991]

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

[@ProfessorAdamMorgan]

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

[@MarcoASilva-zx7to]

Thank you for the video!!! Question... Wich version of Visual Basic can I use to manipulate my Access 2016 Data Base? Thanks.

[@jaquelinejane798]

It was very helpful . Thank you so much !

[@ProfessorAdamMorgan]

Glad it was helpful! Thanks for watching, Jaqueline!

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

[@exc70]

Thanks man. It is gonna help with my assignment.

[@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

[@tolasamson8238]

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

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

[@amyegunn4919]

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?

[@ProfessorAdamMorgan]

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.

[@captainfun6906]

Good Explanation Brother

[@t5698]

Hi Adam how do you add the total function on a report ? And how do you create reports on Excel ?

[@ProfessorAdamMorgan]

Hi Taha, Sure, so after you create your report, go to the content control that you want to add up. Then go to the Report Layout Tools 'Design' tab. In the Grouping and Totals group and select the Totals button. This will bring up a drop down list, select sum. This will add a total content control at the bottom of the column. I hope this helps you. You can convert your Access tables to Excel. I have a video explaining how to do this, so please have a look at it here: kzbin.info/www/bejne/p4m4XqGwi7Wpg9U

[@kerridak]

You are a great teacher.

[@ProfessorAdamMorgan]

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

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

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

[@PiyumSankalpa]

That was very helpful to learn that all in a short time. Thank you very much.

[@WNTR_JOYTOY04]

UR THE BEST I HOPE U BECOME A BIILLIONIAR ONE DAY

[@missboom07]

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

[@shimlagarg5747]

You made my day Thank you very much sir

[@natalieargote4744]

thank you. ur videos r helping me w my project

[@FranklineBungha]

More grace bro keep up th good work👍

[@shilpibajpai685]

Thanks I was having only one braincell about this topic but now I'm having all . I understood all ! HuRray. Regards Archiee Bajpai

[@SoSoSeriousAB]

This was so helpful. Thanks a lot bro

[@ProfessorAdamMorgan]

No problem 👍

[@TOMRYANLUKE]

Thank you sir, really appreciate the effort and help.