|
This course focuses on the use of VBA functions when creating queries, and examples of queries that use the four basic types of joins you can create in Microsoft Access 2007.
Objectives:
- Discuss the elements of expressions
- Use the Immediate window to test return values of VBA functions
- Describe the use of inner joins, outer joins, self-joins, and theta joins in queries
- Create crosstab queries using the Crosstab Query Wizard
Topics:
- Expressions, operators, literals, constants
- Working with functions
- Types of functions
- Creating expressions
- Using inner joins for multitable queries
- Using outer, self, and theta joins
- Creating crosstab queries
|
