Microsoft Access Tutorial - Beginners Level 1 (Quick Start)

Are you new to Microsoft Access and looking to learn how to create a database from scratch? Look no further! In this tutorial, I will take you through the basics of Microsoft Access and guide you step-by-step in creating your first database.

We will start by creating a blank database and taking a quick tour of the tabs and ribbon. From there, we will guide you through creating a table and adding fields to it. You will learn how to add records in datasheet view and import records from an Excel spreadsheet.

Next, we will show you how to create a form and enter or modify records in it. We will take you through the design view of a form and show you how to customize it to your liking.

After that, we will teach you how to create a query in Microsoft Access and modify it in design view. Finally, we will demonstrate how to create a report in Microsoft Access to display and print your data.

Whether you are a student, a professional, or just someone who wants to learn a new skill, this Microsoft Access tutorial is perfect for beginners who want to learn how to build a database from scratch. So what are you waiting for? Join us and start your journey to becoming an Access expert today!

00:00 Introduction
0:25 What is Microsoft Access
1:21 Create a blank database in Access
3:05 A quick tour of the tabs and ribbon
6:45 Create a table in Microsoft Access
8:30 Adding fields to your table
10:53 Add records in datasheet view
12:52 Import records from excel spreadsheet
15:16 Create a form in Microsoft Access
16:15 Design view in a form
18:20 Enter or modify records in a form
20:25 Create a query in Microsoft Access
22:02 Modify your query in design view
23:59 Create a report in Microsoft Access

[whentheleveebreaks]

I touched on Access a small amount in college, but it's been a few years now. At my job I'm using it now and completely forgot most of it. It's difficult to find tutorials on it so I appreciate this video it helped a lot. Thanks

[melissajohnson]

I just got a new job as a senior accountant and this company uses access 😩😩. I have not used it in years since college and wasn’t aware company’s still use this software. Anyways, I am here to learn to get better at my new role 😊

[tamikasepiso]

Jamie is a lifesaver. I like how he takes his time almost in all the videos really patient and the fact that I'm also a patient its comes as a bonus. I have learnt so much from him, in my books he's a hero.

[kevinkendall]

had to use this for a college course and it was probably the simplest assignment ive done because of how you explained it. thank you!

[ChinnyBonny]

My first time trying out MS Access and it was well worth my time to start learning the basics. I'll be looking out for other videos on Access to learn more.
Thanks heaps! You got a new subscriber

[georgekennedy]

Thanks, Jamie. Great beginners' Lesson!

[pcLumsy]

Loud and clear 👏💯💖. I also love that everything is so vividly displayed on the screen.

[curiosity_killed_this_cat]

i have a ICT CT in 4 days, this *will* help me far better than my teacher

[mhgwuwe]

This is super helpful! I had no idea at all and now it is making sense!

[catemugo]

Thank you so much for the explanation. I really needed this looking Forward to the next course

[rayquackenbush]

Greatly helpful. I am in the process of creating and Ancestry and was using Excel but this makes much more sense due to being able compare one person to another. Will be back for more learning.

[dayspring]

Thank you, this was a really good tutorial. There were a couple of times I had to replay how you reverted back to 'Views' and which one you chose but it was easy. This gives me hope that I can learn Access. Will definitely be watching more of your vids. You have a new sub!

[maryfuentes]

Love it. Thank you so very much! You are the best!

[agbejoyeolufunmi]

A teacher walked up to me for help in teaching her how to tackle questions in an external exam with MS Access. Without any knowledge, a look at this video makes me a beginner guru.

Thanks a lot. I am leaving excel for a while to explore this powerful programme

[word_of_christ_ministries]

Well done. This was very helpful. I followed along, creating the database as the teacher performed the task.

[Joseph-rqel]

this is great...learned access when I was young... but don't really have a good view of what it does... this videos now clears everything...

[matatawilson]

thanks to you, you have made me understand right from scratch.

[greenlife-gardens]

Thank you so much, I now have Access to Access! I’ve been using Word & Excel for years and using Excel where I know I really should have been using Access.

I could never find a tutorial that was easy to understand, mainly because the tutors didn’t convey in Layman’s Terms. So easy to digest and implement what you teach, and you deliver in such a simple & fresh way. You get 10/10 from me. I will use Access a lot now to manage a plant database and it will open new doors of creativity for me I’m sure.

Brilliant.

[tamonwancharoensripongsa]

Thanks for sharing this video. It's straightforward to follow and easy to understand the basics. Thanks!

[wathmiubeyrathna]

I love it... This was so simple and easy to understand. Thank u so much... You taught it better than my teacher...