After completing this course, the student should be able to:
 

	Understand the basic concepts of QMF
	Control columns, summary information and headings for your reports
	Employ a variety of formatting techniques in reports

QMF Overview
Presents an overview of concepts pertaining to relational databases and QMF. Describes the tables used in the course.
 

	Relational Concepts  based on a relational model.  Components of relational tables.
	Courses Tables Data found in the tables used in the course.
	QMF Concepts Purpose of QMF.  QMF's Home panel and User Profile panel.  Use of the SHOW and RESET QUERY commands.  The END operation within QMF.

Formatting with QMF
Discusses concepts about report formatting within QMF.  Describes methods to reformat reports using QMF's default form and other forms.
 

	Report Elements Five elements involved with building a report within QMF.  Purpose of QMF's default form.  Accessing the default form from the Report panel.  Redisplaying a report.
	Controlling Columns The SEQ column to resequence the report.  The EDIT column to change the printing of column values.  The WIDTH column to change column width.  The INDENT column to change the spacing between printed items.  Stacking a column title.  Changing default DATE and TIME edit columns.
	Controlling Summary Information The USAGE column for additional formatting features.  The BREAKn option to establish a control break.  The GROUP option to provide summary information within specified groups.  The OMIT option to leave a column out of any grouping.  The ACROSS option to print summary information across the page.
	Controlling Headings The OUTLINE option to indicate printing of repeated column values.  The FOOTING option to print supplemental text when control breaks occur.  The PAGE HEADING and PAGE FOOTING options to place text at the top and bottom of each page.  The FINAL option to place a text line at the end of the report.  The SHOW command to display additional panels.
	Other Form Panels Use of these panels: FORM.COLUMNS, FORM.OPTIONS, FORM.PAGE, FORM.FINAL, FORM.BREAKn and FORM.CALC.

Additional Formatting Techniques
Identifies formatting considerations with USAGE options, control breaks and multiple lines of text.  Describes in more detail three Form panels.
 

	USAGE Options Creating a final aggregated value with AVERAGE, COUNT, FIRST, LAST, MAXIMUM, MINIMUM, STDEV and SUM USAGE options.  Changing detail lines of a report with PCT, CPCT and CSUM USAGE options.  Key points when using aggregating USAGE codes.
	Percentages with Control Breaks The CPCT function with control breaks.  Percentage options (TPCT and TCPCT) that apply to control breaks.
	Creating Multiple Control Breaks Creating and interpreting a report with two levels of control breaks.
	Creating Multi-line Text Creating several lines of text for page headings, page footings, control break text and final text via the LINE, ALIGN and TEXT fields.
	FORM.PAGE, FORM.FINAL, FORM.BREAKn Other Fields on FORM.PAGE,    FORM.FINAL and FORM.BREAKn.  Variables available on FORM.FINAL and FORM.BREAKn.  Accessing additional FORM.BREAK panels.