Some important advantages of using Ms Access IDE are as follows:
Samples databases
MS Access includes samples database applications for users. These applications help the users to learn about real world tables, forms, queries and reports. The users can also understand the interconnection of these objects to form a database management system.
Wizards
MS Access provides many wizards to create a database easily. The user can choose the desired example from several examples of databases using wizard. These examples include contact information, inventory control and ledger etc. The user can also modify examples according to exact requirements.
Key to understand the structure
MS Access allows the user to view all relationships in the database graphically. The relationship window is used to display these database relationships. It makes the process of specifying relationships easier and quicker.
MS Office Integration
MS Access can be used with MS word, Ms excel and other Office applications data stored in Access database can be used to create mail merges, charts etc.
Easier Programming
MS Access provides the facility of easier programming. The user can use relatively simple code with macros to automate the repeated tasks.
Command Standard
It uses standards that enable applications to work in larger environments.
No Redundancy
It allows the user to store, retrieve, sort, analyse and print information stored in the database. It may be manipulate without redundancy by defining relationships between sets of data.