Download your free course transcript here:
️https://www.simonsezit.com/access-2016-course-exercise-files

This is video 1 of a three-part series teaching you how to use Microsoft Access. In this free Microsoft Access tutorial for beginners, we start by creating our first table in Microsoft Access before moving onto how to back up an Access database, how to modify data in an Access database and how to create links between tables in Access.

We've even included a free downloadable follow-along exercises. Download the accompanying exercise files here:

https://www.simonsezit.com/access-2016-course-exercise-files

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

0:00:00 Introduction
0:00:55 Creating a Table and Fields
0:15:41 Indexed Field
0:27:17 Lookup Wizard
0:41:49 Numeric Fields
0:52:33 Exercise 01
0:56:56 Importing Data from Excel
1:11:55 Excercise 02
1:17:14 Backing up your Database
1:24:00 Compact and Repair
1:31:19 Design in the Datasheet View
1:42:43 Sorting and Filtering in Datasheet View
1:53:19 Entering and Modifying Data in Datasheet View
2:06:15 Creating a Link Table
2:18:35 Setting up Relationships
2:31:31 Exercise 03

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 Microsoft Access 2019 Training Tutorials https://www.youtube.com/playlist?list=PLzj7TwUeMQ3j9iS4gy9HWfUcxQ7r7qBQ3

Microsoft Access 2016 Training Tutorials for Beginners playlist https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jb4HGldAc307RUUCn2lX4F

Excel 2021 Tutorials for Intermediate Users here https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jhT7yg37LKe8aSTA7OuWn3

Microsoft Office 2021 and Office 365 Training here https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hH_MxteY6LR3OSMHpDkt_j

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

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 ;-)