MP9003: Network and Database (General) - Basic Report Preparation > FOCUS

This course This course is for anyone who is interested in learning about basic report preparation using FOCUS. 

Topics:
Course Conventions and Databases
Starting a Simple Report
Printing Values
Creating Report Requests
Record Selection

Objectives:
Describe the various course conventions
Identify the screens used by the various course databases
Use the TABLE command to initiate report requests
Use the PRINT and LIST verbs to print the field values in report requests
Use the SUM, ADD, WRITE, and COUNT Verbs in report requests
Describe the basic sorting process of data
Explain the various printing techniques used for creating reports
Use the IF statement and WHERE clause to screen records
Explain the various uses of the WHERE clause

Duration:
3 Hours