I've been using Access as a front-end for Windows Azure SQL Database for a project for the Boy Scouts. It works well enough. You can get going pretty quickly. There are some odd behaviors when it comes to lookup values in drop down lists that I'm still struggling with (my Access days are about 20 years behind me), but it got most of the job done very quickly and easily, which was my requirement. It'll work great with SQL Server too.