Visual FoxPro Database Training

Database training courses cover Microsoft Visual FoxPro from VFP 3 to VFP 9. There is no fixed syllabus, each course is designed to suit the needs of your delegates, their level of knowledge at the start of the course and the level they need to achieve.

The outlines below are typical choices for three different types of delegate. We can run these courses as one-to-one tutorials, as workshops for small groups, or as formal classroom lessons for larger groups.

We provide free telephone and email support to delegates for three months after the end of the course.

Introductory courses

Introductory course for staff who need to be able to use existing FoxPro databases for data entry and for simple search and reporting tasks.

• Database concepts
• Dbf, fpt, and cdx files; copying files and making backups
• Using FoxPro with keyboard and mouse; Menu and Windows
• Browse command; Memo fields
• Searching for data; Viewing a selection of records
• Adding and changing data
• Deleting records
• Queries with the Designer and with SQL code
• Designing and printing reports
• Putting it all together in simple programs

Intermediate programming courses

Intermediate course for staff who are experienced users of FoxPro and who have responsibility for the reliable and accurate storage and retrieval of information.

• Designing a database; Relational concepts
• Concatenated indexes; Multiple index expressions
• Reporting from several databases; Groups and subtotals
• Using SQL with cross tabs and subqueries
• Copying data between Fox and other programs
• Using the Menu Generator
• Designing and running a form

Advanced programming courses

Advanced course for staff who are experienced users of FoxPro or are programmers in another language and who need to be able to develop complete database systems.

• New features, Compatibility
• Creating a database, Index keys, Integrity, Validation, Data buffering
• Form and Control Properties, Data environment
• Classes; Properties, Events, and Methods; Base Classes
• Objects; Inheritance, Encapsulation
• Container objects; Page Frames; Grid controls
• Changing properties and running methods from code
• Types of classes; Class Libraries; Using classes in code
• Objects in program code; Protected properties and methods
• Naming conventions

Earlier versions

We have been working with the FoxPro family for fifteen years and are still supporting databases which were written in Fox 2.00 for DOS and Fox 2.6 for Windows. If you are migrating from one of these legacy versions to Visual FoxPro then ask about a conversion course.

Call us now

Contact us if you are thinking of using a Visual FoxPro database or if you would like to make better use of your existing FoxPro or Visual FoxPro database.

Phone us on 0121 445 1300 or 07850 274902, email sales@alvechurchdata.co.uk, or get full details from our address page.