SQL for Microsoft Access

Learn How You Can Use SQL in Microsoft Access with the Tips, Tools, and Exercises in This Highest-Rated Course.

Created by: IsáBel .
Microsoft Certified IT Professional. Trainer of 25 Years

What Will I Learn?

• Files & SQL Script Included!
• WRITE SQL Queries in Your Microsoft Access Databases
• CREATE Select Queries
• FILTER with the WHERE Clause
• SORT Your Access Records
• GROUP Your Records
• USE Aggregate Functions
• LEARN About Date Function
• GET Familiar with Functions You Can Use with Strings
• LEARN How to Join Tables
• CREATE Tables Using SQL
• INSERT Records Into Your Tables
• Use Action Queries Like:
• - UPDATE
• - DELETE
• CREATE SubQueries
• ... and more

Requirements

• Download the Northwind database to follow along. This is covered in lecture 2.

Target audience

• This SQL course is for Microsoft Access users who are not yet familiar with SQL syntax. No prior programming knowledge is needed, but familiarity with Access databases is. This course is probably not for you is you are looking to learn super advanced queries.