Access holds zero appeal for young software developers. No Silicon Valley VC is going to invest in your Access-based software product. It doesn't scale the way a web-based SaaS does. There will always be a ceiling on how much leverage you can generate selling an Access-based business-to-consumer product that does not exist with web applications.
BUT, if you are a competent Microsoft Access developer, you will have no shortage of custom desktop software projects to build (and maintain). I think it's safe to say there are 100s of thousands (if not millions) of critical business applications running in Microsoft Access today. And there is simply no other product available that offers a seamless migration option for a front-end Access application. In fact, Microsoft practically guaranteed that would be the case when they broke VBx backward compatibility in their move to VB.Net.