Scheduled dates
No public dates scheduled yet
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 outline
Understanding SQL statements
- 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
Understanding SQL action queries
- 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 SQL only queries in Access
- Create a UNION & a UNION ALL query
SQL and its uses in forms & reports
- 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
Using SQL commands in VBA
- 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
Creating and using Recordsets in VBA code
- Create and initialize a Recordset object
- Use the Find and FindNext method of the object
- Loop through a Recordset object
Working with calculations in queries
- Create aggregate functions in queries
- Create calculated fields in queries