Advanced User Training
(2 Hours) Covers advanced functionality for power-users and designers of non-standard reports. Expands upon use of job-function-based templates, modifying existing pivot tables using MSQuery, and utilizing SQL and dBase expressions to fine-tune query contents.
Topics Covered
Pivot Tables:
- Date Grouping
- Numeric Grouping
- Grouping on Field Contents
- Sum, Avg, Count in Data Area
- Drilldown Preferences
- Customizing Reports
- Building Report Workbooks
- Transferring Reports to Others
- MSQuery Features
- Adding Fields
- Using Expressions
- Selection Criteria
MasterMine Interface:
- Modify SQL Query
- Preferences
- Report Builder Toolkit
- Database Manager's Toolkit
- Sales Manager's Toolkit
- Reference Manual Topics
VAR Training Bonus:
- Marketing Support Options
- Customization Support
< back to training topics