Enhance the Sales Transactions database file to perform a database query that finds the transaction code and amount associated with any customer ID input. Apply your results to customer ID 10029.
Tools Data Window Help 61% C+ Wed 10:22 PM Q E SalesTransactions View ExcelFile Edit View Insert Format O AutoSaver BESU: Home Insert Draw Page Layout Formulas Arial 12 A A Poste BIU D YA D1 x fix Data = Review = Wran Text Merge & Center Custom % -% Share Comments EYO Su 2 Sort Find & Ideas Sensitivity X V Filter Select Delete -13 Conditional Format Formatting as Table Cell Styles Format J K L M N O P Q R S T U V W 1 Sales Transactions: July 14 9.09 5:05 10 3 Cust ID Region Payment Transaction Code Source Amount Product Time Of Day 10001 EastPaypal 93816545 Web $20.19 DVD 22:19 10002 West Credit 74083490 Web S17,85 DVD 1327 10003 North Credit 61912368 Web $23.98 DVD 14:27 10004 Wesl Paypal 70580957 Email $23.51 Book 15:38 10005 South Credit 35200917 Web $15.33 Book 15:21 10006 West Paypal 20978903 Email $17.30 DVD 13:11 10007 East Credit 80103311 WebS177.72 Book 21:59 10008 West Credit 14132683 Web $21,76 Book 4.04 10009 West Paypal 40128225 Web S15.92 DVD 19:35 13 10010 South Paypal 49073721 $23.39 DVD 13:26 14 10011 South Paypal 57398.827 Email $24.45 Book 14:17 15 10012 Eas! Credit 34400861 Webi $20.39 Book 1:01 16 10013 North Paypal 54242597 Web $19.54 DVD 10:04 10014 East Credit 62597750 Web S151.67 Book 10015 West Credit 51555882 Web $21.01 DVD 10016 West Paypal 54332864 Web $22.91 DVD 20:29 20 10017 West Credit 28823353 Email $19.51 Book 15.03 21 10018 West Paypal 79594431 Web $20.16 Book 18:54 22 10019 West Credit 89385348 Web $17.53 DVD 20.00 23 10020 West Credit 89088417 Wets $17.74 DVD 12:37 24 10021 North Paypal 59660276 Email $17.16 Book 5:05 10022 West Credit 25456590 Web S205.58 Book 20 42 26 10023 South Credit 93283293 Email $16.12 Book 10:12 10024 West Credit 45991123 Web $20.04 DVD 1627 28 10025 Wesl Paypal 79121745 Email $23.21 DVD 2022 29 10026 West Credit 80695117 Email $22.79 DVD 19:59 30 10027 West Credit 56686474 Web $16.91 DVD 19:44 10028 South Credit 25270813 Wets $20.22 Book 19:28 10029 East Paypal 59736137 Web $18.36 DVD 15:48 33 10030 West Paypal 79615191 Email S206.80 Book 18:14 34 10031 North Paypal 55385094 Email $17.95 DVD 15:15 35 10032 East Credit 79118930 Web $18.29 Book 12:59 36 10033 South Paypal 84470584 WebS18.55 Book 1738 100 Wat adiZAAZADA Data + 26 2 H!! E - 100%
