and a table like:
and I want to return a table that includes all of the names from tbl 1 but that does not include any names in tbl 2.
You need to create a query where you join the Name field from both table so that all the records from table 2, and only those in table 1 that are equal. You can use the find unmatched query wizard in Access or do this:
FROM tbl1 RIGHT JOIN tbl2 ON tbl1.[Name] = tbl2.[Name]
WHERE (((tbl1.[Name]) Is Null));