Access Advanced Tutorial

Access Advanced Tutorial

Get Ad-Free Training by becoming a member today!

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:

For Private Group Trainings please visit:

Username: manuals
Password: password

Start 0:00
Introduction 0:03
Showing File Name Extensions 1:14
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.

[clauria]

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 😅

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

[venkataramanan]

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.

[JLB]

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

[arunshinde]

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.

[hapemokenela]

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

[koteshwarpanuganti]

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

[origbeecee]

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

[InitialGain]

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

[Sandra-vxiw]

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!

[proudlycanadian]

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!

[Mary_]

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!

[kevinkimball]

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.

[samm]

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

[tyroneharding]

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

[AndrewSmith-vvvh]

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.

[odie]

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

[marceljunioregondi]

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.

[sharif]

You are the best teacher for teaching ms access

[umbertofreitas]

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!