A BASIC EXCEL APPLICATION
A basic excel application
The picture of the opening GUI application of the MIS
Here you could perform various tasks of a general MIS database application.
The insertion part of the database application
Here you could insert into the database according to the number of columns present
The picture when the data loads through the excel sheet
Here the data is directly loaded to the excel sheet. The data is loaded after one second, since timesamp is given as a key value here.
The picture of the database
Here the general show db option is given
The picture when the data is updated sucessfully
The picture of the general MIS queries you can perform according to the common schema of the data present
The picture of the helper of MIS naming conventions
The picture of the result of the first query
The picture of the result of the second query
The picture of the result of the third query
The picture of the end note, comiting all existing changes made
Author : Jimut Bahan Pal