Posted: February 25th, 2021
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.
Place an order in 3 easy steps. Takes less than 5 mins.