Microsoft Access SQL: SQL for Non-Programmers

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

4.68 (800 reviews)

Udemy

platform

English

language

Databases

What you will 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

Course Gallery

Microsoft Access SQL: SQL for Non-Programmers – Screenshot 1 — Screenshot 1 – Microsoft Access SQL: SQL for Non-Programmers

Microsoft Access SQL: SQL for Non-Programmers – Screenshot 2 — Screenshot 2 – Microsoft Access SQL: SQL for Non-Programmers

Microsoft Access SQL: SQL for Non-Programmers – Screenshot 3 — Screenshot 3 – Microsoft Access SQL: SQL for Non-Programmers

Microsoft Access SQL: SQL for Non-Programmers – Screenshot 4 — Screenshot 4 – Microsoft Access SQL: SQL for Non-Programmers

Loading charts...

Comidoc Review

Our Verdict

Gain an approachable introduction to SQL within Access with this course that helps non-programmers overcome challenges. Bolster your learning through diligent practice and alternative resources when necessary, but don’t expect hands-on guidance or thorough explanations for every niche topic in this 4-hour, highly-rated course.

What We Liked

Comprehensive SQL coverage for Microsoft Access, including file usage & script, SELECT queries, filtering, sorting, grouping, aggregates, JOINs, subqueries, and more.
Clear examples make SQL manageable for non-programmers. Many students feel they've gained a solid foundation in SQL through this course.
Real-world application emphasized throughout the course helps learners to see when & how to apply topics.
Lab exercises after each section with answer keys foster practice and deeper understanding.

Potential Drawbacks

Pacing of some complex topics (e.g., JOINs and subqueries) may challenge beginners, who might need additional examples or slower instruction speed.
Instructor response to Q&A is inconsistent, leaving students to resolve questions through alternative resources.
Lacking theoretical explanations for certain concepts, potentially impacting the long-term retention of information, as some users desire more 'Why' behind the 'How'.