Database Design & Development

Product Development

Dietary Supplement Contract Manufacturer

Spencer Cole Engineering staff revamped the Operations Performance Plant Reporting database to provide Engineering with an optimized data reporting tool. This case study highlights our work on this effort.


  Re-design existing database to incorporate ERP system data with data collected manually and provide a reporting tool for management review, analysis and reporting.


The existing plant operations data was collected and maintained in a disparate manner. There was no streamlined method of correlating data for analysis, issue resolution and reporting. As a result, engineering and manufacturing issues where unmanageable.

Back to Main Case Studies Page



Imported disparate data into one streamlined database. Built the necessary tables, defined relationships, created all required queries, forms and reports.

Request More Information

Key Benefits

Incorporated macros to perform all daily data import functions with one-step button commands – thereby reducing all manual data import and correlation processes.

New database design provides an integrated picture of the organization’s manufacturing operations

The new database design minimizes data inconsistency

Data access is faster and more accurate. The new system provides users with an enhanced access to data which results in a faster data recovery, analysis and on demand reporting mechanisms

Request More Information

Database Design & Development Case Study

eMail Us | (703) 725-7706 | Discusss this Case Study | Request Consultation | Request for Quote