I don't have access yet to Visual Studio 2010, but am curious about the different ways how one can open VS 2010 and the different possibilities with each of them.

What I understood is that there are several ways:
1) All local: Visual Studio, SQL and Microsoft Test Manager.
2) Team System Web-Access
3) Windows Sharepoint Services
4) Microsoft Office Sharepoint Services

Am I correct that are the ways to connect to Visual Studio?

What are the possibilities of each way of connecting?
I'm mainly interested in adding manual test cases, running them and adding the results and viewing those results.