Microsoft Access Tutorial: 7 Hours of Beginner to Advanced Training

In this Access 2019 Beginner to Advanced training course, we cover the basics of Microsoft Access and expand to more advanced skills. We'll go over database templates, creating and saving your very first database, using the lookup wizard, backing up your database, and creating linked tables.

We'll also explore the datasheet view, how to set up a Northwind Database, link to tables in other databases, install the SQL Server Express, the basics macros, and so much more!

We've even included downloadable instructor and exercise files from our paid-for courses so you can follow along and complete the exercise in this course. This will help you put what you are learning into practice and master MS Access 2019.

📝 Use the timestamps below to navigate to different sections of the course. If you already know one of these topics, skip ahead!

00:00:00 - Simon Sez IT Intro
00:00:21 - Introduction to Access 2019
00:03:40 - Acquiring Access 2019
00:08:05 - Structure of the Course
00:10:28 - Using Database Template
00:21:29 - Creating, Saving, and Opening Databases
00:28:10 - Access Workspace and Backstage
00:41:52 - Online Help
00:50:35 - Working with the Ribbon
01:00:03 - Quick Access Toolbar
01:06:00 - Contextual Menus
01:08:40 - The Status Bar
01:12:49 - Keyboard Shortcuts
01:16:29 - Key Tips
01:20:23 - Access Options
01:29:39 - Creating a Table and Fields
01:41:10 - Indexing Fields
01:49:52 - Lookup Wizard
02:01:27 - Numeric Fields
02:09:15 - Exercise 01
02:12:41 - Importing Data from Excel
02:23:39 - Exercise 02
02:29:17 - Backing Up Your Database
02:33:14 - Compact and Repair
02:39:39 - Design in the Datasheet View
02:49:50 - Sorting and Filtering in Datasheet View
02:59:52 - Entering and Modifying Data in Datasheet View
03:10:47 - Creating a Link Table
03:21:22 - Setting Up Relationships
03:31:18 - Exercise 03

03:41:42 - Advanced Course Overview and Content
03:46:50 - Primary Keys and Indexing Rules and Guidelines
03:56:45 - More About Indexes
04:05:22 - Setting Up Northwind Database
04:08:58 - Working in Datasheet View
04:20:02 - Customizing Datasheet View, Sorting and Filtering Options
04:37:17 - Subdatasheets
04:46:39 - Exercise 01
04:47:47 - Linking to Tables in Other Databases
05:01:14 - Acquiring and Installing SQL Server Express
05:26:34 - Exercise 02
05:27:50 - Splitting Database into Front-end and Back-end
05:37:29 - Converting a Shared Table into a Local Table
05:48:54 - Exercise 03
05:50:45 - Addressing Multi-User Issues when Sharing Data
06:00:38 - Basics of Macros
06:14:05 - Macros on Events; AutoExec
06:26:05 - More about AutoExec
06:42:18 - Macro Security Settings
06:48:50 - Exercise 04

💻 Watch more free popular training tutorials from Simon Sez IT:

🔥Check out our FREE 300+ hour training course playlist here ➡️

💬Stay in touch!

🔔 Subscribe to our channel:

If you enjoyed the video, please give a thumbs up 👍🏽 ;-)

[SimonSezIT]

🔥We have additional free tutorials for MS Access tutorials here 👉

[moizrashid]

Dear Deborah Ashby, I wanted to take a moment to thank you for the incredible Microsoft Access Tutorial. Your explanations were clear and concise, and your voice was easy to follow, making it a pleasure to learn from your videos. As a beginner (been using Access for just over a year now - regret why I did not learn it sooner a decade, or two ago), I found your tutorials incredibly helpful in building my skills in Microsoft Access, and I was able to progress quickly to more advanced features. I am truly grateful for your dedication to creating such high-quality educational content. Once again, thank you for your hard work and commitment to helping others learn. Your contributions to the community are greatly appreciated

[augustodemelo]

It is certainly the best Access course I had been exposed to in years. Deborah Ashby is very didactic, and her way of teaching is clear and follows the natural steps of learning. Deborah and Simon Sez IT, you are the best! Thank you very much.👍

[Recoil]

The First hour and a half is very basic "Tips for using MS office" and has little to do specifically with Access.
From 1:30:00 to 3:40:00 is the introduction to Access up to creating your first link table/ relationship.
At 3:40:00 the class breaks off abruptly, just before beginning Forms, and we jump ahead to the "Advanced" portion of the class
When the class instruction picks up again at 3:47:00, we see that the forms have all been created for our exercise database. That whole section of the Beginner course, where we learned how to make forms, has been skipped.

[staceycummings]

Awesome tutorial. Deb is easy to understand, stays on track, and gave more than enough information for me to start a genealogy census records database linked to an ancestor DB and locality DB.

[gordon]

Hi Deb, another detailed entire training course from Simonsez, looking forward to watching the programme.
Many Many thanks.
Gordon, Halifax UK.

[ericbrugel]

Thank you very, very much for this course. This is helping me a lot. Very well explained and easy to understand.👍

[michaelsvenson]

Many years ago I tryed to do some work with Access, did one database for my brothers wines, did it all from scratch just by trail and error but soon got it to work as I wanted. Then it all just stopped there, I found Excel and it was easier to use, not so advanced as Access, but not as nice to look at.
So, why not try it again and here I am, following your tutorial and enjoy every minute of it. Great work from all of you... Thumbs up from Sweden 🙂

[Dr-Luvaz]

Deb you are such a great teacher i followed your 6hrs cause and enjoyed it, keep up the good work

[jamaldeenyakubuzakaria]

I am a teacher and I'm enjoying your MS Access tutorials so much, especially your voice.

[Recoil]

tbl Tour Trip Type Table Tab Triptype, Data Type. I'm sure all this alliteration and duplicate word choices seemed like a good idea at the beginning...

[DAHCKRAM]

The imports work fine in the exercises but if you change the lookup to "allow multiple values" in let's say the ActivityLevel field then you can no longer import any data into the table from excel or a text file... So what is a workaround to be able to import data into access with a table that has a lookup with "allow multiple values" enabled?

[rvkajal]

Very well explained. Easy to understand.👌

[dzczske]

dziękuję za pomoc, wszystko rozumiem. Elastico fantastico.

[iliesboukhatem]

really great tutorial !
Thank you so much

[brainyclassmates]

Thank you Deb Ashley and thank you SimonSezIT for this very good ACCESS video

[haroune]

Thank you Deb Ashley and thank you SimonSezIT for this helpful video access 😀

[musisir]

This training is so fantastic and I like the calmness of the facilitator although she has hidden her face.

[Quranicinfo]

You are explaining everything So Clearly-
Are you offering A certificate to candidate?

[misbahullahmomand]

hi deb, thanks for that great course you offered, I was to start access in these days.