I'm new to SQL Server and I have some questions about it.

First of all, I'm usually used MS Access DB.

The first question may sound studio but does the name SQL Server means it needs to be installed on a server ?

With MS Access, I could create small db and put it in the application folder but can I do this with SQL Server or for this I should continue using Access ?