Using Excel as a database

Good morning.

I currently have an Access database that holds just over 17,700 records.  Since I have come up against shortcomings of Access (pivot tables, maximum calculated fields, etc), I have been using Excel to view the data using Power Query.  This has worked really well, except for one problem.  Every time I need to make a change to a record, I have to go to Access, find it, change it, go back to Excel, and refresh.  If I find data that is missing, I have to take that and enter it into Access, then go back to Excel and hit refresh.  Same for "retired" products that need to be marked as such.

Is there a way to this all in Excel (store, edit, and add data)?  I have looked at trying to create custom views so that I could have a worksheet that just shows a certain product with its specific columns, but I have found nothing.  I suppose I could create macros on the backend that would hide and show columns and apply filters, but I do not want to make it too complicated.

I have using Excel M365 on Windows 10.

Thank you!!