Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Match Each Application Control with the field that it should be applied to prevent data errors to occur. The Moose Wings Cooperative Flight Club owns
Match Each Application Control with the field that it should be applied to prevent data errors to occur.
The Moose Wings Cooperative Flight Club owns a number of airplanes and gliders. lt serves fewer than 2,000 members, who are numbered sequentially from the founder, Tom Eagle (0001), to the newest member, Jacques Noveau (1368). Members rent the flying machines by the hour, and all must be returned on the same day. The following six records were among those entered for the flights taken on September 1, 2010: Valid plane codes (plane used column): C = Cessna, G-glider, L = Lear Jet, P = Piper Cub) Flight Date Plane Takeoff Landing Record | Member #IMM/DDAY Used | time | time 8:46 8:49 10:23 5:42 1:59 12:43 12:2915:32 15:31 13:45 1234 4111 1210 0023 012A 0999 9/10/2010 9/1/2010 9/1/2010 9/1/2010 9/1/2010 9/1/2010 6:25 4 3:42 Match Each Application Control with the field that it should be applied to prevent data errors to occur. a. Landing Time b. Member # C. Flight Date d. Takeoff Time e. Plane Used Data Validation 3 Settings Input Message Error Alert Validation criteria Allow: Whole number Data: between Minimum: Ignore blank Maximum: 1368 Apply these changes to all other cells with the same settings Clear All Ok Cancel IF(AND(A4 0,A4Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started