How to create a table in access and automatically fills it with information from a query?

Is it possible if I create a table that will lookup for a value filtered from a query (consult), in this case is duplicated "Name"s from a Employees registring table and automaticly fills up that number of registers, then the only thing that I need to change is the values of other fields I made in this new automatic-table?