I agree with the database idea- although you probably don’t want to reinvent everything if it is now (almost) working
MSAccess is problematic, particularly with 64bit operating systems
I have successfully used Dynamo with the free version of SQL server (used to be called SQLExpress, think it is something different now)
The joins/lookups of data would probably be much easier in an SQL query.
You can easily link the SQL tables back into MSAccess or Excel for reporting.