how to open and see data in Tables of MSSQLServer Database

Hallo everyone
Now I have to analyse so many Software systems that my company is using and I have to extract the Datamodels behind these systems.
One of these systems is developed with a MSSQLserver backend. Now I have to open this server tables and see the table structures and data directly how we see in Access.
Please help me by telling the way to open this database.
any help is very much appreciated.

thanks in advance.

Kiran Karnati.

Enterprise Manager

Thank you Mr Doug some of my friends also told that it is posible to see the tables in Enterprise Manger but I really don't know how to use the entertprise manager and so on...

so can you please give me some more information ?

thank you.

kiran Karnati.

Open Enterprise Manager. Click help. There is an entire chapter on EM in the SQL Server Books Online.

You can open all the table structures by going into enterprise manager and expanding on the tree structures. The order goes something like this:

Console Root --> SQL Server Group --> ServerName --> Databases --> DatabaseName --> Tables --> Tablename

ServerName, DatabaseName and TableName are specific to your server. Once you're displaying all the tables, right-click on a table and a popup menu will display. This popup menu has all the options that you need. To display/edit the table structure, select "Design Table" from the popup menu. To display the table data, select "Open Table" from the popup menu and then select how many rows you would like to see (or all rows).