Database Solutions 
 
How can you benefit from a database solution? 
 
Case Study: PAM Database for Palletways (UK) Ltd, Fradley, Lichfield 
 
Palletways required a simple to use database tool to replace a spreadsheet system that monitored KPIs for the majority of their customers. 
 
This old spreadsheet system meant creating a file for each account with a sheet for each month. In isolation this was not a difficult task but Palletways have 40+ customers and it took roughly 80 hours a month to produce this information. Furthermore the efforts were centred on producing the report rather than ensuring the information was correct and acting upon it. 
 
 
 
Case Study: PAM Database for Palletways (UK) Ltd, Fradley, Lichfield 
 
Palletways required a simple to use database tool to replace a spreadsheet system that monitored KPIs for the majority of their customers. 
 
This old spreadsheet system meant creating a file for each account with a sheet for each month. In isolation this was not a difficult task but Palletways have 40+ customers and it took roughly 80 hours a month to produce this information. Furthermore the efforts were centred on producing the report rather than ensuring the information was correct and acting upon it. 
 
 
 
 

What we did 

The PAM (Performance Account Management) database replacement designed in MS Access by 101 Computer Services Ltd enables Palletways to manage the information, cleanse the information in a logical manner and report on the information quickly and accurately in a professional format. Typically, 3% of their 1,500-2,000 consignments per day have issues. The consignment and financial data is uploaded into PAM with little user input on a daily basis. A simple user-friendly dashboard is used to check and cleanse the consignment data, then KPI measures are quickly generated and finally the data is circulated to clients as specially designed reports in pdf format. 
 
The Palletways management were delighted with PAM as it meant that at long last accurate evidence was at hand. 
 
Below, you can see screen shots from the application… 
 
 
 
 
 
See the range of clients that have asked us to build database solutions for them: 
 
 
BID Services 
Birmingham & Solihull Connexions 
BXL Services 
Central Networks (MEB) 
Cofathec Heatsave UK 
GVA Grimley 
GTV Audio And Visual Productions 
Mucknell Abbey 
npower 
Palletways (UK) Ltd 
Prinknash Abbey 
Royal National Institute for the Blind 
University of Wales, Bangor, Music Dept 
Wilkinson & Beven Design Ltd 
Wyre Forest District Council