Microsoft Access 2021 Beginner Course: 3 Hours Database Management Training

Download the free course exercise files to follow along
https://www.simonsezit.com/access-2021-exercise-instructor-files/
In this Microsoft Access 2021 beginner training, we discuss the basics of the latest on-premises Access database release from Microsoft. Enhance your data management capabilities and learn how to easily create small to large databases.
Master the terminology, interface, commands, templates, and more –including crafting meaningful relationships between tables. We'll also show you some handy keyboard shortcuts and key tips to help you work efficiently with Access.
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-exercise-instructor-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 - Simon Sez IT Intro
00:00:19 - Acquiring Access 2021
00:04:17 - What's New in Access 2021
00:07:50 - Exercise 01
00:09:32 - Use Database Templates
00:17:57 - Create, Save and Open Databases
00:26:50 - Expose the Access Interface and Backstage
00:38:10 - Customize the Quick Access Toolbar
00:44:14 - Access Menus
00:49:08 - Keyboard Shortcuts & Key Tips
00:55:04 - Online Help
01:00:41 - Access Options
01:08:42 - Exercise 02
01:12:08 - Create a Table and Fields
01:19:59 - Index Fields, Primary Keys and Add Records
01:26:42 - Use the Lookup Wizard to Create a Drop-down List
01:34:21 - NUmeric and Data validation Rules
01:41:40 - Add More Table Fields
01:46:13 - Exercise 03
01:52:20 - Importing Data from Excel
01:57:06 - Import Data from a Text File
02:01:08 - Exercise 04
02:02:45 - Design in the Datasheet View
02:08:29 - Sort and Filter in Datasheet View
02:14:33 - Enter and Modify Data in Datasheet View
02:19:46 - Exercise 05
02:23:22 - Relationships Explained
02:26:55 - Set Up Relationship
02:31:21 - Create a Link: Part 1
02:37:19 - Create a Link: Part 2
02:43:53 - Edit the Link Table
02:55:50 - Exercise 06
Get unlimited training with Simon Sez IT’s 200+ courses https://www.simonsezit.com/courses/
Supercharge your skills with a FREE 14-day trial to our extensive training library. Learn from 10,000+ ad-free videos and begin your transformation today! https://simonsezit.lpages.co/ssit-14-day-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?listPLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
Check out our free video playlist for Data Analysis using Microsoft Tools https://www.youtube.com/playlist?listPLzj7TwUeMQ3jiDSWwQjtVvHqT09XdYFMi
Microsoft Access Training video playlist https://www.youtube.com/playlist?listPLzj7TwUeMQ3g7dabQhzlqljY-bnxv1YFA
Microsoft Excel Beginner's Training here https://www.youtube.com/playlist?listPLzj7TwUeMQ3iZHn4cv_fZagWSN8tubU9Z
Introduction to Databases Training here https://www.youtube.com/playlist?listPLzj7TwUeMQ3jJ9OhflqrL5huscvd0Q9Qn
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_confirmation1
If you enjoyed the video, please give a thumbs up ;-)