powered by
Center for Curriculum and Transfer Articulation
AS/400 Query/400
Course: CIS142

First Term: 1999 Fall
 Lec + Lab   1 Credit(s)   2 Period(s)   1.7 Load  
Subject Type: Occupational
Load Formula: S


Description: Using IBM`s AS/400 mid-range computer and Query/400, an IBM- licensed program, to produce reports and other data files by selecting, arranging, and analyzing database files defined on the AS/400



MCCCD Official Course Competencies
1. Describe the functions of Query/400. (I)
2. Create, run, and save a Query definition. (I)
3. Produce a report by selecting and sequencing fields. (II)
4. Create new fields based on existing fields in a selected file. (II)
5. Create a report and resequence the output. (II)
6. Select records for a report using logical conditions. (II)
7. Prepare a report using report summary functions. (II)
8. Describe the purpose of report breaks. (II)
9. Create a report using multiple report breaks. (II)
10. Create a report using variables with report break text. (II)
11. Prepare a report changing the spacing between columns, specifying column headings, and changing the output field lengths. (II)
12. Format a report for the printer. (II)
13. Create a database as output. (II)
14. Create a query using more than one file in the query definition. (III)
15. Join existing files into a relation and create a report. (III)
MCCCD Official Course Competencies must be coordinated with the content outline so that each major point in the outline serves one or more competencies. MCCCD faculty retains authority in determining the pedagogical approach, methodology, content sequencing, and assessment metrics for student work. Please see individual course syllabi for additional information, including specific course requirements.
 
MCCCD Official Course Outline
I. Using Query/400
   A. Software and its functions
   B. Creating, running, and saving a query definition
II. Producing reports using Query/400
   A. Selecting and sequencing fields
   B. Defining result fields
   C. Controlling the sequence of output
   D. Selecting records using logical conditions
   E. Using summary functions
   F. Using report breaks
   G. Formatting columnar reports
   H. Selecting output type and form
   I. Printing a report
III. Creating file relationships
   A. Using more than one file in a Query definition
   B. Joining files into a relation
 
MCCCD Governing Board Approval Date:  6/22/1999

All information published is subject to change without notice. Every effort has been made to ensure the accuracy of information presented, but based on the dynamic nature of the curricular process, course and program information is subject to change in order to reflect the most current information available.