SQL for Microsoft Access course - sample video (Subqueries in the Where clause)

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?

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.