Advantages of MS Access
The first advantage that comes to mind is how familiar the interface is to most users. The Office 2007 interface style is familiar, so users who have other Office products will not be lost when dealing with Access.
There are two ways to view the database, no matter whether you are creating a new one or opening something existing. The data view and the design view make it easy to set up Access and start using it. You can enforce discipline when entering data through the data entry forms. All kinds of rules to make sure you enter the right kind of data can be implemented.
Access has become an industry standard in desktop use and the database engine is quite powerful. Integration with voice recognition features makes data entry and menu navigation quite easy. There are a large number of templates, including the ones you can download online, which makes creating new databases quite easy. The ability to customize them not only lets you get productive quickly, but you can also adjust things to fit your specific needs. Connectivity options are a strong asset; Access databases can connect to Excel tables, ODBC connectors, SQL Servers, and SharePoint Services sites for live data. Tables created in these sources can be linked and used for generating reports. These reports then give y
ou a better view/analysis of your data. Data harvesting from a large number of e-mail addresses is possible too.
Multiple reports can be created for the same set of data. You are able to use the grouping, sorting and filtering options to get more perspectives on the same data. Real time previews let you create the different versions of the report that you may need for various audiences.