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

	Understand the basic concepts of QMF
	Build queries with Prompted Query
	Construct QBE language queries

QMF Overview
Presents an overview of concepts pertaining to relational databases and QMF.
 

	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
	Procedures Creating, using and saving procedures.

Prompted Query - Overview
Describes general features of the Prompted Query facility.
 

	General Information Areas of the Prompted Query panel.  Use of the Cancel, Run and Print PF keys.  Function of the Report panel and use of the Query key.  The Windowed Help facility of Prompted Query.
	Commands Purpose and use of these Prompted Query commands: SHOW SQL, CHANGE, SAVE QUERY, CONVERT QUERY and SPECIFY.

Prompted Query - Tables
Discuses the panels provided in Prompted Query to process tables.
 

	Tables Dialog Panel Entering table names in the Tables dialog panel.  Ways to indicate partial table names.  Selecting table names from the Table List dialog panel.  Completing the Join Columns dialog panel.
	Multi-column Joins Definition of a multiple column join.  Adding a table to an existing query.  Completing the Join Tables dialog panel to select tables for joining.  Selecting columns to join tables on the Join Columns dialog panel.

Prompted Query - Rows & Columns
Discuses the panels provided in Prompted Query to process rows and columns.
 

	Specify Dialog Panel: Columns Viewing the Column Description panel.  Selecting columns on the Columns dialog panel.  Entering an expression on the Expression dialog panel.  Completing the Summary Functions dialog panel.  Selecting a column on the Summary Function Items dialog panel.
	Specify Dialog Panel: Row Conditions Selecting a column on the Row Conditions dialog panel.  Selecting a verb and a comparison on the Comparison Operators dialog panel.  Entering a value on the Equal To dialog panel.  Using substitution variables in an expression.  Connecting conditions on the Condition Connectors dialog panel.
	Specify Dialog Panel: Sort Completing the Order field on the Sort dialog panel.  Entering the Columns field on the Sort dialog panel.

Prompted Query - Practice
 

Query Simulation Building a query using the Prompted Query facility of QMF.

Using QBE
Describes how to use the QMF language Query-By-Example (QBE) to build queries and to update tables.
 

	General Information Methods to request a QBE query.  The areas of the QBE Query panel.  Use of the Run PF key.  Function of the Report panel.
	Queries with QBE The Draw and P. commands.  How to select and sort rows.  Entering and using conditions to limit the rows selected.  The method to join tables.  Creating blank target tables.  Enlarging and reducing the dimensions of QBE's graphic representation.
	Table Updates with QBE How to insert, update and delete rows.  Using a calculation to update a column.