Microsoft Access Grade Project

go_a02_grader_h3_student_scholarships.accdb

Home >Information Systems homework help >Microsoft Access Grade Project

ID	mSysRowId
1	K1H1m4AyVCVt7+ZS8FE9u8etU+KFcNdAnUXU7Yds+no=-~1fhjiTnBBKxgAdUZj66wyg==

ID	Scholarship Name	Amount	Major	Award Date	Student ID
S-01	Southwestern States Historical Society Award	¤ 300.00	History	9/22/18	3128456
S-02	Tech Directors Award	¤ 100.00	CIS	2/23/18	9999999
S-03	Texas Business Council Award	¤ 500.00	Business	8/1/18	3845724
S-04	Texas State Business Council Award	¤ 300.00	Child Development	4/23/18	3856958
S-05	Honor Society Leaders Award	¤ 500.00	History	2/15/18	3128456
S-06	National Lakes Protection Foundation Scholarship	¤ 750.00	Biology	6/22/18	2845209
S-07	Georgetown Arts Council Award	¤ 200.00	Art	6/25/18	3569325
S-08	Chemical Engineers State Association	¤ 500.00	Chemistry	1/16/18	2847194
S-09	Texas Medallion Scholars Award	¤ 300.00	Art	10/30/18	3852938
S-10	Austin Historical Society Scholarship	¤ 300.00	History	6/12/18	2840583
S-11	Amanda Snyder Foundation Scholarship	¤ 250.00	Business	11/4/18	3586943
S-12	Austin Business Women's Association Scholarship	¤ 300.00	CIS	2/6/18	2845209
S-13	Biotech Science Talent Award	¤ 200.00	Biology	8/4/18	2845721
S-14	Buda Achievement Scholarship	¤ 750.00	History	11/12/18	2938593
S-15	Leander Academic Achievement Scholarship	¤ 500.00	Paralegal	1/25/18	3847563
S-16	Texas Bright Futures Award	¤ 400.00	Child Development	8/28/18	3857493
S-17	Go Professional Business Council Scholarship	¤ 200.00	Business	7/29/18	3845724
S-18	Smithville Academic Achievement Scholarship	¤ 250.00	Nursing	2/21/18	3856930
S-19	Austin Mathletes Scholarship	¤ 200.00	Math	12/6/18	3857493
S-20	Michael Fresch Memorial Foundation Award	¤ 400.00	Math	4/14/18	2849201
S-21	Silver Star Scholarship	¤ 100.00	Political Science	7/12/18	3458632
S-22	Michael Sweeney Leadership Scholarship	¤ 200.00	Business	2/2/18	3849234
S-23	Round Rock Business Council Scholarship	¤ 500.00	Business	9/15/18	3847589
S-24	Austin Arts Society Scholarship	¤ 500.00	Art	4/10/18	3852938
S-25	Texas Academic Scholars Award	¤ 400.00	Psychology	12/22/18	2903485

Student ID	First Name	Last Name	Address	City	State	Postal Code	mSysRowId
2840583	Oscar	Prince	367 Encino St	San Marcos	TX	78666	KxWpU94bDJf2y3nb8Dhfg1NMj9qoS0aH2wIJnEPAnfg=-~xKTZ7/GaELaDebykiAJ6Mg==
2845209	Stephan	Elraheb	351 Wild Senna Dr	Pflugerville	TX		fUJe83eeikpjP6foY+qTK0SmplfJlGRxW2GqnQ0APXw=-~Ua+gwWnRZG8gZExozCHbgA==
2845721	Dana	Larsen	789 Bois Darc St	Lockhart	TX	78644	sYQ53BStatbEZ2QUpSETCCnEoEDI7CM/YHrax4FrENo=-~r9c2EqSwr/klBsfzzIBRgg==
2847194	Ginetta	Gant	100B W Mercer St	Dripping Springs	TX	78620	4Sq92CgkWiegoN23IljOKO9CdyQmZr19bDrrDIyb3Y4=-~z9rYwvPwkLrN05kGfSElZA==
2849201	Lisa	Sharpe	567 N Pecos St	Lockhart	TX	78644	ct61Mg43OyIBSMHE9aWz5ujiBKK9d952KCNMPkqqjN8=-~+BWjbmx5EKA8y/+AePx/Sg==
2849523	Moises	Fernandez	124 Woodland Ln	Round Rock	TX	78681	5tq4SbJH2g40BJdNZFSFW4Db1CRy0VtxizXIJNy0yXs=-~BrUYP6PMhvBm98TQMfjCAQ==
2903485	Jalpit	Matson	3204 Bird Call Pass	Austin	TX	78754	liuh519Z8G6pwnCisnsXsA4eY0GWhiChkbc+l6Xr4SQ=-~ejB6K2WJTz1B1FLl//glCQ==
2934853	Khrystyna	Tilson	11520 Oaklynn Ct	Manor	TX	78653	d8YKx3v+yRwsbL1N0ykmCfXAlgBmTKRpQCdjzZnKOwY=-~Amx64Chp1ODUokJtjwdm5Q==
2938593	Curtis	Dawson	10344 Yellowstone Dr	Austin	TX	78747	ER8g1R2zVaQMrKYAyhTA4JXaHFp36hmrcMJON5pJaKM=-~G3W7NCDp9yYScLm23oy62Q==
3128456	WenLi	Wall	14380 Ceylon Tea Cir	Pflugerville	TX	78660	KaZnEcKrU0iVcD/CMflignx+aXyRLDQmWecaowrog9g=-~zfvxOhxdEV61eOXPfEnwKQ==
3458632	Stephanie	Caputo	1731 Primrose Trl	Round Rock	TX	78665	/Ipb7GQHwzNpUVyZxmYeZlEZlmJ7Ow4jFFuBaKwknsw=-~BiQw7jBLBaKJ8AF7EpREkg==
3569325	Carlis	Thomas	28A 4th Ave	Smithville	TX	78657	Ogx9qBxSal2nDae33uK2URvMAF67wXlKTzSvjp2odEw=-~znAXGYrIx6ZOApTLIJtyNA==
3572184	Carla	Reid	715 Pampas Ricas Dr	Leander	TX	78641	bnwSOdH3w5AZMC/RrQPgmii9/5/Vb9FPjRokyJGOtmo=-~/dxtwY3CgVbAI0g60POhmw==
3586943	Joseph	Stavish	660 Bayou Bend Dr	Buda	TX	78610	wOyJpHGs+FwkV3MEIN5kGmHMQidr2/4DdQ931frvFqc=-~HMeU+cFNRr8Ca/JYckEtLg==
3842958	McCall	Cheney	1053 Tumbleweed Dr	Dale	TX	78616	EuoQC1vefSkvrRd+0tF4PwPMy/81GUnwdhp6+y6b+Fc=-~d1NHvGX/cBTXgdgey5wLQA==
3845724	Mihir	Subramanian	670 Mogonye Ln	Elgin	TX		gdPSEC9Y1Qx1dmBgg5RbAJOPFxDh/V0zn5dgnXJekkA=-~jmuNaJsLKAf3T30JMtDgKQ==
3847563	Andrew	Lee	14010 Big Thicket Dr	Austin	TX	78747	pIdLqrmVJH1ncSGsb3ifULX64xLCNcIhi9eWoOz7Cjk=-~bfBB3fzoEdxEWyofJi2LDA==
3847589	Prince	Flitcroft	7821 Winsted Ln	Austin	TX	78703	U/H9XfvQC8MSiQFI6XkkHrT+VnHsJK5mK+i4FCN991c=-~1kOQEKZf/grnQujLvYLudg==
3849234	Donald	Hanby	334 Blue Heron run	Wimberley	TX	78676	vxjmB57EcGzP6amHkFjpm3l3iifE+SN0COUPvDNlknc=-~e6nEDVtdIW5Tw2k+iEiDZw==
3852349	Kirsten	Riccardi	632 Ranchero Rd	Leander	TX		d7427d56MAUV6ZWUoXncFyF+0qK5zABuaLST4gduvo4=-~Qj4Ww7rsZMw4xhSWm2YdNw==
3852938	Atonye	Morris	1172 Buttonwood St	Bastrop	TX	78602	ob8X5X2wxMKm+C4k+iewe9ytJsBLwIZqUluV6LlaMew=-~TTUfvn7zrNs5fjT4V0iQKQ==
3856930	Cong	Nguyen	444 E Alamo St	Elgin	TX	78621	Gw+vJwxxhB1HaiFyxUPL2B78JYoEuQ19YVZZvYDHzPo=-~hkXfG05xWfZH3Vd7n8j5EA==
3856958	Danila	Bennett	808 Springbrook Ln	Leander	TX	78641	y/73JL5o9MnchWNwle7hJJ0to1DfHlV6HcdvD/qQWyI=-~T8lrntHanD1qAmjkD8uMkQ==
3857493	Sonia	Olson	193 Middle Creek Rd	Buda	TX	78610	64Y5WcPOAJTp6oGPt3pnc7Ya/ILE2T93XSClBKlKygI=-~ODaxiclq4cU3U4XZ0Q4ezA==
9999999	Nicole	Dutton	122 Whispering Spring Ln	Georgetown	TX	78633	4DwFIR1NjcbdLliXlJhwc+A4t5w9S/StF5fbr/S9PZY=-~G77Jsn26dRrXOP2OtwYJVA==

SELECT [Scholarships Awarded].[Scholarship Name], [Scholarships Awarded].Amount, [Scholarships Awarded].Major FROM [Scholarships Awarded] WHERE ((([Scholarships Awarded].Amount)>=500)) ORDER BY [Scholarships Awarded].[Scholarship Name];