Microsoft Access 2013 Grader Project

profilecoolzville
go_a02_grader_a3_concerts_sponsors.accdb
Concert ID Concert Name Box Office Receipts Date Concert Location Sponsor ID
EVENT-101 Spring Fling ¤ 1,200.00 5/1/18 Austin City Center SPONSOR-101
EVENT-102 Pride of Texas ¤ 575.00 6/15/18 Texas Arts Center SPONSOR-101
EVENT-103 Blues Festival ¤ 500.00 9/10/18 Austin City Center SPONSOR-102
EVENT-104 Spirit of the Capital ¤ 400.00 Austin City Center SPONSOR-104
EVENT-105 Spanish Carols and Candles ¤ 2,000.00 12/15/18 Georgetown Community Theater SPONSOR-107
EVENT-106 Jazz Alley Live ¤ 400.00 9/30/18 Austin City Center SPONSOR-106
EVENT-107 Showtime Show Tunes ¤ 1,900.00 11/18/18 Georgetown Community Theater SPONSOR-107
EVENT-108 Oldies Concert ¤ 2,000.00 1/16/18 Georgetown Community Theater SPONSOR-108
EVENT-109 Bluebell Festival ¤ 1,000.00 10/20/18 Georgetown Community Theater SPONSOR-103
EVENT-110 Cowboy Hospitality Tour ¤ 800.00 Austin City Center SPONSOR-103
EVENT-111 Texas Trail Songs ¤ 500.00 4/20/18 Austin City Center SPONSOR-105
EVENT-112 Valentine Love Songs ¤ 600.00 2/14/18 Texas Arts Center SPONSOR-101
EVENT-113 Fall Jazz Festival ¤ 950.00 10/30/18 Georgetown Community Theater SPONSOR-101
EVENT-114 State Fair Concert ¤ 2,500.00 8/15/18 State Fairgrounds SPONSOR-104
EVENT-115 Winter Jazz Festival ¤ 975.00 1/23/18 Austin City Center SPONSOR-101
EVENT-116 Thanksgiving Festival ¤ 500.00 11/24/18 State Fairgrounds SPONSOR-104
EVENT-117 History of Blues ¤ 675.00 3/15/18 Texas Arts Center SPONSOR-101
ID mSysRowId
1 /MxACpKFItDE/KeiwzCumJbYwcC+bolDPhg9MfAKm1I=-~j4tHzFwqLZ0JARSEl+fROw==
Sponsor ID Sponsor Name Phone Number Web Address mSysRowId
SPONSOR-101 KAUS Radio Station (512) 555-0888 www.kaus.rad OdOtbzT1pEdCP6JwuxVRZdmfhLQ75u4ZyDWa/tHEWGU=-~q/xYLupHq4bAvGkLkuywXw==
SPONSOR-102 Austin Memorial Foundation (512) 555-0557 www.austinmf.com GvKFVFqaD2Ia6CvvNPeInm4cStH+iH3IE7AAYg6+/1w=-~knQjQ6rT56Sx1UO+r5TD3g==
SPONSOR-103 Round Rock Chamber of Commerce (512) 555-0077 www.rrcc.biz C+dxQUEFBGLu3rA02E8gwrqRxDDIW3lDoL6jvIp/a1s=-~cJ62nuuMQidaIGZPmS+OWA==
SPONSOR-104 Georgetown Booster Club (512) 555-3346 www.georgetownbc.com ECJOLJZk/HX8FLx6tivs15FxjOznKWxEx+AqxRuBKdg=-~7rfHLf2VYQwCTI44YVdNbA==
SPONSOR-105 Texas Lakes CC Foundation (512) 555-0090 www.tlcc.edu/foundation br4mmQCN/tG5GoHFuvyf2zqtDs37oMW2FQJ0laUK6xo=-~JxMzq0L47SDcg+bswgbwyw==
SPONSOR-106 Bank of Texas (512) 555-0666 www.botexas.com la0Ex8Y0SDXXLiI1ONJ8J6mAnsrtkNRcCut2b5J5AeE=-~uuXqpaCWxAUuEklDhVDTLw==
SPONSOR-107 Dripping Springs City (512) 555-0323 www.codsprings.gov 1w/pv9bYK38wfUl/c75hUHIuB76yImwwUHYFqrEPgTo=-~YF1Zx7m2HvF94uYdtpkmjg==
SPONSOR-108 KCEM Radio Station (512) 555-0444 www.kcem.rad FeXxfUpSX9z2Wi1AtCfjIIMNTDq9FIgy91EOxPjlgAg=-~0BaMJgSrbhG51zK//hh5wQ==
SELECT Concerts.[Concert Name], Concerts.[Box Office Receipts], Concerts.[Concert Location] FROM Concerts WHERE (((Concerts.[Box Office Receipts])>=1000)) ORDER BY Concerts.[Concert Location];