SQL Basic Tutorial #2 | Master SQL Queries in Microsoft Access

Unlock the power of SQL in Microsoft Access!

In this video, we explore essential SQL queries using real-world examples in MS Access. Whether you're a beginner or brushing up your skills, this tutorial walks you through key SQL functions step by step.

🧠 What You'll Learn in This Video:

✅ How to create and use two tables: Employees and Departments
✅ Use of GROUP BY to group data by departments
✅ Filter grouped results using the HAVING clause
✅ Filtering with IN, BETWEEN, and LIKE in Access (using * wildcard)
✅ Writing INNER JOIN queries to combine employee and department data
✅ Using TOP and subqueries to simulate LIMIT and OFFSET in Access
✅ Applying aggregate functions: COUNT, SUM, AVG, MIN, and MAX

This is Part 2 of our SQL tutorial series using Microsoft Access — ideal for students, analysts, and beginners who want practical hands-on SQL examples.

Tables Used:

Departments: DeptID, DepartmentName
Employees: EmpID, EmpName, Salary, Gender, DepartmentID, JoinDate

📂 Need the sample tables or Access files?

Drop a comment below and we’ll help you set it up!
👍 Like | 💬 Comment | 🔔 Subscribe for more beginner-friendly SQL and database content.

#excel #sql #microsoftaccess #sqltutorial #sqlinaccess #msaccesstipsandtricks #groupby #JoinQueries #AccessSQL #learnsql #sqlforbeginners #datalogix #ibs