Microsoft® Office Access 2007: Level 5 - Introduction to SQL in Access

Course Summary: Enhance your Access databases by using SQL in Access queries, form filters, and VBA code. This is an essential skill set for any Access Power User. 

Course Prerequisite: Due to the advanced nature of this course's content, we require students to have taken Access level 4 prior to enrolling. If you have any questions, feel free to contact us to discuss if this course is right for you.

Delivery Method: Instructor led, group-paced, hands-on classroom-training with activities. Additionally, manuals are provided for each student for after-class reference.

• Our standard class is currently taught using Access version 2007. Advanced Users on previous versions should not have difficulties navigating in this class since the SQL and VBA feature is easily accessible in all versions.
  
  
• Private Corporate training can be taught using either version.

Training Course Content

Lesson 1: SQL statements and advanced SQL queries

Create a query in design view and view the query in SQL view
Examine a few main clauses from a SQL Statement including FROM, ORDER BY, WHERE, HAVING, TOP
Write a SELECT query using SQL Language
Add the Order By clause to the SELECT query
Add a Where clause to the SELECT query
Use the where clause as a join

Lesson 2: SQL statements part II

Show the order of a subquery and the main query
Create a query using design view then copy the SQL code and use it as a subquery
Write a CREATE TABLE query using SQL Language
Write an INSERT query using SQL Language
Write an UPDATE query using SQL Language
Write a DELETE query using SQL Language

Lesson 3: SQL Only queries

Create a UNION & a UNION ALL query
Create a Pass-through query (if/when we install SQL Server on our network)

Lesson 4: SQL and its uses in forms & reports

Create a form in design view and update it’s record source using a SQL statement
Create a report in design view and update it’s record source using a SQL statement
Change the filter property of a report by adding a SQL statement to it
Change the filter property of a form by adding a SQL statement to it
Create a combo box or a list box and update the row source with a SQL statement

Lesson 5: SQL and its uses in VBA code

Create run queries from code
Create a filter for a form using sql
Create a filter for a report using sql

Lesson 6: Creating and using Recordsets in VBA code

Create and initialize a recordset object
Use the Find method of the object
Use the FindNext method of the object

Lesson 7: Advanced aggregate functions and advanced calculated fields in queries

Access 2007 Training Class Outlines:
Level 1 - Fundamentals
Level 2 - Intermediate
Level 3 - Advanced 1
Level 4 - Advanced 2
Level 5 - Access SQL and VBA
Levels 1 - 4 (PDF Document)

Microsoft Access 2003 Training Class Outlines:
Level 1 - Fundamentals
Level 2 - Intermediate
Level 3 - Advanced 1
Level 4 - Advanced 2
Level 5 - Access SQL and VBA
Levels 1 - 4 (PDF Document)