That's the big difference between ACCESS and MS SQL SERVER.

MS SQL has no interface - it's purely a backend database. There is not "UI" like access for frontend.

Normally one would develop the frontend in VB (well at least most of the people on this VB forum would!).