I have created an application in c#.
Following are my concerns.
1) create setup file which includes the ms access db
2) identify the location where this db will be stored
3) use this location as the data source for the application
@deceptikon: As you may have noticed in all my posts, I'm no pro in whatever IT subject here, so connecting to the few "play" DB's I ever set up, it was through VS. I'm aware that databases are a major topic in IT, so if I ever find the time I would certainly like to learn more.
I would agree with deceptikon. Once you get into enterprise level systems, you wouldn't want to use the UI ;)
A better idea is to have two SQL Connection Strings in your app.config (or whatever configuration file you use) and then use those at run time. If you want to play with the database at design time, then you can connect to the SQL Server manually in the data view and run your queries in Visual Studio rather than SQL Server Management Studio :)