An Access Database At The Front Lines of the COVID-19 Pandemic
Published May 11 2020 07:50 AM 11.8K Views

Like many of us in this COVID-19 era, IT Impact, a Microsoft partner located in Chicago that focuses on Microsoft Access & SQL Server consulting, led by Access MVP Juan Soto, asked themselves, “What can we do to help ─ especially given our database knowledge and expertise?”


As we know, up-to-date information at the fingertips of doctors, nurses, and staff is critical to manage any crisis. So, how did IT Impact address this question? By tracking medical supplies, such as Personal Protective Equipment (PPE), which is essential for hospitals, testing and other medical care facilities, and then implementing a Field Hospital Inventory System. This is an easy-to-use solution that is accessible for anyone to download and consume.


Sounds like a perfect case for a Microsoft Access database ;).


Access is a rapid application development (RAD) tool that combines necessary data, forms, reports, and logic into one convenient package. And when lives are on the line, the speed of development and delivery is mission critical.




IT Impact’s free COVID-19 Supplies Tracking Access Database has many useful features, including:

  •         Pre-loaded items such as ventilators, gowns, masks, face shields, cleaning supplies, and even furniture.
  •         A user-friendly interface that does not require previous inventory management experience.
  •         Additional forms and reports to order from suppliers, update data, track inventory receipts, log issues, and report when inventory was sent out.
  •         Tracking of expiration dates, orders, inventory received, and inventory issued.
  •         Offline use, which is vital for field hospitals and locations that may not have internet access.
  •         The system will prompt the user to consume supplies using FIFO, (First In, First Out), displaying items in inventory starting with expired and oldest inventory.


We tend to lose sight of a simple fact: database solutions impact our lives in essential ways, and in the right hands, can even save our lives. Therefore, we appreciate IT Impact for using Microsoft Access to help make an impact during these challenging times, and on behalf of the Access team, we hope that you and your loved ones continue to stay safe.


For more information, please visit IT Impact’s dedicated Web site (, which includes all the contact, support, and additional context that one may need.

Version history
Last update:
‎May 11 2020 07:50 AM
Updated by: