Can we just agree that he is the best teacher? Seriously I've never had it so easy following a teacher's instructions as I am with him. I just wish I had the time to watch through all his access series *before* my access project deadline 😅
@LearnitTraining2 жыл бұрын
Thank you for the kind words Laura! Dan was one of the best teachers we ever had at Learnit!
@shaddwatson18332 жыл бұрын
He is the Total: Sum("best") ☺️
@marceljunioregondi55942 жыл бұрын
@@LearnitTraining where did Dan go to.
@ShylahAddante Жыл бұрын
I have been itching to learn access for YEARS. These videos are the most direct and easiest to follow that I've ever found. You are truly a gifted teacher and I am so grateful that you are sharing your skills with all of us!
@LearnitTraining Жыл бұрын
You are very welcome!
@venkataramanan76564 жыл бұрын
It is indeed the best tutorial not just in access but ever, that i had attended. The Instructor Mr McAlister is too good as he could exactly point out where we have to exercise caution, apply simple solutions to a complex problem and most importantly talks in a clear language. I have incidentally learnt a few SQL tips as well. My gratitudes to this Instructor.
@LearnitTraining4 жыл бұрын
Thank you for the kind words Venkata!
@arunshinde15073 жыл бұрын
This Access Advanced Tutorial is a mammoth - almost 5 hours tutorial but worth our time. Study material is available upfront for doing all the tasks simultaneously with Dan. The flow of pauses is perfect for online learning. He has explained the themes with simple examples. It is fun to learn the complex and more advanced tutorials in this session. Listening to him and working with him gives live exposure - similar to class room training. Nowhere we feel lost even though the session is so long. We grab more and more knowledge as the tutorial progresses. It's fun to learn with him and upgrade the knowledge in such a small span of time. All his hard work is appreciated. Very much glad to find these tutorials on youtube. It's a learning experience.
@LearnitTraining3 жыл бұрын
Thank you Arun for the kind words and for watching!
@hapemokenela73884 жыл бұрын
This is the best Ms Access tutorial i've ever done. Thanks.
@Initial_Gain4 жыл бұрын
Watched... (done... doesn't make sense)
@JLB08804 жыл бұрын
I've been to countless/various in-person Microsoft Suite classes in my 12-year career, which I'm sure the companies I worked for paid a pretty penny for. This series of free KZbin videos are by far the best instruction I've ever received. This Access series is more of a refresher for me, but I've still learned little tips and tricks I didn't know in just the first two vids. The instructor is fantastic, engaging, sometimes silly, but extremely effective. Thank you!
@origbeecee Жыл бұрын
Dan really is the best. Perfect balance of knowledge and humor. Highly recommend.
@LearnitTraining Жыл бұрын
Dan was one the best instructors we ever had!
@koteshwarpanuganti35074 жыл бұрын
This is best tutorial on MS Access i have gone through. Thanks a lot and good job for Learnit and it's team.
@LearnitTraining4 жыл бұрын
You are most welcome
@proudlycanadian3023 Жыл бұрын
I am so amazed and astounded of how impeccably flawless/immaculate of my knowledge of Microsoft Access is! It is of absolute perfection to the highest degree! Thank you for the perfect lesson!
@LearnitTraining Жыл бұрын
Wow, thank you!
@Sandra-vx7iw Жыл бұрын
I'm only just starting with Access, I have tried different versions, but Dan makes it sooo easy to actually understand what you are doing. Thank you!
@LearnitTraining Жыл бұрын
You are very welcome!
@Initial_Gain4 жыл бұрын
One of the best if not THE best tutorial about MS Access in a relaxing enjoyable manner... the rest are quick quickies with clicks here and there in splits of a second that the follower just couldn't follow or worse still the silent movie type ones... you even made me laugh sometimes with your humor... so in short... I liked it very much... keep it up! 😊💖💖
@LearnitTraining4 жыл бұрын
Glad it helped!
@Mary_990 Жыл бұрын
Well done! It was a great tutorial video. I took all three sessions (Access Advanced Tutorial, Master, and Expert). They were greatly helpful! Dan, you are one of the most effective teachers, I have ever seen. Thank you!
@LearnitTraining Жыл бұрын
Great to hear!
@kevinkimball93413 жыл бұрын
Very, very well done. I too teach Access and was inspired by the clarity with which you speak, your very solid understanding of Access and the practical examples you used. Very impressive. I really enjoyed learning from you and am now going to see what other Access tutorials I can from you. You are now my #1 go to Access trainer.
@LearnitTraining3 жыл бұрын
Wow, thank you!
@samm6626 Жыл бұрын
Thanks Dan. I did the latest 2021 Access course and that was great too. But this one really helped me learn more about queries and I’ve been able to build something I thought I couldn’t do. Thanks
@odie67892 жыл бұрын
This is training of an exceptionally high level, thank you for providing this!
@LearnitTraining2 жыл бұрын
You're very welcome!
@tyroneharding57962 жыл бұрын
Dear Mr.Dan aka Fernando,I really appreciate the time and effort you spent into this tutorial. You are an amazing teacher and you’ve made these tutorial so simple for me to understand, but it will be a lot easier if I have those sample file to work with. Thank you 😊 i
@LearnitTraining2 жыл бұрын
You are welcome! The link to the exercise files is in the video description
@garrywoodland6232 Жыл бұрын
Wish I Had a teacher like this for IT
@LearnitTraining Жыл бұрын
Thank you for watching!
@philipwicks3 жыл бұрын
A natural teacher. Outstanding
@LearnitTraining3 жыл бұрын
Thank you for watching and also the kind words!
@amelianameeta73352 жыл бұрын
Vielen dank! Es war eine tolle Erfahrung mit Ihnen zu lernen.
@LearnitTraining2 жыл бұрын
Danke für das Aufpassen! Ich hoffe, Sie haben viel gelernt
@AndrewSmith-vv7vh3 жыл бұрын
Dan, love the way you portray these lessons. I had no experience of Access before - even though there was a little barrel together with an 'A' on the taskbar. Thank you so much for taking the time to educate us 'mere mortals' by presenting the lessons in a really easy to understand (that's me speaking) way.
@LearnitTraining3 жыл бұрын
You are welcome Andrew! Glad you enjoyed the videos!
@DavidSmith-sb6px3 жыл бұрын
This is the most practical approach to Access I've yet to find. Thank you, Lewis Black.
@LearnitTraining3 жыл бұрын
You are welcome David Smith!
@sharif73512 жыл бұрын
You are the best teacher for teaching ms access
@LearnitTraining2 жыл бұрын
Thank you Sharif! Dan was one of the best instructors we had! He is truly missed!
@marceljunioregondi55942 жыл бұрын
Thanks so much Dan for this tutorial and taking the time to record it so that future generations could still get the same knowledge. Thou am sure it will have some outdated infor. I was a complete novice to access but I can now make my own database with several objects. Following up to master level want to make my database look presentable with the different levels of permissions.
@LearnitTraining2 жыл бұрын
Glad it was helpful!
@charles-y2z6c4 жыл бұрын
You are a goofball and an excellent instructor
@lefterisinnova Жыл бұрын
Perfect instructor and perfect lessons !!!
@LearnitTraining Жыл бұрын
Thank you for the kind words!
@umbertofreitas59183 жыл бұрын
Totally agree. I wonder if the author is also going to offer a VBA tutorial just as extensive as tais one. That would be great!
@filipepa1063 жыл бұрын
You're the best teacher I've ever had. Thanks a lot!
@LearnitTraining3 жыл бұрын
Wow, thanks!
@Josh..88 Жыл бұрын
Hands Down Best Teacher
@LearnitTraining Жыл бұрын
Thank you!
@raindropkumara2676 Жыл бұрын
Great Lessons "Fernando". Just kidding. But really thank you for taking the time to instruct and update these Access lessons. This is my third time (try) around with this database in the last 7 years. I decided I will not give up anymore. I MUST learn how to do this for the sake of an amazingly divine curriculum I created to share with K-12 teachers. I was encouraged after seeing you offered a mastery level course of Access AND from reading the comments of many other satisfied students. Working in order, I seem to have gotten stuck at 3:09:00ish mark of the advanced tutorial. Nothing to do with the lesson itself, but with a blocking by disabled mode in the action/description bar. I could not run the make table from query. I went to the Access security section to trust the files, undo/remove macros restrictions then restart. Still cannot get the table to run. I understand how to do the task but cannot get pass the block. PLEASE HELP!!
@LearnitTraining Жыл бұрын
Thank you for the kind words Raindrop! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com
@micahelliott4936 Жыл бұрын
I don't know if this is a feature of a newer version of Access, but when in a query, instead of manually landscaping, you can double click on different points of your box to expand to the minimum size required to see the whole of the information. For example if the table name is too long you can get your arrow on the right side of the table's box in design mode to where your cursor becomes a double arrow horizontal. Double click and it auto expands to see the full table name. If your field list is too long you can hover over the bottom of the table box in design mode until your cursor becomes a double arrow vertically. Double click and it will auto expand downward to make the box as long as needed to accommodate the complete list. The third way is to go to the corner of the table box to where your cursor becomes a double arrow diagonal. Double click and it auto expands to reveal the full name of the table and the fill list of fields in that table.
@LearnitTraining Жыл бұрын
Thanks for the tip!
@alikamel55204 ай бұрын
I'm relay appreciate your great effort in this course , thank you
@LearnitTraining4 ай бұрын
It's our pleasure
@muhamadaji87462 жыл бұрын
Hi Learnit, Please include English subtitles in this video, so I can understand more. Thank you very much
@LearnitTraining2 жыл бұрын
Added!
@muhamadaji87462 жыл бұрын
Thank you, but on the access master and expert list, still no added 😂
@kensimba78684 жыл бұрын
Ur a lovely brilliant funny man and a great teacher. I enjoyed and understood every bit of your tutorials. Am planning to open up a company that needs this knowledge and much more. A big thanku from Nairobi Kenya.
@LearnitTraining4 жыл бұрын
Best of luck!
@kensimba78684 жыл бұрын
@@LearnitTraining thanku so much. I honestly appreciate u guys for the eloquent tutorials. How can one support u guys even if it's not right now but soon in the future. In terms of finances?
@hanifandish25103 жыл бұрын
Thank you for the best tutorial you have done ever
@LearnitTraining3 жыл бұрын
You're very welcome!
@SueChenTranslationpluss3 жыл бұрын
Thank you very much. Great tutorial. It'd be even better and more helpful if the tabs above menu ribbons are not chopped off the screen.
@LearnitTraining3 жыл бұрын
Glad it helped!
@frankhocza6758 Жыл бұрын
This man is the best !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
@LearnitTraining Жыл бұрын
Dan was one our best instructors! RIP Dan!
@jloo19004 жыл бұрын
Love and enjoyed every minute of your video. Thank you. Love you much
@diassetefle97754 жыл бұрын
Thanks a lot my teacher for your help.
@Initial_Gain4 жыл бұрын
Excellent tutorial with easy pace instruction with humour and a laugh not to make things boring. A lot is covered and lets admit its free. Wonder if you could help me with a problem I have: Sometimes when I opened my database and went to make a new entry it forgot the last record number in the AutoNumber column (not a PK or FK) and tried to start with a previous AutoNumber that had already been filled. It then wouldn't enter the entry because of No Duplicates and I had no way to reset the counter with the next number as should. I have found on KZbin how to reset the counter the number you want so at least I found a solution but would like to know and am curious as to why this happened/happens... thanks 💖
@Youssiflagrosse3 жыл бұрын
Excellent training. I feel like Neo in The Matrix when he said "I know kung-Fu" now.. :)
@LearnitTraining3 жыл бұрын
Thank you for the kind words Rej! We hope you learned alot!
@kebincui2 жыл бұрын
Best teacher of Access👍🏻👍🏻👍🏻
@LearnitTraining2 жыл бұрын
Thank you! 😃
@saqibiqbal8661 Жыл бұрын
Time: 4:18:16. After importing from Excel. You forgot to modify the field "Hire Date" from "Short Text" to Data Type "Date/Time".
@LearnitTraining Жыл бұрын
Hello Saqib! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com
@saqibiqbal8661 Жыл бұрын
@@LearnitTraining Thanks for your encouragement.
@tyroneharding57962 жыл бұрын
Thank you for directing me towards the sample files Mr. Fernando 😀. It surely makes things a lot more fun when working with the sample files. OH! by the way,thank for letting us know your from Detroit, EH. Canad EH. LOL, your so funny 😆 🤣 😄 😂. Or, I'm Canadian and am enjoying every bit of your tutorial. EH.
@LearnitTraining2 жыл бұрын
My pleasure!
@VincentAranda-z1h4 ай бұрын
Just brilliant !!!! The best !!
@LearnitTraining4 ай бұрын
Thank you so much!
@ThePalmans3 ай бұрын
Great teacher ! Thank
@LearnitTraining3 ай бұрын
Glad you enjoyed it!
@zdavirandimuhammad15154 жыл бұрын
thanks for your tutorial Mr. Dan. I love the passion the way you exercising your video tutorial.
@sharmarudra3 жыл бұрын
1:33:33 when you did that, my 2 year old thought that I played her favorite cartoon Peppa Pig and said "papa was that the lady wolf?"
@fredkelly69532 жыл бұрын
Thanks Fernando.
@LearnitTraining2 жыл бұрын
You are welcome!
@pipabit2 жыл бұрын
Best tutorial ever
@LearnitTraining2 жыл бұрын
Thank for watching pipabit! An extra big thank for subscribing as well!
@juliahargreaves20954 ай бұрын
Awesome! Thank you.
@LearnitTraining4 ай бұрын
You're welcome!
@LEDAMASUKE2 жыл бұрын
Great instructions ever
@LearnitTraining2 жыл бұрын
Dan was one the best we had! RIP Dan!
@omarg57592 жыл бұрын
Excellent tutorials. Thanks a lot!
@LearnitTraining2 жыл бұрын
Glad you like them!
@thecentralscrutinizerr2 жыл бұрын
If you can't learn from this guy, they need to pull the plug.
@LearnitTraining2 жыл бұрын
Thank you for the kind words!
@shlomosirota18223 жыл бұрын
This man is a legend.
@LearnitTraining3 жыл бұрын
Dan definitely was a legend and was one of the best instructors we ever had.
@jeffreybonto41732 жыл бұрын
Very informative! Thanks for sharing!
@LearnitTraining2 жыл бұрын
Glad you enjoyed it!
@kazerog2000 Жыл бұрын
Great stuff. Thanks a lot.
@LearnitTraining Жыл бұрын
Our pleasure!
@kowal7792 жыл бұрын
Thanks Dan, great course!
@LearnitTraining2 жыл бұрын
Glad you liked it!
@LF100-034 жыл бұрын
To hear Rush Limbaugh narrate this lecture please select Playback Speed 1.50.
@faridjabbouri20822 жыл бұрын
Always great work. many thanks
@LearnitTraining2 жыл бұрын
Thank you so much Farid!
@hiteshjoshi31483 жыл бұрын
first of all a big thankyou Mr. Dan and hey i beg you please make ms sql server tutuorial as well from beginner to master.
@LearnitTraining3 жыл бұрын
Hi Hitesh - SQL is definitely a video we have planned to make this year
@hiteshjoshi31483 жыл бұрын
@@LearnitTraining thanks sir
@kensimba78683 жыл бұрын
@@LearnitTraining am tuned in and waiting
@llyons39992 жыл бұрын
I see on their youtube channel there is an access Expert and Master, but which one comes before which?
@LearnitTraining2 жыл бұрын
Expert then Master
@bmin10223 жыл бұрын
Thanks for your efforts... You are great!!!
@LearnitTraining3 жыл бұрын
Thank you too!
@ashkhendanielyan90523 жыл бұрын
You are amazing😍😍thanks for awesome work ❤❤
@LearnitTraining3 жыл бұрын
Thank you so much 😀
@john1957john4 жыл бұрын
Great Tutorial. Thank you very much
@suraniakbar4 жыл бұрын
Thanks for they video it’s very informative just want to know which is the third party software you use for zooming the screen
@Esclarecidos4 жыл бұрын
It seems that the creation of the first multi table query at 1:32:05 is missing!
@avshots76924 жыл бұрын
Yeah and that can be done by adding three tables actually because dept. name is in dept. table and there is no relation between tblpersonal and tbldept. so we have to add tblpersonal, tblhuman and tbldept.
@magdimohamed64782 жыл бұрын
thank you for your fantastic work. i need your help with my data base if your time allows. thanks
@LearnitTraining2 жыл бұрын
Hi Magdi! You can get help at Offsite, our online community - www.offsitebylearnit.com/
@scottsmalley7863 жыл бұрын
I am not sure where I am going wrong but I cannot download the practice files . I get to them but cant open or DL them. Ive tried MOD1-2 and 3-4. where can I get assistance?
@LearnitTraining3 жыл бұрын
Hi Scott! When you click on the link in the upper left corner there is a download button. We just tested it and it is currently working.
@Cruz0e2 жыл бұрын
why would you choose tabs view over windows , its way better ...
@javierdimixАй бұрын
04:01:50 that's great!
@LearnitTrainingАй бұрын
👍
@MarTin-dn9oe2 жыл бұрын
I have a fund that holds money for several clients. They send me bills and I pay them. Is there anyway I can scan their bills into access for later reference
@simur20403 жыл бұрын
Hi Dan this video is great. I Hope you can add the translation option to this video. Thanks
@LearnitTraining3 жыл бұрын
Hi Armando! We are looking into captions overall!
@sebastianbenke86762 жыл бұрын
Haha the beginning of the videos makes me what some more access stuff indeed!
@LearnitTraining2 жыл бұрын
Thank you for watching! We hope you learned a ton!
@amauryramos66942 жыл бұрын
Awesome!!
@LearnitTraining2 жыл бұрын
Thank you! Cheers!
@georgelast93074 жыл бұрын
You really should put subtitles to this wonderful video, it helps a lot when following
@origbeecee Жыл бұрын
The parameter query shift F9 doesn't work. Only complaint. Literally played with it for quite a while with no success.
@LearnitTraining Жыл бұрын
Hello Original Bee Cee! This video used Access 2016 so the feature may have changed with future versions.
@origbeecee Жыл бұрын
@@LearnitTraining thanks. I'm using 2016. It's all good.
@Initial_Gain4 жыл бұрын
Greetings from Malta the Maltese Islands... Can I set the font size to 11 permanently when using the 'zoom box'? ...thanks.
@stevebebo11963 жыл бұрын
Is it possible for a Parent Table to have more than one Child Table?
@consciouslynatural12763 жыл бұрын
Yes
@abhricosuave4 жыл бұрын
Access is pretty much computing the columns but not individual fields(cells). Is there a way in access to use formula like excel where the fields are at different rows but same column? example: in excel cell A1 has formula "=B1 + B2" or "=B1 + B4 + B6" . Lets just say fields(cells) in column B are being calculated and the total shows on column C. Is this possible in access? thanks
@barsharajbhandari46794 жыл бұрын
I keep getting a type mismatch error while making the query with personal data and human resources table. I did check the data types
@iesmartielongoria73423 жыл бұрын
Is there a way that Parameter search pop up with out Shift-F9 ?
@txreal22 жыл бұрын
49:30 - I couldn't see the star * in the tblPersonalData Field pane because the font size is too big. Couldn't find in Google search either. How do you reduce the font size (MS Office 365 Access)? Thanks.
@LearnitTraining2 жыл бұрын
Thanks for reaching out! For specific questions like these, try joining our community of instructors and peers at Offsite: www.offsitebylearnit.com/
@cparedes23024 жыл бұрын
Excelente vídeo! I am Learning si much! Just a quesitos...The keyboard shortcut to run the query again (Shift+F9) seems not to work on my Access 365. Would yo know what is the shortcut?
@umbertofreitas59183 жыл бұрын
Maybe you'll need to hold the function key (Fn) on your keyboard while hitting shift-F9. Try doing so and tell me what you got. Cheers!
@agg43902 жыл бұрын
53:59
@davidfoo69743 жыл бұрын
What 3rd party zoom app do you use to zoom in on the screen?
@LearnitTraining3 жыл бұрын
Hi David - that is Zoomit
@abdulhakimyasin70983 ай бұрын
wow Amazing
@LearnitTraining3 ай бұрын
Thank you! Cheers!
@chunglee56264 жыл бұрын
Dan Hi how are you? I have question see if you could help me on Microsoft Access. I got two tables, one Customer, one is current month order, how could I find out customer do not order this month. How do I set the criteria on the customer table to display those one not order this month. Thanks
@arnlogic96103 жыл бұрын
Try this Customer left join order where month=this month and qtyorder=0
@venkataramanan76564 жыл бұрын
Hi Dan, In a Crossdata Qry can we not click highlight the columns and press the Sum Function and obtain totals? or is it too ambitious?
@ruchagg45004 жыл бұрын
what version of windows do you have?
@ELIASABISAIAGUIRRERODRIGUEZ3 ай бұрын
Hahahahah Bro, I love this man´s character!
@LearnitTraining3 ай бұрын
Dan was the man! A great instructor gone too soon.
@kunalaggarwal60074 жыл бұрын
Sir, there is no option of Subtitles in this video, please turn on the option of Subtitles, then we will be able to understand the video even better.
@awalsanneh37923 жыл бұрын
nice one
@LearnitTraining3 жыл бұрын
Thanks!
@tootricks3 жыл бұрын
waw maza a gaya
@LearnitTraining3 жыл бұрын
Thank you Sandeep we are glad you had fun learning!
@jacklythgoe14782 жыл бұрын
New JOYsey
@pelajarabadi71044 жыл бұрын
Greetings from indonesia, kind teacher. I am making a restaurant order form on ms access. I would like to have a wav-file-sound playing everytime a quantity is added onto the order; an on-click-event that, in addition to manipulate the value of the field, also plays a wav sound. I am using 64bits access; i have sample-instructions from 32bits but i do not know how to fix them to work on 64bit access. Will you please teach us? Please. Thankyou immensely.
@Lappsund13 жыл бұрын
practice files, where are they?
@LearnitTraining3 жыл бұрын
Hi Hans! The link to the exercise files is in the video description!
@mohammedsalah18214 жыл бұрын
i need a translation file
@commanman9743 жыл бұрын
exercise files link not working. Pls update.
@LearnitTraining3 жыл бұрын
Hi Parthiban! We just tested the link and it is working
@commanman9743 жыл бұрын
@@LearnitTraining thanks for the reply. It also worked for me in my phone. May be problem with my laptop's internet.