Pages

Sunday, May 1, 2011

Two "test project" attempts before major one to be launched...

First Test Project - named QARejects - basically ETL (Extract - Transform - Load) type, cannot be count as an application, it was rather a tool ... Below is a snapshot from the start-up form.


The typical work-flow was:
Export the data from Corporate ERP IQMS - ORACLE based system using Excel Report output...


Convert and Get Data for particular period (usually per month). This will load converted data from Excel spreadsheet into the Access Database.

Last step was to print a monthly report...
Second Test Project - MICS (Material Information Computer System)  was dealing with material inventory...

Below are two screen shots from MICS. Main entry form "Warehouse" and report for Material inventory.