Objectives

This three-day-session fills the need for a practical, short and well-documented course for QMF users.

The course describes the set-up of QMF, the existing objects and their manipulation. The different commands are explained and practised during the exercises.

The basic principles of the SQL language are illustrated in detail. Emphasis lies on the correct use of this language and certainly not on the writing of complex and (mostly) expensive queries.

The participant also learns to explain results in reports and to manipulate formats which are used in functional procedures. Finally the participants will get familiar with the Table Editor, being a skilful QMF tool for data management.

Main topics

• QMF:

basic principles • function • user profile

• Find (Retrieval) QUERY:

questions • database queries • illustration with 'Prompted Query'

• SQL:

simple queries • grouping • union and join • subquery • UPDATE • INSERT • DELETE

• QMF objects:

temporary and stored objects • SAVE DATA • use of personal tables

• QMF commands:

meaning • use • overview

• Reports and forms:

form panels overview • form adaptations • summary and cross reference report • form options

• Procedures:

description • set-up • use of variables