He could try running BootCamp or Parallels Fusion to run Access.
Then play around with the Mac alternatives and see if it improves his process in some other ways.
The Windows compatibility will be a bridge to experimenting with another platform.
But for intensive IO and CPU tasks like database, I'd go with a MacBook Pro instead of a MacBook Air. Heavier but you get more bang for the buck.