SQL Server Express is just a (fairly generous, last I looked!) limited version of the full SQL Server.
So, it's a substitute in terms of affordability. But absolutely not in terms of "rapid GUI application development" for the non-programmer.
It is not. Access was easy to build the app on top of a reasonable database seamlessly, integrated, visually. SQL Express is just the database part and there is nothing that integrates so well on it like Access does internally. Access is not powerful enough for larger databases, but boy it was easy to use for small ones.
I've never used Access so apologies if you're looking for more than a GUI-driven interface to the DB.