Access Master Tutorial

[@jeffdeutsch]

My thanks and highest praise. I am 51 years old and have my MS in computer science. I've taught Word, Excel, and PowerPoint for years both lower-division intro to computers class and in another trade school-type environment. I was also a Visual Basic and Oracle developer for about 7 years back in the late 1990's. Lastly, I have been a teacher in a variety of subjects on and off for decades. All this setup to say that Mr. McAllister put together a well-designed lesson plan, used excellent examples, anticipated areas of potential confusion, and conveyed the essence of Access well enough for me to complete a small project at my current place of employment. All of that for free... Thank you so much. PS- The references to floppy disks, CrLf, etc were both funny and sobering... I, too, am old enough to remember all of these things. Take good care!

[@LearnitTraining]

Thank you Jeff! Dan was an amazing teacher and we are glad you learned so much from him!

[@cranefly23]

I have used MS Access in my work as well as for pleasure in the past, but now in retirement I decided to look even more deeply into it. These courses are exactly what I needed! OK, I knew much of the stuff, but there were lots of hints, tips, tricks, and things I had simply never encountered. Your ‘style’ and pace of teaching suited me perfectly. Thank you so much.

[@LearnitTraining]

Great to hear!

[@VincentAranda-z1h]

This Access tutorial is exceptional, with a well-designed and thoroughly structured format. I have gained a wealth of knowledge and discovered features of Access that I was previously unaware of. Congratulations on a job well done!

[@LearnitTraining]

Thank you so much for your support!

[@yuinique6483]

I have completed Access courses from Beginner to Master. It actually took me more than the hours stated on the videos, from pauses, practices, and trying to figure out the problems I came across while taking it. From someone who didn’t have prior experience or knowledge with Access, I am able to do so much with this program, which assists with job applications and tasks. Hopefully, this will become handy at work. Dan is very through and detailed, step by step instructions. He challenges you as the course goes on at higher level. He has quite of amusement that doesn’t get you bored talking the class, which is A+. This is an online course, you learn at your own time. Nobody is there to tell you what to do so you just have to be disciplined enough to get through all of them. I appreciate you so much. 😊

[@LearnitTraining]

Thank you Yuinque! We are glad you got so much out of the video!

[@kensimba7868]

Thanks so much Learn it and the great teacher Mr Dan McAllister. I've completed all the 4 videos of access and now I can create a database structure for businesses. I pray for this institution to be discovered by the whole world and be given due respect it deserves. Thaaaaankuuuuu. Following from Nairobi Kenya 🇰🇪🇰🇪

[@LearnitTraining]

You're very welcome!

[@shahinulkhan7879]

What a great course. What a great teacher. Watched all 8 modules and learned loads and loads. Thank you.

[@LearnitTraining]

You're very welcome!

[@muhammedqasmallahabdulrahm4832]

Thank you so much for such an amazing 20+ hrs of this professionally presented tutorial. Extremely beneficial.

[@alvaroalpuche3351]

This is a great course. Am thoroughly enjoying it. Dan is an awesome instructor

[@LearnitTraining]

Thank you Alvaro! Dan was one the best we had!

[@kensimba7868]

@@LearnitTraining hi Learn it. Kwani did Dan leave?? I hope not

[@williamstevenson2649]

I agree with everyone else: excellent throughout. I tend to learn things through text, but that's very difficult with a wide ranging, varied and taxing programme like Access. These wonderful videos are just the job- without them I would spend much longer working through the books, articles etc.

[@LearnitTraining]

Thank you for watching William!

[@waleedtawfeek9626]

Thanks alot for those lovely 20+ hours of teaching and FUN, "DAN HUGE SENSE OF HUMOR AS WELL"..

[@LearnitTraining]

You are very welcome Waleed!

[@brettmanwill5667]

Thanks Dan! Great Training. Did the full journey, all eight modules with you. Feel much more confident I can do what I need to in Access Databases now!

[@LearnitTraining]

Thank you for watching!

[@rasikachemburkar8840]

Thank you so much,you explained it in a simple way,learn a lot about macro.

[@westcoast7185]

Thank you Dan for the great tutorial! You are a super teacher with great heart.

[@LearnitTraining]

Thank you for watching!

[@brookesmith3413]

Thank you, Mr., McAllister. Although, I am familiar with Access I haven't used it for a while and learned a thing or two via the four KZbin videos. Excellent job. Now to learn a bit more about VBA and Visual Studio.

[@LearnitTraining]

You're very welcome!

[@darrenwalker2007]

Have really enjoyed these videos didn't know how to work on a database before, have more knowledge now, thanks

[@LearnitTraining]

Glad it was helpful!

[@Initial_Gain]

Excellent tutorial in an enjoyable humerous manner. Can't believe out of 20K views only some gave the thumbs up. All should have given a thumbs up and let us admit... its free. No fees to pay in learning. Thank you very much for your efforts in presenting this series in my opinion in a professional manner. I have learnt a lot watching it and MS Access I like a lot its sort of part of my hobbies too 💖

[@msbeau5341]

All I want to say is THANK YOU!!!!

[@LearnitTraining]

You are WELCOME!

[@mohamedboulehmi215]

I can't believe this is free. Thanks Dan.

[@LearnitTraining]

Thanks for watching Mohamed!

[@kensimba7868]

Me too it's just unbelievable. I hope learn it has a platform for financial support from its beneficiaries. They're precious

[@pascalikoli2243]

Fantastic course, I have really enjoyed it from start to finish ! I am now much more confident with Ms Access because of your videos. Thanks so much !!!

[@LearnitTraining]

You're very welcome!

[@saqibiqbal8661]

Dear Dan McAllister Gone through your series of MS Access Tutorials, while at present I am in the half of 4/4 Tutorial. Really a wonderful set of lectures. I need complete tutorials on VBA for MS Access along with exercise files. Thanks in advance.

[@LearnitTraining]

You're very welcome!

[@grahamparker7729]

Really enjoyed watching these trainings sessions. Well done Dan 👍🏻

[@pedro_em_bra4199]

Thnaks a lot! this Tutorial is amazing, I watched every minute of the video. Through the course, it helps not only to acknowlege the fucntions but also to remember and comprehense the functions.

[@LearnitTraining]

Glad it helped!

[@allabout1135]

Thanks for so big effort. I like this series.

[@samschlenner6582]

McAllister you're a boss.

[@LearnitTraining]

Thanks!

[@muhamadaji8746]

Hi Learnit. Please include English subtitles in this video, so I can understand more. Thank you very much.

[@LearnitTraining]

Added

[@RayAdamson]

Excellent presentation. Good stuff Dan.

[@frisovnim]

Thank you Dan for this excellent tutorial series. Learned a great deal and had a lot fun :)

[@LearnitTraining]

Very welcome!

[@khanbrothers985]

great Teacher

[@njoroge2061]

Dan you should create visual basic classes playlist

[@LearnitTraining]

We wish Dan was still around to do that. He was an incredible teacher!

[@njoroge2061]

@@LearnitTraining Damn, so he is no longer with you.

[@kensimba7868]

​@@njoroge2061vipi njoro?? Dan alituacha bana. Aki Mungu amfikishe binguni coz hii tutorials alituachia imenisaidia kufungua database company

[@marceljunioregondi5594]

This is a bit off access topic but have been wondering how you get your name to appear on the top right hand corner of the window.

[@kossiviaglee2997]

You're the best.

[@fernandostedile7080]

Thanks, great content!

[@LearnitTraining]

You are very welcome Fernando!

[@saeedmosbah8528]

Thank you so mush .. Wonderful..

[@LearnitTraining]

Welcome 😊

[@VforAllofUs]

you r great, thank you

[@LearnitTraining]

You're welcome!

[@soadafify5948]

so much for these videos 😍

[@LearnitTraining]

Glad you like them!

[@Initial_Gain]

One question I would like to ask is why did Microsoft disable the Macros for Security reasons? Will not almost all databases include macros? At first I couldn't understand why my macros weren't working until I learnt that there was the Enable Button! But it took me quite sometime to know about it.

[@alphaanne5486]

Very helpful

[@muditrustagi5775]

how to open a form multiple times in a loop for different things?

[@malchicken]

Please add this video to the Access playlist.

[@LearnitTraining]

Thank you for the heads up Hendrick! It has been added!

[@murugavel5124]

form background image are style how can take

[@milindwaigankar6682]

Can you please share the link for my ready reference

[@wroomauto7615]

I am not able to export databases containing jpg photos in to excel When exported it only shows file name but it does not show actual photo So how to export photos uploaded in ms access in to ms excel file using export to excel command

[@murugan54]

Are you not with Learnit Training any longer, Dan?

[@LearnitTraining]

Hi S Murugan! Unfortunately Dan McAllister passed away a few years ago. He is greatly missed!

[@murugan54]

@@LearnitTraining OMG... His method of tutoring was something that I quite admired! RIP Dan!

[@AoiTodo998]

@@LearnitTraining omg why u do this to me :(

[@kensimba7868]

​@@LearnitTraining😱. Am really crying for Dan. He was an excellent teacher and by this tutorials I can call myself a database programmer. Continue rip sir Dan McAllister 😮

[@kunalaggarwal6007]

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.

[@maheshtorgal]

Thank you sir for sharing great knowledge... Actually I am working on Access project that will used for Real Estate... As we have a template for that but I wanted a database as exact opposite that template.... means We have multiple offices at different locations on rental basis... So I wanted to create a database for the same... Request your help on same

[@samaruti9446]

When I try to download the example files I get html files and not pdf files. Where can I get the pdf files?

[@LearnitTraining]

Hi Sam - when saving the files make sure you select the proper file extension

[@samaruti9446]

@@LearnitTraining Thanks but the files, when I try to save them all indicate that they are html files. I've tried to save with multiple different extensions, none successful

[@milindwaigankar6682]

how and from where to download the practise filesk

[@LearnitTraining]

Hi Milind! The link to the files is in the video description

[@amirhosseinrezaei4723]

why don't have subtitle

[@LearnitTraining]

HI Amirhossein! Seems there was change to the automatic captions by KZbin and due to the length of this video they are no longer available. We will be working on adding on our own in the future

[@stephenkarnes1092]

Did you just call the floppy disk save icon a TV set icon?!?!? Hahahahahahaha