如何插入从另一个表提取的表记录

I'm trying to write a query that extracts and transforms data from a table and then insert those data into another table. Yes, this is a data warehousing query and I'm doing it in MS Access. So basically I want some query like this:I'm trying to write a query that extracts and t