IFSM 300

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 also  Field Properties | Format | Standard
Change the other currency fields to remove the two cents.
Change the area field to one digit after the decimal point.

Us the same state you did for the Excel 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, 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.