Microsoft Access 2016 Complete Tutorial - Access Made Easy by Sali Kaceli
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://youtu.be/xRYSP-yFgb0
Keep in touch:
Website: http://kaceli.com
YouTube Channel: http://youtube.com/skaceli
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.
Видео Microsoft Access 2016 Complete Tutorial - Access Made Easy by Sali Kaceli канала Sali Kaceli
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://youtu.be/xRYSP-yFgb0
Keep in touch:
Website: http://kaceli.com
YouTube Channel: http://youtube.com/skaceli
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.
Видео Microsoft Access 2016 Complete Tutorial - Access Made Easy by Sali Kaceli канала Sali Kaceli
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
HUGE Microsoft Access Tutorial - 3 HOURS! - Import Excel Into Access 2013/2016Word 2016 Tutorial Complete for Professionals and Students50 Ultimate Excel Tips and Tricks for 2020Excel 2016 Tutorial: A Comprehensive Guide on Excel for AnyoneOutlook 2016 Tutorial for the Workplace and Students - A Comprehensive TutorialExcel 2013 Tutorial: A Comprehensive Guide to Excel for AnyoneMicrosoft Access 2016 Tutorial: Linking the Tables and Defining the RelationshipsHow To Manage User Authorization and User Access in Access 2013 🎓Database Design Course - Learn how to design and plan a database for beginnersUser Input Queries and Reports with Date Range in Microsoft Access 2016Microsoft Excel Tutorial for Beginners | Excel Training | Excel Formulas and Functions | EdurekaSQL Tutorial - Full Database Course for BeginnersMicrosoft Access 2016 Tutorial: A Comprehensive Guide to Access - Part 1 of 2PowerPoint 2016 Tutorial - A Complete Tutorial on Using PowerPoint - Full HD 1080PCreating a Dashboard or Switchboard in Access 2016Microsoft Access in Just 40 minutes 2019 - Access User Should Know - Complete Access Tutorial HindiHow To Create A Keyword Search in Access 2013 🎓Access 2016 - How to Make a Database - Part 1 - TablesAccess 2013 Best Practices - Proper Table StructuresMicrosoft Excel 2016 - Learn Excel 2016 Beginners Tutorial Video