Welcome on SSC 🙂

No, it's not possible to create Forms like in Access with SQL Server. You can create reports with Reporting Services.

To create forms use a client-side technology like .Net (C#/VB.Net/...) or MS-Access.

Flo