For the linked table approach. Make a Union query in Access.
Select EmployeeID, CustomerID, Address From LinkedTable1
Select EmployeeID, CustomerID, Address From LinkedTable2
This should do what you are asking for. The All part of the union brings in records that might be the same in both tables. If it could happen that the same records are in both tables and you don’t want both of the records, take off the All clause.