sql connection

I installed sql 2005. Enabled remote..enabled tcp ip connection..created db and gave login rights to a user will be extracting excel data to the new database.

how do I configure hime to access from his client machine? she will need to be able to create tables so…Do I install Management Studion on his machine?

Help! Thanks….