A Small Class Size is the Best Learning Environment*
Only F1 has no more than 6 Delegates in a Class
Everyone has Individual Attention from the Trainer

View Recent History

Visual Studio 2005 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(8521) Microsoft CRM 3.0 Sales Management - Microsoft Training Courses in London and South West
Course:(8524) Microsoft CRM 3.0 Service Scheduling - Microsoft Training Courses in London and South West
Course:(4005) Beyond the Spreadsheet: Managing Financial Information Using Microsoft Office Access 2003 - Microsoft Training Courses in London and South West
Course:(8879) Using the Microsoft Dynamics Sure Step Methodology for Microsoft Dynamics CRM - Microsoft Training Courses in London and South West
Windows Server 2008 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(2381) Planning Collaborative Solutions With Microsoft Office XP Technologies - Microsoft Training Courses in London and South West
Course:(4006) Time and Task Management Using Microsoft Office Outlook 2003 - Microsoft Training Courses in London and South West
Course:(2018) Creating and Customizing Team Folders - Microsoft Training Courses in London and South West
Course:(8912) Customisation and Configuration in Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Course:(F1033) Fast Track to Microsoft Dynamics CRM 4.0 Certification: Become a CRM Developer in 5 Days Flat! - Microsoft Training Courses in London and South West
Course:(4002) Forecasting and Trend Analysis Using Microsoft Office Excel 2003 - Microsoft Training Courses in London and South West
Exchange Server 2010 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(80054) Project Managing Microsoft Dynamics CRM Implementations with Microsoft Dynamics Sure Step - Microsoft Training Courses in London and South West
Course:(F1034) Fast Track to Microsoft Dynamics CRM 4.0 Certification: Become a CRM Expert in 7 Days Flat! - Microsoft Training Courses in London and South West
Course:(F1023) What's New in Microsoft CRM 3.0 - Technical - Microsoft Training Courses in London and South West
Course:(80141) Integrating Microsoft Dynamics CRM 4.0 and Microsoft Office SharePoint Server 2007 - Microsoft Training Courses in London and South West
Course:(8911) Installation and Deployment in Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Course:(2657) Programming Microsoft Access 2002 - Microsoft Training Courses in London and South West
Course:(4003) Summarizing Microsoft Office Excel 2003 Data to Make Better Business Decisions - Microsoft Training Courses in London and South West
Course:(6066) Developing Managed Applications for Microsoft Windows Mobile 6 - Microsoft Training Courses in London and South West
Course:(80003) Workflow in Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Course:(8913) Applications in Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Course:(8529) Microsoft CRM 3.0 Administration - Microsoft Training Courses in London and South West
Visual Basic .NET Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(4008) Building Better Microsoft Office Word 2003 Documents in Less Time - Microsoft Training Courses in London and South West
Course:(2505) Deploying Microsoft Office XP - Microsoft Training Courses in London and South West
Course:(2015) Enabling Business Processes using XML Smart Documents and Smart Solutions within the Microsoft Office System - Microsoft Training Courses in London and South West
Course:(3087) First Look: Microsoft Windows Vista for Developers - Microsoft Training Courses in London and South West
Course:(F1024) What's New in Microsoft CRM 3.0 - Applications - Microsoft Training Courses in London and South West
Application Centre Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(2016) Bringing Data into Desktop Programs using the Microsoft Office 2003 Editions Research and Reference Technologies - Microsoft Training Courses in London and South West
Course:(8530) Microsoft CRM 3.0 Data Migration - Microsoft Training Courses in London and South West
Knowledge Management Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(2732) Planning Deploying and Managing an Enterprise Project Management Solution - Microsoft Training Courses in London and South West
Course:(8531) Extending Microsoft CRM 3.0 - Microsoft Training Courses in London and South West
Course:(F1029) Intermediate Microsoft Dynamics CRM 4 for Small and Medium Businesses - Microsoft Training Courses in London and South West
Course:(4004) Managing Critical Business Information Using Microsoft Office Access 2003 - Microsoft Training Courses in London and South West
Course:(8526) Microsoft CRM 3.0 Installation and Configuration - Microsoft Training Courses in London and South West
Visual Studio 6.0 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(8910) What's New in Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Visual Basic 6.0 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(F1032) Fast Track to Microsoft Dynamics CRM 4.0 Certification: Become a CRM Power User in 3 Days Flat! - Microsoft Training Courses in London and South West
Visual Studio 2010 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(8969) Extending Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Course:(8522) Microsoft CRM 3.0 Marketing Automation - Microsoft Training Courses in London and South West
Course:(F1004) FoxPro 2.6 Intensive - Microsoft Training Courses in London and South West
Course:(F1028) Introduction to Microsoft Dynamics CRM 4 for Small and Medium Businesses - Microsoft Training Courses in London and South West
Course:(F1037) Customisation of xRM/CRM for Microsoft Partners and Customers - Microsoft Training Courses in London and South West
Course:(8525) Microsoft CRM 3.0 Customization - Microsoft Training Courses in London and South West
Course:(4009) Setting Up Projects for Success Using Microsoft Office Project 2003 - Microsoft Training Courses in London and South West
Course:(2151) Microsoft Windows 2000 Network and Operating System Essentials - Microsoft Training Courses in London and South West
Course:(F1001) Visual FoxPro 6.0 Intensive - Microsoft Training Courses in London and South West
Course:(F1030) Advanced Microsoft Dynamics CRM 4 for Small and Medium Businesses - Microsoft Training Courses in London and South West
Course:(80047) Using Microsoft Dynamics Sure Step - Microsoft Training Courses in London and South West
Visual Studio .NET Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(80002) Administration in Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
indexes/Certification_courses_index.aspx Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(3373) First Look: Getting Started with Windows SharePoint Services 3.0 Hands-On Lab - Microsoft Training Courses in London and South West
Visual Studio 2008 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(5056) First Look: Windows Vista for IT Professionals - Microsoft Training Courses in London and South West
Course:(2052) Using Microsoft Visual Studio Tools for the Microsoft Office System - Microsoft Training Courses in London and South West
Course:(F1035) Fast Track to Microsoft Dynamics CRM 4.0 Certification: Become a CRM Guru in 10 Days Flat! - Microsoft Training Courses in London and South West

Compare Recently Viewed Course Dates


Exclusive
FoxPro

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

We currently do not have any dates scheduled for this course.
Please contact us to arrange a closed course for your company or add your details to courses in waiting.
(Remember F1 has smaller classes)
Ask a Question ?Print 2 Page PDF


> 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.
top
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.
top
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.
top
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.
top
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.
top
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.
top
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.
top
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.
top
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.
top
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.
top
Module 11: Database Design
  • Know how to eliminate duplicate entries
  • Eliminate duplicate relationships
  • Setting foreign and primary keys.
top
Module 12: Rushmore
  • Understand the way Rushmore works
  • Understand the use of Rushmore
  • Know how to set Rushmore on and off.
top
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.
top
Module 14: Wizards
  • What are Wizards?
  • Identify Wizards likely to be useful in application building
  • Use the Report, Form,Import, Documenting and Application Wizards.
top
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.
top
Module 16: Understand the Object Model
  • Define object-oriented programming
  • Discuss approaches to software design
  • Contrast procedural and object-oriented analysis.
top
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.
top
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.
top
Module 19: Component Gallery
  • Introduction to VFP visual classes
  • Navigate around the Component Gallery
  • Use components in an application
top
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.
top
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.
top
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.
top
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.
top
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.
top
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.
top
> 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.
> EXAMS
There are no exams directly associated with this course