The Advantages of MS Access over MS SQL Server:

•  A method for generating relational databases that is efficient, simple, and accessible.
•  The learning curve for Access is not as steep as it is for other database management systems.
•  The user interface is similar to that of Microsoft Office.
•  Ability to create functional forms and reports
•  Make full-fledged data-centric apps with VBA.
•  Develop Office Applications That Work Together
• Easily share your databases
•  Templates and Wizards are readily available.
•  Send your databases to customers who don't have Access using Access Runtime.
•  There is an active user community and a wealth of learning materials available.

Read More: Explain The Technique Used To Increase The Size Of Ms-Access Database?