IFSM 201 Access Counties Create a table by importing from the counties2010.txt file. External Data tab | Text File runs the import dialogue. Click the checkbox to indicate the first row contains the field names. Change the type of the two money fields to Currency. Have the fips field be the primary key. There should be 3143 records. Create calculated fields for population density and for income: "income" is the product of population and percapIncome. "density" is the quotient of population and area. [SKIP: as you did in the Excel counties spreadsheet]. To specify the number of decimal digits: Field Properties | Decimal Places | 1 and, maybe Field Properties | Format | Fixed Change the other currency fields to remove the two cents. Change the area field to one digit after the decimal point. Choose a state from the list below (states with too few counties are not on the list) that no one else has already chosen (only one person per state, first-come first-served). Filter out all states but yours. i.e. Display just one state. Sort your state's counties in decreasing order of income. Print the first page of this. Print the results of a query that shows the sum of pop, sum of area, and sum of income of your state. Print the results of a query that shows the sum of pop, sum of area, and sum of income for each state. (i.e. Group By state) Print the results of a query that shows the sum of pop, sum of area, and sum of income of the country. **************************************************************************** Alabama Alaska Arizona Arkansas California Colorado Florida Georgia Idaho Illinois Indiana Iowa Kansas Kentucky Louisiana Maine Maryland Massachusetts Michigan Minnesota Mississippi Missouri Montana Nebraska Nevada New Jersey New Mexico New York North Carolina North Dakota Ohio Oklahoma Oregon Pennsylvania South Carolina South Dakota Tennessee Texas Utah Vermont Virginia Washington West Virginia Wisconsin Wyoming