SQL for Microsoft Access
Share This Class:
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.
- 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