First you need to connect to SQL Server. You can use Enterprise Manager in SQL 2000 or Management Studio in SQL 2005. First create a database, then create tables in the database. You can also use Server Explorer window in Visual studio. It is not the same and with same posibility like the one that cames with SQL Server but for creating and viewing is good enough. In VS you need again connection to SQL Server engine, and then to create database and database tables.
here are some web sites for beginer tutorial , also take a look at SQL Server Books Online which will gives you idea about everything you wants to know about SQL Server.
Hemantgiri S. Goswmai