Microsoft Access 2016 Tutorial in 30 Minutes: Beginner to Expert - Access Made Easy
This is the concise version of the Microsoft Access 2016 tutorial. Explore it for your next job application. It covers most areas of what one needs to know to be familiar with databases in a business environment. Learn more at https://learn.kaceli.com.
The tutorial starts with the very basics and continues to the more advanced features on properly understanding how design and use an Access database. #access tutorial; #access 2016 tutorial; #access 365 tutorial;
THE DATA FILES FOR THE TUTORIAL ARE HERE: https://kaceli.com/a/access2016files/
The following are covered in this tutorial along with the timeline:
Getting Started with Access Concepts
General Concepts Related to Databases
Components of a Database: Tables, Queries, Forms and Reports
Database components in an actual database: A brief overview
Opening and working with an existing Access database template and identifying components
Creating a new database and saving a database
The Access user interface components
Creating your first table in Microsoft Access and table components
Understanding data types in an Access Database and tables
Defining the table fields and data types
Entering data directly into a table
Primary Key concepts
Using the Design View to design a Table
Modifying the Design of an existing table using Design View and adding a new field
Yes/No fields in a table and assigning the Primary Key in a table
Creating forms from a table to enter and update data using the Form Wizard
Modifying a form in Access
Creating a simple query from a table and using the Query Wizard
Creating reports and using the Report Wizard
Modifying a report
Using the Data Files for the tutorial
Creating Tables from an Excel data file
Importing the data structure and the data from an external file
Creating tables and importing the data from a .csv file
Creating a Table from a .csv file
Understanding the Primary and Foreign Keys in a database
Linking tables in Access 2016 and Defining the Relationships
Identifying the primary and foreign keys
Selecting the tables and linking the tables
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.
Learn how to create a query or report with user input.
Learn how to export data out of Access.
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/YAj0vzMdEPE
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 Tutorial in 30 Minutes: Beginner to Expert - Access Made Easy канала Kaceli TechTraining
The tutorial starts with the very basics and continues to the more advanced features on properly understanding how design and use an Access database. #access tutorial; #access 2016 tutorial; #access 365 tutorial;
THE DATA FILES FOR THE TUTORIAL ARE HERE: https://kaceli.com/a/access2016files/
The following are covered in this tutorial along with the timeline:
Getting Started with Access Concepts
General Concepts Related to Databases
Components of a Database: Tables, Queries, Forms and Reports
Database components in an actual database: A brief overview
Opening and working with an existing Access database template and identifying components
Creating a new database and saving a database
The Access user interface components
Creating your first table in Microsoft Access and table components
Understanding data types in an Access Database and tables
Defining the table fields and data types
Entering data directly into a table
Primary Key concepts
Using the Design View to design a Table
Modifying the Design of an existing table using Design View and adding a new field
Yes/No fields in a table and assigning the Primary Key in a table
Creating forms from a table to enter and update data using the Form Wizard
Modifying a form in Access
Creating a simple query from a table and using the Query Wizard
Creating reports and using the Report Wizard
Modifying a report
Using the Data Files for the tutorial
Creating Tables from an Excel data file
Importing the data structure and the data from an external file
Creating tables and importing the data from a .csv file
Creating a Table from a .csv file
Understanding the Primary and Foreign Keys in a database
Linking tables in Access 2016 and Defining the Relationships
Identifying the primary and foreign keys
Selecting the tables and linking the tables
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.
Learn how to create a query or report with user input.
Learn how to export data out of Access.
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/YAj0vzMdEPE
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 Tutorial in 30 Minutes: Beginner to Expert - Access Made Easy канала Kaceli TechTraining
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
How to use Microsoft Access - Beginner TutorialMicrosoft Access 2016 Tutorial: A Comprehensive Guide to Access - Part 1 of 2Relational Combo Boxes in Microsoft Access - Get the Values from Another Table or QueryAccess 2019 Complete Tutorial: Microsoft Access Made EasyTHIS is what Windows 10 should look like! - Custom Windows Image TutorialMicrosoft Access 2016 Tutorial for the Workplace and Students: Part 2 of 2 for by Sali KaceliExcel Tutorial: Learn Excel in 30 Minutes - Just Right for your New Job ApplicationMicrosoft Access Beginner Full 3 Hour Tutorial Database Planning, Customer Table, Queries, FormsMicrosoft Access 2016 Tutorial for Beginners - Learn How To Use Access in 30 MinutesHow to Create Multiple Nested Continuous Subforms in Microsoft AccessMicrosoft Access 2016 Forms: SwitchboardMicrosoft Access 2016 Complete Tutorial - Access Made Easy by Sali KaceliExcel Tutorial for Beginners | Excel Made EasyHow and Why to Split Your Microsoft Access Database - Linked Table, Front End, Back End, BenefitsMicrosoft Access 2016: Modifying Tables, Creating Queries, Forms & ReportsAccess Beginner TutorialTop 15 Advanced Excel 2016 Tips and TricksWord Tutorial: Learn Word in 30 Minutes - Just Right for your Job ApplicationHow to Use Macros in Microsoft Access 2013 - Examples of Macros and Using AutoexecPowerPoint Tutorial: Learn PowerPoint in 30 Minutes - Just Right for your Job Application