I'm currently using Access 2010. I want to give sql server a try but OI have no idea where to start. So far I've downloaded and installed: sql server express which 0nly has the database engine. So far with that I see no interface to create forms or anything, only a configuration and an import/export tool. So I downloaded and installed one of the others but not sure which one. I got this from this site: http://www.microsoft.com/en-us/sqlserver/editions/2012-editions/express.aspx
I have no idea where to begin and what I need to download.
Hopefully someone can point me in the right direction.
Also, SQL Server is not a tool to create forms, or any sort of UI, as you can in Access. You can continue to use Access for the front end if you want, but eventually you'll probably want to move on to something better suited, like Visual Studio.