F1 Solutions

Database design and software training

Custom Search
HOME         ABOUT US         OUR SERVICES         WE OFFER         CASE STUDIES         USEFUL LINKS         CONTACT US
Database Development/Software Training

Case Studies

Freight Consignment System

Requirement. To replace a DOS based system to log freight consignments that leave the warehouse and to produce the freight consignment note that accompanies the freight as the existing system that was being used by the client was not Year 2000 compliant and was not dating the consignment notes correctly. In addition to calculate the cost of the freight based on the charges incurred from the freight carrier in conjunction with the weight and size of the freight.

Read More

Chemical Inventory System

Requirement. The main function of the database was to produce the monthly report - a 20 page document that was done in Excel, each page containing 6 graphs which had to be created manually each month.

Read More

Annual Leave Database

Requirement. To build a system for an individual department within the company that allowed staff to enter their annual leave requests and for their managers to approve these leave requests.

Read More

Car Logging System

Requirement. To replace a DOS based system that was not Year 2K compliant. The system kept track of car pool costs, their mileage and their costs.

Read More

Telemarketing System

Requirement. To build a system that enabled the call logging of all telemarketing, the sales achieved from such calls and the ability to remind the user at set periods to call the client once again.

Read More

Inventory and Usage Databases

Requirement. The main function of these databases was to automate files exported from SAP into Access, manipulating the data in Access and in turn exporting the data back into Microsoft Excel.

Read More

Time Sheet System

Requirement. To provide a system to record job details and the time worked on each job, enabling a job costings report to be produced.

Read More

Exam Information Database


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 set up, it lacked any form of automation needed through the addition of VBA and SQL code.

Read More