Access 2019 Full Tutorial: Microsoft Access Made Easy

The concepts outlined here apply to Access 2016, Access 2013, Access 2010 or earlier.

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
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
Learn how to create forms in a database in Access.
Learn how customize forms in Access.
Learn how to create queries in Access.
Learn how to create custom queries with criteria and calculated fields.
Learn how to create reports in Access
Learn how to customize reports.
Creating Compound Form (a form with subform) in Access
Customizing Forms in Access 2016
Locating and Filtering Data in an Access Form
Creating Queries from multiple tables
Advanced Queries and Query Design in a database
Using multiple criteria options in a query
Creating calculated fields in a query
Creating and modifying reports in Access
Creating reports from multiple tables
Customizing reports in Access
Adding a new field to an existing report
How to create queries that utilize user input prompt e.g. enter the date range and retrieve the data. Learn how to user input queries in reports in Access databases.
Exporting data from tables or queries to Microsoft Excel.
Performing a mail or email merge with data from an Access database.
Creating a database dashboard in Microsoft Access. Adding items to the dashboard.
Adding a new field to an existing table in Access. Adding attachments to records in a database.
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.

[sandyheagy]

One of the best tutorials I have watched! He explained everything well and made the training easy to understand. Thank you.

[cobmask]

The most comprehensive, best-explained and easy-to-understand tutorial on Access on youtube, by far. I want to say a big Thank You to Mr. Kaceli.

[zljbb]

Absolutely brilliant tutorial... This has given me a lot of confidence in building my first database and cannot thank you enough! A lot of info, but in a style that will stick. Cheers Sali, great work and amazing delivery!

[petersalkeld]

One of the best tutorials I have seen on YouTube. Thank you for the enormous amount of work that went into producing a superb, professional video.

[Skouliko]

Slow and easy to understand. Full 3 Hours. All in one. My Respects Teacher.

[jerrylounsberry]

I sincerely appreciate the amount of effort and time you put into this video. It help me very very much and I appreciate your expertise. Many thanks!

[KayaEdy]

I'll watch this a bit later. I like to practice a bit while i follow the tutorials... Many thanks sir, for sharing these great tutorials!
We appreciate your work!
To all : Wishing you a happy, healthy New Year !!! :)

[progressivelifeforwardisth]

One of the best tutorials on the internet 🙏🏽🙏🏽

[kamaraemmanuelf]

one of the best tutor in the world... one love sir

[mariellari]

Thank you Sali 🙂🙏 This was absolutely very informative. Learn a lot today about Microsoft Access.

[Saeedcrowe]

Thanks for sharing all the valuable instructions. it's very comprehensive and thorough.

[Strballa]

Such a great tutorial! Your method of instruction was straightforward, easy to follow, and showed all the requirements for making a complete database. Your video is helping me to prepare for a new database manager position. Thank you very much!

[jamesclark]

Thank you Sali. This helped me to greatly prepare for college prior learning assessment test. I know the other Office programs pretty good, but Access is a different world. Hope I pass....

[basu]

Fantastic tutorial for the beginner. Lots of information structured and paced out well. Excellent presentation. Thanks very much!

[jervin]

I agree, very nice for people who are somewhat familiar with Microsoft Office and with databases. Great overview with sufficient details. Time well spent.

[mboyer]

i watched one other access tutorial, it was 2 1/2 hours long and was completely useless. This tutorial goes over creating queries, forms, and reports...which is why i'm using Access. Thank you:)

[TrungTran-mrqo]

Thank you very much! The course is very easy to understand

[rusher]

Beautiful and You for producing such a nice tutorial..

[renan]

Thanks for the video. Real nice overview. Good job.

[abdullahkhan-kufp]

Excellent tutorial. Thank you for such beautiful tutorial.