Hello, I need assistance in gaining an explanation and answer for a Microsoft Access assignment.
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.
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
