SQL for Microsoft Access

44

Lessons

All

Skill Level

4:27h

course Duration

English

Audio

Eng

Subtitles

Share This Class:

Overview

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?

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.

Completing this course will help you:

Who is the course for?

This course is for you if you want to develop your Microsoft Access skills by learning how to code SQL queries.

This course is for you if you want to create more advanced queries in Access.

This course will use the latest version of Access, but is ideal for you if you use any modern version – Access 2007, 2010, 2013, 2016 or 365.

This course is also for you if you use an older version of Microsoft Access, but want to learn the newer versions.

Learning Path

  • 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
  • Adding some order – using the ORDER BY clause
  • 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
  • Where can you use SQL statements?
  • Adding a second table
  • Different types of JOINs
  • Writing a JOIN query
  • Inequality Joins
  • Adding a third table
  • Do I need complicated JOINs? Subforms and subreports
 
  • Missing data
  • Creating a Make Table query
  • Inserting data
  • Deleting data
  • Updating data
 
  • Importing or Linking data – Tables
  • Creating a Pass-Through query
 
We’ll will now be creating sub-queries, working through objectives 7b-e of the exam 70-461. We’ll be created correlated subqueries, where the results of the subquery depend on the main query. We’ll be looking at Common Table Expressions using the WITH statement, and we’ll be using what we have learned to solve a common business problem.

We’ll be looking at functions (objective 14), including the three different types of User Defined Functions (UDF): scalar functions, inline table functions, and multi-statement table functions. We’ll then complete objective 6 by looking at synonyms and dynamic SQL, and objective 8 by looking at the use of GUIDs. We’ll also look at sequences.

We’ll have a look at XML. Finally, for SQL Server 2016 and later (exam 70-761), we’ll examine JSON and Temporal Tables.

What people are saying

Are You Ready To Start?

More Courses

You might also be interested in these courses

Database Fundamentals in 8 hours

Learning Database Fundamentals with Microsoft SQL Server

Database Fundamentals in 8 hours

View Course

Microsoft SQL Server Reporting Services

Learn to create reports in SSRS

SQL Server Reporting Services

Learn how to create reports in SSRS
View Course