Using the Woodcraft database file, create some queries that use concepts found in the textbook, as well as this week's lab. Post a screenshot of your query design and result set in a Word document.

? Totals ac ReplaceVerdana Ascending Descending Advanced- 1 Save uyspelling Remove Sort YToggle Filter selection ? Copy FForm at Painter Go To Filter Refresh Xoelete ? Records More ? Views All Tables Customer Clipboard Sort & Filter Find Text Formatting ???11?cust CustomerE Customertype EE City ID LastName FirstName Street Adc CityID Income ? NumOrder. Preferred -DateAcqui ? Customer- Click to Add 30 6 8 123 Easy St North Bruns $500,000.00 1/1/2005 Scouting Org 1/5/2006 Other 1 Smith Bob 2 Gaines Michelle345 ABS Str Orlando 3 Gaston Pierre 4 Smitts Bertha 5 Kay 6 MitchellChuck 7 Jasper Jasmine 84954 Rue I Tinley Park 8 Fromberg Laurinda 451 Germai Tinley Park 9 Maloney Gene customer : Ta City $50,000.00 5/30/2007 Church 856 Stonebi North Bruns $65,000.00 542 Foxcha: Orlando 789 Ben 854 Simmor Pomona City :Table $95,000.00 $25,000.00 $14,000.00 20? CustomerType A CustomerTyp.. 6/8/2009 Church 5/5/2009 Church 6/6/2009 Other Dawn t Pir Pomona 3 50? 15 $250,000.00 8/26/2008 Other $80,000.00 8/9/2006 Scouting Or 6/8/2007 Church 895 Wildhor Long Beach $95,000.00 891 Golden Long Beach $105,000.00 6/10/2009 Scouting Or 10 Coleman Trish 35 (New) ? Totals ac ReplaceVerdana Ascending Descending Advanced- 1 Save uyspelling Remove Sort YToggle Filter selection ? Copy FForm at Painter Go To Filter Refresh Xoelete ? Records More ? Views All Tables Customer Clipboard Sort & Filter Find Text Formatting ???11?cust CustomerE Customertype EE City ID LastName FirstName Street Adc CityID Income ? NumOrder. Preferred -DateAcqui ? Customer- Click to Add 30 6 8 123 Easy St North Bruns $500,000.00 1/1/2005 Scouting Org 1/5/2006 Other 1 Smith Bob 2 Gaines Michelle345 ABS Str Orlando 3 Gaston Pierre 4 Smitts Bertha 5 Kay 6 MitchellChuck 7 Jasper Jasmine 84954 Rue I Tinley Park 8 Fromberg Laurinda 451 Germai Tinley Park 9 Maloney Gene customer : Ta City $50,000.00 5/30/2007 Church 856 Stonebi North Bruns $65,000.00 542 Foxcha: Orlando 789 Ben 854 Simmor Pomona City :Table $95,000.00 $25,000.00 $14,000.00 20? CustomerType A CustomerTyp.. 6/8/2009 Church 5/5/2009 Church 6/6/2009 Other Dawn t Pir Pomona 3 50? 15 $250,000.00 8/26/2008 Other $80,000.00 8/9/2006 Scouting Or 6/8/2007 Church 895 Wildhor Long Beach $95,000.00 891 Golden Long Beach $105,000.00 6/10/2009 Scouting Or 10 Coleman Trish 35 (New)