Access Advanced Tutorial

[@clauria11]

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 😅

[@LearnitTraining]

Thank you for the kind words Laura! Dan was one of the best teachers we ever had at Learnit!

[@shaddwatson1833]

He is the Total: Sum("best") ☺️

[@marceljunioregondi5594]

@@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!

[@venkataramanan7656]

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.

[@LearnitTraining]

Thank you for the kind words Venkata!

[@origbeecee]

Dan really is the best. Perfect balance of knowledge and humor. Highly recommend.

[@LearnitTraining]

Dan was one the best instructors we ever had!

[@arunshinde1507]

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.

[@LearnitTraining]

Thank you Arun for the kind words and for watching!

[@koteshwarpanuganti3507]

This is best tutorial on MS Access i have gone through. Thanks a lot and good job for Learnit and it's team.

[@LearnitTraining]

You are most welcome

[@hapemokenela7388]

This is the best Ms Access tutorial i've ever done. Thanks.

[@Initial_Gain]

Watched... (done... doesn't make sense)

[@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!

[@JLB0880]

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!

[@Initial_Gain]

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! 😊💖💖

[@LearnitTraining]

Glad it helped!

[@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!

[@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!

[@pingao1841]

These are the Best Access tutorial, very helpful. Well done and thank you Dan

[@LearnitTraining]

Thank you! Dan was a great instructor and we are happy to see his work still helping out so many people!

[@sharif7351]

You are the best teacher for teaching ms access

[@LearnitTraining]

Thank you Sharif! Dan was one of the best instructors we had! He is truly missed!

[@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

[@kevinkimball9341]

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.

[@LearnitTraining]

Wow, thank you!

[@odie6789]

This is training of an exceptionally high level, thank you for providing this!

[@LearnitTraining]

You're very welcome!

[@garrywoodland6232]

Wish I Had a teacher like this for IT

[@LearnitTraining]

Thank you for watching!

[@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.

[@amelianameeta7335]

Vielen dank! Es war eine tolle Erfahrung mit Ihnen zu lernen.

[@LearnitTraining]

Danke für das Aufpassen! Ich hoffe, Sie haben viel gelernt

[@philipwicks]

A natural teacher. Outstanding

[@LearnitTraining]

Thank you for watching and also the kind words!

[@tyroneharding5796]

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

[@LearnitTraining]

You are welcome! The link to the exercise files is in the video description

[@marceljunioregondi5594]

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.

[@LearnitTraining]

Glad it was helpful!

[@Josh..88]

Hands Down Best Teacher

[@LearnitTraining]

Thank you!

[@DavidSmith-sb6px]

This is the most practical approach to Access I've yet to find. Thank you, Lewis Black.

[@LearnitTraining]

You are welcome David Smith!

[@lefterisinnova]

Perfect instructor and perfect lessons !!!

[@LearnitTraining]

Thank you for the kind words!

[@kebincui]

Best teacher of Access👍🏻👍🏻👍🏻

[@LearnitTraining]

Thank you! 😃

[@AndrewSmith-vv7vh]

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.

[@LearnitTraining]

You are welcome Andrew! Glad you enjoyed the videos!

[@charles-y2z6c]

You are a goofball and an excellent instructor

[@alikamel5520]

I'm relay appreciate your great effort in this course , thank you

[@LearnitTraining]

It's our pleasure

[@umbertofreitas5918]

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!

[@filipepa106]

You're the best teacher I've ever had. Thanks a lot!

[@LearnitTraining]

Wow, thanks!

[@kensimba7868]

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]

Best of luck!

[@kensimba7868]

@@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?

[@frankhocza6758]

This man is the best !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

[@LearnitTraining]

Dan was one our best instructors! RIP Dan!

[@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

[@Initial_Gain]

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 💖

[@tyroneharding5796]

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.

[@LearnitTraining]

My pleasure!

[@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!

[@hanifandish2510]

Thank you for the best tutorial you have done ever

[@LearnitTraining]

You're very welcome!

[@Esclarecidos]

It seems that the creation of the first multi table query at 1:32:05 is missing!

[@avshots7692]

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.

[@SueChenTranslationpluss]

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.

[@LearnitTraining]

Glad it helped!

[@jloo1900]

Love and enjoyed every minute of your video. Thank you. Love you much

[@suraniakbar]

Thanks for they video it’s very informative just want to know which is the third party software you use for zooming the screen

[@zdavirandimuhammad1515]

thanks for your tutorial Mr. Dan. I love the passion the way you exercising your video tutorial.

[@txreal2]

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.

[@LearnitTraining]

Thanks for reaching out! For specific questions like these, try joining our community of instructors and peers at Offsite: www.offsitebylearnit.com/

[@diassetefle9775]

Thanks a lot my teacher for your help.

[@abhricosuave]

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

[@VincentAranda-z1h]

Just brilliant !!!! The best !!

[@LearnitTraining]

Thank you so much!

[@kowal779]

Thanks Dan, great course!

[@LearnitTraining]

Glad you liked it!

[@omarg5759]

Excellent tutorials. Thanks a lot!

[@LearnitTraining]

Glad you like them!

[@shlomosirota1822]

This man is a legend.

[@LearnitTraining]

Dan definitely was a legend and was one of the best instructors we ever had.

[@ThePalmans]

Great teacher ! Thank

[@LearnitTraining]

Glad you enjoyed it!

[@jeffreybonto4173]

Very informative! Thanks for sharing!

[@LearnitTraining]

Glad you enjoyed it!

[@Initial_Gain]

Greetings from Malta the Maltese Islands... Can I set the font size to 11 permanently when using the 'zoom box'? ...thanks.

[@faridjabbouri2082]

Always great work. many thanks

[@LearnitTraining]

Thank you so much Farid!

[@ashkhendanielyan9052]

You are amazing😍😍thanks for awesome work ❤❤

[@LearnitTraining]

Thank you so much 😀

[@muhamadaji8746]

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

[@LearnitTraining]

Added!

[@muhamadaji8746]

Thank you, but on the access master and expert list, still no added 😂

[@MarTin-dn9oe]

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

[@simur2040]

Hi Dan this video is great. I Hope you can add the translation option to this video. Thanks

[@LearnitTraining]

Hi Armando! We are looking into captions overall!

[@thecentralscrutinizerr]

If you can't learn from this guy, they need to pull the plug.

[@LearnitTraining]

Thank you for the kind words!

[@bmin1022]

Thanks for your efforts... You are great!!!

[@LearnitTraining]

Thank you too!

[@magdimohamed6478]

thank you for your fantastic work. i need your help with my data base if your time allows. thanks

[@LearnitTraining]

Hi Magdi! You can get help at Offsite, our online community - www.offsitebylearnit.com/

[@pipabit]

Best tutorial ever

[@LearnitTraining]

Thank for watching pipabit! An extra big thank for subscribing as well!

[@john1957john]

Great Tutorial. Thank you very much

[@hiteshjoshi3148]

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.

[@LearnitTraining]

Hi Hitesh - SQL is definitely a video we have planned to make this year

[@hiteshjoshi3148]

@@LearnitTraining thanks sir

[@kensimba7868]

@@LearnitTraining am tuned in and waiting

[@LEDAMASUKE]

Great instructions ever

[@LearnitTraining]

Dan was one the best we had! RIP Dan!

[@iesmartielongoria7342]

Is there a way that Parameter search pop up with out Shift-F9 ?

[@stevebebo1196]

Is it possible for a Parent Table to have more than one Child Table?

[@consciouslynatural1276]

Yes

[@kazerog2000]

Great stuff. Thanks a lot.

[@LearnitTraining]

Our pleasure!

[@llyons3999]

I see on their youtube channel there is an access Expert and Master, but which one comes before which?

[@LearnitTraining]

Expert then Master

[@juliahargreaves2095]

Awesome! Thank you.

[@LearnitTraining]

You're welcome!

[@barsharajbhandari4679]

I keep getting a type mismatch error while making the query with personal data and human resources table. I did check the data types

[@cparedes2302]

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?

[@umbertofreitas5918]

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!

[@fredkelly6953]

Thanks Fernando.

[@LearnitTraining]

You are welcome!

[@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.

[@georgelast9307]

You really should put subtitles to this wonderful video, it helps a lot when following

[@venkataramanan7656]

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?

[@Youssiflagrosse]

Excellent training. I feel like Neo in The Matrix when he said "I know kung-Fu" now.. :)

[@LearnitTraining]

Thank you for the kind words Rej! We hope you learned alot!

[@scottsmalley786]

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?

[@LearnitTraining]

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.

[@davidfoo6974]

What 3rd party zoom app do you use to zoom in on the screen?

[@LearnitTraining]

Hi David - that is Zoomit

[@amauryramos6694]

Awesome!!

[@LearnitTraining]

Thank you! Cheers!

[@chunglee5626]

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

[@arnlogic9610]

Try this Customer left join order where month=this month and qtyorder=0

[@ruchagg4500]

what version of windows do you have?

[@sharmarudra]

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?"

[@Cruz0e]

why would you choose tabs view over windows , its way better ...

[@LF100-03]

To hear Rush Limbaugh narrate this lecture please select Playback Speed 1.50.

[@javierdimix]

04:01:50 that's great!

[@LearnitTraining]

👍

[@pelajarabadi7104]

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.

[@commanman974]

exercise files link not working. Pls update.

[@LearnitTraining]

Hi Parthiban! We just tested the link and it is working

[@commanman974]

@@LearnitTraining thanks for the reply. It also worked for me in my phone. May be problem with my laptop's internet.

[@mohammedsalah1821]

i need a translation file

[@sebastianbenke8676]

Haha the beginning of the videos makes me what some more access stuff indeed!

[@LearnitTraining]

Thank you for watching! We hope you learned a ton!

[@abdulhakimyasin7098]

wow Amazing

[@LearnitTraining]

Thank you! Cheers!

[@awalsanneh3792]

nice one

[@LearnitTraining]

Thanks!

[@agg4390]

53:59

[@tootricks]

waw maza a gaya

[@LearnitTraining]

Thank you Sandeep we are glad you had fun learning!

[@ELIASABISAIAGUIRRERODRIGUEZ]

Hahahahah Bro, I love this man´s character!

[@LearnitTraining]

Dan was the man! A great instructor gone too soon.

[@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.

[@jacklythgoe1478]

New JOYsey

[@何源-l6o]

要是有中文字幕就好了

[@何源-l6o]

谢谢您的知识分享！

[@LearnitTraining]

我们正在制作字幕 We are working on subtitles!

[@hidingindanielsroom7268]

Agatha Christie: The unusual case of Ms EN1-39