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:(2439) Scripting Microsoft Windows Management Instrumentation - 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
Course:(6067) Developing Native Applications for Microsoft Windows Mobile 6 - 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
Course:(2088) Designing a Highly Available Web Infrastructure (IIS) - 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:(F1008) Developer Reskilling: Visual FoxPro to Visual Basic - 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:(F1002) Visual FoxPro 6.0 Enterprise - 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
Course:(7197) Managing Enterprise Desktops Using the Microsoft Desktop Optimization Pack - Microsoft Training Courses in London and South West
Course:(2433) Microsoft Visual Basic Scripting Edition and Microsoft Windows Script Host Essentials - 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

Developer Reskilling: Visual FoxPro to Visual Basic
(Microsoft Training Course: F1008) - 4 days - £2100 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
THIS COURSE HAS NOW RETIRED. PLEASE SEE THE SUPPLEMENTARY INFORMATION FOR DETAILS OF ALTERNATIVE COURSES.
This course provides experienced Visual FoxPro developers with a fast track reskilling route to get them up and running in Microsoft Visual Basic programming.
> Course outline
  1. Similarities Between the VFP and VB Environment
  2. Using Forms
  3. Building Controls
  4. Using Wizards
  5. Introduction to Data Access
  6. Introduction to Data Handling
  7. Advanced Data Handling
  8. Using Variables
  9. Elementary Programming Techniques
  10. Build Menu Structures for Applications
  11. Error-handling
  12. Using Report Writers
  13. Advanced Report Writing
  14. Design Queries
  15. SQL Commands
  16. Using Object-Centred Programming
  17. The Component Object Model
Supplementary Information This course has now retired and is no longer available. However, we can generate a similar course, customised to client needs, for more than two people. Please call for details.
Module 1: Similarities Between the VFP and VB Environment
  • Establishing common VB/VFP functionality
  • Comparing and contrasting VB and VFP design-time environments
  • Customising the VB and VFP menu structures
  • Setting Toolbar options
  • Adding Toolbox tabs
  • Using right-mouse functionality
  • Setting properties using the Properties Window
  • Adding multiple projects to the current VB session
top
Module 2: Using Forms
  • Investigating VB and VFP forms' properties and methods
  • Using the VB Form Layout window Comparing effective custom interfaces in VB and VFP using standard and custom controls
  • Designing MDI applications
  • Using the Forms collection to control your application
top
Module 3: Building Controls
  • Using custom controls to enhance your application
  • Deploying the Windows common controls to provide project enhancements
  • Building a simple spinner control project
  • Compiling an OCX control project
top
Module 4: Using Wizards
  • Using the Application Wizard to create SDI and MDI applications
  • Incorporating the Data Form Wizard to add complex data forms to your application
  • Utilising the Class Builder to provide an object model for your application
  • Running the ActiveX Document Wizard to migrate forms in your application to ActiveX Documents
top
Module 5: Introduction to Data Access
  • Investigating VB and VFP's data access options
  • Understanding the different data object library structures
  • Defining the optimal mechanism for data access
top
Module 6: Introduction to Data Handling
  • Contrasting visual methods (VFP's Data Environment) versus VB's data environment
  • Manipulating the Data Control
  • Using VB and VFP data-bound controls to create and display local Recordsets and remote Resultsets
  • Comparing VB and VFP Grids
  • Employing SQL to group and filter data rows
top
Module 7: Advanced Data Handling
  • Building ODBC data sources using the ODBC Data Source Administrator
  • Employing the UserConnection designer
  • Creating Connection strings for remote data access
  • Building ActiveX data handling objects
  • Investigating data object library events
  • Understanding multi-user concurrency issues
  • Controlling Data Access
  • Customising Locking
  • Using Transaction Management
  • Understanding Transaction Logging issues
top
Module 8: Using Variables
  • Investigating the system data types
  • Comparing and contrasting VB and VFP variables
  • Understanding the scope of variables in VB
  • Using variable naming conventions
top
Module 9: Elementary Programming Techniques
  • Saving and running programs
  • Using in-line comments for documenting code
  • Contrasting procedural and event-driven coding processes
  • Developing code using conditional structures
  • Creating user-defined sub and function procedures
  • Using the Optional argument
top
Module 10: Build Menu Structures for Applications
  • Contrasting the VFP and VB Menu Editors
  • Defining Access keys for menus
  • Building Short-cut keys
  • Negotiating for toolbar positioning
  • Using Menu Control Arrays to simplify programming
  • Incorporating Clipboard functionality into a VB menu
top
Module 11: Error-handling
  • Avoiding logical and syntactical errors
  • Handling errors using the Err object's properties/methods
  • Tracking errors in the Debug (Immediate) window
  • Using Breakpoints and the Stop statement to step through code
  • Using the Watch window to track and change variable values
  • Check the Call Stack for currently executing procedures
top
Module 12: Using Report Writers
  • Using VB's data Reports to output simple data reports
  • Laying out the structure of a report page
  • Building multicolumn reports from ODBC data
top
Module 13: Advanced Report Writing
  • Incorporating computed columns
  • Using Aggregate functions
  • Working with Cross-Tab reports
top
Module 14: Design Queries
  • Using the DAO 3.51 object library
  • Programming the ADO 2.1 object library
top
Module 15: SQL Commands
  • Investigate the SELECT statement
  • Creating a database
  • Using the CREATE/ALTER TABLE statement
  • Building an index with the CREATE INDEX statement
  • Understanding join types: Inner, Outer and Self Joins
  • Carrying out multi-table joins
  • Using an append query - INSERT INTO
  • Updating data rows with the UPDATE statement
  • Deleting data rows using the DELETE statement
top
Module 16: Using Object-Centred Programming
  • Using Object-Centred Programming
  • The Component Object Model (COM)
  • Creating objects with user-defined properties and methods
  • Raising events from the ActiveX Server to the Client
  • Using the VB Class Builder to create user-defined properties, events and methods
  • Building an ActiveX Code Component to open local Jet databases
  • Extending the ActiveX Code Component to open remote data sources
  • Developing the ActiveX Code Component to return resultsets
  • Using the ActiveX Code Component to modify data
top
Module 17: The Component Object Model
  • Understanding the underlying structure of ActiveX objects
  • Investigating common interfaces (Unknown, Dispatch)
  • Designing Polymorphic interfaces
  • Building Dual interfaces
  • Using Aggregation in place of Implementation Inheritance
top
> Pre-Requisites
Before attending this course, students must have the following pre-requisites:
  • Knowledge and practical experience of developing systems using Visual FoxPro.
> Purpose
The overall aim of the course is to provide the delegate with the skills, experience, and knowledge to program effectively within Visual Basic 6, using the existing knowledge they have gained in Visual FoxPro. The course concentrates on differences between the products and gives practical advice on the best methodologies and approach to use when developing in VB 6. The course combines the Microsoft Mastering CD series and F1’s developed courseware to provide a course that is fine-tuned to the needs of VFP developers.
> Supplementary Information
This course has now retired and is no longer available. However, we can generate a similar course, customised to client needs, for more than two people. Please call for details.
> EXAMS
There are no exams directly associated with this course