An Access Database At The Front Lines of the COVID-19 Pandemic

This post has been republished via RSS; it originally appeared at: Access Blog articles.

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.

REMEMBER: these articles are REPUBLISHED. Your best bet to get a reply is to follow the link at the top of the post to the ORIGINAL post! BUT you're more than welcome to start discussions here:

This site uses Akismet to reduce spam. Learn how your comment data is processed.