MP9002: Desktop Computing - Expressions and Queries > Access 2007 Advanced

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. 

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

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

Duration:
3 Hours