Is there a way to generate a map of the existing tables and their relationships to each other?

Access has something like this where you view all the relationships between the existing tables, displayed as lines connecting them: keys, 1 to many, etc. I can't find anything in ss2008 - I'm very new to it on top of that. Any help would be appreciated.

How do I map relationships in Excel?

Right-click a table diagram, and then click Create Relationship. The Create Relationship dialog box opens. If the table is from a relational database, a column is preselected. If no column is preselected, choose one from the table that contains the data that will be used to correlate the rows in each table.

open up the database folder for the database that you are interested in, click on database diagram, click on yes when a confirmation box pops up right click on database diagrams and select new database diagram

Pick all the tables you want, click add and a diagram will be created

Now you can save the diagram, give it a useful name and it will be available next time you want to look at it