I was asked to create a database and based on the information I was given assumed that it would be used for storing data and would be used by multiple people. Now I'm realizing that's not the case. I'm the only person using the database and I'm using it to import Excel spreadsheets, run queries on the data to modify it or convert it, then export back to Excel. I'm wondering now if I should stop working on this database and switch to something else (e.g. Power Query/Pivot).
Things I'm doing in Access that I don't know if can be done with something else better or easier:
Outer/Inner joins on multiple tables using = and Like operators, update queries, union queries, totals queries
Since I don't need to store data or have a user interface, it seems like I should keep the data in Excel (or use something else) but I don't know if Excel has the functionality that I need. The most records that I process in Access at once is about 20k. Access works very well for what I've created so far and my tasks are mostly automated, but each time I need to create a new query or edit an existing query or write code I start thinking there must be an easier to use tool available.