Microsoft Access SQL: SQL for Non-Programmers

Tell the Query Design Window, "Good-bye", Start Scripting SQL, and Boost Your Earning Potential While You're At It.
4.4 (64 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
3,401 students enrolled Bestselling in Access
$19
$175
89% off
Take This Course
  • Lectures 86
  • Length 4 hours
  • Skill Level Beginner Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 6/2015 English

Course Description

*UPDATED: Nov. 8, 2016*


SQL Is One Of The Most Sought-After Skills By Employers.

You Can Quickly Learning How To Query Your Microsoft Access Databases with SQL

If you are already familiar with Microsoft Access databases, and would like to:

  •  Have more employable skills
  •   Learn an in-demand programming language
  •   Get the answers that you want, when you want them from your database
  •   Break free of the Query Design window, or Query Wizards


Then this course will enable you to discover how you can use SQL to query your Access databases. There is enormous value in knowing the basics and being efficient in SQL.

You can start using SQL today.
Here's your first example,

SELECT [SQL Course]

FROM Udemy

WHERE Instructor = 'IsáBel Harrison'

               

What are the requirements?

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

What am I going to get from this course?

  • 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

What is the 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.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Latest SQL for Non-Programmers Quick Tip
Article

Get the latest Quick Tips from Microsoft Access: SQL for Non-Programmers

Section 2: Introduction to Scripting SQL with Microsoft Access
01:46

Welcome to this Microsoft Access SQL course on Udemy.com

02:49

In this course you will be able to follow along using the Northwind database. This database can be downloaded from within Microsoft Access.

1 page

Make the most out of this course. Follow these steps for a successful course experience, and as always, feel free to message me or post a discussion.

Section 3: SQL: SELECT
02:11

Learn the structure of the SELECT statement, used to retrieve data from your database.

10:32

Multiple examples will walk you through the core of scripting SQL - the SELECT statement.

03:55

Learn to use aliases to temporarily rename a column heading

Article

The SQL used in this section.

2 pages

Exercises to reinforce the SQL you learned in this section of the course - SELECT

Section 4: SQL: WHERE
01:22

The WHERE clause is in SQL used to filter records

04:46

In SQL, wildcard characters are used with the LIKE operator, and can be used to substitute any character(s) in a string.

04:24

Learn additional ways to filter records in SQL

08:07

Examples of how you can use WHERE to filter records in SQL

07:27

More examples of how you can use WHERE to filter records in SQL

Article

The SQL used in this section.

2 pages

Exercises to reinforce the SQL you learned in this section of the course - WHERE

Section 5: SQL: ORDER BY
01:08

In SQL, ORDER BY is used to sort the result set

07:40

Examples of how you can use ORDER BY in SQL to sort records in your Access databases

Article

The SQL used in this section.

2 pages

Exercises to reinforce the SQL you learned in this section of the course - ORDER BY

Section 6: Introduction to Aggregate Functions in SQL
01:48

In SQL, use aggregate functions to return one value, calculated from multiple values in a column

07:03

Examples of the SQL SUM function

01:16

Examples of the SQL AVERAGE function

04:47

Examples of the SQL COUNT function

03:41

Examples of the SQL MIN and MAX functions

Article

The SQL used in this section.

2 pages

Exercises to reinforce the SQL you learned in this section of the course - Aggregate functions

Section 7: SQL: Date Functions
00:45

Examples of the SQL DATE function

00:18

Example of the SQL NOW function

00:37

Example of the SQL DAY function

00:58

Example of the SQL MonthName function

03:39

Examples of the SQL DatePart function

02:31

Examples of the SQL DateAdd function

02:02

Examples of the SQL DateDiff function

01:42

Examples of the SQL DateValue function

02:58

Learn how to format dates using SQL in your Microsoft Access databases

Article

The SQL used in this section.

2 pages

Exercises to reinforce the SQL you learned in this section of the course - Date Functions

Section 8: SQL: String Functions
01:52

Learn how to bring fields together using SQL

01:21

Use SQL to convert the value of a field to lowercase or uppercase

01:45

Extract characters from the left or right side of a character string in SQL

01:44

Extract characters from a character string in SQL

00:43

In SQL, find the length of a value in a string

01:13

Remove blank characters from the beginning and/or end of a character string in SQL

03:54

Replace characters with other characters

Article

The SQL used in this section.

2 pages

Exercises to reinforce the SQL you learned in this section of the course - String Functions

Section 9: Updating and Deleting Records Using SQL
01:55

In SQL, use UPDATE to update existing records in a table

09:41

Examples of how you can use UPDATE in SQL to update existing records in your Access databases

02:22

In SQL, use DELETE to delete existing records in a table

05:03

Examples of how you can use DELETE in SQL to delete existing records in your Access databases

Article

The SQL used in this section.

2 pages

Exercises to reinforce the SQL you learned in this section of the course - Updating and Deleting Records

1 page

If you are enjoying this Microsoft Access SQL course, please leave a positive comment, and a rating, which you can do at the top right hand corner of the Course Dashboard.

It takes less than a minute and it is a huge help to other students, and to me too.

Section 10: SQL: Subqueries
07:49

In SQL, a subquery is a query that is nested inside a SELECT, INSERT, UPDATE, or DELETE statement, or inside of another subquery

1 page

Learn to use EXISTS

Article

The SQL used in this section.

2 pages

Exercises to reinforce the SQL you learned in this section of the course - Subqueries

Section 11: Joining Tables Using SQL
03:42

The PRIMARY KEY uniquely identifies each record in a table. A FOREIGN KEY in one table is the PRIMARY KEY in another table.

05:12

Learn about INNER JOINS and OUTER JOINS

05:08

Learn the SQL syntax for creating Joins

12:47

Examples of how to Join tables in your Access database using SQL

3 pages

Examples of joining 3 or more tables in the Northwind database.

03:28

Learn to use aliases to temporarily rename tables

2 pages

Now that you know how to create a Subquery, and how to create a Join, which one should you use?

Article

The SQL used in this section.

3 pages

Exercises to reinforce the SQL you learned in this section of the course - Joins

Section 12: SQL: Tables
01:58

Learn how to create tables using SQL in your Microsoft Access databases

2 pages

Get familiar with different data types

03:23

Example of how to use SQL to create tables in your Microsoft Access databases

02:27

Example of how to use SQL to create tables in your Microsoft Access databases

03:01

Now that your table has been created, learn how to insert data into those tables using SQL

02:03

Examples of how to insert data into those tables using SQL

03:05

In SQL, use ALTER TABLE to add, delete, or modify columns in an existing table.

Article

The SQL used in this section.

2 pages

Exercises to reinforce the SQL you learned in this section of the course - Tables

Section 13: Other SQL Clauses & Functions
08:55

Learn how to create Crosstab Queries in SQL by using TRANSFORM and PIVOT

02:13

In SQL, use DISTINCT to return only distinct values.

06:57

In SQL, use TOP to specify the number of records to return.

05:43

Learn how to combine like SELECT queries with UNION.

Article

The SQL used in this section.

Section 14: Test Your SQL Skills
5 pages

Put what you have learned in Microsoft Access: SQL for Non-Programmers to the test with this 5 page resource

4 pages

The answers to the 5 page Test Your Skills questions for Microsoft Access: SQL for Non-Programmers

01:12

Thanks for being a part of this Udemy.com course. I hope that it has helped to further your understanding of SQL in Microsoft Access. if you have any questions, please let me know. I look forward to feedback.

1 page

What can you do, now that the course is complete, to help you with scripting SQL in Microsoft Access databases?

Here are your next steps.

Article

Complete one of my courses within 10 days of enrollment, get another one of my courses 100% free.

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

IsáBel Harrison, Computer Training Specialist Since 1999.

Inspiring and Empowering People to Achieve Their Goals through Learning.


Sharing the strategies, and tips you need to regain control at work, and optimize productivity.

IsaBel has been serving students since 1999. Successfully self-employed, she is a trusted consultant for businesses large and small. She is a publisher, and author of several highly-rated eBooks.

IsaBel has been certified many times over as a Database Administrator, IT Professional, Developer, Network Administrator, and even Certified Ethical Hacker. Even with a technical background, she is a down to earth half-marathoner, who enjoys her family, good food, and sports.

IsaBel grew up around teachers, so education was always important to her.

All her life she has seen how gaining even a little more knowledge can make such a big difference in everything from the way you speak, to the way you cook, the way you parent, to the way you fix a leaky faucet, the speed in which you perfect your spreadsheets, to the upgrade your resume can get by learning SQL.

She was taught the importance of always learning, and works hard daily to help others, like you, meet your goals.

Enroll Now, because Change Matters, Growth Matters.


Ready to start learning?
Take This Course