AS/400 Query for Users (Audio Training)

Course Description:
AS/400 Query for Users is a self-paced audiocassette course providing comprehensive, practical training in the many facets of Query and the fundamentals of report writing.

Time required: Approximately 10 hours

When you have completed of this course, you will be able to:
   • Select a specific file to be queried
   • Perform record and field selection as well as record and field sequencing
   • Format the report using system-defined and user-defined specifications
   • Create report breaks based on the value of a field
   • Produce detail and summary reports
   • Create a simple query that joins two files
   • Create and use result fields

Audience: Users, Operators, Programmers

Prerequisites: Workstation Operations

Course Outline:
   Basic AS/400 File Concepts
   Query Processing Cycle
   Formatting Reports
     Report and Column Headings
     Field Edit Codes
     Edit Words
     Selecting Fields
     Sequencing the Report Columns
     Omitting Fields
     Footers
     User-defined Headings
   Data Selection and Sorting
     Selecting Specific Records
     Sorting Report Information
   Computation Fields
     Defining Computation Fields
     Add, Subtract, Multiply, and Divide
     Computation Field Headings
     Batch Processing
   Summary Reports
     Totals and Subtotals
     Averaging Functions
     Report Breaks
   Managing and Printing Reports
     Executing Query Programs
     Displaying Reports on the Workstation
     Changing and Deleting Query
     Programs
     Displaying the Layout of a Query
   File Chaining
     Query Program Maintenance
     Renaming Query Programs
     Copying Query Programs
     Security
   Merging Query Within a Document
     Direct Merge
   Help Support

Course Details:

Level:	Intermediate
Subject:	Query
Length:	10 hrs.
Materials:	Six audiocassettes; Student text; Workbook; Interactive media
Publisher:	ATS
Publish Date:	June 1998