My office is (finally) migrating from an MS Access database solution for our website to MS SQL Server.
Currently, a lot of content owners update their pages by opening the MDB file in the Access desktop interface, then adding rows of data. My question is, with MS SQL Server, do you still have a database file that can be edited without the user knowing SQL (i.e. is there some sort of interface) or will there be some other way to update the data (like importing Excel files, or the old Access MDB files)?
Other than Access, I only have MySQL experience, so I have no idea how MS SQL even works.