Don't Wait !! Contact us now for your FREE quote |
What our clients are saying! |
|
"Wow, thanks for the fast |
Case Studies
These case studies detail some of our work. They may help you to understand what Fulcrum Group has been involved in. If your industry/requirement is different to those below don't despair, contact us as we have extensive experience.
|
Access Database upsize to SQL Server
|
Requirement. To move Access data to Microsoft SQL. The Access front end application will continue to be used by the organization while the data is to be stored on Microsoft SQL. This was required in order to provide a more scalable solution for the organization.
|
|
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.
|
|
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.
|
|
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.
|
|
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.
|
|
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.
|
|
Time Sheet System
|
Requirement. To provide a system to record job details and the time worked on each job, enabling a jobcosting report to be produced.
|
|
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.
|