Creating Advanced SQL/TSQL Queries and Macros

I need some one to create some advanced queries for MS Access 2007 - 2010. I need a query that gets records from two or more link tables that share a relationship. The query gets the records and places the record in a new table, I will call the new table local table for simplicity sake. Than the query runs everyday at a certain time (designated) gets new records from the link tables and place them in the local table. Here is where it gets important. When the query runs daily, it updates any record that has been changed in the link tables, so if a person address changes, the address is updated in the local table. If there are no new records or updated records in the link table, nothing is brought over. If there are new records, they are brought over. Finally I need all the data queried from the local table exported as a CSV file to a specific directory or to a server via FTP. All this needs to happen sequentially, and automated using Macros. I need this clean and easy to understand. Lets get to work.