MS Access provides a huge range of functions some of them are
• It is used by small business, departments of large corporations, and
by amateurs to create applications on their desktop for data
• Access is very useful for small web based database applications hosted on IIS and using ASP.NET pages.
• It can be used as a RAD for building prototype and Stand alone applications.
• Access can be used as a frontend while the backend can be a ODBC compliant product.