Kenton Solutions, L.L.C.
 
Recent Database Projects

Recent Database projects.

Paint mixing station:  MS Access 2003 database for paint mixing stations (at the painting location) for major paint manufacturer.

  • Electronic scale interface for real time mixing display on PC.

  • Touch screen interface.

  • Formula storage, retrieval, and calculation by volume to mix.

  • Formula correction for mixing errors.

  • Inventory tracking with reorder reports.

  • VOC reports.

  • Label printing on Dymo printer.

Production Status:  MS Access 2003 database for tracking production status from order entry to order shipping for a major paint manufacturer.

  • Tracks work hours for each step of the production process for three production cells.

  • Tracks batches and gallons produced.

  • Tracks quality control data.

  • Provides graph of work hours per month by production step.

  • Provides graph of work hours per production step by month.

  • Produces reports of batches produced, gallons produced, and average work hours per batch by month for any 12 month period and current year to date.

  • Includes custom work calendar for specifying daily work hours for each of the 3 production cells

Paint mixing station:  MS Access 2003 database for mixing paint at the painting location for major paint manufacturer.

  • Electronic scale interface for real time mixing display on PC.

  • Touch screen interface.

  • Formula storage, retrieval, and calculation by volume to mix.

  • Formula correction for mixing errors.

  • Inventory tracking with reorder reports.

  • VOC reports.

MedWatch Database:  MS Access 2000 database for recording and reporting adverse events.
Includes an interface to your MedDra database with an easy to use term lookup browser.

Freezer Inventory Control Database:  MS Access 2000 database for inventory management of materials that are required to be stored in a freezer.

  • Records time in and out of the freezer and calculates remaining shelf life.

  • Records materials used by job number.

  • Calculates materials remaining and materials to be ordered.

  • Scale interface to allow weighing of materials.

Clinical Trials Database:  MS Access 2000 database for management of clinical trials including serious adverse event reporting.  Key design elements.

  • Clinical investigator database.

  • Drug and device database.

  • Patient database.

  • Serious Adverse Event reporting.

Flexible Spending Account Database (Flexible Spending Account Software) (Cafeteria Plan Software):  MS Access 2000 database for management of employee flexible spending accounts.  Key design elements.

  • Management of all six flexible spending accounts.

    • Medical Reimbursement

    • Dependent Care

    • Individual Owned Medical Insurance

    • Disability

    • Group Medical, Dental, Vision

    • Group Term Life

  • Company deposits.

  • Employee contributions, supporting 5 pay periods

    • Weekly

    • Bi-Weekly

    • Semi-Monthly

    • Monthly

    • Annual

  • Company and Employee Disbursement check printing.

  • Check register.

  • Mailing label printing including United States Postal service (USPS) Postnet barcodes.

Document Tracking Database:  MS Access 97 database for major pharmaceutical company used in standards and specs department for tracking of document changes.  Key design elements.

  • Active document database.

  • Archived document database.

  • Barcoded report printing.

  • Statistics on documents processed and department throughput.

Publication Reader Response Card Processing Database:  MS Access 97 database for major pharmaceutical company used in technical publication department for tracking and processing of reader response cards.  Key design elements.

  • Multiple publications database.

  • Subscriber database by publication.

  • Sales rep. database by geographical region.

  • Reader response processing and reply automation.

  • Statistical analysis and reporting of responses.

 

Hit Counter

Embedded Systems | PC Applications | WEB Site Development | Database Development | Software Quality Assurance
home
| contact us | about Kenton Solutions

Copyright Kenton Solutions, L.L.C.

Kenton Solutions, L.L.C.
 Database Projects

WEB Site by Kenton Solutions, L.L.C.
http://www.kenton-solutions.com