IDE use a graphical interface. The users do not create database applications manually. They use the graphical interface of IDE to enter specifications of the required application. The IDE automatically build the application. The details of database creation are hidden from the user. A user does not require detailed knowledge of the database system to create database applications.
Ms Access is a popular integrated development environment. It is used to communicate with databases for manipulating data.
Some advantages of IDE are as follows:
It is easy to use.
It simplifies the creation of database applications.
It does not require a detailed knowledge of database.
It provides predefined facilities to search, sort, retrieve and process data in database.
It also provide facilities to create an attractive user interface with menu, buttons text boxes etc.
IDE uses graphical interface. It requires more memory and processing power.
Some IDEs don't allow users to interact with the database directly.