David. Microsoft Access has several weaknesses or strengths, depending on your prospective. What makes it easy to use (single file) also makes it brittle from the prospective of change management, security and scalability.
Simply stated, the solution requires many users performing very complex business functions across a vast geographic landscape, then the technology is not appropriate. Yet, it's the best working prototyping platform or work-group level software in the world.
At Help4Access.com, we help large clients with decades of legacy technical debt built on MS Access, migrates critical business functions to more robust technologies while supporting their existing MS Access applications during the transition period.
To read about some of these business cases, please see the following URL.
https://www.help4access.com/services/migration-services/
To answer your cloud question, MS Access migrated to the cloud allows for integrating it's data with other web services (SaaS) applications. I feel that it's this ability to share data with web applications makes or extends Microsoft Access's worth to many businesses.