Clients and Projects

Works Request Database System

I was approached by Excel IT Ltd. to undertake development of a works requests database system, the company were using Excel to track thier work requests and had realised that a 'proper' database was required.

The system was written in Access 2003, and runs on a server to provide centralised access to the data throught the organisation.

• Holds data relating to engineers, suppliers and customers.

• Uses the above stored data to provide engineer, supplier and customer information to the main works requests data table.

• Produces small order works request with a single click.

• Includes comprehensive report selection criteria.

• Dynamically calculates profit/loss in both monetary and percentage terms.