Visual FoxPro 6.0 Intensive
(Microsoft Training Course: F1001) - 5 days - £2640 exc VAT

> Target Audience
The course is designed for individuals who are new to Visual FoxPro and require an intensive introduction to the available functionality. Delegates may be users of existing database who need to build local departmental applications or reporting modules; members of a programming team planning to implement a large database application; or technical evaluators looking at the place of Visual FoxPro as part of an information strategy.
> Course outline
  1. Introducing Database Management Systems (DBMS)
  2. Introducing the Visual FoxPro Environment
  3. Introduction to Data Handling
  4. Using Variables
  5. Elementary Programming Techniques
  6. Errors & Debugging
  7. Report Writing
  8. Query Designer
  9. SQL Commands
  10. Creating Tables Using the Database Container
  11. Database Design
  12. Rushmore
  13. Implementing Validation in Database Container
  14. Wizards
  15. Understand the VFP View Window
  16. Understand the Object Model
  17. Object Oriented Programming
  18. Use Object-oriented Programming Commands and Functions
  19. Component Gallery
  20. Forms
  21. Properties, Events and Methods
  22. Understand Form Functionality
  23. Project and Menu Managers
  24. Work with the Grid
  25. Data Buffering and Multi-User Programming

Module 1: Introducing Database Management Systems (DBMS)
  • Introducing Database Management Systems (DBMS)
  • Be aware of basic Database Terminology
  • Understand the advantage of using a DBMS
  • Be aware of the Technical Features of Visual FoxPro.
Module 2: Introducing the Visual FoxPro Environment
  • Use the Menu structure
  • Understand the Toolbar
  • Use the Option window for changing system settings
  • Use the View Window
  • Use the Browse Window
  • Create and Change Indexes on a Table
  • Become familiar with the “Right Mouse”
  • Use the command window to set system configurations.
Module 3: Introduction to Data Handling
  • Understand the Browse window and Edit mode
  • Know how to LOCATE records
  • Set a Filter on a Table
  • Understand xBASE Syntax
  • Use xBASE Commands to process Data
  • Understand the Scope, For and While clauses
  • Perform Calculations on Table Data.
Module 4: Using Variables
  • Understand the data types of variables
  • Understand Public, Private & Local variables
  • Understand variable naming conventions
  • Assign values to variables
  • Display variables
  • Save and restore a set of variables
  • Use variables to write modular code
  • Use the EVALUATE function
  • Use macro substitution and referencing in command lines.
Module 5: Elementary Programming Techniques
  • Be Able to Create and Run Programs
  • Add Comments to a Program
  • Understand FoxPro Functions
  • Implement Structured Programming with Conditional and Iterative Code
  • Create Procedures that accept Parameters
  • Create User Defined Functions
  • Use a procedure file or library Call subroutines and control program flow.
Module 6: Errors & Debugging
  • Use the Debug window to suspend programs
  • Use the Trace window to follow program execution and suspend programs
  • Use the Watch window to amend variables
  • Use the Locals window to display and amend local variables
  • Use the Call Stack window to view currently executing programs
  • Use Event Tracking and Coverage Logging.
Module 7: Report Writing
  • Understand the use and limitations of Report Wizards
  • Understand the use of the Report Designer
  • Understand , manipulate and format Report Objects
  • Select Page Layout Options
  • Preview report output.
Module 8: Query Designer
  • Understand the use of the Query Designer
  • Know how to order a query
  • Be able to select data using the full range of selection options
  • Create multi table queries
  • Create calculated fields and use aggregate functions
  • Understand the SQL command structure
  • Be able to output queries to Graphs and Export Files.
Module 9: SQL Commands
  • Use the SELECT command
  • Understand the additional functionality not supported by the Query designer.
  • Use the CREATE TABLE command
  • Use the ALTER TABLE command
  • Use the INSERT INTO command
  • Use the SQL DELETE and UPDATE commands.
Module 10: Creating Tables Using the Database Container
  • Know the data sources that can be accessed by VFP
  • Understand the purpose of the Database Container
  • Know the Data Types available with VFP
  • Learn how to create a Table
  • Create Databases and add Tables
  • Set Indexes and understand their purpose
  • Understand the Relationship Types and create Relationships between tables.
Module 11: Database Design
  • Know how to eliminate duplicate entries
  • Eliminate duplicate relationships
  • Setting foreign and primary keys.
Module 12: Rushmore
  • Understand the way Rushmore works
  • Understand the use of Rushmore
  • Know how to set Rushmore on and off.
Module 13: Implementing Validation in Database Container
  • Understand the VFP View Windown Define Field Validations
  • Define Record Validations
  • Understand the purpose of and be able to define Stored Procedures
  • Use the Input Mask and Format properties.
Module 14: Wizards
  • What are Wizards?
  • Identify Wizards likely to be useful in application building
  • Use the Report, Form,Import, Documenting and Application Wizards.
Module 15: Understand the VFP View Window
  • Define Field Validations
  • Define Record Validations
  • Understand the purpose of and be able to define Stored Procedures
  • Use the Input Mask and Format properties.
Module 16: Understand the Object Model
  • Define object-oriented programming
  • Discuss approaches to software design
  • Contrast procedural and object-oriented analysis.
Module 17: Object Oriented Programming
  • Object Oriented Terminology
  • Referencing Objects with Variables
  • Set Propertiesn Call Methods
  • Understand Object Hierarchy
  • Create and Add Objects
  • Object Variable Naming Conventions.
Module 18: Use Object-oriented Programming Commands and Functions
  • Explain the function of the dot (.) and scope resolution (::) operators
  • Use the reference statements: THIS, THISFORM, THISFORMSET, and PARENT
  • Use the FUNC...ENDFUNC function
  • Use the PROC...ENDPROC procedure
  • Use the WITH...ENDWITH command
  • Use Read and Clear Events.
Module 19: Component Gallery
  • Introduction to VFP visual classes
  • Navigate around the Component Gallery
  • Use components in an application
Module 20: Forms
  • Understand the use of the Form Designer
  • Have a basic understanding of Properties, Events and Methods
  • Understand the purpose of and how to use the Data Environment
  • Know and use the Controls available from the Form Designer
  • Understand Form Properties
  • Create Table Navigation Buttons
  • Implement Private Data Sessions
  • Define HotKeys on a Form
  • Implement Form Specific Menus
  • Implement Right Click Functionality.
Module 21: Properties, Events and Methods
  • Be aware of the types of Base Classes
  • Understand Properties, Events, and Methods
  • Discuss the Event sequence for a Form
  • Understand the Event Model for a Form and its Controls
  • Implement Form and Control Methods
  • Create User Defined Properties and Methods.
Module 22: Understand Form Functionality
  • State the definitions of the data environment, cursor objects, and relation objects
  • Create and use data sessions and multiple data sessions
  • Create and use page frames
  • Create and use form sets
  • Run forms
  • Save a form as a class or a nonclass form
  • Explain run-time properties and design-time properties for forms
  • Set properties for forms
  • Use Form Wizards and Builders to create forms quickly.
Module 23: Project and Menu Managers
  • Understand the use of a Project Manager
  • Know the tasks Project Manager can perform and create a project
  • Know Standards and Naming Conventions
  • Be aware of Menu conventions and application structure
  • Be able to create appropriate Menus
  • Create Shortcut menus for Right Mouse clicks
  • Know how to compile an application.
Module 24: Work with the Grid
  • Define the term Grid and explain its use
  • Describe the structure of a Grid control
  • Add controls to Grid Columns
  • Create one to many Forms with a Grid
  • Use Conditional Formatting.
Module 25: Data Buffering and Multi-User Programming
  • Review VFP’s Shared Access and Data Locking
  • Understand Data Buffering and the different types of Buffering
  • Become familiar with the functions that support Data Buffering
  • Manage data conflicts
  • Understand Transaction Support and the commands that facilitate it.
> Pre-Requisites
Before attending this course, students must have the following pre-requisites:
  • Familiarity with Windows and database concepts.
> Purpose
The course introduces all the features and functionality of Visual FoxPro with an emphasis on the rapid implementation of database implementation including the use of Visual FoxPro as a front end to client-server or other data sources. An emphasis is placed on using the Visual Design Tools as much as possible and on the use of Visual Classes for rapid implementation of functionality. During the course the delegate will develop a complete application which pays attention to usability issues and conforms to Windows design guidelines.