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 [ Ссылка ] 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: [ Ссылка ]. 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: [ Ссылка ]
Access course: [ Ссылка ]
Keep in touch:
Website: [ Ссылка ]
YouTube Channel: [ Ссылка ]

If you want to take get a deeper understanding of Microsoft Access, take a look at [ Ссылка ]

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.

свернуть