The data manipulation tools are the part of the database the user interacts with most of the time. Data manipulation consists of a number of activities: The user will have some way of viewing all of the records in the database. She will probably also have a way to add or delete records, and edit the fields of existing records. There will usually also be ways of sorting the records by any field in ascending or descending order.
Often there will be large spreadsheet-looking devices on the screen that allow you to manipulate records. These are quite hand if you want to compare a lot of records at a time, but they can be quite intimidating. Most DBMS systems have a way of using and creating forms for user input.
A form simply displays one record at a time in a less cluttered form on the screen. If you have to do a lot of data entry, you will appreciate well designed forms.
Data manipulation is related to input When you use this kind of
tool, you are somehow inputting information to the system.