Monday, May 24, 2010

Still Battling with "Al-Furqaan Batabank" Database

Due to the teeming commitments in my hands, the "Al-Furqaan Databank" database I started sometime ago had to be halted. I thought doing that was better in order to save the piling job in my hands. Afterall, the School authorities knew very little about the progress of the project. I started it all voluntarily, to save them the pains of piling up their students' records. All this is now history.

I was reading one saturday morning when one of the teachers called me on phone that they "are seriously in need of the database now". They recently lost all the data they had in the school's system due to lack of backup and a concrete plan for records keeping. I was called upon to reinstal the operating system and start all over again. He told me that the school is procuring a new system and there is an urgent need for a small database to take care of their records.

I swinged into action immidiately. I located the saved database, looked into it and made a plan for completion. Already, there are forms, and sample queries backing all the tables created. After studying the state of the database, I found that, based on my earlier plan, the database is still in need of the following:

  1. Design report templates of various styles;
  2. Customise all the input forms already created (including data validation/security/control, updating, searching/querying forms);
  3. Feeding empty forms with the required data samples for test;
  4. Creating codes and feeding same into the input forms designed for it;
  5. Linking related tables for cross-data-entry;
  6. Creating and customising User Login Interface for the database;
  7. Editing all "Close" buttons.
These are the most important outstanding activities to carry out immidiately. In due course, as usual, I shall post all the images of the related activities already conducted, and the latest ones to be carried out.