How to solve

Objective

In this project, we are going to practice using MS Access to practice how to run SQL queries that help transform data into

information to support managerial decision making by retrieving data from multiple tables.

Task

You are given a database in a MS Access file called $\text{'}$DBP$-$e$14-$Cape$-$Codd' that contains data collected in an outdoor sports retail

store. The retail store hired you as a data analyst to answer questions in order to help them make business decisions that will

help them grow.

For each of the queries listed, save your query and write down your SQL statement in the corresponding cell.

Number your answers corresponding to the query number.

Once completed, upload your assignment in MS Word document file and $.$accdb file to Blackboard.

Please submit each file separately. Do not put them in a zip file!

$($to help you answer these questions, you shoud practice running the practice SQL queries shown in the videoes$).$