Show all steps

Please create three queries, and three reports on four items in the template, do this three times. example of one All issues by specific color or brand or type-your choice then the veneer or strings problems then the remarks. EE Piano All Access Obje... ID Search. Tables Piano Building Shop Shop Shop Shop Shop Shop Location Front Back Back left Left Center Front Back left Front Back wall Back wall Left side Brand Serial Numb Color Cable Kinsbury 191972 Brown 2 Farband 6262 Dark Brown 3 Aeolian 82107 Dark brown 4 Aldrich 26365 Walnut 5 Kimball 912497 Walnut 6 Straube 9424 Brown 7 Lester Plano O Brown 8 Victor 32839 Dark brown 9 Farrand 25402 Dark Brown 10 Kranich and Ba 52874 Black 11 George P Bent 547 Dark brown 12 Richmond 28403 Red/Brown 13 Spinet 0 14 P.S. Wick 12379 Light Brown 15 Chickering 119222 Brown 16 Hammond 13082 Green 17 Foster O Brown 18 Junk 0 19 Junk 0 20 Walworth 7590 Red 21 Junk 0 22 Monarch 168898 Borwn 23 Schiller 10285 Chestnut 24 Wurlitzer O ??? Type Upright XP Player Upright Upright Upright Spinet Upright Upright Player Upright Upright Spinet Upright Upright Upright Upright Junk Junk Upright Junk Upright Upright Spinet Sound Board - Venier Good Small pieces missing Good Minor chips Good Chips Good Good Good Cracked, top broken, ornate Good OK, but bad finish Good Very dirty, paint Good Good Good Good Good Excellent Good Minor wear Good Bad finish Shop Strings Excellent, nori Rust Rust Excellent Rusty Good Good, some ru Some rust 1 missing, non Like new Minor rust Good S1 2 S3 S4 Shop Shop Shop Shop Shed Shed Shed Shed Shed Shed Shed Shed Shed Shed Shed Shed Shed Good Good ??? Good Good, scaling on top Bad, many problems Ornate, minor breaking Rust, all coppe Good, some ru Rusty, very dirt S5 Good Rusty S6 S7 S8 Good Parting, separated Rusty S9 S10 S11 S12 S13 ?? Good Good Good Good, clean int Excellent, some missing, ornate Good Poor Good Please create three queries, and three reports on four items in the template, do this three times. example of one All issues by specific color or brand or type-your choice then the veneer or strings problems then the remarks. EE Piano All Access Obje... ID Search. Tables Piano Building Shop Shop Shop Shop Shop Shop Location Front Back Back left Left Center Front Back left Front Back wall Back wall Left side Brand Serial Numb Color Cable Kinsbury 191972 Brown 2 Farband 6262 Dark Brown 3 Aeolian 82107 Dark brown 4 Aldrich 26365 Walnut 5 Kimball 912497 Walnut 6 Straube 9424 Brown 7 Lester Plano O Brown 8 Victor 32839 Dark brown 9 Farrand 25402 Dark Brown 10 Kranich and Ba 52874 Black 11 George P Bent 547 Dark brown 12 Richmond 28403 Red/Brown 13 Spinet 0 14 P.S. Wick 12379 Light Brown 15 Chickering 119222 Brown 16 Hammond 13082 Green 17 Foster O Brown 18 Junk 0 19 Junk 0 20 Walworth 7590 Red 21 Junk 0 22 Monarch 168898 Borwn 23 Schiller 10285 Chestnut 24 Wurlitzer O ??? Type Upright XP Player Upright Upright Upright Spinet Upright Upright Player Upright Upright Spinet Upright Upright Upright Upright Junk Junk Upright Junk Upright Upright Spinet Sound Board - Venier Good Small pieces missing Good Minor chips Good Chips Good Good Good Cracked, top broken, ornate Good OK, but bad finish Good Very dirty, paint Good Good Good Good Good Excellent Good Minor wear Good Bad finish Shop Strings Excellent, nori Rust Rust Excellent Rusty Good Good, some ru Some rust 1 missing, non Like new Minor rust Good S1 2 S3 S4 Shop Shop Shop Shop Shed Shed Shed Shed Shed Shed Shed Shed Shed Shed Shed Shed Shed Good Good ??? Good Good, scaling on top Bad, many problems Ornate, minor breaking Rust, all coppe Good, some ru Rusty, very dirt S5 Good Rusty S6 S7 S8 Good Parting, separated Rusty S9 S10 S11 S12 S13 ?? Good Good Good Good, clean int Excellent, some missing, ornate Good Poor Good