|
Module 1: xBase Overview
- Use the Command Window
- Use the Program Editor
- Understand the Program Menu
- Use & customize the Toolbar
- Use the command window to execute commands & functions
Top
|
|
Module 2: Introduction to Data Handling
- Use commands to open databases and tables, set index orders and relations
- Know how to LOCATE records
- Set a Filter on a Table
- Understand xBASE Syntax
- Understand the Scope, For and While clauses
- Perform Calculations on Table Data
Top
|
|
|
Module 3: Configure the VFP Environment
- Change the file and directory locations
- Change the Regional and Data options
- Dock and undock windows
Top
|
|
Module 4: Datafile Basics in Code
- Datafile Management - Work Areas
- Open Tables in work areas
- Select a particular Table Establish Relational links between tables
- Use and test a One to Many relation
- Use and test a Many to One relation
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: Using Variables
- Understand the data types of variables
- Understand variable naming conventions
- Assign values to variables & display variables
- Use the EVALUATE function
- Use macro substitution and referencing in command lines
- Assign Memory Variables with the Store command
- Use and know the different data types
- Use variables in commands
- Display FoxPro memory
- Save sets of memory variables to a file using optional wildcards and clauses
- Restore variables from a file
Top
|
|
|
Module 9: Datafile Management Commands
- Use the command line to manipulate databases
- Use commands to open and close tables
- Write a program to set up the environment, open tables, set the index order and set relationships
Top
|
|
Module 10: 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 11: Create and Use Indexes
- Create simple ascending and descending indexes by modifying the record structure
- Apply indexes to change the record order
- Create compound indexes
- Find and retrieve records using the index
Top
|
|
Module 12: 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 13: Output Reports
- Preview report output
- Send reports to a printer
- Set printer options
Top
|
|
Module 14: Elementary Programming Techniques
- Be Able to Create and Run Programs
- Add Comments to a Program
- Provide developer information
- Beautify Code
- Use Intellisense
Top
|
|
|
Module 15: FoxPro Functions
- Use FoxPro Functions within FoxPro commands
- Understand the additional scope and functionality available by using functions in commands
Top
|
|
Module 16: 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 17: 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 18: Structured Programming
- 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
- Understand compile time constants
Top
|
|
|
Module 19: Procedures and Sub-routines
- Understand the compile option
- Store and run programs as .PRG text files
- Store and run sub-routines using different options
- Call subroutines and control program flow
- Assign Public,Local and Private Memory Variables
- Be aware of modular coding techniques
- Use the Document window
Top
|
|
Module 20: 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 21: Using The Debug Tools
- Use the Trace window to follow program execution and suspend programs
- Use the Watch window to set breakpoints and amend variables
- Use the Debugout window
- 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 22: Error Handling
- Trap an error
- Display Error information
- Collect environment and status information
- Use Local and Global error traps
Top
|
|
|
Module 23: 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 24: Use FoxDoc
- Create formatted programs
- Document program hierarchies, variable cross references etc
Top
|
|
