These days everything new and interesting seems to be web-enabled. From email to ERP, everyone is going to the web. So it's interesting to note that a company like Google, heavily centered in the online world, offers a client-based application to manage pay-per-click (PPC) advertising campaigns. While rich internet applications continue to evolve and replace traditional desktop apps, it's good to know even Google recognizes the value (and necessity) of client-side apps.
For that very reason, Access 2010 will hold value where low- to mid-level complexity tasks are accomplished in a web client, and high-complexity (or processor intensive) activities are handled by power-user client applications.