Food / Beverage
We've built and fixed Access Databases for Pepsi, Clement Pappas, Ferrara Candy, Fiorucci Foods and New World Pasta. We've found that Food and Beverage Manufacturing and Distribution firms have lots of database needs including improving manufacturing processes, tracking the training of employees to gain and keep certifications, and many more needs
Here are some clients we have helped in the Food / Beverage industry:
|PepsiCo Worldwide Flavours
||Built Access Database for Concentrate portion of Bottling Business. This Access database is used for tracking productivity of resources within the manufacturing / bottling facility. We modified a previous Access database built for the Pepsi Pennsylvania plant and imported raw data from Excel.
||This Access Database application also integrates with a barcode scanner and the FedEx software for creating shipping labels.
Selma Cookies is an Orlando Cookie Manufacturing whose largest client is Disney Corporation.
Selma found us on the internet about 10 years ago. We've been modifying and supporting her Access database since then.
This is a customer order management database that helps Selma keep track and fulfill Yahoo orders.
This database imports from Excel derived spreadsheets that are produced by Yahoo and stages these orders to fulfillment and shipping.
From Selma's website:In 1990, Selma Sayin began as a passionate baker
whose secret recipes warmed the hearts and satisfied
the sweet tooth of friends, clients and family.
|Pepsi Bottling - Los Angeles
||Los Angeles, CA
||Trained Pepsi on an Access Database we built tracking plant efficiency. We worked in Los Angeles (Riverside plant) and also created a training manual for the plant.
|PepsiCo Global Concentrate Solutions
||In Atlanta, we are working with PepsiCo Global Concentrate Solutions to implement a Plant Picking database we built for Pepsi's Carlisle, PA plant. Pepsi Bottling approached us 20 years ago to build a Plant Efficiency tracking database that was rolled out nationwide. The other divisions within Pepsi then contacted and contracted us to build other professional Access database solutions.
|The Pancake Man
||Fix Access Database to run Pancake catering business outside of Milwaukee, WI. Heavy interaction with Microsoft Outlook including customized calendar events. Mail Merge letters accomplished through Access Reports. Complex Data entry logic.
We provided the free Microsoft Access quote for this project and did the development as well.