The vegas tours souvenir shop is where las vegas bus tours start and end, seven days a week. the shop sells a variety of vegas souvenirs to customers who take the tour and to those who simply want to purchase souvenirs, either in person or online. managers have been using an access database to keep track of customers, products, and transactions. you have been given some sample sales data from february 2018. managers have asked you to create queries that will them manage their business more efficiently.

start access. open the downloaded access file named a03ch07_grader_a1.accdb. save the file with the name a03ch07vegastours_lastfirst using your last and first name. if necessary, enable the content.

create a query in design view based on tblpurchase and tblpurchaseline that displays the purchasedate, productid, and quantity fields (in that order) and shows the total of each product sold on a particular date.