iSeries (AS/400) Query for Users

Now Released on Audio CD

Course Code: AQY1

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

Upon completion you'll 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.

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
Audience Both data processing and non-data processing personnel who require more information from the AS/400 using the Query tool. Prerequisites AS/400 Workstation Operations or keyboard familiarity	Format Self Study Interactive Materials 11 Audio CD's Student Text Workbook Interactive Software	Time Required Approximately 10 Hours Price £ 395