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.
  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.

Use the same state that you used for the Excel counties assignment.
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, sum of income,
and number of counties of your state.

Print the results of a query that shows the sum of pop, sum of area, sum of income,
and number of counties for each state.
(i.e. Group By state)

Print the results of a query that shows the sum of pop, sum of area, sum of income,
and number of counties of the country.

Print the results of a query that shows county names that are in 15 or more states.