Access Advanced Tutorial
Access Advanced Tutorial
Get Ad-Free Training by becoming a member today!
/ @learnittraining
Exercise Files: www.learnitanytime.com/p/exer...
Who it's For: Access is designed for people who are comfortable with spreadsheet programs like Excel. These users need more power and analyzation, as well as a stronger forward-facing interface.
What it is: Access is a database creation and management program. It helps you design, build, and interface with a robust database to help your organization run smoothly. Many small to medium-sized businesses use Access for this exact purpose.
What You'll Learn: This course starts with database basics, terms, and information you’ll need to confidently build your database later on. Then, you’ll learn how to build tables, determine relationships, query data, and create simple-to-use interfaces that other people at your company can use to interact with your data.
For ad free training and certificates please join Learnit Anytime:
www.learnitanytime.com
For Private Group Trainings please visit:
www.learnit.com/private-group...
Manuals: bit.ly/30xZb59
Username: manuals
Password: password
Start 0:00
Introduction 0:03
Showing File Name Extensions 1:14
Opening Query.mdb 4:26
Updating File Formats and Showing Document Tabs 11:48
Hiding Table Fields 20:11
Unhiding Table Fields 27:57
Creating and Running Queries 30:54
Sorting the Query 37:29
More Ways to Select Views 45:14
Filtering Using OR 56:53
Filtering Using AND 1:06:09
Combining AND with OR 1:13:28
Filtering Using NOT and NULL 1:23:38
Multi-Table Queries 1:32:05
Wild Card Symbols 1:40:26
Calculations 1:48:54
Concatenating Words 1:59:47
Parameter Queries 2:07:49
Introduction 2:23:19
Multiplying and Aggregating 2:24:32
Subtotals via a Totals-Query 2:37:18
Crosstab-Query 2:49:49
Make-Table Query 3:02:41
Delete-Query 3:14:54
Update-Query 3:22:38
Append-Query 3:33:46
Exporting to PDF 3:41:40
Exporting to Word-RTF 3:54:16
Exporting to Excel 4:03:54
Importing from Excel 4:09:01
Linking to Excel 4:22:52
Linking from Access to Access 4:35:14
Lookup List in a Query 4:46:41
#Access
(C) 2021 Learnit, Inc.
Any illegal reproduction of this content will result in immediate legal action.
Пікірлер: 204
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
2 жыл бұрын
Thank you for the kind words Laura! Dan was one of the best teachers we ever had at Learnit!
@shaddwatson1833
2 жыл бұрын
He is the Total: Sum("best") ☺️
@marceljunioregondi5594
Жыл бұрын
@@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!
@LearnitTraining
Жыл бұрын
You are very welcome!
This is the best Ms Access tutorial i've ever done. Thanks.
@cosmicfugue1226
3 жыл бұрын
Watched... (done... doesn't make sense)
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
4 жыл бұрын
Thank you for the kind words Venkata!
Dan really is the best. Perfect balance of knowledge and humor. Highly recommend.
@LearnitTraining
Жыл бұрын
Dan was one the best instructors we ever had!
This is best tutorial on MS Access i have gone through. Thanks a lot and good job for Learnit and it's team.
@LearnitTraining
3 жыл бұрын
You are most welcome
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
3 жыл бұрын
Thank you Arun for the kind words and for watching!
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 KZread 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!
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
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
4 жыл бұрын
Glad it helped!
thanks for your tutorial Mr. Dan. I love the passion the way you exercising your video tutorial.
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!
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!
Love and enjoyed every minute of your video. Thank you. Love you much
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
3 жыл бұрын
Wow, thank you!
You are a goofball and an excellent instructor
Wish I Had a teacher like this for IT
@LearnitTraining
Жыл бұрын
Thank you for watching!
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!
Thanks a lot my teacher for your help.
I'm relay appreciate your great effort in this course , thank you
@LearnitTraining
2 ай бұрын
It's our pleasure
You're the best teacher I've ever had. Thanks a lot!
@LearnitTraining
3 жыл бұрын
Wow, thanks!
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!
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
2 жыл бұрын
You are welcome! The link to the exercise files is in the video description
This is training of an exceptionally high level, thank you for providing this!
@LearnitTraining
2 жыл бұрын
You're very welcome!
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
3 жыл бұрын
You are welcome Andrew! Glad you enjoyed the videos!
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!
You are the best teacher for teaching ms access
@LearnitTraining
2 жыл бұрын
Thank you Sharif! Dan was one of the best instructors we had! He is truly missed!
Vielen dank! Es war eine tolle Erfahrung mit Ihnen zu lernen.
@LearnitTraining
2 жыл бұрын
Danke für das Aufpassen! Ich hoffe, Sie haben viel gelernt
A natural teacher. Outstanding
@LearnitTraining
3 жыл бұрын
Thank you for watching and also the kind words!
Great Tutorial. Thank you very much
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
4 жыл бұрын
Best of luck!
@kensimba7868
4 жыл бұрын
@@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?
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 KZread 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 💖
Thanks for they video it’s very informative just want to know which is the third party software you use for zooming the screen
Perfect instructor and perfect lessons !!!
@LearnitTraining
Жыл бұрын
Thank you for the kind words!
This is the most practical approach to Access I've yet to find. Thank you, Lewis Black.
@LearnitTraining
3 жыл бұрын
You are welcome David Smith!
Hands Down Best Teacher
@LearnitTraining
Жыл бұрын
Thank you!
Thank you for the best tutorial you have done ever
@LearnitTraining
3 жыл бұрын
You're very welcome!
Just brilliant !!!! The best !!
@LearnitTraining
2 ай бұрын
Thank you so much!
Great teacher ! Thank
@LearnitTraining
Ай бұрын
Glad you enjoyed it!
Excellent training. I feel like Neo in The Matrix when he said "I know kung-Fu" now.. :)
@LearnitTraining
3 жыл бұрын
Thank you for the kind words Rej! We hope you learned alot!
You really should put subtitles to this wonderful video, it helps a lot when following
Thanks for your efforts... You are great!!!
@LearnitTraining
3 жыл бұрын
Thank you too!
If you can't learn from this guy, they need to pull the plug.
@LearnitTraining
2 жыл бұрын
Thank you for the kind words!
Thanks Dan, great course!
@LearnitTraining
2 жыл бұрын
Glad you liked it!
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
This man is the best !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
@LearnitTraining
Жыл бұрын
Dan was one our best instructors! RIP Dan!
Excellent tutorials. Thanks a lot!
@LearnitTraining
2 жыл бұрын
Glad you like them!
Best teacher of Access👍🏻👍🏻👍🏻
@LearnitTraining
2 жыл бұрын
Thank you! 😃
Very informative! Thanks for sharing!
@LearnitTraining
2 жыл бұрын
Glad you enjoyed it!
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
2 жыл бұрын
My pleasure!
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?
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
3 жыл бұрын
Glad it helped!
I keep getting a type mismatch error while making the query with personal data and human resources table. I did check the data types
Awesome! Thank you.
@LearnitTraining
2 ай бұрын
You're welcome!
Great stuff. Thanks a lot.
@LearnitTraining
Жыл бұрын
Our pleasure!
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 instructions ever
@LearnitTraining
2 жыл бұрын
Dan was one the best we had! RIP Dan!
You are amazing😍😍thanks for awesome work ❤❤
@LearnitTraining
3 жыл бұрын
Thank you so much 😀
Always great work. many thanks
@LearnitTraining
2 жыл бұрын
Thank you so much Farid!
Greetings from Malta the Maltese Islands... Can I set the font size to 11 permanently when using the 'zoom box'? ...thanks.
Thanks Fernando.
@LearnitTraining
2 жыл бұрын
You are welcome!
Hi Learnit, Please include English subtitles in this video, so I can understand more. Thank you very much
@LearnitTraining
2 жыл бұрын
Added!
@muhamadaji8746
2 жыл бұрын
Thank you, but on the access master and expert list, still no added 😂
Awesome!!
@LearnitTraining
2 жыл бұрын
Thank you! Cheers!
Is there a way that Parameter search pop up with out Shift-F9 ?
Best tutorial ever
@LearnitTraining
2 жыл бұрын
Thank for watching pipabit! An extra big thank for subscribing as well!
This man is a legend.
@LearnitTraining
3 жыл бұрын
Dan definitely was a legend and was one of the best instructors we ever had.
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?"
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!
It seems that the creation of the first multi table query at 1:32:05 is missing!
@avshots7692
3 жыл бұрын
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.
what version of windows do you have?
04:01:50 that's great!
@LearnitTraining
5 күн бұрын
👍
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.
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
Haha the beginning of the videos makes me what some more access stuff indeed!
@LearnitTraining
2 жыл бұрын
Thank you for watching! We hope you learned a ton!
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
3 жыл бұрын
Try this Customer left join order where month=this month and qtyorder=0
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
3 жыл бұрын
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!
To hear Rush Limbaugh narrate this lecture please select Playback Speed 1.50.
Hi Dan this video is great. I Hope you can add the translation option to this video. Thanks
@LearnitTraining
3 жыл бұрын
Hi Armando! We are looking into captions overall!
thank you for your fantastic work. i need your help with my data base if your time allows. thanks
@LearnitTraining
2 жыл бұрын
Hi Magdi! You can get help at Offsite, our online community - www.offsitebylearnit.com/
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
3 жыл бұрын
Hi Hitesh - SQL is definitely a video we have planned to make this year
@hiteshjoshi3148
3 жыл бұрын
@@LearnitTraining thanks sir
@kensimba7868
3 жыл бұрын
@@LearnitTraining am tuned in and waiting
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
2 жыл бұрын
Thanks for reaching out! For specific questions like these, try joining our community of instructors and peers at Offsite: 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".
@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.
wow Amazing
@LearnitTraining
2 ай бұрын
Thank you! Cheers!
nice one
@LearnitTraining
3 жыл бұрын
Thanks!
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
3 жыл бұрын
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.
I see on their youtube channel there is an access Expert and Master, but which one comes before which?
@LearnitTraining
2 жыл бұрын
Expert then Master
Hahahahah Bro, I love this man´s character!
@LearnitTraining
Ай бұрын
Dan was the man! A great instructor gone too soon.
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.
What 3rd party zoom app do you use to zoom in on the screen?
@LearnitTraining
3 жыл бұрын
Hi David - that is Zoomit
why would you choose tabs view over windows , its way better ...
waw maza a gaya
@LearnitTraining
3 жыл бұрын
Thank you Sandeep we are glad you had fun learning!
Is it possible for a Parent Table to have more than one Child Table?
@consciouslynatural1276
2 жыл бұрын
Yes
i need a translation file
53:59
New JOYsey
practice files, where are they?
@LearnitTraining
3 жыл бұрын
Hi Hans! The link to the exercise files is in the video description!
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.
exercise files link not working. Pls update.
@LearnitTraining
3 жыл бұрын
Hi Parthiban! We just tested the link and it is working
@commanman974
3 жыл бұрын
@@LearnitTraining thanks for the reply. It also worked for me in my phone. May be problem with my laptop's internet.
Agatha Christie: The unusual case of Ms EN1-39
Wow have Ihave Ihave I
@cosmicfugue1226
3 жыл бұрын
??