COURSE OUTLINE:

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. 

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

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.

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

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. 

Errors & Debugging

• Understand the different types of error

• Use the Debug window to see current values
• 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

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.

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

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. 

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

Database Design

• Know how to eliminate duplicate entries

• Eliminate duplicate relationships
• Setting foreign and primary keys.

Rushmore

• Understand the way Rushmore works

• Understand the use of Rushmore
• Know how to set Rushmore on and off.

TOP

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. 

Wizards

• What are Wizards?

• Identify Wizards likely to be useful in application building
• Use the Report, Form,Import, Documenting and Application Wizards.

TOP

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. 

Understand the Object Model

• Define object-oriented programming

• Discuss approaches to software design
• Contrast procedural and object-oriented analysis. 

TOP

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.

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

Component Gallery

• Introduction to VFP visual classes

• Navigate around the Component Gallery
• Use components in an application

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

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.

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

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.

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

Debugging Forms

• Use the Debug and Trace features with Forms, Objects, Properties and Methods. 

TOP

PARTICULARS:

Cost:	£1650( € 2640) excluding VAT
Platform:	Windows NT
Numbers:	Maximum of 6 people on each course at F1’s training facilities in London, Bath and Manchester