|
Requirement
To adjust an existing database that was built to contain all the examination information required at any one time at a tertiary institution. While the existing database was well setup, it lacked any form of automation needed through the addition of VBA and SQL code.
|
Industry: University
Company Size:
Thousands Nationwide
|
|
Functionality
The database was made up of a menu driven system which allowed the user easy access to specific areas of the system. In addition:
- A process was created whereby Exam, examiner and student information was imported automatically into the database from a standardised text file. This was accessed through a dedicated import form where the only user input required was navigation to the specific text file.
- A form was created whereby the user could select a specific examiner, a specific exam and a specific time to allocate the examiner to that exam. The system checked the availability of the examiner by searching through the database and prevented the user from allocating an examiner who had previously been allocated at the selected time.
- A comprehensive report system was already set up in the database. Further functionality was needed by adding in SQL code and enabling specific filtering to be added to the database.
- The system needed to be split into a frontend database containing the queries, forms and reports, and a backend database containing the tables. A VBA routine was written to connect the frontend to the backend automatically should the database be moved from the current location to an alternative location on the network server.
|
|