Channel: Kaceli TechTraining

Category: Education

Tags: access tutorial beginnersmicrosoft access tutorial beginnersaccess 2019accessaccess 2019 tutorial beginnerscomplete tutorial accessaccess tutorialhow to use access 2019kacelimicrosoft access 2019access 2019 tutorialmicrosoft access 2019 tutorialmicrosoft access coursemicrosoft access 2019 tutorial beginnermicrosoft accesshow to use microsoft accesskacelitechtrainingfree course ms accesshow to use accesshow to use microsoft access 2019

Description: This is the complete course for Access 2019, Office 365 designed for teachers or students or professionals who want to learn Access and concepts related to databases. The tutorial is concepts-based, easy to understand. For more info. visit learn.kaceli.com and even consider taking the Access course. The concepts outlined here apply to Access 2016, Access 2013, Access 2010 or earlier. THE DATA FILES FOR THE TUTORIAL ARE HERE: kaceli.com/a/access2016files. You will need to download and unzip them. 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. Video URL: youtu.be/C7oCwdm_wXg Access course: learn.kaceli.com Keep in touch: Website: kaceli.com YouTube Channel: youtube.com/skaceli If you want to take get a deeper understanding of Microsoft Access, take a look at 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.