Maricopa Community Colleges  CIS142   19982-19995 
Official Course Description:   MCCCD Approval:  11/25/97  
CIS142      19982-19995 L+L 3 Credit(s) 4 Period(s)
AS/400 Query/400
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. Prerequisites: CIS122AB
 
Go to Competencies    Go to Outline
 
MCCCD Official Course Competencies:
 
CIS142   19982-19995 AS/400 Query/400
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)
Go to Description    Go to top of Competencies
 
MCCCD Official Course Outline:
 
CIS142   19982-19995 AS/400 Query/400
    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
        Go to Description    Go to top of Competencies    Go to top of Outline