lesson 4 introduction to MS access

:

📘 Microsoft Access Tutorial 4 – Primary Keys, Foreign Keys & Practice Exercise
Welcome to Lesson 4! In this 26-minute tutorial, we explore the core concepts of Primary Keys and Foreign Keys—essential for building relational databases in Microsoft Access. We also introduce a hands-on exercise for you to practice what you’ve learned!

🛠 What You’ll Learn:
✅ What a Primary Key is and why it’s essential
✅ How to define and use Foreign Keys to link tables
✅ How to insert records into related tables (with Access limitations)
✅ How to query across linked tables
✅ Practice Exercise: Build a “Cars” table and answer real database questions

📂 Follow Along:
We’ll continue using the Students and Results tables, and you’ll create a new Cars table for the exercise.

⏱ Video Chapters (26:02 Total):
0:00 – Introduction to Database Keys
2:10 – Primary Keys Explained
5:30 – Foreign Keys Explained & Setup
10:15 – Inserting Records into Related Tables
14:40 – Querying Across Tables Using Foreign Keys
18:20 – Exercise Introduction: Create the “Cars” Table
21:50 – Exercise Questions Presented
24:30 – Challenge for Viewers
25:40 – Recap & Next Steps

📝 Your Challenge:
At the end of the video, you’ll be asked to:

Create the Cars table and insert the provided data

Determine the number of records and fields

Write queries to filter cars by speed, doors, price, and acceleration

Try it yourself and share your answers in the comments!

📚 Playlist Progress:
⬅️ Previous: Lesson 3 – SQL Operators (BETWEEN, LIKE, AND, OR)
➡️ Next: Lesson 5 – [Coming Soon]

👨‍💻 Perfect For:
Learners ready to take the next step into relational database design and apply SQL skills to a real exercise.

🔗 Engage & Support:
💬 Post your answers to the exercise in the comments! I’ll provide feedback and guidance.
👍 If you found this helpful, please like and share!
🔔 Subscribe & hit the bell so you never miss a tutorial.

🎓 Course Material Prepared By:
Evans Devancie Bwalya for IT Society @KMU. Used with permission for educational purposes.

#MicrosoftAccess #PrimaryKey #ForeignKey #SQLExercise #DatabasePractice #AccessTutorial #LearnSQL #RelationalDatabase #DataModeling #HandsOnLearning