Most users probably don't miss features in LO as such. The issue like with much open source software, is UI and stability related.

Joe Marketing ain't going to jump through UI hoops and do complex bug work-arounds, when he can avoid this entirely by buying a MS office license for 200 USD or whatever the price is.

In 10 years (since 2004), over 400-600 users, I've seen exactly one instance of Access in use, and that was by a developer (not a casual user) who had been using it prior to 2004. On the flipside, Excel and Word are so prevalent that they've now become the default "operating system" - window/OS X are secondary to those two apps.

My wife is a financial director. Her team uses Access all of the time to aggregate different sources of data together, including some legacy systems.

A couple of the senior people write queries and import routines, and the clerks/etc use them in their workflow. Works great.

I have clients in the health insurance industry that use Access all the time. These are not devs, but rather business analysts. Datasets become to much for Excel, and many learn basic sql.