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 > Select Query

1. Click on "Queries" found under "Objects" in the left column of the database window. Then, double click "Create query in Design view."

2. Select "lowell_p_top200_tutorial," then click "Add." Click "Close."

3. Select all columns except "puma5." This can be done by clicking on the first field under the asterisk. Then, while pressing the "Shift" key click on the last field in the list. This selects all fields. Now eliminate "puma5" by holding down the "Ctrl" key and clicking on "puma5." This action unselects just "puma5." Now click and hold the left mouse button on the list and drag and drop it at the first column in the empty data table.

Now we will query this data table for all records of persons 25 and over. Scroll over to the age column and next to criteria type in ">= 25." Click the "!" button at the top. This will "Run" your query.

4. Check the number of the 25-year-old or older people. It should be 118.

5. Save this query as "qr_sample_p." This can be done by closing the query and saving or choosing File->Save.

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