MS Access is appropriate for smaller databases. But there comes a time when you need either more reliable data stability, have more data than MS Access can handle efficiently, you want to add web or mobile connectivity to the data, you are ready to move from MS Access as a front end user interface, or you need the more advanced query handling capabilities and tools available with SQL Server.
The most compelling of these reasons is multiple occurrences of any repetitive reason of is MS Access