Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedMatch Each Application Control with the field that it should be applied to prevent data errors to occur.

image text in transcribedimage text in transcribedimage text in transcribed

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,A4

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Agile Audit Transformation And Beyond

Authors: Toby DeRoche

1st Edition

1032062894, 978-1032062891

More Books

Students also viewed these Accounting questions