Microsoft Access 2016 Tutorial: A Comprehensive Guide to Access - Part 1 of 2

The following are covered in this tutorial along with the timeline:
00:00 Getting Started with Access Concepts
00:50 General Concepts Related to Databases
02:55 Components of a Database: Tables, Queries, Forms and Reports
04:13 Database components in an actual database: A brief overview
09:08 Opening and working with an existing Access database template and identifying components
11:22 Entering data in a database from a template
13:47 Creating a new database and saving a database
14:00 The Access user interface components
15:35 The Tell me feature in Access 2016
16:19 Creating your first table in Microsoft Access and table components
17:59 Understanding data types in an Access Database and tables
18:19 Defining the table fields and data types
20:22 Entering data directly into a table
22:35 Primary Key concepts
23:57 Using the Design View to design a Table
28:51 Modifying the Design of an existing table using Design View and adding a new field
29:41 Yes/No fields in a table and assigning the Primary Key in a table
31:44 Creating forms from a table to enter and update data using the Form Wizard
36:31 Modifying a form in Access
38:53 Creating a simple query from a table and using the Query Wizard
41:30 Creating reports and using the Report Wizard
43:47 Modifying a report
45:00 Using the Data Files for the tutorial
48:00 Creating Tables from an Excel data file
49:43 Importing the data structure and the data from an external file
53:58 Creating tables and importing the data from a .csv file
55:16 Creating a Table from a .csv file
57:12 Understanding the Primary and Foreign Keys in a database
1:00:30 Linking tables in Access 2016 and Defining the Relationships
1:02:02 Identifying the primary and foreign keys
1:02:53 Selecting the tables and linking the tables
1:03:30 Defining the relationships

If you like the video, please "Like," "Favorite," and "Share" it with our friends to show your support on this work. Subscribe to this channel so that you do not miss out on the new videos on this series.

Keep in touch:

Copyright notice: These videos may not be downloaded or distributed in any way without permission from Sali Kaceli. Contact me if you have such a need.

[JENAGAL]

I must say I was very intimidated by Access 2016, avoided it every way I could. Then I started a new job and the first thing they wanted me to do is to develop a Database... EWK!!!! So the first tutorial I came across was yours. Let me say sir, in two days I have created a Table, a Form, a Query, and a report. Very basic stuff, but it will get me on my way. Thank you so much for your wonderful video!!!

[Walkinhighlightt]

Wow, I hadn't messed around with access since college and had to relearn it for a new job, just amazing. I learned more in an hour and a half than I did in an entire semester, it really is all about the teacher. Amazing work. thank you so much, cant wait to go over part 2 and learn more

[nancychow]

I fall in love of the video before I even finishing it. This is by far the most intuitive and easy to follow video I could find, thank you Sali for presenting it from the audience's view and step by step leading us from very basic to advance levels.

[gloriamarkham]

I've watched several Access videos and this one is the best I've found so far. He gives the most important information and is brief. Some videos are too brief, missing important points. Some are too long and most of us with work and life don't have hours to spend to get the information we need! Very easy to follow and understand!

[kylerstevens]

This tutorial was amazing! Easy to follow, simple explanations, and he provides the Access files that he uses to explain the concepts he's teaching on. Great job Sali!

[mommabear]

I'm only 8 minutes in and I already understand Access a little better and am not feeling so intimidated. The online MS Office course I'm taking is all text based, but sometimes you just need a video. Thank you for all your hard work and for sharing this with the world!

[m.raedallulu]

It's obvious that you've made a hard work while preparing this useful and informative video, to present it to us on youtube for free.. Thank you so much.

[brookelynNY]

This has been by far the best tutorial, I've taken a class as well as tried to follow a book. I made much more sense of it by watching these vids. Thank you so much for sharing, this gave me a good foundation!!!

[fredb]

Unbelievably helpful. I was in the process of completing a 6 hour course via LinkedIn. Your clear, succinct instruction saved me time and frustration. Thank you.

[umarchetty]

You want an honest opinion? Your tutorial was wonderful. I learned so much. I thought I would never get to understand Access. It was one hour 11 mins and 31 second well spent on my weekend. Thank you again.

[SamudraFlavorsYT]

Only 10K likes? This video deserves more.
This was a wonderful tutorial!

[stefanijarandjelovic]

Thank you Sali, this is amazing. It is the first time that I decided to learn how to use MS Access, and this tutorial is just perfect, easy to follow and right on point. Can't wait for the part 2.

[robmelis]

Thank you!!! My team needed to do a fairly detailed database of their products and photos for a client in a very short time. Though we are extremely proficient in in web and graphic design, we have never had a client throw a database project at us for use by sales people. It's not complex as databases go but complex for us. It is intricate and the visuals are important as there are lots of photos of products. We didn't know where to start on this and somebody said "let's use MS Access" and quickly realized that MS Access was indeed perfect for what the client required. Years ago I had Filemaker Pro experience but literally have never touched Access. This tutorial got us up to speed super quickly and we are now moving quickly towards completion of the project. Everything we saw here worked great in the current MS Access we have through Office 365 so all the info is up to date. This is a fantastic tutorial delivered in a very logical way that gave us the foundational knowledge we needed. I thank you very much for putting it together. :-)

[caribbeanwoman]

Thank you Mr. Kaceli for your thorough yet simple to follow tutorial. You are an awesome teacher. Thank you for sharing. Never used Access and find myself having to get a quick handle on it as I go back out in to the work place. You have given me the confidence I needed, by making what I thought was going to be a mind boggling experience into a easy to understand one. Thank you so very much. Shalom

[radekhurt]

Mr. Kaceli is an absolute star...:)) Thank you very much for your excellent tutorials. Free tutorials that would elsewhere cost a fortune. I really like your pace of explaining the matter.

[avinashsookur]

thank you very much Man, you really saved me from From now on, i'll consider you as my Master

[cruzerbagercruzerbager]

Thanks for the Video!

I am a programming major with zero Access experience. I recently got a position at a company and Access is a must! You really helped me understand the fundamentals! Thanks!

[lordshahnewazchowdhury]

Excellent work. I have not to use Access for the last 3 years. It refreshes my skills and learning. Thank you.

[rosemalott]

Thank you for this Sali. I have basic knowledge of databases and have always wanted to learn more about Access. This tutorial is so easy to follow. Looking forward to the next one.

[showdownpublisher]

First of all i started as a complete beginner but once i got a project work with MS Access to create a database to do it. Thank you for helping me you kind of saved my life. Also you deserve more subscribers for your Excellent explanation skill!