Download the free course exercise files to follow along ️https://www.simonsezit.com/access-2021-advanced-course-files/

In this Advanced Microsoft Access 2021 training course, we cover everything you need to take your database management skills to the next level. We'll discuss various topics to maximize your efficiency and success.

Set up your Access environment for success, master the intricacies of primary keys and indexing, and gain a deeper understanding of working in a datasheet view. Customize and leverage advanced sorting, filtering, and sub datasheets to enhance your data analysis capabilities. Learn how to link tables to other Access databases and explore the SQL Server Express integration world. Discover the power of splitting an Access database into frontend and backend, and address multi-user issues when sharing data. Delve into the basics of macros, automate processes with macro events, and optimize your macro security settings.

Become a Microsoft Access 2021 expert with this 2.5-hour tutorial and revolutionize your database management skills!

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

https://www.simonsezit.com/access-2021-advanced-course-files/

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 - Course Introduction
00:02:31 - Set Up for Success in Access 2021
00:05:33 - Primary Keys and Indexing Rules and Guidelines
00:14:58 - More About Indexes
00:23:03 - Setup Northwind Database
00:26:21 - Work in Datasheet View
00:26:21 - Customize Datasheet View
00:35:22 - Advanced Sorting and Filtering in Datasheet View
00:43:48 - Subdatasheets
00:52:07 - Exercise 01
00:53:20 - Linking Two Tables to Other Access Databases
01:04:55 - Install SQL Server Express
01:14:25 - Setup SQL Server Express
01:24:07 - Exercise 02
01:25:21 - Splitting an Access Database into Frontend and Backend
01:32:56 - Convert to Local Table
01:40:44 - Addressing Multi-user Issues when Sharing Data
01:50:58 - Exercise 03
01:52:52 - Basics of Macros
02:00:28 - Macros On-Events; AutoExec
02:11:34 - More About AutoExec
02:23:30 - Macro Security Settings
02:29:19 - Exercise 04

Get unlimited training with Simon Sez IT’s 170+ courses ⏩ https://www.simonsezit.com/courses/

Level up your skills with a free 30-day trial to our complete training library of 9,200+ videos ⏩ https://www.simonsezit.com/ssit-first-month-free

Watch more free popular training tutorials from Simon Sez IT:

Check out our FREE 300+ hour training course playlist here ️
https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU

Check out our free video playlist for Data Analysis using Microsoft Tools https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jiDSWwQjtVvHqT09XdYFMi

Microsoft Access Training video playlist https://www.youtube.com/playlist?list=PLzj7TwUeMQ3g7dabQhzlqljY-bnxv1YFA

Microsoft Excel Beginner's Training here https://www.youtube.com/playlist?list=PLzj7TwUeMQ3iZHn4cv_fZagWSN8tubU9Z

Introduction to Databases Training here https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jJ9OhflqrL5huscvd0Q9Qn

Stay in touch!
SimonSezIT.com: https://www.SimonSezIT.com/
LinkedIn: https://www.linkedin.com/company/simon-sez-it/
FaceBook: https://www.facebook.com/SimonSezIT

Subscribe to our channel:
https://www.youtube.com/simonsezittraining?sub_confirmation=1

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