> For the complete documentation index, see [llms.txt](https://help.iviva.com/lucy/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://help.iviva.com/lucy/my-work-folders/databases/editing-data-in-a-database.md).

# Editing Data in a Database

In Lucy, tweaking data stored in a database is pretty straightforward and achievable in few simple steps.

This involves updating existing records or removing unnecessary data maintaining data accuracy, system efficiency, and adaptability, ultimately supporting informed decision-making and data integrity.

## <mark style="color:blue;">Editing Data in a Database</mark>

To edit data in a database:

1. On the Lucy app **homepage**, go to the **My Work** tab on the sidebar.
2. All the folders you have created, as well as those created by others, will be listed.
3. If you cannot locate the folder in the list, type in the folder name under **Search Folders.**
4. Click on the folder you wish to open.
5. Go to the **Databases** tab.
6. Search and click on the desired **database**. Your database will be opened in a spreadsheet view.
7. Click the **Edit** button to enter the edit mode in the database.
8. Enter your data.
9. As soon as you enter data, the change will be saved. It will show a green tick once the edit is done.

## <mark style="color:blue;">Deleting Data Records in a Database</mark>

To delete existing data records in a database:

1. On the Lucy app **homepage**, go to the **My Work** tab on the sidebar.
2. All the folders you have created, as well as those created by others, will be listed.
3. If you cannot locate the folder in the list, type in the folder name under **Search Folders.**
4. Click on the folder you wish to open.
5. Go to the **Databases** tab.
6. Search and click on the desired **database**.
7. Select the data records to be deleted.
8. Select the checkboxes next to the data records you want to delete.
9. Click **Delete Selected**.
10. Click **Confirm** to confirm the deletion. The selected records will be deleted from the database.
