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

Published 05-11-2020 07:50 AM 5,242 Views
Microsoft

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.

 

Ebo_Quansah_1-1589207890669.png

 

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 (https://covidsuppliesdatabase.com/), which includes all the contact, support, and additional context that one may need.

11 Comments

Thanks to the Microsoft Access team for getting the word out on this effort, we look forward to helping out organizations around the world with this free tool.

 

Juan Soto

Access MVP

Senior Member

i saw the slides from the DevCon (Donkarl)

YOU are doing a great job

thank you!

You can also watch the recording of Juan Soto's introduction of this project at the DevCon.

 

Karl

Access DevCon Vienna

New Contributor

How to create like this? Do you have any demo link??

Super Contributor

Hi @Ebo_Quansah and @Juan Soto,

I downloaded it today (german region), but my Windows 10 Home device blocked the file, because Windows Defender said, it isn't safe. Can you please review the file?

 
 
 
 

 

Hi Eva

 

The file IS SAFE but since Defender does not have a lot of experience with it, it errs on the caution of unsafe. Please proceed to use it as needed.

 

Juan Soto

Access MVP

Occasional Visitor
Good Day How do I access this database.
Super Contributor

@meagz87 Are you familiar with other ms access databases in the past? Describe your issue with it, send a screenshot, so maybe I can help.

Occasional Visitor

@Eva Vogel  my experience with access is limited. However I have asked our IT department to come through and assist me.  We run a clinic on a mining company and would like to use this database to track our covid-19 supplies.  But I cant seem to find where I can download a copy.  Secondly I am not sure if anyone has developed a database to track COVID-19 testing and results. But for now I would like to download and start using this database. 

 

Super Contributor

@meagz87 Weard: The firm whitch built that access database for download, is still alive, but my windows defender dissallowed me to download the file again. And I already deleted it. 

 

I recommend, that you create a SharePoint Site with e.g. 3 LIsts:

1) "Testing LIst"

2) "Testteam LIst"

3) "Tested Persons LIst"

 

If you already started with an Excel List, it is easy to upload these List on a SharePoint Site.

The Lists can be referred on Columns to each other with a logic structure (like Access Databases did until 2018) so that you can create Reports, e.g. with Power Automate like "Who was tested on which date with which result!"

With the lists you can have a Power Apps App for the input and output forms, shared for each team person which has to access the data online.

SharePoint in my eyes is much better than MS Access.

 

If you need help to create such a database with SharePoint in your MS 365 Tenant , I'll be happy to assist you to create that App. Without MS Access.

 

 

 

 

 

 

 

Super Contributor

@Ebo_Quansah Would'nt it be a good idea to migrate / create/ upload a Covid 19 Testing App into the Microsoft Store for free? The Windows Defender is blocking the covid19supplierdatabase and the new windows defender rules are quite enerving... Please make it free to download a covid 19 testing App. Thanks.

%3CLINGO-SUB%20id%3D%22lingo-sub-1379998%22%20slang%3D%22en-US%22%3EAn%20Access%20Database%20At%20The%20Front%20Lines%20of%20the%20COVID-19%20Pandemic%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1379998%22%20slang%3D%22en-US%22%3E%3CP%3ELike%20many%20of%20us%20in%20this%20COVID-19%20era%2C%20%3CA%20href%3D%22https%3A%2F%2Fnam06.safelinks.protection.outlook.com%2F%3Furl%3Dhttps%253A%252F%252Fitimpact.com%252F%26amp%3Bdata%3D02%257C01%257CEbo.Quansah%2540microsoft.com%257Cd127363527c14da00a1708d7f36eda3d%257C72f988bf86f141af91ab2d7cd011db47%257C0%257C0%257C637245529749253828%26amp%3Bsdata%3DuN6G7LphpN8QR8HO23RqYaVwQvq26zr8Oo6x4FyuZcM%253D%26amp%3Breserved%3D0%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3EIT%20Impact%3C%2FA%3E%2C%20a%20Microsoft%20partner%20located%20in%20Chicago%20that%20focuses%20on%20Microsoft%20Access%20%26amp%3B%20SQL%20Server%20consulting%2C%20led%20by%20Access%20MVP%20Juan%20Soto%2C%20asked%20themselves%2C%20%E2%80%9CWhat%20can%20we%20do%20to%20help%20%E2%94%80%20especially%20given%20our%20database%20knowledge%20and%20expertise%3F%E2%80%9D%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAs%20we%20know%2C%20up-to-date%20information%20at%20the%20fingertips%20of%20doctors%2C%20nurses%2C%20and%20staff%20is%20critical%20to%20manage%20any%20crisis.%20So%2C%20how%20did%20IT%20Impact%20address%20this%20question%3F%20By%20tracking%20medical%20supplies%2C%20such%20as%20Personal%20Protective%20Equipment%20(PPE)%2C%20which%20is%20essential%20for%20hospitals%2C%20testing%20and%20other%20medical%20care%20facilities%2C%20and%20then%20implementing%20a%20Field%20Hospital%20Inventory%20System.%20This%20is%20an%20easy-to-use%20solution%20that%20is%20accessible%20for%20anyone%20to%20download%20and%20consume.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESounds%20like%20a%20perfect%20case%20for%20a%20Microsoft%20Access%20database%20%3B).%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAccess%20is%20a%20rapid%20application%20development%20(RAD)%20tool%20that%20combines%20necessary%20data%2C%20forms%2C%20reports%2C%20and%20logic%20into%20one%20convenient%20package.%20And%20when%20lives%20are%20on%20the%20line%2C%20the%20speed%20of%20development%20and%20delivery%20is%20mission%20critical.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Ebo_Quansah_1-1589207890669.png%22%20style%3D%22width%3A%20500px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F190607iBCD7B741A259A299%2Fimage-dimensions%2F500x254%3Fv%3D1.0%22%20width%3D%22500%22%20height%3D%22254%22%20title%3D%22Ebo_Quansah_1-1589207890669.png%22%20alt%3D%22Ebo_Quansah_1-1589207890669.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIT%20Impact%E2%80%99s%20%3CSTRONG%3Efree%3C%2FSTRONG%3E%20COVID-19%20Supplies%20Tracking%20Access%20Database%20has%20many%20useful%20features%2C%20including%3A%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20Pre-loaded%20items%20such%20as%20ventilators%2C%20gowns%2C%20masks%2C%20face%20shields%2C%20cleaning%20supplies%2C%20and%20even%20furniture.%3C%2FLI%3E%0A%3CLI%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20A%20user-friendly%20interface%20that%20does%20not%20require%20previous%20inventory%20management%20experience.%3C%2FLI%3E%0A%3CLI%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20Additional%20forms%20and%20reports%20to%20order%20from%20suppliers%2C%20update%20data%2C%20track%20inventory%20receipts%2C%20log%20issues%2C%20and%20report%20when%20inventory%20was%20sent%20out.%3C%2FLI%3E%0A%3CLI%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20Tracking%20of%20expiration%20dates%2C%20orders%2C%20inventory%20received%2C%20and%20inventory%20issued.%3C%2FLI%3E%0A%3CLI%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20Offline%20use%2C%20which%20is%20vital%20for%20field%20hospitals%20and%20locations%20that%20may%20not%20have%20internet%20access.%3C%2FLI%3E%0A%3CLI%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20The%20system%20will%20prompt%20the%20user%20to%20consume%20supplies%20using%20FIFO%2C%20(First%20In%2C%20First%20Out)%2C%20displaying%20items%20in%20inventory%20starting%20with%20expired%20and%20oldest%20inventory.%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWe%20tend%20to%20lose%20sight%20of%20a%20simple%20fact%3A%20database%20solutions%20impact%20our%20lives%20in%20essential%20ways%2C%20and%20in%20the%20right%20hands%2C%20can%20even%20save%20our%20lives.%20Therefore%2C%20we%20appreciate%20IT%20Impact%20for%20using%20Microsoft%20Access%20to%20help%20make%20an%20impact%20during%20these%20challenging%20times%2C%20and%20on%20behalf%20of%20the%20Access%20team%2C%20we%20hope%20that%20you%20and%20your%20loved%20ones%20continue%20to%20stay%20safe.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFor%20more%20information%2C%20please%20visit%20IT%20Impact%E2%80%99s%20dedicated%20Web%20site%20(%3CA%20href%3D%22https%3A%2F%2Fnam06.safelinks.protection.outlook.com%2F%3Furl%3Dhttps%253A%252F%252Fcovidsuppliesdatabase.com%252F%26amp%3Bdata%3D02%257C01%257CEbo.Quansah%2540microsoft.com%257Cd127363527c14da00a1708d7f36eda3d%257C72f988bf86f141af91ab2d7cd011db47%257C0%257C0%257C637245529749253828%26amp%3Bsdata%3DCVCZJKYITdDTO3JF6%252Bnx76CiDYPRKHXzrMo5wyqa5oQ%253D%26amp%3Breserved%3D0%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fcovidsuppliesdatabase.com%2F%3C%2FA%3E)%2C%20which%20includes%20all%20the%20contact%2C%20support%2C%20and%20additional%20context%20that%20one%20may%20need.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-1379998%22%20slang%3D%22en-US%22%3E%3CP%3EMicrosoft%20partner%2C%20IT%20Impact%2C%20develops%20an%20accessible%20Access%20database%20to%20help%20organizations%20battle%20the%20COVID-19%20Pandemic.%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1379998%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ECovid-19%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Edatabase%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EHospitals%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOrganizations%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPandemic%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1382983%22%20slang%3D%22en-US%22%3ERe%3A%20An%20Access%20Database%20At%20The%20Front%20Lines%20of%20the%20COVID-19%20Pandemic%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1382983%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20to%20the%20Microsoft%20Access%20team%20for%20getting%20the%20word%20out%20on%20this%20effort%2C%20we%20look%20forward%20to%20helping%20out%20organizations%20around%20the%20world%20with%20this%20free%20tool.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EJuan%20Soto%3C%2FP%3E%0A%3CP%3EAccess%20MVP%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1421499%22%20slang%3D%22en-US%22%3ERe%3A%20An%20Access%20Database%20At%20The%20Front%20Lines%20of%20the%20COVID-19%20Pandemic%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1421499%22%20slang%3D%22en-US%22%3E%3CP%3Ei%20saw%20the%20slides%20from%20the%20DevCon%20(Donkarl)%3C%2FP%3E%3CP%3EYOU%20are%20doing%20a%20great%20job%3C%2FP%3E%3CP%3Ethank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1423358%22%20slang%3D%22en-US%22%3ERe%3A%20An%20Access%20Database%20At%20The%20Front%20Lines%20of%20the%20COVID-19%20Pandemic%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1423358%22%20slang%3D%22en-US%22%3E%3CP%3EYou%20can%20also%20watch%20the%20%3CA%20href%3D%22https%3A%2F%2Fyoutu.be%2FrVdaXOv5TZw%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Erecording%20of%20Juan%20Soto's%20introduction%3C%2FA%3E%20of%20this%20project%20at%20the%20DevCon.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EKarl%3C%2FP%3E%0A%3CP%3E%3CA%20class%3D%22moz-txt-link-freetext%22%20href%3D%22http%3A%2F%2FAccessDevCon.com%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3EAccess%20DevCon%20Vienna%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1428355%22%20slang%3D%22en-US%22%3ERe%3A%20An%20Access%20Database%20At%20The%20Front%20Lines%20of%20the%20COVID-19%20Pandemic%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1428355%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20to%20create%20like%20this%3F%20Do%20you%20have%20any%20demo%20link%3F%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1565963%22%20slang%3D%22en-US%22%3ERe%3A%20An%20Access%20Database%20At%20The%20Front%20Lines%20of%20the%20COVID-19%20Pandemic%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1565963%22%20slang%3D%22en-US%22%3E%3CP%3EGet%20instant%20Access%20support%20here%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.help4access.com%2Fpayment%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.help4access.com%2Fpayment%2F%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Version history
Last update:
‎May 11 2020 07:50 AM
Updated by: