✅ Download the free course exercise files to follow along ➡️[ Ссылка ]
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.
✅[ Ссылка ]
📝 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 ⏩ [ Ссылка ]
🚀 Level up your skills with a free 30-day trial to our complete training library of 9,200+ videos ⏩ [ Ссылка ]
💻 Watch more free popular training tutorials from Simon Sez IT:
🔥Check out our FREE 300+ hour training course playlist here ➡️
[ Ссылка ]
✅ Check out our free video playlist for Data Analysis using Microsoft Tools 👉 [ Ссылка ]
✅Microsoft Access Training video playlist 👉 [ Ссылка ]
✅ Microsoft Excel Beginner's Training here 👉 [ Ссылка ]
✅ Introduction to Databases Training here 👉 [ Ссылка ]
💬Stay in touch!
SimonSezIT.com: [ Ссылка ]
LinkedIn: [ Ссылка ]
FaceBook: [ Ссылка ]
🔔 Subscribe to our channel:
[ Ссылка ]
If you enjoyed the video, please give a thumbs up 👍🏽 ;-)
