Access Master Tutorial

Access Expert 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
Free-Floating Parent and Child Forms 0:52
Starting Your First Macro 12:23
Adding Actions to Your First Macro 23:40
Three Ways to Trigger Macros 41:34
Creating Command Buttons Without the Wizard 57:28
Joining Forms by a Shared Field 1:06:43
Parent Form Size and Position 1:23:18
Child Form Size and Position 1:40:46
If-THEN and IN-List 1:46:51
Creating Combo-Boxes by Typing Entries 2:02:15
Combo-Boxes from Imported Tables 2:09:45
SETVALUE and GOTOCONTROL 2:19:16
Introduction to VBA 2:28:47
SELECT CASE Example in VBA 2:57:11
Debugging Simple Macros 3:12:04
Radio Buttons in VBA 3:17:34
Wrapping Up 3:39:28
Introduction 3:42:33
Compacting and Repairing Databases 3:43:18
Hyperlinks in Tables 3:49:49
Hyperlinks from Pictures in Forms 4:01:56
Switchboard Using Command Buttons 4:12:21
Read-Only Form Buttons 4:24:28
Switchboard Manager Method 4:31:55
Navigation Forms as Switchboards 4:50:02
Record Locking 4:56:36
Startup Options 5:04:13
Special Keys 5:14:54
Wrapping Up 5:27:39

#Access

(C) 2021 Learnit, Inc.
Any illegal reproduction of this content will result in immediate legal action.

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

[cranefly]

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.

[nfirliy]

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!

[yuinique]

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. 😊

[kensimba]

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.
Following from Nairobi Kenya 🇰🇪🇰🇪

[muhammedqasmallahabdulrahm]

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

[shahinulkhan]

What a great course.

What a great teacher.

Watched all 8 modules and learned loads and loads.

Thank you.

[williamstevenson]

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.

[brettmanwill]

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!

[InitialGain]

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 💖

[brookesmith]

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 YouTube videos. Excellent job. Now to learn a bit more about VBA and Visual Studio.

[alvaroalpuche]

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

[pascalikoli]

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

[rasikachemburkar]

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

[waleedtawfeek]

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

[saqibiqbal]

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.

[grahamparker]

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

[westcoast]

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

[pedro_em_bra]

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.

[darrenwalker]

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