Massachusetts Institute of Technology
Department of Urban Studies and Planning

11.220 Quantitative Reasoning and Statistical Methods for Planning

MS-Access

HOME   |   TEST-OUT   |   BRUSH-UP   |   MATERIALS

MS-Access > Join

1.On the main 11220db window click "Queries" in the left column and then double-click "Create Query in Design View." Add the "lowell_h_top200_for_tutorial" table, then click on the "Queries" and add the "qr_sample_p" query. Close the "Show Table" window. Go to File->Save and name this query "qr_sample_p_and_h."

2. Create a "join" by clicking on "serialno" in the "qr_sample_p" query variable list and drag-and-drop it onto "serialno" in the "lowell_h_top200_for_tutorial" variable list. A line is drawn to represent the linking fields. Select all fields except "serialno" in the "lowell_h_top200_for_tutorial" list (as described in "Select Query" tutorial) and drag-and-drop them into the data table. You must scroll to the right when adding the second dataset and drop it in the first blank column.

3. Now click the Run button (looks like !) and view the data in Datasheet View. One housing unit may have multiple people as shown by multiple records with the same serialno. Save the query with File->Save.

Created by Myounggu Kang on January 25, 2004. Edited by Rhonda Ryznar on January 19, 2005.