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 😅
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!
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.
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 TH-cam 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!
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.
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!
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!
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! 😊💖💖
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
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.
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
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.
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.
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.
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!!
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.
@@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?
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.
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 TH-cam 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 💖
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
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
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.
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?
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?
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
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.
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.
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 😅
Thank you for the kind words Laura! Dan was one of the best teachers we ever had at Learnit!
He is the Total: Sum("best") ☺️
@@LearnitTraining where did Dan go to.
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!
You are very welcome!
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.
Thank you for the kind words Venkata!
Dan really is the best. Perfect balance of knowledge and humor. Highly recommend.
Dan was one the best instructors we ever had!
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 TH-cam 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!
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.
Thank you Arun for the kind words and for watching!
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!
Wow, thank you!
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!
You are very welcome!
You are the best teacher for teaching ms access
Thank you Sharif! Dan was one of the best instructors we had! He is truly missed!
This is the best Ms Access tutorial i've ever done. Thanks.
Watched... (done... doesn't make sense)
This is best tutorial on MS Access i have gone through. Thanks a lot and good job for Learnit and it's team.
You are most welcome
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!
Great to hear!
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! 😊💖💖
Glad it helped!
A natural teacher. Outstanding
Thank you for watching and also the kind words!
These are the Best Access tutorial, very helpful. Well done and thank you Dan
Thank you! Dan was a great instructor and we are happy to see his work still helping out so many people!
Hands Down Best Teacher
Thank you!
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
Wish I Had a teacher like this for IT
Thank you for watching!
This is training of an exceptionally high level, thank you for providing this!
You're very welcome!
Best teacher of Access👍🏻👍🏻👍🏻
Thank you! 😃
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.
Wow, thank you!
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
You are welcome! The link to the exercise files is in the video description
Perfect instructor and perfect lessons !!!
Thank you for the kind words!
You are a goofball and an excellent instructor
This man is the best !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
Dan was one our best instructors! RIP Dan!
Vielen dank! Es war eine tolle Erfahrung mit Ihnen zu lernen.
Danke für das Aufpassen! Ich hoffe, Sie haben viel gelernt
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.
Glad it was helpful!
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.
You are welcome Andrew! Glad you enjoyed the videos!
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.
Thanks for the tip!
You're the best teacher I've ever had. Thanks a lot!
Wow, thanks!
I'm relay appreciate your great effort in this course , thank you
It's our pleasure
This is the most practical approach to Access I've yet to find. Thank you, Lewis Black.
You are welcome David Smith!
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!!
Thank you for the kind words Raindrop! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com
Thank you for the best tutorial you have done ever
You're very welcome!
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.
Best of luck!
@@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?
Love and enjoyed every minute of your video. Thank you. Love you much
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!
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.
My pleasure!
This man is a legend.
Dan definitely was a legend and was one of the best instructors we ever had.
Thanks for they video it’s very informative just want to know which is the third party software you use for zooming the screen
thanks for your tutorial Mr. Dan. I love the passion the way you exercising your video tutorial.
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 TH-cam 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 💖
If you can't learn from this guy, they need to pull the plug.
Thank you for the kind words!
To hear Rush Limbaugh narrate this lecture please select Playback Speed 1.50.
Thanks a lot my teacher for your help.
Excellent tutorials. Thanks a lot!
Glad you like them!
Very informative! Thanks for sharing!
Glad you enjoyed it!
Thanks Dan, great course!
Glad you liked it!
Greetings from Malta the Maltese Islands... Can I set the font size to 11 permanently when using the 'zoom box'? ...thanks.
Just brilliant !!!! The best !!
Thank you so much!
You are amazing😍😍thanks for awesome work ❤❤
Thank you so much 😀
Always great work. many thanks
Thank you so much Farid!
Best tutorial ever
Thank for watching pipabit! An extra big thank for subscribing as well!
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
Great Tutorial. Thank you very much
Thanks for your efforts... You are great!!!
Thank you too!
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.
Glad it helped!
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
Great teacher ! Thank
Glad you enjoyed it!
You really should put subtitles to this wonderful video, it helps a lot when following
Hi Learnit, Please include English subtitles in this video, so I can understand more. Thank you very much
Added!
Thank you, but on the access master and expert list, still no added 😂
thank you for your fantastic work. i need your help with my data base if your time allows. thanks
Hi Magdi! You can get help at Offsite, our online community - www.offsitebylearnit.com/
Time: 4:18:16. After importing from Excel. You forgot to modify the field "Hire Date" from "Short Text" to Data Type "Date/Time".
Hello Saqib! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com
@@LearnitTraining Thanks for your encouragement.
I see on their youtube channel there is an access Expert and Master, but which one comes before which?
Expert then Master
Great stuff. Thanks a lot.
Our pleasure!
Great instructions ever
Dan was one the best we had! RIP Dan!
Awesome! Thank you.
You're welcome!
Excellent training. I feel like Neo in The Matrix when he said "I know kung-Fu" now.. :)
Thank you for the kind words Rej! We hope you learned alot!
It seems that the creation of the first multi table query at 1:32:05 is missing!
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.
Hi Dan this video is great. I Hope you can add the translation option to this video. Thanks
Hi Armando! We are looking into captions overall!
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?
Is there a way that Parameter search pop up with out Shift-F9 ?
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?
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!
Thanks Fernando.
You are welcome!
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?
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.
Is it possible for a Parent Table to have more than one Child Table?
Yes
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.
Hi Hitesh - SQL is definitely a video we have planned to make this year
@@LearnitTraining thanks sir
@@LearnitTraining am tuned in and waiting
I keep getting a type mismatch error while making the query with personal data and human resources table. I did check the data types
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?"
what version of windows do you have?
why would you choose tabs view over windows , its way better ...
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
Try this Customer left join order where month=this month and qtyorder=0
What 3rd party zoom app do you use to zoom in on the screen?
Hi David - that is Zoomit
04:01:50 that's great!
👍
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.
Thanks for reaching out! For specific questions like these, try joining our community of instructors and peers at Offsite: www.offsitebylearnit.com/
Awesome!!
Thank you! Cheers!
The parameter query shift F9 doesn't work. Only complaint. Literally played with it for quite a while with no success.
Hello Original Bee Cee! This video used Access 2016 so the feature may have changed with future versions.
@@LearnitTraining thanks. I'm using 2016. It's all good.
Haha the beginning of the videos makes me what some more access stuff indeed!
Thank you for watching! We hope you learned a ton!
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.
practice files, where are they?
Hi Hans! The link to the exercise files is in the video description!
exercise files link not working. Pls update.
Hi Parthiban! We just tested the link and it is working
@@LearnitTraining thanks for the reply. It also worked for me in my phone. May be problem with my laptop's internet.
i need a translation file
nice one
Thanks!
wow Amazing
Thank you! Cheers!
waw maza a gaya
Thank you Sandeep we are glad you had fun learning!
Hahahahah Bro, I love this man´s character!
Dan was the man! A great instructor gone too soon.
53:59
New JOYsey
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.
要是有中文字幕就好了
谢谢您的知识分享！
我们正在制作字幕
We are working on subtitles!