Hello, I need assistance in gaining an explanation and answer for a Microsoft Access assignment.
Need help with this assignment?Get an original answer from a qualified tutor — from $10/page.
Get it written →Hello, I need assistance in gaining an explanation and answer for a Microsoft Access assignment.
I will be attaching below the instructions for the first part of the question. (Please provide separate reports for each question)
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 Download Percentage Change. |
||||||||||||||||||
| -Sum the GDP revenue for the year 2020 at the bottom of the 2020 column. | ||||||||||||||||||
|
-Sum the GDP revenue for the year 2019 at the bottom of the 2019 column. Save the database file on your desktop keeping the name the United States. |
||||||||||||||||||
I will attach the Access reports needed to complete and Word documents for the other links mentioned. (Please keep in mind the Access reports will be provided in PDF format and the answer will need to be provided in an Access format unless provided instructions on how to convert from Excel to Access)
Assignment Part 2 will be provided below (Reminder: Please submit both answers in SEPARATE reports)
Download in a new window the United States.accb file created in the last assignment.
Create a query to list the State Name, State abbreviation, and State Capital for the state of New Hampshire. Name the query State Inquiry.
Create a report listing all the State Names and Territories and their abbreviations. Name the report: Abbreviations for State Names and Territories.
Please let me know if more information is needed or clarification. Reminder you will need Access to the Microsoft Software/platform (Access) to complete. Simply follow the provided instructions to complete the question.
Get a plagiarism-free answer to this question
Send us your instructions and we’ll match you with the best writer in your subject.
- 100% human-written, zero AI
- Turnitin report included
- Confidential — we never share your data
- Free revisions & refunds