It's still hard to beat Access as rapid application development environment for building data entry forms. If your access tables are properly normalized and have proper keys you can import the tables into SQL Server, create linked tables in access and then bind your forms to the linked tables with a minimum of effort.

It's a reasonably low cost solution for small to medium amounts of data/users. This setup can get a bad reputation because often poorly designed access databases get 'upsized' to SQL server.

I would evaluate your design before moving to SQL Server. If possible import your tables into SQL Server, generate DDL and start a new thread here asking for an evaluation of your database design.