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/ra... Customer Data (for copy pasting) https://github.com/chandoo-org/SQL/bl... All other data (for copy pasting) https://github.com/chandoo-org/SQL/bl... 🕜 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