This is the complete tutorial on Microsoft Access 2016. The tutorial starts with the very basics and continues to the more advanced features on properly understanding how design and use an Access database. For more info. visit http://learn.kaceli.com/. THE DATA FILES FOR THE TUTORIAL ARE HERE: https://kaceli.com/a/access2016files/ 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 Learn how to create forms in a database in Access 2016. Learn how customize forms in Access 2016. Learn how to create queries in Access 2016. Learn how to create custom queries with criteria and calculated fields. Learn how to create reports in Access 2016 Learn how to customize reports in Access 2016. 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. Video URL: https://www.youtube.com/watch?v=xRYSP-yFgb0 Keep in touch: Website: http://kaceli.com/ YouTube Channel: null If you want to take get a deeper understanding of Microsoft Access, take a look at http://learn.kaceli.com/ 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.