How can I add columns from one table to another in Microsoft Access 2007?

This is probably very basic, but I've been struggling over the last couple of hours with it:



I have two tables in Microsoft Access 2007. Table 1 has ~200 people and Table 2 has about ~100 people. All of people in table 2 are also in table 1. Each person has a unique identifier.



I want to expand Table 1 to include data that is found in columns in Table 2.



The tables could be referenced by their common identifiers.



Thanks!How can I add columns from one table to another in Microsoft Access 2007?
use a view that combines the two tables.