The resolution on the small screen is extremely high so it depends on your eyesight (seriously). I'm in that borderline region of having to wear reading glasses, so there comes a point where high resolutions on small screens become an issue.
So I think your question related to MS Access is more about screen real estate rather than processing capability. With 8GB RAM MS Access works just fine (FYI, I deal with BI tools, SQL Server, Oracle and Teradata).
Had a Galaxy Note 12.2 (still have a 10.1). Returned the 12.2 (no regrets). The 10.1 is collecting dust as the SP3 just works. The Macbook Air has also not been used in weeks (which truly shocks me - I have to admit).
Never been a Jihadi about hardware, operating systems, etc. They're just tools to me and if they work for me I use them. If they don't, well....... they collect dust then get sold.
I'll be the first to state I prefer Mac OSX over Windoze. Just a personal preference (I think UNIX is better for me). However, MS really caught my attention with the SP3. Enough so that I'll put up with Win 8.1 as the hardware features far outweigh my personal OS biases/preferences. My
REI BlackDiamond Bullet Daypack Backpack feels almost empty now with the SP3 in it. No need for any other hardware (ipad, Android tablet, etc).