Skip to content
Write a review
UdemyMicrosoft AccessPaid courseAll LevelsCertificate

SQL for Microsoft Access (Udemy.com)

Learn how to write SQL code in Microsoft Access, so you can create more advanced Access queries

4.7
418 reviews

Created by: Phillip Burton

Last updated December 2024

icon
What you will learn

  • Know all 6 clauses of the SELECT statement, and in which order.
  • Add functions and formulas into your code.
  • Do basic and advanced JOINs, some of which cannot be done in the graphical interface.
  • Create UNION queries, which also cannot be done in the graphical interface.

icon
Course Description

Do you want to learn how to write more advanced queries in Access. And do you want your queries to be portable into SQL Server and Access?

Please note: This course is not affiliated with, endorsed by, or sponsored by Microsoft.


What do people just like you think of this course?

"This is an excellent course, very well organized, structured, explained and paced. In addition, the course is content rich, provides a very good context and helpful tips! This is exactly what I was looking for. Thank you very much!" - Dmitry Tlusten

"I am a 51 year old complete beginner and just wanted to learn access to create my own database for a side business. I first took an MS Access course and then this SQL for Access course which allowed me to understand access better and to add some useful functionality to my database. Really enjoyed it, felt like a great introduction to SQL." - Mark Nugent

"If I were to name single biggest advantage of this course I would say that it is very logically structured. In my opinion essential to master any subject. Before the course I had some vague idea of SQL, but after it I feel quite solid." - Bartomiej Kurzeja

In this course learn how to:

  • Write SQL code, using the six SELECT clauses.

  • Use functions and formulas in your SELECT statements.

  • Create joins between tables, including more complex joins which cannot be evaluated using the graphical interface.

  • Write action queries and cross-queries.

  • Using derived tables in the FROM clause, and subqueries in the WHERE clause.

  • Creating correlated queries and cross-queries.

  • Using UNION and UNION ALL, and

  • Importing or Linking data and creating Pass-Through queries from other databases.

Hopefully, by the end of this course, you will also feel "quite solid" in Access SQL, and be able to use the extra functionality allowed only when using Access SQL to build even better databases.
Read More All Levels All Levels product length iconTime: 4.5h

icon
Udemy Discount

The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.

Get the Udemy discount

Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.

icon
Instructor Details

Phillip Burton

Hi. I'm Phillip, and I'm proud to Teach with Udemy as a Udemy Instructor Partner. I have been teaching on Udemy since 2015, and I have over 1,000,000 students and more than 60 video courses, including over a dozen Bestseller courses.

My courses include Microsoft Power BI and Fabric, Tableau, SQL Server, Power Platform (Power Apps, Power Automate, etc.), Azure, Microsoft Office, and more. The majority of my courses align with the requirements for official certifications from Microsoft, Oracle, and Tableau - so with a bit of practice, you could enter the exam or assessment and put it on your CV or resume.

I have been a Computing Consultant providing expert services in the development of computer systems and data analysis. I am one of 9 award winning Experts for Experts Exchange's 11th Annual Expert Awards. My interests are working with data, including Microsoft Power BI, Excel, Access, SQL Server, and the Power Platform.

Read More

icon
More courses by Phillip Burton

$18.99

$22.99

$22.99

$99.99

$13.99

Free

All courses by Phillip Burton

icon
More Microsoft Access courses

$64.99

$64.99

$11.99

$64.99

$74.99

$74.99

All Microsoft Access courses

icon
Reviews

4.7

418 ratings on Udemy

Select a bar to show only those reviews.Select the bar again to show every rating.

Write a review

By Omarwin Barrero on 8/25/2022

Another amazing course delivered by Phillip, who is an amazing instructor. I have previously taken other courses from him. Phillip is very knowledgeable and delivers such amazing trainings. This course is very well-explained, concise and straight to the point.

By Gergana Krasteva on 5/8/2022

Easy to understand and to follow, I like the course so far. Good examples, however I am giving 4/5 stars as I am missing praticle exercies - please add at least 1 exercise after each section with instructions to solve it alone.

By Dmitry Tlusten on 1/15/2021

This is an excellent course, very well organized, structured, explained and paced. In addition, the course is content rich, provides a very good context and helpful tips! This is exactly what I was looking for. Thank you very much!

By Jose Chavez Jr on 4/19/2020

So far the content is very interesting to me and I want to learn to use SQL language writing to improve the capabilities of my current queries. The clicking on screen is very fast.

By S O Olivarez on 4/12/2020

The information was good but I had a hard time keeping up with the actions the author took, e.g. jumping from one tab to another - maybe an explanation of this reasoning or logic. Alternatively, I will just have to find and repeat individual couses.

By FeltonLovett Sr. on 9/20/2019

I am very satisfied with what I've learned in this course. I've been using access for about 2 years and the things that I have learned will go a long way to making my and my co-workers job so much easier.

By Bartomiej Kurzeja on 4/26/2019

If I were to name single biggest advantage of this course I would say that it is very logically structured. In my opinion essential to master any subject. Before the course I had some vague idea of SQL, but after it I feel quite solid.

By Dan A North on 12/8/2018

The course is excellent and I would recommend it as both an introduction to MS ACCESS SQL and a great refresher. Mr. Burton reminded me of several options I had forgotten about and helped me solve more than one puzzle at work. Thank you for a great course sir.

By Carlos Hernández Nieves on 11/11/2018

The instructor makes easy what it looks difficult to understand. I like the way of explaining how to write the SQL code. The teacher sometimes writes SQL that doesn't work but these errors are not forced. He explained what it is wrong and then he drives you to the correct SQL code very naturally.

By Charlie@Enginspire.Co.Uk on 4/16/2018

All-in-all the course and instructor are excellent. However the instructor did flash between screens very quickly at times and this was difficult to follow as a 'Newbie'. This did not detract from my overall enjoyment of the course. Great as usual - thanks.

Showing all 10 reviews on CourseDuck

Read all 418 reviews on Udemy

icon
Quality Score

No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 94 / 100

SQL for Microsoft Access
Visit course on Udemy Write a review
  • Video Duration: icon 4.5h
  • Price: $10.99
  • Provider: icon Udemy
  • Updated: icon December 2024
  • Level: All Levels All Levels
  • Language: icon English
  • Certificate: icon Yes
30-day money-back guarantee on most paid courses

Udemy Coupon Price Tracker

Udemy price history

For any issues or feature requests please email CourseDuck's Co-Founder at mkuhlman12@gmail.com