| |
|
Query Manager Training (1 day)
Overview
This course is designed for users of the Empower-HR system
who need to quickly become proficient in creating and modifying queries.
Topics include navigating the Query Manager environment, running saved queries, manipulating query results,
creating and modifying a basic query, selecting records using standard and advanced filters,
summarizing data and
creating parameters. Advanced topics include drill-down queries, sub-queries and union queries.
This course uses training materials
developed by Management Information Systems(WA) Pty Ltd.
Who Should Attend?
People who want to learn about the Query Manager and leave the
course being able to create queries using both basic and advanced query
skills.
Prerequisites
Basic knowledge of the EmpowerHR application.
TOPICS COVERED
What is the Query Manager
QM Navigation
• Searching for Data Fields
• Data Display / Hiding
• Sorting Data
• Field Names
The Results Window
• Searching Query Results
• Sorting Results
• Displaying / Hiding Results
• Exporting Results
Displaying SQL
Query Tabs
• Data
• Filter
• Alerts
• Save
Running a Saved Query
Creating a Basic Query
• Query Tabs
• Data Field Issues
• Organisational Details
• Sub-Folder Structures
|
Intermediate Features
• Advanced Filters
• Creating Parameters
• Creating an Email List
• Calculated Fields
Advanced Features
• Drill-down Queries
• Sub-Queries
• Union Queries
Advanced Filter Operands
• Fields
• Literals
• Functions
Query Manager Security
• Application Security
• Folder and Query Security
• Organisational Security
Query Manager Administration
• Template Management
• Access Management
• Assigning Users to a Template
• Assigning Templates to Users
• Folder Management
|
Return
to top
|
|
