Welcome to this Microsoft Access SQL course on Udemy.com

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

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.

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

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

Learn to use aliases to temporarily rename a column heading

The SQL used in this section.

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

The WHERE clause is in SQL used to filter records

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

Learn additional ways to filter records in SQL

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

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

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

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

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

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

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

Examples of the SQL SUM function

Examples of the SQL AVERAGE function

Examples of the SQL COUNT function

Examples of the SQL MIN and MAX functions

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

Examples of the SQL DATE function

Example of the SQL NOW function

Example of the SQL DAY function

Example of the SQL MonthName function

Examples of the SQL DatePart function

Examples of the SQL DateAdd function

Examples of the SQL DateDiff function

Examples of the SQL DateValue function

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

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

Learn how to bring fields together using SQL

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

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

Extract characters from a character string in SQL

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

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

Replace characters with other characters

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

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

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

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

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

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

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.

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

Learn to use EXISTS

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

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

Learn about INNER JOINS and OUTER JOINS

Learn the SQL syntax for creating Joins

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

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

Learn to use aliases to temporarily rename tables

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

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

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

Get familiar with different data types

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

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

Examples of how to insert data into those tables using SQL

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

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

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

In SQL, use DISTINCT to return only distinct values.

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

Learn how to combine like SELECT queries with UNION.

The SQL used in this section.

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

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

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.

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.