Visual FoxPro 6.0 Enterprise
(Microsoft Training Course: F1002) - 3 days - £1700 exc VAT

> Target Audience
This course is intended for Visual FoxPro developers who wish to create and distribute mission-critical or enterprise applications.
> Course outline
  1. Local Views
  2. Remote Views
  3. Offline Views
  4. Error Handling
  5. Use Object-oriented Programming Commands and Functions
  6. Visual Classes
  7. Use Visual Classes
  8. Component Gallery
  9. OLE with VFP
  10. VFP as an OLE Client
  11. ActiveX (OCX) Controls
  12. VFP as an OLE Server
  13. Dynamic-Link Libraries
  14. WWW
  15. Creating & Distributing Executables
  16. Compiling Help
  17. Visual SourceSafe
  18. Windows 98 Compliance
  19. Tips Tricks and Techniques

Module 1: Local Views
  • Create Local Views
  • Know when and how to use Local Views
  • Update with Local Views
Module 2: Remote Views
  • Define the term client/server
  • Create an ODBC Connection to a Remote Access Data Source
  • Create Remote Views
  • Use and understand the importance of parameterized views
  • Specify Update Criteria for Remote Views
  • Specify Database Container Properties for Remote Views
  • Use SQL pass-through commands to: view local and remote data; manage connections; retrieve, update, delete, and insert data on a server.
Module 3: Offline Views
  • Know when and how to use Offline Views
Module 4: Error Handling
  • Handle errors locally
  • Create an application error handler
Module 5: Use Object-oriented Programming Commands and Functions
  • Explain and use the CREATE CLASS and DEFINE CLASS (Add Object clause) commands
  • Use the CREATEOBJECT() function and ADDOBJECT() method
Module 6: Visual Classes
  • Define and describe visual classes
  • Define and describe the container hierarchy
  • Describe the difference between base classes and subclasses
  • Explain how subclassing works
  • Create classes and subclasses
  • Create reusable classes
  • Create class libraries
  • Map data types and fields to classes
Module 7: Use Visual Classes
  • Creating Visual Classes from Form Objects
  • Creating Visual Classes in the Class Designer
  • Using Visual Classes in the Form Designer
  • Overriding inherited Properties and Methods
  • Protect Properties and Methods
  • Understand Manager Classes
  • Use Access and Assign methods
Module 8: Component Gallery
  • Use the login component
  • Use the Splash screen component
  • Add categories and lists
Module 9: OLE with VFP
  • Recognise the features of insertable OLE objects: linking and embedding, automation, visual editing, and drag and drop
  • Use an OLE Object in a Form
Module 10: VFP as an OLE Client
  • Define and describe the features and benefits of OLE Automation
  • Use Visual FoxPro to Control Microsoft Word
  • Use Visual FoxPro to Control Microsoft Excel
Module 11: ActiveX (OCX) Controls
  • Use ActiveX controls in a Form
  • Use progress bars, sliders and outline controls
  • Use the Rich Textbox control
  • Use the Multimedia control
  • Subclass ActiveX controls
Module 12: VFP as an OLE Server
  • Control VFP from other applications
  • Build a standalone VFP OLE Server
Module 13: Dynamic-Link Libraries
  • Describe the purpose and benefits of DLLs
  • Declare and use a DLL in Visual FoxPro
  • Pass a NULL pointer to a DLL procedure
  • Describe the difference between ByVal and ByRef
  • Use an alias and use handles
Module 14: WWW
  • Use the Web Wizard to create HTML pages
Module 15: Creating & Distributing Executables
  • Build the Executable
  • Use the Setup Wizard
  • Distribute OCX controls
Module 16: Compiling Help
  • Select a help system
  • Use a Windows Help system
  • Use an HTML Help system
  • Use fonts and styles
  • Use graphics
  • Use Context Jumps
Module 17: Visual SourceSafe
  • Add Projects to SourceSafe Control
  • Check files In and Out
  • Understand the consequences of checking in and out
  • Track changes
  • Roll Back to a previous Version
Module 18: Windows 98 Compliance
  • Understand the rules for compliance
  • Use Win95 UI styles and guidelines
Module 19: Tips Tricks and Techniques
  • Uncover Useful Miscellaneous features
  • Get ahead with Hot Performance Hints
> Pre-Requisites
Before attending this course, students must have the following pre-requisites:
  • A working knowledge of Windows, Microsoft Visual FoxPro and good practical experience with the xBase language.
  • Knowledge of relational database design concepts.
  • Attendance on F1 Course F1001 Visual FoxPro 6.0 Intensive is recommended.
> Purpose
At the end of the course, students will be able to develop multi-user systems, apply object-oriented programming concepts to VFP and take advantage of its functionality; utilise the core commands and functions of OOP, create classes and subclasses; develop forms with additional functionality, add methods to control a grid; manage and control data in multi-user situations; and use OLE with VFP, Word and Excel.