Learn MS Access and Build your First Database Today

Microsoft Access is the easiest and best starting database for many businesses and day to day applications. In this comprehensive video, learn how to use MS Access and create your very first database in under 45 minutes!

📕 Concepts covered in this video

What is MS Access
Database theory
Creating tables and adding data in Access
Table design mode vs. data sheet mode
Linking one table with another with relationships
Keys (primary vs. foreign)
Data validation in Access
Creating data entry forms in Access
Linking one form to another (nested forms) in Access
Writing queries in Access - simple and complex example
Creating reports from your database
Saving and reopening Access files
📁 Download Files:

Sample Access DB
https://github.com/chandoo-org/SQL/raw/refs/heads/main/OUR%20FIRST%20DB.accdb

Customer Data (for copy pasting)
https://github.com/chandoo-org/SQL/blob/main/customer%20data.xlsx

All other data (for copy pasting)
https://github.com/chandoo-org/SQL/blob/main/data%20for%20the%20database%20v1.xlsx
🕜 Video chapters:

0:00 - What to expect in this video
00:15 - What is MS Access and how to get started with it?
05:20 - Creating your first database table (customer table)
13:39 - Adding data to Access by copy pasting (from Excel)
20:47 - Setting up table relationships in Access (Primary vs. Foreign Key)
26:18 - Forms in Access
34:05 - Nested Forms in Access
37:09 - Queries in Access
46:20 - Creating your first report in Access
50:21 - Saving and Reopening your Access DB

~

Two tables were having a romantic date 🥰
Another table walks up to them and says...
That looks fun ... Can I join you? 😂

#Access #database

Видео Learn MS Access and Build your First Database Today канала Chandoo