Access Level 5: SQL Usage in Access & VBA
Go straight to the source with SQL inside Access. Write SELECT and action queries by hand, drive forms and reports with SQL, and run it from VBA to build powerful, data-driven applications.
Scheduled dates
This course is available for private and onsite training - delivered for your team anywhere in the U.S., or virtually on your schedule. You can also ask us to add it to the public calendar, or let us know you’re interested and we’ll reach out when a date is set.
Course objective
Students will write SQL directly in Access, including SELECT and action queries, apply SQL in forms and reports, run SQL from VBA using recordsets, and build aggregate and calculated fields.
Prerequisites
To ensure your success, we recommend that you have experience with Access queries, forms, reports, and some exposure to VBA. Students can obtain this level of skill through our Access Level 1 through 4 courses. This course is technical since it involves SQL and VBA.
Course outline
- Create a query in design view
- Examine a few main clauses from a query
- 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
- Create a query using design view
- 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
- Create a UNION & a UNION ALL query
- Create a form/report and update its record source
- Change the filter property of a form or report
- Create a combo box or a list box
- Use the DoCmd.RunSQL method in VBA
- Create a filter for a form using SQL in VBA
- Create a filter for a report using SQL in VBA
- Create and initialize a Recordset object
- Use the Find and FindNext method of the object
- Loop through a Recordset object
- Create aggregate functions in queries
- Create calculated fields in queries