Microsoft (MS) Access and SQL are different database applications with pros and cons. But, instead of choosing between them, you can, as it turns out, make them work together.

How to: MS SQL to MS Access. Microsoft Access provides tools that make it relatively easy to load data from a variety of external data sources and in many different formats.