Visit our new web pages

We have launched a new extended set of web pages at www.alvechurchdata.co.uk. These old pages will stay on the server because people still have links to them but they will not be updated.

The new version of this page is at www.alvechurchdata.co.uk/services/adtfox.html.

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 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
    • 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 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 course for staff who are experienced users of FoxPro or programmers in another language and who are beginning 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.


Hints & tips

The textbox class in Visual FoxPro 9 has a new Autocomplete property which shows the user the previous values that have been entered in that textbox.
Autocomplete in VFP 9

Your Access database will look more impressive if you add custom toolbars...
Custom toolbars

FoxPro has always had functions to read and write files at a low level...
Foxpro low level file functions

More...
More pages of hints and tips for users of Microsoft FoxPro and Access databases.

Site Map