Intermediate FoxPro for Windows

The purpose of this course is to expand upon your ability to use Foxpro for Windows in your day to day microcomputer work. The course covers those features which enable the participant to create a menu-driven application for the his or her own convenience or that of others. This text is divided into five main sections including the creation of screen programs, multiple relations, query files, menu programs, and project applications. The features used include the Screen Builder, View mode, RQBE, SQL, and the Project Manager. This 2 day course is intended for those who have taken the Introductory course, or who have experience working with FoxPro on a day to day basis. The class exercises provide "hands-on" experience in using the FoxPro commands. More than 70% of class time is hands-on use of FoxPro for Windows.



By the end of the program participants should:

1 Create a customized data entry and editing screen program


2 Be familiar with the View mode and its use


3 Construct relations: many to one, and one to many


4 Use the Relational Query By Example mode


5 Report on more than one file simultaneously





Table of Contents

The course booklet is used to facilitate a logical sequence of discussion of the terminology, concepts, and practical applications of FoxPro. Consult the manufacturer's documentation for specific

FoxPro commands.

Intermediate FoxPro 1

Objectives 1

10 Main Functions of a DBMS 2

File Extensions 3

FoxPro's Amazing Browse 4

Menu System 5

HELP Mode Menus 6

Expression Builder 7

Number Crunching 8

STORE Data in Memory 8

Fancy Editing Screens 9

Creating a custom Screen Format 10

View Mode 15

One-To-Many Relations 18

Complex Multi-Relations 20

Multi-File Reports 22

Relational Query By Example 25

Project Manager 29

Query Files 30

Users Groups / Magazines/ Books 31

Working With FoxPro 31

FoxPro Commands 32

FoxPro File Extensions 33

Sample File 34