How to use Microsoft Access - Beginner Tutorial

In this step-by-step tutorial, learn how to use Microsoft Access. We walk what Access is for, why you should use it over a spreadsheet, how to create tables, how to add a form, how to run SQL queries, and how to create a report. By the end of this video, you'll understand the fundamentals of working with databases in Access.

📚 RESOURCES

⌚ TIMESTAMPS
00:00 Introduction
01:01 Advantages of a database over Excel
02:36 Access alternatives
03:17 Overview of tutorial structure
04:10 Access start page
05:04 Create blank database
05:22 Tables, fields & records
14:36 Calculated field & expression builder
15:50 Sample order data
16:50 Opening & closing windows
17:16 Relationships
19:01 Import data sources
19:25 Forms
22:12 Queries
27:51 Reports
30:02 Save Database
30:25 Wrap up

📺 RELATED VIDEOS

🙌📩 NEWSLETTER

🔽 CONNECT WITH ME

🎁 TOOLS AND DISCOUNTS

🎒 MY COURSES

🙏 REQUEST VIDEOS

🔔 SUBSCRIBE ON YOUTUBE

🙌 SUPPORT THE CHANNEL
- Hit the THANKS button in any video!

⚖ DISCLOSURE
Some links are affiliate links. Purchasing through these links gives me a small commission to support videos on this channel. The price to you is the same.

#stratvert

[domiqueallen]

You are A lifesaver. You taught me this in 31mins and my teacher couldn't in 3hrs. I have a test coming up on database and this helps me greatly. Thank

[davegrays]

I feel confident enough to call this YouTube channel ''Kevin University." Thanks, Kevin.

[robertjohnson]

I’m more of a watcher and rarely give comments but I had to speak on how helpful this video was, and how much it will help me at work.

[kudussumani]

My name is Sumani Kudus and I'm watching this video from Ghana, West Africa. I'm a student of the University of Cape Coast, Ghana. Your video has really made Access soo simple for me. I'm having a presentation on Access and with the help of your video I'm pretty sure everything will be easy for me. Thank you!

[haseebkahn]

Oh my ....! It is absolutely fantastic to see how you managed to pack our 2 months of Access academic course in just 31 mins. Thank you so much, Kevin! 😍🥰

[A_mx]

How dare Excel limit me to a million rows?!?!

All jokes aside, this was incredibly useful since I've not used Access before. Thanks Kevin!

[staceyb]

Thank you, Kevin! You show everything without showing too much, and you explain things very succinctly for those of us who have NO clue, but you also don't talk down to us. You are a great instructor, and I will seek you out for other training!

[satorace]

my college professor made us watch this instead of teaching it himself to the class.

[ElnurMalikov]

Kevin is a great educator. Very informative - not too short, not too long - just the right size. Very helpful. It has been ages since I last time used Microsoft Access and Kevin's video was a great refresher! Cheers and thank you

[CC-mxrd]

This was an excellent course! I've been tasked by my customer to create a database using Access, but I have never used Access before. I watched a few other tutorials, but they were either outdated, over simplified, or targeted to a user not familiar with a computer at all, providing more information than a generally experienced Windows user needs. This course is streamlined with clear, concise directions and lots of hands on examples. I created a database alongside Kevin, during the video and it's easy to pause or rewind if it gets ahead of you, or you need further clarification of a step. I will definitely subscribe to more of these videos. Great direction, thanks Kevin!

[cpt_schaner]

This is amazing... truly a work of art. With your help Kevin, you are going to help me be SO successful in the early stages of my career. The lack of this knowledge throughout companies is mindblowing and you're really giving so much information in such a great and digestible way. Thank you sincerely.

[huwerlthornton]

Thank you so much for this video Kevin! I'm trying to take a large, unwieldy spreadsheet and create a database that will tell me what 3rd party vendors are going to be at which site and the date. You've given me enough information to take a crack at it. Your style of explanation is easygoing and understandable. You truly have the heart of a teacher! I've subscribed and liked!

[SeniorEliteStrike]

Thanks Kevin. We need part 2 on how to import data from different sources like Excel and others. More Access tutorials would be so nice.

[Aichauer]

Kevin, i am an Office Trainer in Germany since 1999. I have to say, that you are realy impressing me with your very deep knowledge and the very kind and genius way to make everything easy to understand. You are how an excellent Trainer should be!👍

[lindascrofano]

It's been a long time since I have used Access. I needed a great refresher from start to finish for the basics. This is by far one of the best technical tutorials I've seen on YouTube. Thank you!

[LibraNails]

FINALLY! I understand Access. Couldn't image learning anything in just 30 minutes but you nailed it. 20 years of struggling on my own and giving up ... and this video is like life!!

[heatherwhittemore]

This was an amazing tutorial to refresh my brain on my Microsoft Access class from 2001. I am an independent bookseller and have an affiliate site where I can get an Excel report of all of the info, and way more than I even need. Now I have all of my customers entered, the books they've purchased, dates, sales, commissions, etc. It's so nice to just click their name and see their entire order history rather than scrolling through a bunch of cells. Thank you!!!

[sandeway]

WOW! In half an hour I have learnt so much than what I was thought in college several years ago. Thank you Kevin

[ashrithanu]

I have a interview tonight, have never used Access before ....Nw after 31 mins i feel i can convince anyone that i have months of experience in access... Thanks kEV...

[kb]

Wow! Really good tutorial and encouraging to get started! Concise, informative, and simple. Well done!!