Report Generator Workshop - Course Overview

Course Objective

The purpose of this training is to assist you in carrying out the daily, weekly and monthly tasks performed within the workplace. It captures and addresses the pain points for these tasks whilst utilising the tools learnt throughout the Learning Journey.

At the end of this Learning Journey you will be able to accurately and successfully carry out the tasks covered in the Content list below:

 

Contents - Day 1

• Utilising & managing the Report Desktop Tool
• Reviewing Database Structures & relationships
• Reviewing the importance of Table Indexing
• Using the Drive Table Definition Tool to locate data
• Using the Spy Function to identify where data is held
• Setting Main Report Parameters
• Creating Tables in My Report
• Creating Simple Columnar Output
• Setting Sequence of Records Output
• Writing & reviewing Fixed & Variable selection criteria
• Creating Report Prompts

Contents - Day 2

• Relating data via Table Linking
• Creating Derived Columns
• Writing & understanding Ternaries
• Designing Sub total Headings
• Utilising the Drill down functionality
• Efficient reporting using the Options Tool
• Creating Pre-Defined functions
• Understand the purpose of Commands
• Check boxes & Radio Buttons
• Conditional Formatting
• Adding search Buttons/Notes/Remarks
• Saving & Loading Reports

Advanced Preparation

This course requires that delegates must attend Day 1 of the Report Generator Workshop, in order to continue with the second stage of the Learning Journey.

How to Book

For Training Subscription Plan customers, kindly contact customertraining@keyloop.com to enquire about availability of the respective workshops.

For non-Training Subscription Plan customers, kindly use the Contact form here to enquire about training workshop costs with our Sales Department.

Return to course list