Visual Studio is an IDE for you to create applications and projects. You can create a database in it, use it in your client systems, allow users to work all through the Visual Studio.
But there is a better way of doing this. Go ahead, install SQL Server in your machine. You can use Express version that is free and you will get the understanding of the SQL Server. Access is not that much efficient while working with Internet based applications. Use SQL Server.
Secondly, you can then create an instance of your database connection, that connection string is used to connect to the databases, locally or remotely. Even if you're inside the SQL Database Management Studio, you will still be required to provide with that connection string. It is of this form generally
string connectionString = "Server= myServerAddress; Database= myDataBase; Trusted_Connection= True;"
Above connection string was captured from
this website[
^]. You can find more of these connection strings from that website.
Usually people set the authentication mode to Windows authentication thus the above connection string works. Otherwise you can set username and passwords too.
Try giving
this one article[
^] of mine a read to start your SQL database progress.
You can create user accounts from your SQL DBMS, you can then use a connection string on your client machine to work with the SQL. Visual Studio has nothing to do with this one. It is just an IDE and will be used for developmental process only, once developed it will be a job for your SQL Server to allow remote (since you're going to use the database from client computers) connections to your database and your clients will connect to the database on the server which you specify inside your connection string.