Tracking Databases

I am working on a tracking database which needs to be re-designed. My responsibility is not only to design the UI (front-end)for the transactions but also to make the work flow, which is user friendly. I would like to get some ideas form usability aspect, which can merge with technical aspects also.