lesson 2 introduction to MS access

📘 Microsoft Access Tutorial 2 – SQL Queries: INSERT, SELECT, UPDATE, DELETE & ALTER
In this in-depth 44-minute tutorial, we dive deep into the essential SQL commands you'll use daily in Microsoft Access. Learn how to add, retrieve, modify, and remove data—and even change your table structure—all with practical examples and step-by-step guidance.

🛠 What You’ll Learn:
✅ How to INSERT single and multiple records (and Access’s limitation)
✅ Using SELECT with WHERE to filter and view specific data
✅ Updating records with the UPDATE command
✅ Modifying table structure with ALTER TABLE (ADD, MODIFY, DROP)
✅ Safely removing data with DELETE
✅ Common pitfalls and best practices in Access SQL

📂 Practice Along:
Use the database you created in Lesson 1, or start fresh with a new table called “Students” to follow along.

⏱ Video Chapters (44:05 Total):
0:00 – Introduction & What You’ll Learn
2:15 – INSERT INTO – Adding New Records
10:30 – SELECT with WHERE – Filtering Data
18:45 – UPDATE – Editing Existing Data
26:20 – ALTER TABLE – Adding & Removing Columns
34:50 – DELETE – Removing Records Safely
40:10 – Common Mistakes & Tips
42:30 – Summary & What’s Next in Lesson 3

📚 Playlist Progress:
⬅️ Previous: Lesson 1 – Introduction to Tables
➡️ Next: Lesson 3 – Operators & Keys

👨‍💻 Perfect For:
Beginners with no prior SQL knowledge, students, office professionals, and anyone looking to manage data efficiently in Access.

🔗 Engage & Learn:
💬 Questions? Drop them in the comments—I respond to every one!
👍 If this helped you, please like and share!
🔔 Subscribe & hit the bell so you never miss a lesson.

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

#MicrosoftAccess #SQL #DatabaseTutorial #AccessQueries #INSERT #SELECT #UPDATE #DELETE #ALTER #LearnSQL #AccessForBeginners #DataManagement #OfficeSkills