ERP002- Data Base / Programing Concepts / Algorithms

Part 1- Visual FoxPro DATA BASE – 6 Sessions

1.Visual FoxPro

  • Visual FoxPro Environment
  • DATABASE Definition And Usage
  • Creating Tables, Data Types & Fields
  • Append / Edit / Delete Records
  • Display / List / Browse Records
  • Query / Report with Simple Conditions

2.Table & Record

  • Record Pointer Movement
  • Replace / Group Records Change
  • Sorting & Indexing a Table
  • Multiple Index & Conditional Index
  • Multi Types & Compound Index Keys
  • Set Order & Set Index & Set Filter
  • Work Area /Open Share Again Tables
  • Locate / Seek / Find in a Table

3.Conditions & Relations

  • Compound Conditions
  • Logical Operators
  • Mathematical Operator
  • Character String Functions
  • Date Functions
  • Set Relation to Multiple Tables

4.Database Manipulation

  • Modify / List Table Structure
  • ZAP / PACK / REINDEX
  • Add & Remove Tables to D.B
  • Import & Export Other Formats
  • Directory & File Management
  • Data Base Documentation
  • Set Environment Configs / SET
  • Get System Information / SYS()

5.Programming 1

  • Programming Concepts & Macros
  • Create / Edit / Run / Debug a Program
  • Functions / Procedures / Nested Calls
  • Constants/Public, Private, Local Variable
  • Release / Save / Restore / List Variables
  • Expressions / Operands / Operators

6.Programming 2

  • INPUTBOX / MESSAGEBOX Commands
  • Count / Sum / Average / Calculate
  • DO WHILE, ENDDO/SCAN, ENDSCAN loop
  • FOR, ENDFOR Loop
  • IF, ELSE, ENDIF / DO CASE, ENDCASE
  • Nested IF / IIF , Nested DO CASE
  • SKIP / EOF / BOF / EXIT / CANCEL / SUSPEND
  • Nested WHILE, SCAN, FOR Loops

Part 2- Object Oriented Programming & Reports– 6 Sessions

7.Programming 3

  • Working with MEMO Fields
  • Dimension/Array Manipulation
  • System Variables
  • Modular Programming/Procedure File
  • Parameters  Passing
  • Ports / Low-Level File Manipulation

8.Object Oriented Programming 1

  • Object Oriented Programming Basics
  • Base Classes & Properties Window
  • Forms & Controls
  • Label / Text Box / Edit Box Objects
  • Command Button Object
  • Command Group Object
  • Project #1- Customer Data Entry Form

9.Object Oriented Programming 2

  • Check Box Object
  • Spinner Object
  • Option Group Object
  • Combo Box Object
  • Page Frame Object
  • Project #2- Add More Fields to P#1

10.Object Oriented Programming 3

  • Grid Object
  • Image Object
  • Line/Shape/HyperLink Object
  • Timer Object
  • Form Set Object
  • Tab Order Setting
  • Project #3- Add More Fields to P#2

11.CLASS-BASE Programming

  • User Define Classes
  • Toolbar Class
  • Query Cells Class
  • Query Generator & Form of Query Cells
  • Base Table Class & Base Forms
  • Project #4-Center Code Query Generator

12.Report Making

  • Report Designer
  • Report Page Header
  • Report Detail
  • Report Page Footer
  • Report Data Environment
  • Report Variables / Page Layout
  • Report Data Grouping
  • Project #5- Full Report of Customers