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

Поделиться
HTML-код
  • Опубликовано: 13 янв 2025

Комментарии • 497

  • @khaya8493
    @khaya8493 4 года назад +150

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

  • @TinaxVale
    @TinaxVale Год назад +8

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

  • @sabrinasamreen3861
    @sabrinasamreen3861 6 лет назад +54

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

  • @cosmin4510
    @cosmin4510 2 года назад +14

    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!

  • @caraid3957
    @caraid3957 3 года назад +8

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

  • @vaughanbogran2156
    @vaughanbogran2156 6 лет назад +2

    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
      @ProfessorAdamMorgan  6 лет назад

      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.

  • @ricsellang2481
    @ricsellang2481 2 года назад +1

    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
    @ITACHI_QUOTEZ 3 года назад +10

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

  • @snoopy9292
    @snoopy9292 6 лет назад +14

    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
      @ProfessorAdamMorgan  6 лет назад +3

      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

  • @kmunson007
    @kmunson007 6 лет назад +21

    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
      @ProfessorAdamMorgan  5 лет назад +6

      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.

  • @HamzaMohamed-xj9tz
    @HamzaMohamed-xj9tz 5 лет назад +3

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

    • @ProfessorAdamMorgan
      @ProfessorAdamMorgan  5 лет назад +1

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

  • @iNeelamSingh
    @iNeelamSingh 4 месяца назад +1

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

  • @GoniSiromare-ol1ce
    @GoniSiromare-ol1ce Год назад +3

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

  • @lisacaravello1086
    @lisacaravello1086 4 года назад +2

    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
      @ProfessorAdamMorgan  4 года назад +1

      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

  • @teefit3102
    @teefit3102 6 лет назад +28

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

    • @ProfessorAdamMorgan
      @ProfessorAdamMorgan  6 лет назад +4

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

  • @gonzaloasegurado5429
    @gonzaloasegurado5429 5 лет назад +4

    this guy deserves millions of subs

    • @ProfessorAdamMorgan
      @ProfessorAdamMorgan  5 лет назад +1

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

  • @naylianas8159
    @naylianas8159 Год назад +1

    Tq Prof, really helfull. Short but clear

  • @josephmanoj45
    @josephmanoj45 3 года назад +1

    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.

  • @sunitakurre4604
    @sunitakurre4604 Год назад +1

    Thanks it helped me the most

  • @OS-qd5wo
    @OS-qd5wo 5 лет назад +1

    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
      @ProfessorAdamMorgan  5 лет назад

      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
      @OS-qd5wo 5 лет назад +1

      @@ProfessorAdamMorgan Thanks you too

  • @FresitaDM
    @FresitaDM 5 лет назад +1

    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
      @ProfessorAdamMorgan  5 лет назад

      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!

  • @pranishrubixcube4595
    @pranishrubixcube4595 Год назад

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

  • @karimallam4757
    @karimallam4757 4 года назад

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

  • @LT-st8rf
    @LT-st8rf 5 лет назад +2

    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
      @ProfessorAdamMorgan  5 лет назад

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

  • @unitedcleaning1876
    @unitedcleaning1876 6 лет назад +5

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

    • @ProfessorAdamMorgan
      @ProfessorAdamMorgan  6 лет назад +3

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

  • @FresitaDM
    @FresitaDM 5 лет назад +2

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

    • @ProfessorAdamMorgan
      @ProfessorAdamMorgan  5 лет назад +1

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

    • @FresitaDM
      @FresitaDM 5 лет назад +1

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

  • @darkprince0012
    @darkprince0012 9 месяцев назад

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

  • @welcometowatchmojo6152
    @welcometowatchmojo6152 5 лет назад +5

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

    • @ProfessorAdamMorgan
      @ProfessorAdamMorgan  5 лет назад +1

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

    • @welcometowatchmojo6152
      @welcometowatchmojo6152 5 лет назад +2

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

    • @ProfessorAdamMorgan
      @ProfessorAdamMorgan  5 лет назад +1

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

  • @OrbZo-n6x
    @OrbZo-n6x 3 года назад

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

  • @carmenrichey4841
    @carmenrichey4841 4 года назад +2

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

  • @bensonmophakedi9159
    @bensonmophakedi9159 3 года назад

    learnt 3 concept in under 10 minutes. thats awesome

  • @armanlakha9200
    @armanlakha9200 4 года назад +2

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

  • @RakeshKumar-rz6eh
    @RakeshKumar-rz6eh 4 года назад +1

    Short and crisp. Thanks.

  • @adelenatashabemberry5505
    @adelenatashabemberry5505 4 года назад +1

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

    • @ProfessorAdamMorgan
      @ProfessorAdamMorgan  4 года назад

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

  • @VishalPatel-gb2ri
    @VishalPatel-gb2ri 3 года назад +2

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

  • @katehogg243
    @katehogg243 15 дней назад

    You have great videos ! you explain things clearly thank you

  • @upandenergy
    @upandenergy 5 лет назад +1

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

    • @ProfessorAdamMorgan
      @ProfessorAdamMorgan  5 лет назад

      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

  • @nicksrandom3277
    @nicksrandom3277 2 года назад

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

  • @bloodhound000
    @bloodhound000 5 лет назад +1

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

    • @ProfessorAdamMorgan
      @ProfessorAdamMorgan  5 лет назад

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

  • @urbestie4396
    @urbestie4396 3 года назад

    1 hour before The exam u saved my Life thank u

  • @lavinmohammad7716
    @lavinmohammad7716 3 года назад

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

  • @Anime_Apostle
    @Anime_Apostle 3 года назад

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

  • @nettahandika7075
    @nettahandika7075 4 года назад +2

    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

  • @upshawconsulting2024
    @upshawconsulting2024 5 лет назад +1

    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
      @ProfessorAdamMorgan  5 лет назад

      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
    @chloeliu6642 5 лет назад +3

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

    • @ProfessorAdamMorgan
      @ProfessorAdamMorgan  5 лет назад +1

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

  • @admondtonu5756
    @admondtonu5756 4 года назад +1

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

  • @gisellehorne3961
    @gisellehorne3961 3 года назад +2

    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
      @arianazara6794 2 года назад

      Can u help me? Do u have Instagram or Facebook

  • @abyiyeshigeta3058
    @abyiyeshigeta3058 4 года назад +6

    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
      @ProfessorAdamMorgan  4 года назад +1

      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.

    • @bennyaustin3169
      @bennyaustin3169 Год назад +1

      ​@@ProfessorAdamMorganThank you for being a BLESSING 🙏❤

  • @joysetbeforeme
    @joysetbeforeme 5 лет назад +1

    Very helpful. Short and sweet. Thank you!

    • @ProfessorAdamMorgan
      @ProfessorAdamMorgan  5 лет назад

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

  • @malinasarkar5099
    @malinasarkar5099 4 года назад +2

    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
      @ProfessorAdamMorgan  4 года назад

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

  • @NancyOlague-rw7ot
    @NancyOlague-rw7ot Год назад

    Thank you for a simple and easy to understand explanation!

  • @nicyshiko2563
    @nicyshiko2563 3 года назад +1

    Thanks Prof, this is really helpful.

  • @rietta1166
    @rietta1166 4 года назад

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

  • @kerridak
    @kerridak 6 лет назад +2

    You are a great teacher.

  • @gopinath6765
    @gopinath6765 4 года назад +2

    Thank you for this amazing explanation professor Adam

  • @brenanguyen8
    @brenanguyen8 6 лет назад +9

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

    • @ProfessorAdamMorgan
      @ProfessorAdamMorgan  6 лет назад +2

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

  • @najmasalum4663
    @najmasalum4663 5 лет назад +3

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

    • @ProfessorAdamMorgan
      @ProfessorAdamMorgan  5 лет назад

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

  • @bostonplayroom1
    @bostonplayroom1 3 года назад +2

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

  • @SoloMomJourney
    @SoloMomJourney 2 года назад

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

  • @valarierono3458
    @valarierono3458 4 года назад

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

  • @donnakessler48
    @donnakessler48 2 года назад

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

  • @jaquelinejane798
    @jaquelinejane798 4 года назад +1

    It was very helpful . Thank you so much !

  • @anbarasankannan4740
    @anbarasankannan4740 3 года назад

    I really enjoyed learning access with you. Thank you sir

  • @mammenjohn2179
    @mammenjohn2179 4 года назад +1

    Very nice presentation. Thank you very much.

  • @growingupwithharoon8988
    @growingupwithharoon8988 5 лет назад +1

    thank you soo much really I am learning lot of things from you.

    • @ProfessorAdamMorgan
      @ProfessorAdamMorgan  5 лет назад

      I am happy that you're learning from my videos, Hallema. Thank you for watching!

  • @davegoodo3603
    @davegoodo3603 Год назад

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

  • @Musteasanimande_ingawa
    @Musteasanimande_ingawa Год назад +1

    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

  • @takudzwamicheal991
    @takudzwamicheal991 4 года назад +1

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

    • @ProfessorAdamMorgan
      @ProfessorAdamMorgan  4 года назад

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

  • @SoSoSeriousAB
    @SoSoSeriousAB 4 года назад +1

    This was so helpful. Thanks a lot bro

  • @khulekaniclive2091
    @khulekaniclive2091 3 года назад

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

  • @kaunapawamulokoshi9266
    @kaunapawamulokoshi9266 5 лет назад +1

    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
      @ProfessorAdamMorgan  5 лет назад

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

  • @brianadperry
    @brianadperry 5 лет назад +2

    This was super helpful, thank you!

    • @ProfessorAdamMorgan
      @ProfessorAdamMorgan  5 лет назад

      I'm glad this was helpful for you, Briana. Thank you for watching and have a nice day.

  • @CristinaFrank
    @CristinaFrank 6 лет назад +13

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

    • @ProfessorAdamMorgan
      @ProfessorAdamMorgan  6 лет назад +4

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

  • @arriaga11
    @arriaga11 6 лет назад +2

    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
      @ProfessorAdamMorgan  6 лет назад

      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.

  • @sadafkhan1679
    @sadafkhan1679 5 лет назад +1

    Unusually helpful.... U r incredibly awesome

    • @ProfessorAdamMorgan
      @ProfessorAdamMorgan  5 лет назад

      Hey thanks Sadaf, I'm glad this was helpful for you. Thanks for watching!

  • @CJII269
    @CJII269 2 года назад

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

  • @kanshashiteiru6552
    @kanshashiteiru6552 4 года назад +1

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

    • @c23rik3
      @c23rik3 3 года назад

      All of them are

  • @ChromeDonutGaming
    @ChromeDonutGaming 4 года назад

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

  • @anjalisahani1345
    @anjalisahani1345 4 года назад

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

  • @shaunakdeshpande9408
    @shaunakdeshpande9408 Год назад

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

  • @luvre44
    @luvre44 2 года назад

    SOOOOOOOOOOOOOOPER HELPFUL man!! Thank you

  • @idibekjalilov
    @idibekjalilov 2 года назад

    Thanks a lot man!
    So clear and very helpful.

  • @21desember1992
    @21desember1992 5 лет назад +1

    Great explanation and easy to understand, thanks..

    • @ProfessorAdamMorgan
      @ProfessorAdamMorgan  5 лет назад

      No problem Garnita, glad it was helpful for you!

    • @21desember1992
      @21desember1992 5 лет назад +1

      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
      @ProfessorAdamMorgan  5 лет назад

      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
      @21desember1992 5 лет назад +1

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

    • @ProfessorAdamMorgan
      @ProfessorAdamMorgan  5 лет назад

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

  • @captainfun6906
    @captainfun6906 2 года назад

    Good Explanation Brother

  • @shivrajmankar8566
    @shivrajmankar8566 Год назад +1

    thanks it helped me a lot!!

  • @FranklineBungha
    @FranklineBungha 8 месяцев назад

    More grace bro keep up th good work👍

  • @andiswagladile8983
    @andiswagladile8983 3 месяца назад

    Ohw this was really helpful😊😊

  • @atokaymensah-forson403
    @atokaymensah-forson403 6 лет назад +2

    This has been very helpful, thanks

  • @kumaransv114
    @kumaransv114 2 года назад

    Thank you ! Informative presentation.

  • @mrchosentaco8725
    @mrchosentaco8725 4 года назад

    Explained Very well !!

  • @simranpreetkaur1087
    @simranpreetkaur1087 4 года назад

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

  • @bensonmophakedi9159
    @bensonmophakedi9159 3 года назад

    you are a great teacher

  • @vishaladhithiya2884
    @vishaladhithiya2884 2 года назад

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

  • @maryjaneaihevba4689
    @maryjaneaihevba4689 4 года назад +1

    This video was acc so helpful. Thank you so much

  • @shimlagarg5747
    @shimlagarg5747 2 года назад

    You made my day
    Thank you very much sir

  • @exc70
    @exc70 3 года назад

    Thanks man. It is gonna help with my assignment.

  • @abdurrafay2955
    @abdurrafay2955 5 лет назад +1

    I had practical tommorow and it is helping alot thank you

  • @navyasingh__1081
    @navyasingh__1081 3 года назад +1

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

  • @sharathkoshy9002
    @sharathkoshy9002 3 года назад +1

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

  • @PiyumSankalpa
    @PiyumSankalpa 3 года назад

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