Simplest means to develop relational database for SQL Server
===

For those of you have have experience of this, what particular tools would you recommend? 

 - MS Access 
 - MS Visual Studio 
 - SQL Management Studio
 - etc?

For use with SQL Server 2008 R2 as part of an online booking system with multiple tables and relationships, and incorporated into an ASP.Net site.