Question: need help for this ASAP Leave yoru email so that I can send the file. I've been staying up all night for this. Thanks! Now

need help for this ASAP
Leave yoru email so that I can send the file. I've been staying up all night for this. Thanks!
Now that the data is cleaned, we are ready to do some analysis. Initially, we'll create some queries to help explore the data and answer questions that are most easily done in Access rather than Excel. Be sure to use the new tables you created. Do NOT use the imported data we want you to do joins. Save the queries using our usual WAFE naming scheme 1. How many bird strike incidents occurred to each Airplanes and Helicopters. Not that the data also contains some blank aircraft types as well as C. Your result should have two rows, one for Airplanes and one for Helicopters 2. Which airline had the most bird strike incidents? Exclude "UNKNOWN" and MILITARY" from your analysis, i e., find the airline other than UNKNOWN and MILITARY. Display the airline name only 3 of 5 3. Count the number of airlines which had bird strike incidents during either the "Approach" flight phase or the "Climb" flight phase but not both. Hint: Use this as your criteria for the field Flight Phase Approach" OR "Climb" as your first subquery. Afterwards it is easiest to use a set-complement query where you subtract the airlines that had both kinds of incidents.. 4. How many airlines had a bird strike incident during the "Approach" flight phase but not during the "Climb" flight phase. Some airlines may have had incidents during various phases of flight. In this query, we only want to count those airlines that had incidents during "Approach" and no incidents during "Climb". Of course, if they had incidents during "Approach" and "Landing" it would count as long as it did not also have an incident during "Climb". Be sure not to double count any airlines 14 Now that the data is cleaned, we are ready to do some analysis. Initially, we'll create some queries to help explore the data and answer questions that are most easily done in Access rather than Excel. Be sure to use the new tables you created. Do NOT use the imported data we want you to do joins. Save the queries using our usual WAFE naming scheme 1. How many bird strike incidents occurred to each Airplanes and Helicopters. Not that the data also contains some blank aircraft types as well as C. Your result should have two rows, one for Airplanes and one for Helicopters 2. Which airline had the most bird strike incidents? Exclude "UNKNOWN" and MILITARY" from your analysis, i e., find the airline other than UNKNOWN and MILITARY. Display the airline name only 3 of 5 3. Count the number of airlines which had bird strike incidents during either the "Approach" flight phase or the "Climb" flight phase but not both. Hint: Use this as your criteria for the field Flight Phase Approach" OR "Climb" as your first subquery. Afterwards it is easiest to use a set-complement query where you subtract the airlines that had both kinds of incidents.. 4. How many airlines had a bird strike incident during the "Approach" flight phase but not during the "Climb" flight phase. Some airlines may have had incidents during various phases of flight. In this query, we only want to count those airlines that had incidents during "Approach" and no incidents during "Climb". Of course, if they had incidents during "Approach" and "Landing" it would count as long as it did not also have an incident during "Climb". Be sure not to double count any airlines 14
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
