Access Beginner Tutorial

Поделиться
HTML-код

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

  • @jamesgrant5945
    @jamesgrant5945 4 года назад +76

    Dear Sir
    I would just like to say that whilst browsing the internet looking for information on how to create a personal database using Access 2019, I stumbled onto your video “Access Beginner Tutorial”.
    I learnt more in half an hour of watching the video that I had in days.
    Dan McAllister is such a good teacher. Takes you through each section and gives you time to try every little thing. He has such a wonderful calming voice, unlike presenters of other video’s. He does you credit.
    I’ll be sticking with your video and hoping that the information sinks into this 68 year old brain sufficiently for me to produce the database I need.
    Thank you

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

      Glad you got more out of it

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

      Sir I m 50 year old and I inspired to you 🎉.

  • @LearnwithCSDTech
    @LearnwithCSDTech Год назад +29

    This is the best course for MS Access that I found on RUclips. I appreciate you for creating that much valuable content freely available to all. Thank you very much!

  • @shahinulkhan7879
    @shahinulkhan7879 Год назад +18

    Thank you so much.
    I have now watched this 3 times. Made a complex database (at least by my standard). Made tons of mistakes. Came back here to get the basics right. You covered it all. But for a newbie making mistakes was important learning.
    What an amazing course.
    Onwards and upwards.

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

      Hi Shahinul! That is great to hear! We are glad you learned so much!

  • @arunshinde1507
    @arunshinde1507 3 года назад +4

    This tutorial is amazing for beginners. The flow of session is maintained brilliently till end. You get hands on experience while watching this tutorial. One of the best course.

  • @MaineBassGuy
    @MaineBassGuy 3 года назад +20

    I like that the humor, anecdotes, and personality come forward slowly throughout the video. Like, I've lured you in with my professional acumen but keeping you here for Steven Wright and Billy Crystal references.

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

    This is brilliant. I have done a lot off access but not for ages and had forgotten some of the steps. Of course as soon as I see you do the step I am thinking how did I forget that. What I really like is how you don't miss out any detail especially the simple details that some trainers skip right over forgetting that not everybody already knows the actions to take. Doe example the different ways to open, close and not change a record.

  • @mepshtain
    @mepshtain 2 года назад +6

    Dear Dan, I learned Access many years ago ,1995, but have not used it since. Now I wanted to design a database for my work and came to look for a refreshment and what a surprise!. You are a great teacher know exactly how to present a subject and how to lead your student especially on such a remote learning. I enjoyed every moment. Thank you so much. So many thinks we can learn from the way you teach. Well done.

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

      Thank you for the kind words Moshe! Dan was one of our best instructors and is deeply missed here at Learnit!

  • @mjl1966y
    @mjl1966y 3 года назад +5

    Oh man, it has been at least 15 years since I've done the Northwind thing. Amazing how much you can forget!

  • @koteshwarpanuganti3507
    @koteshwarpanuganti3507 3 года назад +7

    I have gone through whole Beginner Access video. I really appreciate and happy for the video and Learnit team for doing this great job. It was long pending dream of learning Microsoft Access. Atlast, i found the perfect video to learn. Thanks a lot.

  • @redsanders8754
    @redsanders8754 4 года назад +3

    EXCELLENT teaching techniques! My job for many years was to observe and evaluate the instructional skills and techniques of middle and high school science and math teachers. Later I served as an Instructional Technology Director, during which some of my duties were to design and conduct classes for K-12 teachers on MS Windows, Word, Excel and PowerPoint. I designed a database that tracked the classes and performances of all teachers that attended our classes. I toyed with the idea of teaching MS Access, but never felt that my knowledge was as complete as it should have been to do as good a job as I would have wanted to do. Watching your "Beginner Tutorial" confirms that I have gaps in my knowledge! :-) I guess I never really took the time to fully explore all of the nooks and crannies of MS Access.
    Aside from having a firm understanding the content for which you are teaching (which sadly was not always the case for some teachers with whom I worked), you employ essential techniques, such as making few assumptions of the viewers' knowledge. For example, you include expected behaviors of Windows, and not just Access. Other extremely important techniques that you employ are: You FREQUENTLY loop back to review and hopefully reinforce what has been taught; You provide "wait time" so that viewers to follow the pace of your instruction; You raise the possibility of problems occurring, and patiently illustrate how to either avoid or address them; You check for understanding by giving viewers chances to implement procedures that you taught by letting them try out their understanding before you proceed. You use appropriate and reasonable amounts of humor at appropriate times to relieve mental tension. Consequently, your pace is not hurried, which is essential when teaching somewhat difficult content such as this.
    Ok, I can "see" and "hear" some techies moaning and rolling their eyes at my comments, and at your instructional methods. I strongly suspect that they have never tried to EFFECTIVELY teach folks for whom technology is not as easy to learn as it is for them. I've attended MANY classes conducted by techies whose apparent goal was to impress their students of how much they knew, rather than effectively teach. And BOY does that turn off many learners!!!
    And WOW...the time you and your organization take to make videos with this much detail and length at no cost to viewers. Very rare, and very much appreciated!
    Dan, based on your instructional performance in this video, I would have given you my highest marks in my evaluation. I wish I could see you teach in person, it would be a pleasure!

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

      BTY James Grant, I'm working with a 78 year old brain, and have the same hopes as you. My son-in-law has come to me with the need to create a database for his small business. After having not used Access for more than 10 years, I'm really dusting off the mental cobwebs and making my brain ache again. Feels good! :-)

  • @damienhackney6499
    @damienhackney6499 4 года назад +8

    Excellent teacher. Thank you!

  • @michellguzelgul4267
    @michellguzelgul4267 3 года назад +4

    So impressive. Wish I could like a video twice.

  • @ethansodaro3945
    @ethansodaro3945 Год назад +5

    A silky voice, excellent sense of humour and superb quality course. Dan McAllistar, thank you! I really enjoyed following along.

  • @jeffdeutsch
    @jeffdeutsch 2 года назад +7

    Terrific. I'm a former database programmer and it's been years. Going to design a dbase for my work in Access and needed to run through how things work here. Did some fast forwarding but you are a great teacher... You know the material but you know how to teach as well! : )

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

      Thank you for watching and an extra big thank you for subscribing!

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

    I was so scared when I first got to do with access but with your video I started to understand better the things in it. Thank you

  • @RobertBrunnerBREG
    @RobertBrunnerBREG Год назад +4

    I have taken a dozen or so courses in database management, Filemaker Pro and Access. This instructor is really, really good, I love how he gets right into hands on stuff and keeps your interest. Other courses start with very mundane technocrap. I am definitely going to look into paying for additional courses. Well played Mr. McAllister, well played.

  • @b9watchkeeper903
    @b9watchkeeper903 3 года назад +7

    you are such an amazing teacher.i love to have private classes whenever possible,,,100 percent undertood.

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

    Enjoyed the course. Only recommendation would be to correct whatever happened at 2:33:33.

  • @CrisStuart
    @CrisStuart 2 года назад +2

    ⭐⭐⭐⭐⭐ 5 STARS is what I give you for the incredibly didactic trainning !!!! I'M FROM BRASIL , RIO DE JANEIRO and I prefer study by American Professors and teachers... Your training is good because of the 3 points I consider crucial: 1)Your language is clear and to the point 2)Your exemples are exactly what we find in the files (no unpleasant surprises as some other not so didactic teachers from Learnit made me go through while following their classes, rendering me a lot of headaches!!!) 3)You are a very detail-oriented person, which made me like you even more!!!!
    ....
    I wish all the success, health and joy to you!!! You are one in a million... !!!! 🙏🙏🙏

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

      Thank you so much for the kind words Cris! We are glad you learned so much!

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

    Wow! That you SO much for your generosity, time, skill, warm demeanor and humour.
    The only other similar comprehensive course I could find had some free videos but for a thorough continuous course I would have had to pay far more than I could afford. I have tried several times to learn Access - using books, videos and other means, and I have become frustrated and defeated every time - until now thanks to you. I am half way through the first series and look forward to working through the other 3. The idea of sample files and pausing for us to repeat actions is brilliant. Again, thanks so much Dan!
    PS. I have also made available hours of free RUclips content (on Inkscape), and am grateful to others like you who generously assist others to learn via RUclips.

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

      You are very welcome! We hoped you learned alot!

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

    Best teacher, this is not a lesson, this is an adventure, a roller Coaster of Access. the course is very well structured and presented with amazing flow.
    thank you DAN.

  • @cozycubix
    @cozycubix 4 года назад +5

    Thank you very much , Good work - you are an excellent professional.

  • @grahamlamming1128
    @grahamlamming1128 3 года назад +12

    Best style of teaching I’ve come across. By far the best, love it.

  • @semagull6126
    @semagull6126 4 года назад +5

    Your good work is visible, even to the one who doesn’t want to see. Job well done and May you be rewarded handsomely!

  • @veronicacebanu7210
    @veronicacebanu7210 3 года назад +4

    The best explanation! It’s very easy to understand with this wonderful sense of humor! Great 👍 job! Thanks 🙏!

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

    Just ended This Video and I Am !00% Statisfied It Was Worth It. Best Teacher On RUclips For Computer Programs Learnings

  • @mehdi.sajadi
    @mehdi.sajadi Год назад +2

    You're the best instructor ever, and explain everything in detail, thank you very much

  • @okenkei-solutions452
    @okenkei-solutions452 Год назад +2

    So far so good this is the best Access course I’ve come across. Thank you so much for this quality but free video.

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

    Greetings from New Zealand. You're an awwwesome tutor, Excellent content too. I'd say personally this is the BEST tutorial in regards to Microsoft Access for beginners. Your other " Microsoft tutorials " are top notch too. Thanks, cheers

  • @kazerog2000
    @kazerog2000 11 месяцев назад +1

    I am an an experienced access user, but I found many small things I did not know. Thank you for the tutorial.

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

    Great training. Thanks a lot.

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

    Success in life comes from great teachers

  • @nextstep2239
    @nextstep2239 3 года назад +6

    Thank you so much, you're seriously an amazing trainer.

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

    Thanks for the video, really good and easy to follow.

  • @gersiveshi
    @gersiveshi 7 месяцев назад +1

    My congratulations on this wonderful course!!! I admire your simplicity in explaining things and getting into details step-by-step. This is a wonderful course!

  • @raizadavarun
    @raizadavarun 3 года назад +7

    Absolutely mind blowing method of sharing knowledge ! Thanks a ton for putting in this awesome effort

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

    Thank you so much for this great video. This is excellent content.

  • @josiahzimmerman5724
    @josiahzimmerman5724 3 года назад +3

    Thank you so much for the very useful tutorial.
    I have never really understood Access and this tutorial was very well put together and you explained everything very well

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

    Manu thanks! GREAT VIDEO and I can tell you it has helped me a lot to start undesrtanding Access!

  • @Death10186
    @Death10186 7 месяцев назад +2

    Hey Dan, or should I say Fernando :D Thanks for making this video, it's helping me understand the program properly and will help me add tremendous value to my job position. The amount of times I've said "Oh, wow." while following this tutorial is insane. You're really good at putting the info down and I look forward to finishing the entire course using your videos. Thanks again!

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

    Keep up the good work, it really helped me and many others!

  • @user-nf5ir9li4y
    @user-nf5ir9li4y Месяц назад +1

    This tutorial is extremely professional and should be the go-to guide for anyone looking to learn. It's fantastic and truly top-notch. I was very impressed and it left me wanting to learn even more. Keep up the great work!

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

    HANDS DOWN THIS IS THE BEST VIDEO EVER

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

    It also helps if you are watching on your pc that you have it hooked up your tv and have it set to the 2 screens and have the video on one and access on the other

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

    This was extremely helpful and well-paced. Thank you so much!

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

    Amazing instructor / teacher, outstanding tutorial!!! Thank you

  • @ErmaPeachey
    @ErmaPeachey 8 месяцев назад +1

    This is the most effective strategy I've ever come across. It's like magic!

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

    Excellent information, Lewis Black. Very easy to follow with easy explanations!

  • @ahmadkadid1022
    @ahmadkadid1022 4 года назад +4

    ​uhh i cant wait for the video i want it so bad i know for a fact that it is going to be so helpful

  • @lsansco3012
    @lsansco3012 2 года назад +2

    Took one look at the display pic for this guy and I knew this was the guy I needed to teach me this stuff

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

      Dan was the definitely the guy to teach anything really!

  • @JAzzWoods-ik4vv
    @JAzzWoods-ik4vv 3 года назад +1

    thank you very much for uploading this. I need to learn access for a job abd this is a really comprehensive tutorial

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

      You are weclome J.Azz Woods! Good luck on your job!

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

    Thank you very much for these perfect lessons! My knowledge of Access is of absolute perfection-it is impeccably flawless and immaculate to the highest degree! I am surprised even how I am perfect that I am! Thank you for being perfect!

  • @kebincui
    @kebincui 2 года назад +2

    The best and clear ACCESS tutorial 👍

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

    this is the best access tutorial on youtube. thank you so much. helped me a lot

  • @omlahoti1516
    @omlahoti1516 4 года назад +3

    Thank you for a great session , you are an excellent teacher,

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

    This is very good if you know absolutely nothing about databases or access. I never used Access but worked heavily with SQL, so I tried to skip a lot of the info about database design.

  • @victoriabillah6125
    @victoriabillah6125 9 месяцев назад +1

    I’m really enjoining this tutorial so far and the the instructor is a gem thanks

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

    Getting relationships to work where it concerns MULTIPLE tables always presented challenges for me. The more tables used, the harder it is for me to follow along. Parenthetically, I suspect my slow learning in such matters is largely due to my limited IQ. Nevertheless, big applause goes out to you for taking the precious time needed to achieve your teaching outcomes. With respect to the relational database section of this video (toward the end), I would rate me at least a 9 in terms of comprehension with 10 being perfect understanding. I take a bow, yes, but you first, because you made it happen with your clear delivery and perfect pacing throughout the tutorial. Bravo, good sir! You crossed the Rubicon and achieved your victory and in doing so I learned how to swim.

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

    I don't know how to thank to you for your great free service. Thank you so much. I am waiting for your more courses.
    From my heart 💓💓💓💓💓💓💓💓💓💓💓💓💓💓💓💓💓💓

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

    Thank you so much

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

    That was extremely helpful, thanks!

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

    Learning Access has never been so funny! Thank you Sir! :)

  • @shopsurvival1652
    @shopsurvival1652 8 месяцев назад +1

    I'd bet that between the words 'put your video on pause' and 'welcome back,' a lecturer sneaks in a couple of sips of good whisky) Very good sense of humor.

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

    This teacher is the best!

  • @MegaPekota
    @MegaPekota 2 года назад +2

    You're seriously a top trainer. Many thanks for this great session.

    • @LearnitTraining
      @LearnitTraining  2 года назад +2

      Glad you enjoyed it!

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

      @@LearnitTraining Indeed..a colleague showed me years ago how to use Access and my eyes almost bled. This is SOOOO helpful and _interesting_ . I never thought I would think this way about MS Access.

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

    Great learning

  • @jstan3076
    @jstan3076 3 года назад +12

    this is great tutorial! need help, why is copy so problematic ? Most the time it fail to copy field value. any help is greatly appreciated

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

    Thank you very much

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

    Best method of teaching by providing the Exercise file. This is how it should be. Thanks Dan, keep the good work. I never tried Access. This is my first time.

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

      Thank for watching MJB! We hoped you learned alot!

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

    THANK YOU for this.

  • @Qnbee007
    @Qnbee007 3 года назад +4

    Thanks , very detailed this is one of my least favorite apps. I always ask for someone to show me and no one I know uses Access. Everybody is scared of Access. I will refer to this Video

  • @InspirationJunction2
    @InspirationJunction2 2 месяца назад +1

    VERY, VERY HELPFUL!!! THANK YOU!

    • @LearnitTraining
      @LearnitTraining  2 месяца назад

      You are very welcome! Glad you are enjoying so many of our videos!

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

    Thank you! This was fantastic!

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

    Thanks. Great tips, as always!

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

    Foi expetacular, estou muito impressionado com a forma de ensino, I was wonderfull

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

    Thank you very much for this. Thorough and comprehensive!
    Not to mention that you often sound like Lewis Black in voice, accent and inflection. I anticipated expletives and tantrums, and got none.

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

      Hi Kris - well it is a family channel, haha

  • @osumarine
    @osumarine 12 дней назад

    Great tutorial, loving this - but there is a jump at 2:33:33 that skips over where you were to another point in the presentation and different access about relationships

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

    Absolutely Amazing !!!!! Thank you very much

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

    Thank you for bringing so great value to us for free. God bless you real good

  • @DjordjeGligorijevic-su1xw
    @DjordjeGligorijevic-su1xw 11 месяцев назад +1

    Thank you so much for this, sir! This channel has a lot of material to learn and master so many topics. I guess I won't be leaving the computer for a while :)

  • @juliahargreaves2095
    @juliahargreaves2095 Месяц назад +1

    Thank you very much!

  • @user-ey1xr9qo3v
    @user-ey1xr9qo3v 9 месяцев назад +1

    Excellent ACCESS Tutorial!! The structure of the course is well organized and the contents are well selected! I love your sense of humor, it makes me laugh where learning :). Enjoy so much this tutorial and reviewed the ACCESS fairly through in less than 4 hours. Thank you!! Find a little typo though, for Weight, you typed 6.3, but somehow 6 is showing at the end (without decimal point), not sure why that happened since you used Decimal as data type.

  • @josuecavejr.611
    @josuecavejr.611 3 года назад +1

    Thank you

  • @christophesafarilwiyando8502
    @christophesafarilwiyando8502 5 месяцев назад +1

    That was a masterpiece for real!!! Thanks a lot Teachers

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

    simply the best. Much love from Kenya

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

      Thank you for watching from California!

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

      Me too from Kenya and I've watched all this series. Iam actually venturing into database business courtesy to u learnit and a few others. @ jargon master, any community of database programmers here?

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

    Primary key for owner may change if owner moves auto number is better

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

    Very informative video. I learned Ms Access step by step with you sir. Thanks 👍

  • @JayPatel-ds1xp
    @JayPatel-ds1xp 2 года назад +1

    Very well explained. Thank you.

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

    thank you

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

    Thank you for sharing this with us, it was really helpful and amazing explanation.

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

      You are very welcome Fares! Thank you for watching!

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

    too much helpful, great job!

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

    The diagram was an excellent choice. Thank you

  • @user-xl6np6el1x
    @user-xl6np6el1x 7 месяцев назад +1

    YOU ARE A GREAT TEACHER FERNANDO!

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

    Nice Lecture. Excellent sound and video quality. I will recommend to the peoples who are interested to learn in detail about MS Access.

  • @user-xl6np6el1x
    @user-xl6np6el1x 7 месяцев назад

    תודה!

  • @user-ps2tm5xj1k
    @user-ps2tm5xj1k 2 месяца назад +1

    Great course and huge efforts

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

    your videos are so helpful, thanks

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

    thanks alot, its working.

  • @richardgiannamore2562
    @richardgiannamore2562 2 года назад +2

    Great Job. Thanks.

  • @livefreetilldeath
    @livefreetilldeath 6 месяцев назад +1

    Thank you!!!!