Access Database Consultants, Programmers and Developers


- Web Enabling Access

- Migrating Access To Cloud

- Migrating Access to the Web

- Access and Excel Visual Basic for Applications (VBA) programming

Manufacturing

Access Database Programmers Manufacturing

We've been building Access database solutions for Manufacturer's since day 1.

Our very first clients included Hercules Chemical in Wilmington, DE and Pepsi Bottling Group in Somers New York. Both hired us to build Access databases to track an improve manufacturing processes.

Since then, we've added on such big name clients as Philip Morris, Meadwestvaco, RockTenn, Ball Manufacturing, Greystone Manufacturing, Miller Manufacturing and many more manufacturing clients.

Our Downtime tracking / Overall Equipment Efficiency Tracking application is so popular, it's been rebought 3 times by new clients. So now we offer it for sale here: Overall Equipment Effectiveness Database Application

We also do PHP, Angular JS, and MySQL Development for manufacturing clients. More about that here: PHP and MySQL and Angular JS expert developers


Here are some clients we have helped in the Manufacturing industry:

Client

Location

Project Description

WestRock

Glen Allen, VA

Build Access database for Fortune 500 paper and packaging company. Database manages 1 Billion of Inventory

Ryson Conveyor

Virginia Beach, VA

Yorktown - We were subcontracted to Ryson through our network engineering strategic partner Network Technologies and Solutions (NTS). Ryson's Chief Operating officer had been slowly putting together and Access Database to replace a series of complex Excel files in order to manage the process of building conveyor belts. We took over the Access database, enforced naming conventions, developed easy to use navigation forms and maintenance tables. Now this conveyor manufacturer has a backbone database application that provides completion timeline information to the engineering departments, the manufacturing departments, the finance departments and the sales department. A calendar is created for everyone to see. Huge printouts showing all current projects and the people needed to sign off are printed out and put up throughout the facility. We hope to replace these with direct feeds to monitors.

B to B Solutions

Richmond, VA

Partner / Subcontract to build Access, SQL Server, .NET applications for their clients: Chemical Engineering client DuPont, their staffing client Apex Systems, Their health industry client Result Performance, and their insurance client Affinity Group Underwriters in Richmond, VA

MatlenSilver Group ltd.

Richmond, VA

MatlenSilver Group, Inc subcontracted us to their Fortune 500 Tobacco /Food Manufacturing Philip Morris (now Altria) for Manufacturing Training Tracking in Richond, VA.

The Matlen Silver Group, Inc. provides information technology (IT) staffing services.

Altria desired to track which employees had what training in their plants and what certifications were going to expire. This Access database tracked that information and provided reports to help schedule future training of employees

Simpson Strong-Tie Co. Inc.

Baltimore, MD

Built New Batch process tracking Access database to manage the production and shipping of batches. Simpson Strong Tie is a Fortune 500 company that strategically uses Access Database to manage department activities

Tredegar Corporation

Richmond, VA

About Tredegar: Deeply rooted in manufacturing, Tredegar Corporation is a global operating company with industry-leading businesses in the plastic films and aluminum extrusions markets. We were engaged through one of our strategic partners to help Tredegar manage a special bonus functionality in the Human Resource department. We've built many commission and bonus related Access databases in a variety of firms including Fortune 500 Altria and more, so we were well positioned to referred to Tredegar for this Microsoft Access database consulting engagement. Tredegar has a Lotus 123 spreadsheet (yes! Lotus 123) for keeping track of retired employees and the distributions those employees choose to take out of their retirement. Tredegar asked us to convert this Lotus 123 Spreadsheet into an Access Database. The new Access 2013 database will replace the Lotus 123 spreadsheet functionality of managing and administrating this human resource function of retired employee distributions. We were the Microsoft Access Database consultants for this project

Tower Steel, Inc.

Houston, Texas

This Steel Manufacturer in Houston Texas needed a remote Access database programmer to build them an Access Database. They also host their data on our Servers.

Commonwealth Center for Advanced Manufacturing

Richmond, VA

CCAM contacted us to convert their Excel Spreadsheet into an Access Database. They needed expert Access programmers for this task. Their spreadsheet was calculating the SPI Index for ongoing projects. But not working due to the complex nature of the calculation. A database was necessary and Microsoft Access was the perfect solution for converting this spreadsheet to a database.

From the CCAM Website: THE COMMONWEALTH CENTER FOR ADVANCED MANUFACTURING "CCAM" IS WHERE THE BEST OF INDUSTRY, ACADEMIA AND GOVERNMENT COME TOGETHER TO SOLVE ADVANCED MANUFACTURING CHALLENGES.

We also build expert PHP and MySQL web application solutions for the manufacturing industry. More information here: PHP and MySQL web application solutions for the manufacturing industry

We have also built Overall Equipment Effectiveness Access Databases and similar efficiency tracking databases for Pepsi Bottling and Clement Pappas. We have converted these applications for general use and more information is available here: Overall Equipment Effectiveness for the manufacturing industry

Volcafe - TaylorWinch

Nairobi, Kenya

Volcafe is a worldwide Coffee Manufacturer involved in Purchasing, Collection, Processing and Import/Export

UpTime Solutions Professional Services Group

Richmond, VA

Network Engineering Firm in Richmond, Virginia.

This is a Quality tracking and improvement Access database for a manufacturing firm: Greystone in Toano, VA (near Westpoint and Williamsburg).

This application receives multiple excel files throughout the day that are produced from quality control machiney in the plant. The excel files are imported to the Access database automatically.

The Access database scrolls through the excel files, parsing out the relevant information from the excel file and appends the relevant data points to a table that is then used to run monthly and quarterly quality control reports.

The data is pertinent to the automobile manufacturing process and determines which production batches should or should not be accepted for Greystones automobile manufacturing clients.

We built this database through our strategic partner: Uptime Solutions, a premier network integration and engineering firm in Richmond, VA and Tampa, FL.

Ritchie & Associates

Philadelphia, PA

Ritchie is a management consulting firm headquartered outside of Los Angeles, California. They consult with Fortune 500 firm Meadwestvaco (now WestRock). They advised the paper and packaging firm to build an historical demand based Access Database. It incorporated not only ERP (SAP) sourced historical demand, but also provided advanced logistic support to this Paper and packaging corporation.

This Access database determined optimim supply levels in plants and warehouses throughout the US including Maine, North Carolina, Ohio, California, Texas, Colorado, Washington, Oregon, and Michigan.

Networking Technologies and Support

Virginia Beach, Virginia

Yorktown - This Access database for a conveyor manufacturing company tracks is a project management database with multiple dates for the completion of manufacturing and engineering tasks with advanced calendaring.

ActivSupport

New York, NY

ActivSupport contacted us to fix various Access, SQL Server, and Sharepoint Databases for their clients in Charlottesville, VA.

Active Support needed an expert database consulting company to support their clients without having to worry about the end results. Keeping their client happy was most important to ActivSupport. By supplying professional database developers to ActivSupport and their clients, we kept both our partner and their client happy

Sycom Technologies

Richmond, VA

Access Database to track Employee Stock Distributions. Sycom's client, Tredegar Industries, needed to get out of a Lotus 123 Spreadsheet and into an Access database. We converted they're advanced Lotus Macros and now they create distributions, deposits, etc. for their stock plan with the new Access database. We were the Microsoft Access Database programmers for this project

Pepsi Bottling - Tulsa

Tulsa, OK

Build Access database - Manufacturing Process Efficiency Tracker

Ball Corporation

Staunton, VA

Fix Access database for Aluminum products manufacturer. Database tracks orders and shipments. Second database request to fix quality management database.

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