|
Module 1: 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.
Top
|
|
Module 2: 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
|
|
|
Module 3: 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.
Top
|
|
Module 4: 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
|
|
|
Module 5: 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.
Top
|
|
Module 6: Errors & Debugging
- 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
|
|
|
Module 7: 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.
Top
|
|
Module 8: 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
|
|
|
Module 9: 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 10: 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
|
|
|
Module 11: Database Design
- Know how to eliminate duplicate entries
- Eliminate duplicate relationships
- Setting foreign and primary keys.
Top
|
|
Module 12: Rushmore
- Understand the way Rushmore works
- Understand the use of Rushmore
- Know how to set Rushmore on and off.
Top
|
|
|
Module 13: 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.
Top
|
|
Module 14: Wizards
- What are Wizards?
- Identify Wizards likely to be useful in application building
- Use the Report, Form,Import, Documenting and Application Wizards.
Top
|
|
|
Module 15: 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.
Top
|
|
Module 16: Understand the Object Model
- Define object-oriented programming
- Discuss approaches to software design
- Contrast procedural and object-oriented analysis.
Top
|
|
|
Module 17: 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.
Top
|
|
Module 18: 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
|
|
|
Module 19: Component Gallery
- Introduction to VFP visual classes
- Navigate around the Component Gallery
- Use components in an application
Top
|
|
Module 20: 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
|
|
|
Module 21: 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.
Top
|
|
Module 22: 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
|
|
|
Module 23: 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.
Top
|
|
Module 24: 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
|
|
|
Module 25: Data Buffering and Multi-User Programming
- Review VFP’s Shared Access and Data Locking
- Understand Data Buffering and the different types of Buffering
- Become familiar with the functions that support Data Buffering
- Manage data conflicts
- Understand Transaction Support and the commands that facilitate it.
Top
|
|
|
