There are ways to accomplish all of this without proprietary Microsoft database features.

After 30 years of marketing-driven Microsoft trying to force my assimilation, I'm more than just a little skittish about putting my neck (and therefore my customers' necks) in that noose.