PLEASE HELP , will hundred percent reward 100% thumbs up like, completed through access.

https://drive.google.com/open?id=1O5RJGUdghmIt1occequyp8QWRO3pSuZb

ABOVE IS THE SPREADSHEET DATA NEEDED FOR CREATION OF THE ACCESS TABLES^^

Requires you to build a relational database in MS Access based on the attached spreadsheet file (IS.xlsx). The spreadsheet contains two workbooks: An OrderSummary workbook and a EmployeeSkill workbook. Create an MS Access file based on these two workbooks and complete the following tasks (the same instructions are provided in the third workbook in the excel file):

DBMS Assignment:

1. Create all necessary tables based on the entities identified in each of these two workbooks.

2. For each table, set the appropriate data type for attributes and specify the primary key.

3. In the Relationship window in Access, connect tables derived from each workbook by setting up foreign keys and enforcing referential integrity. Note that some table(s) may participate in more than one relationship.

4. In the same relationship window, connect the tables from OrderSummary workbook with tables from EmployeeSkill workbook (so that all tables are connected).

5. In either step 3 or step 4 above, you may run into an error caused by a data point violating the referential integrity, identify the data error and update the value with the nearest value from the associated parent table.

6. Create a query in Access named HW3_Query1_Orders to show the detailed information of all orders (i.e. the first 18 rows of the original OrderSummary table with all columns).

7. Create a query named HW3_Query2_Orders&Customers to show the entire original OrderSummary workbook (all rows and columns).

8. Create a query named HW3_Query3_OrdersByCust1&2 to show all orders placed by customers 1 and 2.

9. Create a query named HW3_Query4_AvgPricefromFL to show the average price of all products ordered by customers from FL.

10. Create a query named HW3_Query5_Supervisedby9002 to show the information of all employees supervised by Employee 9002 and their supervisor's information (i.e. ID, name, hiredate and title)." So essentially this query will require you to show the same employee related columns twice, first for the employee, then for their supervisor.

11. Extra credit (optional): Create a query named HW3_Query6_ExtraCredit to show the total dollar amount of all orders in charged by employees supervised by 9002.