Download the course files to follow along and practice what you learn ️https://www.simonsezit.com/access-2019-beginner-to-advanced-course-files/
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.
https://www.simonsezit.com/access-2019-beginner-to-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 - 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
Get unlimited training with Simon Sez IT’s 150+ courses ⏩ https://www.simonsezit.com/courses/
Level up your skills with a free 30-day trial to our complete training library of 8,500+ 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 ;-)