Horizontally merge (combine, match, union) two Access tables into one by a common column (field) of data.

The two tables can be located in the same Access file or two different Access files.

The two tables are not changed, a new table is created with the results.

No complicated options or SQL knowledge required.