Create database and table/ Queries and Report. More in Details
Create a database and save it to your desktop. Name the database file including Your name – United States. Using Table Design, name the first Field as Name of State or Territory. Set this as the primary key and set the data type to short text. Name the second Field State Abbreviation. Set the data type to short text.
Switch to datasheet view. In column 1, type 50 state names, one per row. Add the District of Columbia in this column. In column 2, type the state abbreviation for each state. District of Columbia has the abbreviation of D.C.
Check your spelling in the table.
Save the table with the name State Abbreviations.
Close the table and database.
Import the State Abbreviation table from the database that you just created into the database United State
Download United States. Download the United States database in a new window.
Create a relationship between the table’s United States and State Abbreviation. Drag the linking field designated as the primary key to its mate in the other table.
Create a relationship between the tables State Abbreviation and State and District Capitals. Drag the linking field designated as the primary key to its mate in the other table.
| Open the GNP table, it lists the annual Nominal Gross Domestic Product of each State and Territory of the U.S. for the years 2020 and 2019. | ||||||||||||||||||
| The GDP data does not reflect the fourth-quarter 2020 GDP totals, but rather the annual totals. | ||||||||||||||||||
| The raw GDP data is measured in Millions of U.S. Dollars | ||||||||||||||||||
| -Calculate the GDP change between 2020 and 2019 for each state and territory using a formula. Name the column Absolute Change | ||||||||||||||||||
| Download Absolute Change. | ||||||||||||||||||
| -Calculate the change between the years 2020 and 2019 as a percentage showing 2 decimal places for each state and territory using a formula.
Name the column Percentage Change |
||||||||||||||||||
