SQL for Microsoft Access

.

44

LESSONS

ALL

SKILL LEVEL

4:27 hr

DURATION

ENGLISH

AUDIO

ENG

SUBTITLES

OVERVIEW

This course covers how to write more advanced queries in Microsoft Access, which are portable into SQL Server and Access, to help you build better databases.

On completion, you will know all six clauses of the SELECT statement, add functions and formulas into your code, do basic and advanced JOINs, and create UNION queries.

.

WHO IS THE COURSE FOR?

This course is for those who want to develop Microsoft Access skills by learning how to code SQL queries, and who want to create more advanced queries in Access.

The course will use the latest version of Access but is suitable for any modern version: 2007, 2010, 2013, 2016 or 365.

.

LEARNING PATH

START WITH SQL

  • A basic SELECT statement, using the SELECT and FROM clauses.
  • Adding a WHERE clause.
  • Summarising data with a GROUP BY clause.
  • Adding a HAVING clause.
  • Using the ORDER BY clause.

ADDING FUNCTIONS AND FORMULAS

  • GROUP BY – Adding Aggregating functions.
  • Using Aliases.
  • Using WHERE on Text fields.
  • Using WHERE on NULLs.
  • Using WHERE on Date fields.
  • Date/Time Functions.
  • Maths and Text Functions.
  • Conditional functions.

ADDING ADDITIONAL TABLES

  • Where can you use SQL statements?
  • Adding a second table.
  • Different types of JOINs.
  • Writing a JOIN query.
  • Inequality Joins.
  • Adding a third table.
  • Sub-forms and sub-reports.

FIND MISSING DATA. DELETE AND UPDATE DATA

  • Missing data.
  • Creating a Make Table query.
  • Inserting, deleting and updating data.

MORE ADVANCED QUERIES

  • Adding DISTINCT and TOP in the SELECT clause
  • Using derived tables, subqueries and correlated queries
  • Creating a cross-query and using UNION
  • Adding parameters

IMPORTING DATA FROM SQL SERVER

  • Importing or Linking data – Tables.
  • Creating a Pass-Through query.

REVIEWS

“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.” Omarwyn

“As a beginner to Access and SQL, this was an excellent start on the basics and how to proceed outside of Access. Class was easy to follow and clear.” Jenifer

“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.” Felton

.