(<img height='1' width='1' border='0' src="http://www.googleadservices.com/pagead/conversion/1072619999/?value=1&label=Lead&script=0" />)
F1
About F1Course ScheduleOther ServicesSite MapContactHome

FoxPro Intensive Part I

Exchange Server
Office (inc Access)
SQL Server
Visual Studio .NET
Windows
Web Development
Visual FoxPro
Programming
Business
Knowledge Management
Certification
Learning Options
Reserve a Place
12 May London
02 Jun London
07 Jul London
04 Aug London
01 Sep London
06 Oct London
03 Nov London
01 Dec London
05 Jan London
02 Feb London
02 Feb London
02 Feb London
View Other Courses in Same Category

Module 1: Database Concepts

  • Understand the definition of a Database
  • Why use a Database
  • Understand the benefits of the FoxPro 2.6 Database Management System.
Top

Module 2: Use FoxPro Interactively

  • Understand the Menu layout
  • Be aware of the Command window
  • Use windows and dialogs
  • Understand the terms Database, Table, Record, Field, Index and Relation.
Top

Module 3: Configure FoxPro

  • Change the on/off settings
  • Change the file and directory locations
  • Change the International and Miscellaneous options
  • Save the current settings to a .VUE file
  • Restore settings from an existing .VUE file.
Top

Module 4: Datafile Basics

  • Datafile Management - Work Areas
  • The VIEW window
  • Open Tables in work areas
  • Select a particular Table.
Top

Module 5: View the Records in a Table

  • Use the Browse option to view and modify data
  • Modify the Browse layout to see selected fields
  • Use both Browse and Change displays.
Top

Module 6: Navigating a Table

  • Understand the record focus
  • Move to the next, previous, top, bottom or specified record
  • Search for one or more records matching specific criteria.
Top

Module 7: Datafile Analysis

  • Count the number of records in a table that match specific criteria
  • Summate or average values in tables
  • Carry out more calculations on tables, including finding maximum and minimum values.
Top

Module 8: Create and Use Indexes

  • Create simple ascending and descending indexes by modifying the record structure
  • Apply indexes to change the record order
  • Create complex indexes using the Modify index dialogue
  • Find and retrieve records using the index.
Top

Module 9: Create and Use Relations

  • Establish Relational links between tables
  • Use and test a One to Many relation
  • Use and test a Many to One relation.
Top

Module 10: Create Tables and Modify Tables

  • Set up a Database table structure
  • Set a Field list
  • Set a Filter
  • Know the Data Types and when to use them.
Top

Module 11: Create Reports with the Report Designer

  • Create simple reports using the Quick Report option
  • Understand and Modify report layouts
  • Move and align report objects
  • Use the Text tool, Field tool, Line and Box tools to enhance the design
  • Change Fonts and Font sizes and styles
  • Include calculated fields in the report
  • Add additional group or summary bands using memory variables in a report.
Top

Module 12: Output Reports

  • Preview report output
  • Send reports to a printer
  • Set printer options.
Top

Module 13: Use the Relational Query By Example

  • Select input information
  • Select output information
  • Sort information
  • Summarise information
  • Group information
  • Output to screens, reports or graphs
  • Link to datafiles
  • Using Multiple Related Databases.
Top

Module 14: Use the Application Generator

  • Walk through the steps in generating an application with the application generator
  • Run the application and be aware of the functions provided and interface issues
  • Understand its limitations, and how to enhance the application.
Top

Module 15: Use Wizards

  • Use Wizards to create tables, reports and screens
  • Understand the limitations of Wizards
  • Modify the result of the Wizard.
Top

Module 16: Elementary Programming Commands

  • The Xbase Command Language
  • System Configuration Commands
  • Setting the environment
  • Understand command syntax
  • Use the help screen
  • Use the command reference manual
Top

Module 17: Datafile Management Commands

  • Use the command line to manipulate databases
  • Write a program to set up the environment, open tables, set the index order and set relationships.
Top

Module 18: Use General Command Syntax

  • Use the SCOPE options
  • Use the FOR and WHILE clauses
  • Use field lists
  • Use Key words to modify a command.
Top

Module 19: Assign Memory Variables with the Store command

  • Use and know the different data types
  • Use variables in commands
  • Display the values stored in variables
  • Display FoxPro memory
  • Save sets of memory variables to a file using optional wildcards and clauses
  • Restore variables from a file.
Top

Module 20: FoxPro Functions

  • Use FoxPro Functions within FoxPro commands
  • Understand the additional scope and functionality available by using functions in commands.
Top

Module 21: FoxPro Expressions

  • Use the FoxPro expression builder to store complex expressions into variables
  • Use the EVALUATE function to make program commands more flexible
  • Use macro substitution as the ultimate tool
  • Use referencing to enable expressions to be used where names are expected in the command syntax.
Top

Module 22: The BROWSE Command

  • Use the browse command and key words to protect tables
  • Use key words to store browse formats so that they can be reused
  • Use field clauses to protect and validate fields
  • Include fields from other related tables
  • Use expressions to calculate or derive new columns in the Browse.
Top

Module 23: Use essential Programming Standards

  • Write programs using conditional and code structures (IF..ENDIF DO CASE..ENDCASE)
  • Write programs using iterative code structures (DO WHILE..ENDDO FOR..ENDFOR SCAN..ENDSCAN)
  • Use the Immediate IF function.
Top

Module 24: Procedures and Sub-routines

  • Understand the compile option
  • Store and run programs as .PRG text files
  • Store and run sub-routines using different options.
Top

Module 25: Pass Parameters into Programs

  • Pass parameters to programs and subroutines
  • Assign Public and Private Memory Variables
  • Be aware of modular coding techniques.
Top

Module 26: User Defined Functions

  • Write User Defined Functions (UDFs)
  • Use UDFs in FoxPro commands to extend FoxPro’s functionality
  • Change the parameter passing method for UDFs and procedures.
Top

Module 27: Using The Debug Tools

  • Use the Debug window to check the value of variables, fields or expressions
  • Set a breakpoint against a change in value
  • Use the Trace window to follow a programs execution or to see the command that has just caused a breakpoint
  • Set a breakpoint against a command line so that program execution suspends.
Top

Module 28: Use FoxDoc

  • Create formatted programs
  • Document program hierarchies, variable cross references etc.
Top

Module 29: Import and Export Data

  • Copy records to new tables
  • Copy records to different file formats
  • Limit the records & fields selected for import
  • Add records from other tables
  • Add records from different file formats
  • Limit the records & fields selected for export.
Top

Module 30: Program Screen Commands

  • Understand the commands used to program screen display and input
  • Use the Read command
  • Code a Simple Data Input screen
  • Use advanced GET and READ parameters
  • Define Windows with specified properties.
Top

Module 31: Use the Screen Designer

  • Create a data review screen using the quick screen option
  • Generate a screen program from the screen design.
Top

Module 32: Screen Controls and Screen Sets

  • Use a utility Toolbox to control screens Screen Sets
  • Screen controls
  • Push Buttons
  • Check Boxes
  • Radio Buttons
  • Popups.
Top

Module 33: Projects and Applications

  • Use the Project tool to aid development
  • Understand the different components of a project
  • Add elements to a project
  • Benefit from options stored with screens as part of a screen set
  • Build a Project.
Top

Module 34: Create Menus

  • Understand the commands to program menus
  • Use the Menu designer to generate Menu programs
  • Keyboard Short-cuts and Disabling Options
  • Integrating Menus With Procedures And Attaching Edit Screens.
Top

Module 35: Code Snippets & Event Driven Programming

  • Screen Events
  • Field Events
  • Read Events
  • Creating Standard User Entry Screens with PopUp Validation
  • Append and Delete Validation.
Top

Module 36: Advanced Screens

  • Screen Sets
  • Browse Window Control Of A Screen Set
  • Hand Coding Menus
  • Database Implementation
  • Use Of Entities, Relationships and Attributes
  • Include more than one data screen from related tables
  • Use Memory variables in data entry screens.
Top

Module 37: Database Design

  • System Overview
  • Entity Descriptions
  • Entity Relationships
  • Entity Modelling
  • Primary, Secondary and Foreign Keys
  • Additional Fields
  • Field Types
  • Eliminate Duplicate Entities
  • Eliminate Duplicate Relationships
  • Tidy the Diagram
  • Create the Database
  • Primary Index
  • Further Design Issues.
Top

Module 38: Rushmore Datafile Access

  • How Rushmore Changed The Way We Program
  • New Index Structures
  • Commands used with compound indexes
  • How Rushmore Works.
Top

Module 39: Query by Example - SQL

  • Queries using Multiple Related Databases
Top

Module 40: Project Management

  • Overview
  • User Requirement
  • Functional Specification
  • Database Design
  • Functional Design
  • Implementation
  • Distribution
  • Documentation
  • Support
  • Corporate Data Management.
Top

Module 41: Applications & Executable Files

  • The Controlling READ
  • Distribution Options
  • Generating Applications
  • Modify the properties of the FoxPro icon and add the name of the application file after the FOXPROW command.
Top

Module 42: Networking FoxPro

  • Configure FoxPro for multi-user applications
  • Programming Considerations
  • Understand FoxPro’s automatic locks
  • Consider the implications of multi-user systems and the requirement for optimistic or pessimistic locking
  • Use record locking and file locking functions and commands
  • Write a program using record locking techniques
  • Memory variables in screens.
Top

Module 43: Arrays

  • The Use of Arrays from within Screens
  • Relationships
  • One to Many Relationships
  • Cyclical Relationships.
Top

Module 44: Use the Screen Generator to Create Screens

  • Know when to use Push Buttons, Check Boxes, Radio Buttons, Popups, Lists and Spinners
  • Use the above devices and use options in the corresponding dialogues to modify their appearance and behaviour
  • Use text Edit regions for Memo or large Character fields
  • Use the Disable option to protect fields
  • Use the Say or Output form for read only fields
  • Avoid problems with saving the environment in a screen
  • Generate a data screen with a utility toolbar
  • Add generic functions to the toolbar.
Top

Module 45: Modify the Screen using the Layout Options

  • Specify a name and title for the window
  • Change the default window type to a Dialog window, an Alert window or a Desktop
  • Change the default window properties, e.g. the window may or may not Minimize, Float, have borders, Close etc.
  • Set the window font options
  • Set the window background colour or pattern.
Top

Module 46: Add code to validate fields

  • Add code to protect fields Add messages to appear in the status bar Add error messages to be displayed if field validation fails Code commands to be processed before the screen is written Code commands to be processed after the screen closes down Use popup validation for foreign keys.
Top

Module 47: Use Options to control the Screen Generator

  • Use options to include or exclude code for opening and closing tables, defining windows, releasing windows
  • Select options to change the READ clauses
  • Select options to choose platform independent code.
Top

Module 48: Use Event Driven Programming Techniques

  • Use the code snippets to handle specific events during the program
  • Understand the sequence of Field Events and Read Events.
Top

Module 49: Validate Data on Entry

  • Write routines to provide field level validation
  • Write routines to provide record level validation.
Top

Module 50: Append and Delete Validation

  • Create and use routines for adding and deleting records to maintain data integrity.
Top

Module 51: Error Handling

  • Trap Errors
  • Store information to aid error recovery or correction.
Top

Module 52: Help Options

  • Select Windows style or FoxPro style Help systems
  • Create a user defined help file
  • Code Context sensitive help
  • Use See Also lists in a Help topic.
Top

Module 53: Optimise Code

  • Understand Rushmore Datafile Access
  • Code commands to run with Optimised speed
  • Avoid expressions and clauses that will make a command Non Optimisable.
Top

Module 54: SQL Programming

  • Use the SELECT Command
  • Use options not available with RQBE
  • Optimize SQL Queries
  • Use the SQL INSERT command
  • Use the SQL CREATE TABLE command
  • Create and use temporary cursor files.
Top

Module 55: Use and Manipulate Arrays

  • Set up arrays
  • Fill arrays from tables, records, queries or assign individual elements
  • Use list and popup devices.
Top

Module 56: Build Applications & Executable Files

  • The Controlling READ
  • Distribution Options
  • Use the project management tools to assist the development cycle
  • Generating Applications
  • Modify the properties of the FoxPro icon
  • Generate Executable files from a project using the FoxPro Distribution Kit.
Top

Exams:

  • There are no exams directly associated with this course

Price Options ex VAT:

Classroom Training
?		 Distance Learning
?		 eLearning Options
?		 Book Learning
?
£ 1185
(€1683) 		£ 674.00
(€957) 		- No Books Supported for Course at present

Call Free on 0800 169 1890
Print 2 Page Flyer
Last Modified 01 May 2008