Hey,
Going by the high level description that you have shared, I can tell you that the requirement could be full-filled through macros written either in Access (like Access Forms) or Excel (like userforms). Queries can be made dynamic as well such that if they need some specific data points (like in 'where' clause) but rest of the query remains constant, you may not have to write them all over again.
If you could share some more detailed requirements, I would certainly be able to help you by creating an automated system that will work on click of a few buttons rather than entering data/queries etc. manually.
Please note that since the requirements are not clear, I have made the bid for a placeholder amount, I would be able to provide appropriate quote once I have the full details.
Please let me know if you would like me to work on this project for you and we may discuss the details.
Thank you for considering my bid.
Regards,
Rishi
(Automyze Consulting)