Create complex reports including parameter fields and sub-reports. Use the Section Expert and objects to format complex reports. Write advanced formulas using variables, advanced functions, constructs and running totals. Work with advanced data access techniques and alerts. Create charts and maps within reports. This course is intended for students who are comfortable writing simple reports, but want to take a step beyond the basics.

You'll learn to:

1) Use parameter fields.
2) Create and use subreports.
3) Use the section expert.
4) Create formulas and functions using variables and constructs.
5) Use ODBC to access data.
6) Create SQL queries.
7) Create and modify report alerts.
8) Create charts and maps to represent data.