Thanks for posting your question in the Microsoft Q&A forum.
SQL Server Express edition is the free, entry-level version of SQL Server that can be used for production environments without any licensing costs.
The only limitations of the Express edition are the database size (10GB) and some advanced features that are not available. However, for a medium-sized company migrating from Access, the Express edition should be sufficient
Please don't forget to close up the thread here by upvoting and accept it as an answer if it is helpful