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:    • Microsoft Access 2016 Tutorial in 30 Minut...   Keep in touch: Website: http://kaceli.com YouTube Channel:    / 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.