Food / Beverage

Microsoft Access Database for 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:

Client

Location

Project Description

PepsiCo Worldwide Flavours

Dallas, TX

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.

Selma's Cookies

Orlando, FL

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

Atlanta, GA

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

Milwaukee, WI

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.

Our Clients Include:

  • The Army, Defense Supply Center, Chesterfield (Richmond) Virginia - Warehouse Inventory Application subcontracted through Goodwill Industries as a prime vendor
    The Army, Defense Supply Center, Chesterfield (Richmond) Virginia - Warehouse Inventory Application subcontracted through Goodwill Industries as a prime vendor
  • The Navy, Naval Research Laboratory in Waldorf, Maryland - Inventory, Purchase Orders, Service Life Tracking Microsoft Access database subcontracted through ACSG as the prime vendor
    The Navy, Naval Research Laboratory in Waldorf, Maryland - Inventory, Purchase Orders, Service Life Tracking Microsoft Access database subcontracted through ACSG as the prime vendor
  • Pepsi Bottling Group in Somers (New York) New York - Overall Equipment Effectiveness Microsoft Access database that tracks SKU production and downtime categories to improve LEAN efficiency
    Pepsi Bottling Group in Somers (New York) New York - Overall Equipment Effectiveness Microsoft Access database that tracks SKU production and downtime categories to improve LEAN efficiency
  • Virginia Commonwealth University, Medical College of Virginia, Richmond Virginia - Mortality Statistic tracking for the hospital using an Access database
    Virginia Commonwealth University, Medical College of Virginia, Richmond Virginia - Mortality Statistic tracking for the hospital using an Access database