Download the Fall_2019 database posted in the Access and Data Analytics Test Module under CONTENT on BeachBoard. 2.Ensure that primary keys are set and establish appropriate relationships among the ta

Download the Fall_2019 database posted in the Access and Data Analytics Test Module under CONTENT on BeachBoard. 2.Ensure that primary keys are set and establish appropriate relationships among the tables: Stores, Vendors, Purchases, and Purchase_Items. Stores and Vendors should be linked to Purchases. Purchases should be linked to Purchase_Items. 3. Prepare the following queries, naming the queries qa, qb, qc, qd, corresponding to the identifying letters below: 

a. Use the purchase_items table to calculate the dollar amount of each item purchased in an extension query; name your new calculated field purchase_item_amount and format it appropriately. 

b. Use qa and the purchases table to sum the purchase item amounts for each purchase in an accumulation query; include all fields from the purchases table and the purchase_item_amount field from qa; name your summed field purchase amount and format it appropriately. 

c. Use qb and the vendors table to sum the purchase amounts from each vendor in another accumulation query; include vendor number, name, city, and state; name your summed field vendor purchases and format it appropriately. d. Use the qb query. Keeping all fields from qb, calculate the month of the purchase; name that field purchase month.