> Access works best when combined with a bunch of VBS/macro scripts...
You're thinking of Visual Basic for Applications (VBA), which is interpreted inside of Access. The standalone Visual Basic Scripting (VBScript) is a completely different thing, and eliminating VBScript doesn't have any ramifications for Access.
Ugh, yeah. VBA not VBS. I'd like to say "the keys are right next to each other", but the truth is I've been in both those worlds for far too long...