I have become quite versed at Excel, but it's been many years since I've used Access.

I have an Access database with 2 tables that are linked to two different worksheets in an Excel file. I also have 3 query's that filters out specific data from the two tables, based on different criteria. Then there's 1 final query that pulls all matching records from the first 3 query's and then puts that data into a report.

To get the report to populate correctly, I have to open Access and:
1) update the linked tables
2) run the final query
3) and then run the report.

I need to set this up in other offices, and am trying to make things as simple as possible. Is there a way to automate steps 1-3? Any suggestions would be greatly appreciated.