i have to do all projects for my computer class in the book GO office 2013 volume 1 in word...

acssess.zip

Home >Computer Science homework help >i have to do all projects for my computer class in the book GO office 2013 volume 1 in word...

a01_student_files.zip

a01_student_files/a01A_Faculty_Advisors.xlsx

Faculty Advisors

Faculty ID	Rank	Campus	Last Name	First Name	Address	City	State	Postal Code	Home Phone	Cell Phone	Email
FAC-0393	Professor	Northeast	Betancourt	Charles	156 Zarogoza St	Elgin	TX	78621	(512) 555-5123	(512) 555-6214	[email protected]
FAC-0767	Professor	Southeast	Soja	Binit	660 Cypress St	Bastrop	TX	78602	(512) 555-5143	(512) 555-6240	[email protected]
FAC-1133	Professor	Northwest	Bell	Dora	1450 Horseback Hollow	Austin	TX	78732	(512) 555-5207	(512) 555-6304	[email protected]
FAC-1283	Professor	Northwest	Hart-Rodriguez	Melanie	623 Camino Alto	Leander	TX	78641	(512) 555-5140	(512) 555-6237	[email protected]
FAC-1772	Professor	Southeast	Haq	Mark	1234 Tumbleweed Trl	Dale	TX	78616	(512) 555-5159	(512) 555-6256	[email protected]
FAC-2234	Associate Professor	Southwest	Sweeney	Megan	910 Oak Meadow Dr	Dripping Springs	TX	78620	(512) 555-4545	(512) 555-2323	[email protected]
FAC-2245	Professor	Northwest	Szulkin	Martin	3730 Deer Trl	Spicewood	TX	78669	(512) 555-5213	(512) 555-6310	[email protected]
FAC-2289	Assistant Professor	Southeast	Sideris	Dana	550 Hondo St	Lockhart	TX	78644	(512) 555-5142	(512) 555-6239	[email protected]
FAC-2322	Professor	Southwest	Briggs	Luis	105 Bayou Bend Dr	Buda	TX	78610	(512) 555-5124	(512) 555-6215	[email protected]
FAC-2375	Associate Professor	Northeast	Torres	Robert	190 Estancia Way	Georgetown	TX	78626	(512) 555-5141	(512) 555-6238	[email protected]
FAC-2377	Associate Professor	Northeast	Kubzansky	Amy	11640 Sunny Creek Ln	Manor	TX	78653	(512) 555-5148	(512) 555-6245	[email protected]
FAC-2877	Professor	Southwest	Treiman	Roger	123 Moonlight Pl	Kyle	TX	78640	(512) 555-5132	(512) 555-6227	rtreiman@capcc c.edu
FAC-2998	Professor	Northwest	Holland	Timothy-John	156 Keirsey Ln	Red Rock	TX	78662	(512) 555-5210	(512) 555-6307	[email protected]
FAC-3433	Professor	Southeast	Hackett	Jessica	1265 Summit St	Austin	TX	78741	(512) 555-5175	(512) 555-6272	[email protected]
FAC-3567	Associate Professor	Southwest	Michaels	Payne	333Encino Way	San Marcos	TX	78666	(512) 555-5203	(512) 555-6300	[email protected]
FAC-3991	Professor	Southeast	Capelle	Arturo	476 Rivers St	Smithville	TX	78657	(512) 555-5165	(512) 555-6262	[email protected]
FAC-4901	Professor	Northeast	Saguy	Vilma	600 Lonesome Lilly Way	Pflugerville	TX	78665	(512) 555-5131	(512) 555-6224	[email protected]
FAC-6534	Assistant Professor	Southeast	Lang	Phillippe	125 Peach St	Bastrop	TX	78602	(512) 555-5168	(512) 555-6265	[email protected]
FAC-6543	Professor	Southwest	Goldani	ZsuZsa	256 Mill Race Ln	Wimberley	TX	78674	(512) 555-5132	(512) 555-6229	[email protected]
FAC-6678	Assistant Professor	Southeast	Hasenfeld	Larthia	6240 Stiles Cv	Austin	TX	78721	(512) 555-5144	(512) 555-6241	[email protected]
FAC-7223	Assistant Professor	Northwest	Ong	Joel	745 Northcreek Blvd	Leander	TX	78641	(512) 555-5196	(512) 555-6293	[email protected]
FAC-7342	Instructor	Northwest	Villareal	Jose Luis	120 Blue Bonnet Ln	Liberty Hill	TX	78642	(512) 555-5150	(512) 555-6247	[email protected]
FAC-8223	Assistant Professor	Southeast	Kilbride	Thea	188 Dale Ln	Dale	TX	78616	(512) 555-5163	(512) 555-6260	[email protected]
FAC-8375	Instructor	Southwest	Friend	Gyula	2193 Rio Grande St	Austin	TX	78705	(512) 555-5155	(512) 555-6252	[email protected]
FAC-8523	Associate Professor	Northwest	Abromsky	Alexandru	25380 Pedernales Point Dr	Spicewood	TX	78669	(512) 555-5191	(512) 555-6288	[email protected]
FAC-8662	Instructor	Southwest	Suh	Kingston	290 Tobin Dr	Buda	TX	78610	(512) 555-5134	(512) 555-6231	[email protected]
FAC-8727	Assistant Instructor	Southeast	Gilmore	Teshome	1430 N Pecos St	Lockhart	TX	78644	(512) 555-5154	(512) 555-6251	[email protected]
FAC-9005	Assistant Instructor	Northwest	Wazir	Paul	11440 Sweet Basil Ct	Austin	TX	78726	(512) 555-5151	(512) 555-6248	[email protected]
FAC-9119	Assistant Instructor	Northeast	Bowman	Nuzhut	3208 Misty Oaks Way	Round Rock	TX	78664	(512) 555-5172	(512) 555-6269	[email protected]

mailto:[email protected] mailto:[email protected]

a01_student_files/a01A_Students.xlsx

Students

Student ID	Last Name	First Name	Middle Initial	Address	City	State	Postal Code	Phone	Email	Faculty Advisor ID	Amount Owed
2034834	Telfer	Larry	J	162 Rattlesnake Ln	Red Rock	TX	78662	(512) 555-2017	[email protected]	FAC-2245	402.50
2349535	Vohra	Ashwin	M	316 Lost Cove Dr	Spicewood	TX	78669	(512) 555-0302	[email protected]	FAC-2289	0.00
2583697	McElaney	Cleta	E	13273 Copperfield Dr	Austin	TX	78753	(512) 555-0305	[email protected]	FAC-6543	15.15
3128456	Wall	WenLi	Z	14380 Ceylon Tea Cir	Pflugerville	TX	78660	(512) 555-2329	[email protected]	FAC-2245	0.00
3458632	Caputo	Stephanie	G	1731 Primrose Trl	Round Rock	TX	78665	(512) 555-2330	[email protected]	FAC-8223	0.00
3569325	Thomas	Carlis	A	28A 4th Ave	Smithville	TX	78657	(512) 555-0301	[email protected]	FAC-8223	0.00
3572184	Reid	Carla	N	715 Pampas Ricas Dr	Leander	TX	78641	(512) 555-2026	[email protected]	FAC-6543	1232.00
3586943	Stavish	Joseph	C	660 Bayou Bend Dr	Buda	TX	78610	(512) 555-9360	[email protected]	FAC-2234	26.25
3593653	Hernandez	Anna	R	2132 Mesquite Ln	Georgetown	TX	78626	(512) 555-0301	[email protected]	FAC-6543	896.25
3768532	Alexander	Rebekah	A	218 Chapparral Trl	Dale	TX	78616	(512) 555-1017	[email protected]	FAC-8223	0.00
3852938	Morris	Atonye	O	1172 Buttonwood St	Bastrop	TX	78602	(512) 555-1018	[email protected]	FAC-2289	0.00
3856930	Nguyen	Cong	L	444 E Alamo St	Elgin	TX	78621	(512) 555-1004	[email protected]	FAC-6543	3210.00
4352863	Bradley	Christine	Y	2708 Kickapoo Cavern Dr	Pflugerville	TX	78660	(512) 555-2013	[email protected]	FAC-2245	0.00
4719238	DiAntonio	Avelina	A	1008 Sunset Canyon Dr	Dripping Springs	TX	78620	(512) 555-2319	[email protected]	FAC-6543	0.00
4739502	Alvarez	Eliza	J	3590 Longhorn Trl	Round Rock	TX	78681	(512) 555-2025	[email protected]	FAC-2234	0.00
4769304	Furfy	Jana	E	2107 Edenwood Dr	Austin	TX	78745	(512) 555-2064	[email protected]	FAC-2289	0.00
4852384	Parkhill	James	A	105 E Myrtle St	Liberty Hill	TX	78642	(512) 555-2323	[email protected]	FAC-2245	112.00
5820384	Rose	Edward	N	555 S Blanco St	Lockhart	TX	78644	(512) 555-2019	[email protected]	FAC-8223	16.67
5834924	Kakaulian	Anastasia	B	4822 Turtle Mound Bnd	Austin	TX	78748	(512) 555-2031	[email protected]	FAC-2289	2345.75
5835035	Poon	Laurence	F	263 Caddis Cv	Kyle	TX	78640	(512) 555-0304	[email protected]	FAC-2234	1182.50
5849320	Soltan	Reza	H	5498 Wild Foxglove Rd	Spicewood	TX	78669	(512) 555-9362	[email protected]	FAC-6543	0.00
5860300	Campbell	Daria	I	162 Rockwood Dr	Wimberley	TX	78674	(512) 555-1016	[email protected]	FAC-2289	0.00

a01_student_files/a01B_Workshops.xlsx

Student Workshops

Title	Start Time	End Time	Location	Description
Transferring to a 4-Year University	4/8/18 11:00 AM	4/8/18 12:30 PM	Northeast Campus	Transfer
Financial Aid	4/14/18 7:00 PM	4/14/18 8:30 PM	Southeast Campus	CC Info
Sensitivity Training	4/15/18 8:00 AM	4/15/18 9:00 AM	Northwest Campus	Human Behavior
Preparing for the Job Interview	4/15/18 12:30 PM	4/15/18 2:00 PM	Northwest Campus	Job Skills
Class Note Taking	4/18/18 12:30 PM	4/18/18 1:30 PM	Southeast Campus	Study Skills
Managing Time and Stress	4/18/18 6:00 PM	4/18/18 7:30 PM	Southwest Campus	Study Skills
Work Smart at Your Computer	4/20/18 10:00 AM	4/20/18 11:00 AM	Northeast Campus	Computer Skills
Preparing for Tests	4/20/18 4:00 PM	4/20/18 5:00 PM	Southeast Campus	Study Skills

a01_student_files/a01C_Administrators.xlsx

College Administrators

Employee ID	Title	Last Name	First Name	Middle Initial	Address	City	State	Postal Code	Phone Number	Department ID	Salary
ADM-8725	Executive Vice President	Adwoa	Karen	R	584 Haysel St	Bastrop	TX	78602	(512) 555-2323	EX	154000
ADM-2305	President	Balitsky	Wayne	C	7432 Liberty Ln	Dale	TX	78616	(512) 555-2101	EX	230000
ADM-1368	Vice President	Bautista	Azucena	B	82 N Pecos St	Lockhart	TX	78644	(512) 555-2018	FI	125000
ADM-4599	Director	Cai	Chunsheng	S	786 Rattlesnake Ln	Red Rock	TX	78662	(512) 555-2331	HR	92560
ADM-3367	Vice President	Seki	Masahiro	J	1256 Olive St	Smithville	TX	78657	(512) 555-2030	IT	115560
ADM-1230	Associate Vice President	Cale	Muriel	L	434 Meridian Oak Ln	Austin	TX	78744	(512) 555-2318	IS	96350
ADM-5284	Chief of Staff	Roy	Amitava	Q	123 Northern Trl	Leander	TX	78645	(512) 555-2019	EX	75330
ADM-0893	Director, Budget Offices	Kooi	Ginger	C	104 Grove St	Liberty Hill	TX	78642	(512) 555-2031	AS	82480
ADM-8421	Vice President	Piao	Cheng	A	222 Fall Creek Rd	Spicewood	TX	78669	(512) 555-0304	WD	118490
ADM-7730	Director	Eddy	Randy	B	466 Mesa Dr	Austin	TX	78731	(512) 555-9362	GR	85720
ADM-9124	Vice President	Hanna	Donna	L	43 Clarence Ct	Buda	TX	78610	(512) 555-1016	IR	113500
ADM-2693	Associate Vice President	Denou	Elessessi	W	422 W Mercer St	Dripping Springs	TX	78620	(512) 555-9363	IT	91635
ADM-3933	Director	Lee	Jeffrey	C	8765 Dandelion Loop	Kyle	TX	78640	(512) 555-1019	FD	78200
ADM-6266	Vice President	Rodriquez	Juan	E	890 Encino St	San Marcos	TX	78666	(512) 555-2027	SS	128450
ADM-5449	Associate Vice President	Bray	Cindy	M	2599 Melody Way	Wimberley	TX	78676	(512) 555-2012	GS	93300
ADM-2845	Director, Client Services	Ray	Darrell	L	78 Roaring Springs Dr	Austin	TX	78736	(512) 555-1020	IT	78620
ADM-0034	Associate Vice President	Ianni	Sherry	I	266 Madison St	Elgin	TX	78621	(512) 555-9361	WD	91490
ADM-3007	Assistant Director	Mattei	Lisa	A	78 Highview Rd	Georgetown	TX	78627	(512) 555-0303	GR	62550
ADM-6143	Associate Vice President	Dani	Pallavi	H	1024 Ring Dr	Manor	TX	78653	(512) 555-1008	FI	93450
ADM-0456	Associate Vice President	Jones	Kossi	M	4566 Valley Glen Rd	Pflugerville	TX	78660	(512) 555-2318	AS	91220
ADM-5690	Director	Lee	Carolyn	E	125 Vinson Ct	Round Rock	TX	78665	(512) 555-1001	MM	75660
ADM-2111	Assistant Director	Fernandez	Jacki	D	5263 Falcon Dr	Round Rock	TX	78681	(512) 555-2022	FD	59900
ADM-0007	Controller	Jack	Donna	V	874 Long Day Dr	Austin	TX	78754	(512) 555-2014	AS	84900
ADM-9630	Registrar	Poche	Jason	R	89 Piping Rock Trl	Austin	TX	78748	(512) 555-2322	SS	78400
ADM-1639	Director, Research	Trinh	Tung	F	6735 Exposition Ave	Austin	TX	78703	(512) 555-2027	IR	63500
ADM-2377	Director, Financial Aid	Trivvey	Karen	Q	351 Elfen Cv	Austin	TX	78724	(512) 555-2025	SS	76500
ADM-0178	Director, Emergency Planning	Uwaifo	Rao	G	32 Nolan Dr	Georgetown	TX	78633	(512) 555-1010	FI	81570

a01_student_files/a01C_Departments.xlsx

Departments

Department ID	Department Name	Department Phone	Department Fax	Suite Number	Department Email
AS	Academic Services	(512) 555-2545	(512) 555-2546	610	[email protected]
EX	Executive Staff	(512) 555-2526	(512) 555-2527	600	[email protected]
FI	Finance	(512) 555-9342	(512) 555-9343	510	[email protected]
HR	Human Resources	(512) 555-2531	(512) 555-2532	620	[email protected]
IT	Instructional Technology	(512) 555-8215	(512) 555-8216	608	[email protected]
IS	Information Systems	(512) 555-1243	(512) 555-1244	514	[email protected]
WD	Workforce Development	(512) 555-2151	(512) 555-2152	508	[email protected]
GR	Grants	(512) 555-6213	(512) 555-6214	604	[email protected]
IR	Institutional Research	(512) 555-2135	(512) 555-2136	602	[email protected]
FD	Foundation	(512) 555-2124	(512) 555-2125	520	[email protected]
SS	Student Services	(512) 555-9124	(512) 555-9125	612	[email protected]
GS	Global Studies	(512) 555-1551	(512) 555-1552	618	[email protected]

a01_student_files/a01D_Certification_Events.xlsx

Cert Test Prep Events

Title	Start Time	End Time	Description	Location
Word 2013	8/5/18 10:00 AM	8/5/18 4:00 PM	Office 2013	Southeast Campus
Windows Server	8/6/18 8:00 AM	8/6/18 2:00 PM	Networking	Northeast Campus
Excel 2013	8/12/18 3:00 PM	8/12/18 9:00 PM	Office 2013	Southeast Campus
Windows 8	8/13/18 10:00 AM	8/13/18 4:00 PM	Networking	Southwest Campus
Access 2013	8/19/18 9:00 AM	8/19/18 3:00 PM	Office 2013	Northeast Campus
A+	8/19/18 12:00 PM	8/19/18 6:00 PM	Networking	Southwest Campus
PowerPoint 2013	8/26/18 1:00 PM	8/26/18 7:00 PM	Office 2013	Northwest Campus
Network+	8/26/18 9:00 AM	8/26/18 3:00 PM	Networking	Northwest Campus

a01_student_files/a01E_Inventory.xlsx

Inventory

Item ID	Item	Category	Campus	Storage Location	Price	Quantity in Stock
T-2	T-shirt, M	Clothing	Southeast	SE100B	18.5	100
T-3	T-shirt, L	Clothing	Southeast	SE100B	19.5	100
T-4	T-shirt, XL	Clothing	Southeast	SE100B	20.5	100
T-5	T-shirt, XXL	Clothing	Southeast	SE100B	21.5	50
S-1	Notebook with logo	School Supplies	Southeast	SE100C	4.75	250
S-2	Pen with logo	School Supplies	Southeast	SE100C	2.25	500
S-3	Pencil with logo	School Supplies	Southeast	SE100C	0.75	1000
H-1	Ball cap with logo	Clothing	Southeast	SE100B	22.99	50
H-2	Visor with logo	Clothing	Southeast	SE100B	11.25	50
B-1	Baseball with logo	Sports	Southeast	SE100D	7.5	50
B-2	Soccer ball with logo	Sports	Southeast	SE100D	15.99	10
WB-1	Water bottle with logo	Miscellaneous	Southeast	SE100E	3.49	230
P-1	Pennant, small	Sports	Southeast	SE100D	6	100
P-2	Pennant, large	Sports	Southeast	SE100D	12	50

a01_student_files/a01E_Inventory_Storage.xlsx

Inventory Storage

Category	Storage Room	Location Detail
Candy	SE100A	Cooler
Clothing	SE100B	Bins 1-10
Miscellaneous	SE100E	Bins 1-2
School Supplies	SE100C	Bins 1-10
Sports	SE100D	Bins 1-6

a01_student_files/a01F_Recruiting_Events.xlsx

Recruiting Events

Title	Start Time	End Time	Description	Location
Workforce Development	6/4/18 10:00 AM	6/4/18 1:00 PM	Adults	Southwest Campus
Culinary Arts	6/6/18 8:00 AM	6/6/18 11:00 AM	Culinary Arts Students	Northeast Campus
New Students	6/6/18 1:00 PM	6/6/18 4:00 PM	Transfer Students	Northwest Campus
Workforce Development	6/7/18 9:00 AM	6/7/18 12:00 PM	Adults	Northeast Campus
New Students	6/7/18 4:00 PM	6/7/18 7:00 PM	Open House	Southwest Campus
International Business	6/8/18 2:00 PM	6/8/18 5:00 PM	Business Students	Bowie High School
New Students	6/8/18 6:00 PM	6/8/18 9:00 PM	Open House	Northeast Campus
Sports	6/9/18 8:00 AM	6/9/18 11:00 AM	Sports Clinic	Texas Lakes High School
New Students	6/9/18 7:00 PM	6/9/18 10:00 PM	Open House	Southeast Campus

a01_student_files/a01G_Contractors.xlsx

Contractors

ID	Contractor	Last Name	First Name	Email Address	Cell Phone
C-01	RR Construction	Borders	Peter	[email protected]	(512) 555-7830
C-02	Marshall Ellis Construction	Li	Susan	[email protected]	(512) 555-1904
C-03	Woodward Construction	Helene	Jean-Claude	[email protected]	(512) 555-2561
C-04	CEM Builders	Marquis	Cara	[email protected]	(512) 555-4007

a01_student_files/a01G_Projects.xlsx

Projects

Project ID	Building Project	Site	Contractor	Budget Amount
P-698	Joint Use Library	Southeast Campus	Woodward Construction	60000000
P-546	Trinity Building Renovation	Northeast Campus	Woodward Construction	5000000
P-276	Gymnasium	Southwest Campus	CEM Builders	30000000
P-487	Writing Center	Northwest Campus	Marshall Ellis Construction	2000000
P-326	Student Lounge	Northwest Campus	Marshall Ellis Construction	100000

a01_student_files/a01H_Scholarships.accdb

Amount	Sport	Term	Award Date	Athlete Last Name	Athlete First Name	ID
40000	Football	2 years	1/29/2018	Bass, Jordan		S-01
10000	Swimming	1 year	11/1/2018	Goldstein	Hugh	S-02
8000	Diving	1 year	9/15/2018	Eckert	Katie	S-03
10000	Volleyball	2 years	7/14/2018	Berguin	Marianne	S-04
20000	Softball	2 years	3/27/2018	Zadro	Jean	S-05
30000	Basketball	2 years	9/1/2018	Boulward	Shawn	S-06
15000	Swimming	1 year	3/21/2018	Geng	Lan	S-07
10000	Swimming	1 year	3/17/2018	Telfer	Larry	S-08
40000	Football	2 years	10/1/2018	Vohra	Ashwin	S-09
25000	Golf	1 year	9/1/2018	McElaney	Cleta	S-10
8000	Track	2 years	11/1/2018	Siegel	Joyce	S-11
27000	Basketball	2 years	1/15/2018	Ibtehal	Ahjamu	S-12
20000	Baseball	2 years	11/5/2018	Asfar	Ryan	S-13
30000	Football	2 years	11/4/2018	Chinoso	Austin	S-14
12000	Track	1 year	4/16/2018	Hardy	Caitlyn	S-15
18000	Golf	1 year	10/5/2018	Dutton	Nicole	S-16
41000	Football	2 years	1/3/2018	Prince	Oscar	S-17
26000	Basketball	2 years	10/5/2018	Elraheb	Stephen	S-18
9000	Track	1 year	12/15/2018	Larsen	Dana	S-19
23000	Basketball	2 years	2/28/2018	Gant	Ginetta	S-20
20000	Golf	2 years	5/1/2018	Sharp	Lisa	S-21
26000	Basketball	2 years	11/5/2018	Fernandez	Moises	S-22
35000	Football	2 years	11/15/2018	Matson	Jalpit	S-23
15000	Softball	1 year	10/15/2018	Tilson	Khrystyna	S-24
20000	Baseball	2 years	9/1/2018	Dawson	Curtis	S-25

a01_student_files/a01J_Scholarships.xlsx

Scholarships

Scholarship ID	Athlete Last Name	Athlete First Name	Campus	Sport	Amount	Term	Award Date
S-02	Goldstein	Hugh	Southeast	Swimming	10000	1 year	11/1/18
S-03	Eckert	Katie	Southeast	Diving	8000	1 year	9/15/18
S-04	Berguin	Marianne	Northwest	Volleyball	10000	2 years	7/14/18
S-05	Zadro	Jean	Southwest	Softball	20000	2 years	3/27/18
S-06	Boulward	Shawn	Northwest	Basketball	30000	2 years	9/1/18
S-07	Geng	Lan	Southeast	Swimming	15000	1 year	3/21/18
S-08	Telfer	Larry	Southeast	Swimming	10000	1 year	3/17/18
S-09	Vohra	Ashwin	Northeast	Football	40000	2 years	10/1/18
S-10	McElaney	Cleta	Northeast	Golf	25000	1 year	9/1/18
S-11	Siegel	Joyce	Southeast	Track	8000	2 years	11/1/18
S-12	Ibtehal	Ahjamu	Northwest	Basketball	27000	2 years	1/15/18
S-13	Asfar	Ryan	Southwest	Baseball	20000	2 years	11/5/18
S-14	Chinoso	Austin	Northeast	Football	30000	2 years	11/4/18
S-15	Hardy	Caitlyn	Southeast	Track	12000	1 year	4/16/18
S-16	Dutton	Nicole	Northeast	Golf	18000	1 year	10/5/18
S-17	Prince	Oscar	Northeast	Football	41000	2 years	1/3/18
S-18	Elraheb	Stephen	Northwest	Basketball	26000	2 years	10/5/18
S-19	Larsen	Dana	Southeast	Track	9000	1 year	12/15/18
S-20	Gant	Ginetta	Northwest	Basketball	23000	2 years	2/28/18
S-21	Sharp	Lisa	Northeast	Golf	20000	2 years	5/1/18
S-22	Fernandez	Moises	Northwest	Basketball	26000	2 years	11/5/18
S-23	Matson	Jalpit	Northeast	Football	35000	2 years	11/15/18
S-24	Tilson	Khrystyna	Southwest	Softball	15000	1 year	10/15/18
S-25	Dawson	Curtis	Southwest	Baseball	20000	2 years	9/1/18

a01_student_files/a01K_Student_Activities.docx

GO! With Microsoft Office 2013

Data for Access Project 1K Student Activities

ID	Title	Date	Description	Location
1	Student Talent Show	10/2/18	Student Services	Northeast Campus Theater
2	Co-ed Volleyball	10/3/18	Sports	Southwest Campus Gymnasium
3	Movie Night	10/5/18	Student Services	Northeast Campus Theater
4	Bowling	10/9/18	Sports	Austin Lanes
5	Chess Match	10/17/18	Student Services	Southeast Campus, Rm. A402
6	Austin Musicians	10/22/18	Student Services	Northwest Campus Theater

a01_student_files/a01L_Club_Presidents.xlsx

Club Presidents

Student ID	Last Name	First Name	Address	City	State	Postal Code	Phone
3849234	Hanby	Donald	1334 Cole Springs Rd	Buda	TX	78610	(512) 555-2316
3852349	Riccardi	Kirsten	332 Fisher St	Elgin	TX	78621	(512) 555-9359
3852938	Morris	Atonye	1463 Dale Ln	Dale	TX	78616	(512) 555-1018
3856930	Nguyen	Cong	4509 Ranchero Rd	Leander	TX	78641	(512) 555-1004
3856958	Bennett	Danila	236 Wild Buffalo Dr	Kyle	TX	78640	(512) 555-9364
3857493	Olson	Sonia	5214 Concho Bend Rd	Austin	TX	78735	(512) 555-2024
3857684	Stanton	Michael	234 Creek Dr	Dripping Springs	TX	78620	(512) 555-2327
3859305	Santangelo	Mildred	68 Carson Ave	Liberty Hill	TX	78642	(512) 555-0307
3859323	Rosario	Micah	76 Sand Hills Rd	Red Rock	TX	78662	(512) 555-1015
3859375	Morrissey	Nancy	690 Breezeway Ln	Georgetown	TX	78626	(512) 555-2061
3905345	Alvarado	Oscar	90 Westfield Dr	Austin	TX	78731	(512) 555-1022
3948506	Fleischer	Kerry	12578 Copperfield Dr	Austin	TX	78753	(512) 555-0309
3957203	Fishman	Howard	18 Arizona St	San Marcos	TX	78666	(512) 555-2062
4352863	Bradley	Christine	5210 Texas Bluebell Dr	Spicewood	TX	78669	(512) 555-2013
4719238	DiAntonio	Avelina	765 Farm St	Bastrop	TX	78602	(512) 555-2319
4739502	Alvarez	Eliza	1360 Sleepytime Trl	Pflugerville	TX	78660	(512) 555-2025
4769304	Furfy	Jana	1350 Flint Rock Dr	Round Rock	TX	78661	(512) 555-2064
4852384	Parkhill	James	567 Wisteria Way	Round Rock	TX	78665	(512) 555-2323
5720358	Schneider	Margot	288 Clearfork Rd	Lockhart	TX	78664	(512) 555-2101
5730483	Forrester	Clement	415 Cedar Hollow Rd	Red Rock	TX	78662	(512) 555-2018
5738495	Chun	Robert	1786 La Costa Dr	Austin	TX	78747	(512) 555-2331
5739437	Sotova	Eugene	13000 Windstone Ct	Manor	TX	78653	(512) 555-2030
5748392	Cildaro	Renato	1334 Colorado St	Smithville	TX	78657	(512) 555-2318
5820384	Rose	Edward	321 Rockwood Dr	Wimberley	TX	78676	(512) 555-2019
5834924	Kakaulian	Anastasia	14006 Ruxton Ln	Austin	TX	78749	(512) 555-2031

a01_student_files/a01L_Clubs.docx

GO! With Microsoft Office 2013

Data for Access Project 1L Student Clubs

Club ID	Club Name	Meeting Day	Meeting Time	Campus	Room ID	President ID
AP-9324	Alpha Phi	Monday	7:00 PM	Northwest	B115	3849234
AR-3532	Art Club	Tuesday	5:30 PM	Southeast	B402	3852349

a01_student_files/a01L_Student_Clubs.xlsx

Clubs

Club ID	Club Name	Meeting Day	Meeting Time	Campus	Room ID	President ID
AL-9352	Alumni Association	Thursday	6:00 PM	Northeast	B403	3859323
BL-9342	Business & Law Society	Friday	6:30 PM	Northwest	E110	5834924
CD-2345	Career Development Club	Wednesday	12:30 PM	Southeast	E208	5748392
CM-0235	Creative Music Society	Monday	7:30 PM	Southwest	T102	3857493
DB-0235	Debate Club	Thursday	6:00 PM	Northeast	D142	3856930
DP-8353	Delta Phi Honor Society	Tuesday	5:00 PM	Southeast	B210	5739437
EH-9352	Economics Honor Society	Tuesday	5:00 PM	Southwest	T532	3857684
ES-0356	Engineering Society	Friday	6:30 PM	Northwest	J321	3856958
FC-8235	French Club	Wednesday	6:00 PM	Southeast	C211	4852384
GC-8234	German Club	Friday	6:30 PM	Northeast	T106	3859375
HC-8352	Hiking Club	Monday	7:00 PM	Northwest	T105	3905345
KC-8356	Kinesiology Club	Friday	5:00 PM	Southwest	L404	5730483
MA-8352	Marketing Association	Wednesday	5:30 PM	Southwest	W323	3859305
NC-9235	Neuroscience Club	Wednesday	5:00 PM	Southeast	N215	3957203
PL-8365	Pre-Law Council	Thursday	6:00 PM	Northwest	N113	5820384
PM-8234	Pre-Medicine Society	Monday	4:30 PM	Northeast	P112	5738495
PS-9352	Political Science Club	Wednesday	5:00 PM	Northwest	D322	3852938
PV-3586	Pre-Vet Club	Thursday	4:00 PM	Southwest	A354	4352863
SC-8346	Spanish Club	Thursday	6:30 PM	Northeast	D273	5720358
SW-2934	Student Wellness Program	Monday	4:00 PM	Southeast	C144	4739502
TC-8235	Taekwondo Club	Tuesday	12:30 PM	Southwest	T141	3948506
TM-9325	Toastmasters	Tuesday	12:30 PM	Northwest	C432	4769304
UF-8235	Ultimate Frisbee Club	Friday	4:30 PM	Southeast	L143	4719238

a01_student_files/a01M_Faculty_Training.docx

GO! With Microsoft Office 2013

Data for Access Project 1M Faculty Training

ID	Title	Date	Description	Location
1	Student Advising	8/2/18	Counseling	Northeast Campus, Room H248
2	Club Sponsorship	8/3/18	Student Services	Southwest Campus, Room A23
3	Office 2013	8/5/18	IT	Northeast Campus, Computer Lab
4	Course Management System	8/9/18	Online	Southeast Campus, Computer Lab
5	Cloud Computing	8/12/18	IT	Southeast Campus, Room B13
6	Mentoring of Students	8/14/18	Student Services	Northwest Campus, Room J414

a02_student_files.zip

a02_student_files/a02A_Instructors_Courses.accdb

Instructor ID	Rank	First Name	Last Name	Office Phone	Department	College Email
1224567	Associate Professor	Craig	Fresch	(512) 555-1100	LGL	[email protected]
1228964	Professor	Jean	Woodward	(512) 555-1102	HRI	[email protected]
1252234	Professor	Scott	Carson	(512) 555-5123	ACC	[email protected]
1478893	Associate Professor	Lucy	LePorter	(512) 555-5208	ACC	[email protected]
1566543	Professor	Emanuel	Hamme	(512) 555-5159	BUS	[email protected]
1578223	Professor	Valerie	Jonese	(512) 555-5209	BUS	[email protected]
1578523	Professor	Eduardo	Gauser	(512) 555-5213	BUS	[email protected]
1922322	Associate Professor	Cynthia	Pedigree	(512) 555-5148	LGL	[email protected]
1922377	Assistant Professor	Claudette	Macon	(512) 555-5132	BUS	[email protected]
2013987	Instructor	Kevin	Elkington	(512) 555-1104	MKT	[email protected]
2034681	Professor	Susanne	Carter	(512) 555-1048	IST	[email protected]
2109876	Assistant Professor	Peter	Kaniski	(512) 555-5133	HRI	[email protected]
2278662	Professor	Louis	Tinnarro	(512) 555-5175	IST	[email protected]
2312375	Associate Professor	Joan	Castile	(512) 555-5203	IST	[email protected]
2388652	Professor	Kimberlee	Perezo	(512) 555-5167	IST	[email protected]
2543991	Professor	Gary	Noehle	(512) 555-5165	IST	[email protected]
2584901	Associate Professor	Cindy	Birdsong	(512) 555-5131	ACC	[email protected]
2621133	Assistant Professor	William	MacNamarra	(512) 555-5168	IST	[email protected]
2643912	Associate Professor	Bryce	Steagallor	(512) 555-5127	IST	[email protected]
2715255	Professor	Bill	Clemente	(512) 555-5169	IST	[email protected]
2810005	Professor	Lisle	Carter	(512) 555-5170	IST	[email protected]
2912338	Professor	Gregory	Tinafossey	(512) 555-5128	IST	[email protected]
2912398	Professor	Debbie	Binhamm	(512) 555-5185	IST	[email protected]
2988821	Assistant Professor	Mary	Geable	(512) 555-5171	IST	[email protected]
3033300	Professor	Bonita	Volkman	(512) 555-5189	IST	[email protected]
3102555	Assistant Professor	Deborah	Fresch	(512) 555-5180	ACC	[email protected]
3152998	Associate Professor	Pamela	Parkman	(512) 555-5173	ACC	[email protected]
3233995	Associate Professor	Brenda	Saidlachek	(512) 555-5174	BUS	[email protected]
4856545	Professor	William	Genkinse	(512) 555-5196	MKT	[email protected]
5012877	Professor	Barbara	Blanche	(512) 555-5151	HRI	[email protected]
5087223	Professor	Roberto	Heart	(512) 555-5172	ACQ	[email protected]
6145288	Professor	Ivey	Clarke	(512) 555-5192	AST	[email protected]
7222244	Professor	Jacqui	Warrenton	(512) 555-5194	AST	[email protected]
9999999			Staff

Schedule ID	Subject	Catalog#	Course Name	Credits	Section	Prerequisite	Day(s)	Start Time	End Time	Room#	Instructor ID	Delivery Mode	Session
48368	ITD	258	Database Performance & Tuning	4	H01NE		Tu	12/30/99	12/30/99	H207	2988821	Hybrid	1st 8 weeks
40066	ACC	100	Bookkeeping I	5	N01NE		TuTh	12/30/99	12/30/99	H220	1478893	Lecture	Regular
40098	ACC	210	Advanced Bookkeeping	3	N01NE	ACC 100	We	12/30/99	12/30/99	H210	3152998	Lecture	Regular
40176	ACC	211	Principles of Accounting I	3	D01NE		MoWe	12/30/99	12/30/99	H210	1252234	Lecture	Regular
40198	ACC	211	Principles of Accounting I	3	D02NE		TuTh	12/30/99	12/30/99	H210	1252234	Lecture	Regular
40211	ACC	211	Principles of Accounting I	3	D03NE		Fr	12/30/99	12/30/99	H210	9999999	Lecture	Regular
40243	ACC	211	Principles of Accounting I	3	D04NE		MoWe	12/30/99	12/30/99	H210	3102555	Lecture	Regular
40344	ACC	211	Principles of Accounting I	3	D05NE		TuTh	12/30/99	12/30/99	H210	1252234	Lecture	Regular
40434	ACC	211	Principles of Accounting I	3	D06NE		MoWe	12/30/99	12/30/99	H210	1478893	Lecture	Regular
40496	ACC	211	Principles of Accounting I	3	D07NE		TuTh	12/30/99	12/30/99	H210	1252234	Lecture	Regular
40523	ACC	211	Principles of Accounting I	3	D08NE		MoWe	12/30/99	12/30/99	H210	9999999	Lecture	Regular
40703	ACC	211	Principles of Accounting I	3	D09NE		TuTh	12/30/99	12/30/99	H210	9999999	Lecture	Regular
40792	ACC	211	Principles of Accounting I	3	H10NE		Th	12/30/99	12/30/99	H210	3152998	Hybrid	Regular
40859	ACC	211	Principles of Accounting I	3	N11NE		MoWe	12/30/99	12/30/99	H210	9999999	Lecture	1st 8 weeks
40861	ACC	211	Principles of Accounting I	3	N12NE		MoWe	12/30/99	12/30/99	G106	9999999	Lecture	1st 8 weeks
40990	ACC	211	Principles of Accounting I	3	N13NE		TuTh	12/30/99	12/30/99	H225	9999999	Lecture	2nd 8 weeks
41086	ACC	211	Principles of Accounting I	3	N14NE		Tu	12/30/99	12/30/99	H210	9999999	Lecture	Regular
41109	ACC	211	Principles of Accounting I	3	N15NE		Mo	12/30/99	12/30/99	H210	9999999	Lecture	Regular
41133	ACC	211	Principles of Accounting I	3	N16NE		Tu	12/30/99	12/30/99	H210	9999999	Lecture	Regular
41237	ACC	211	Principles of Accounting I	3	N17NE		We	12/30/99	12/30/99	H210	9999999	Lecture	Regular
41277	ACC	211	Principles of Accounting I	3	O18NE		Virtual			Virtual	1252234	Online	Regular
41515	ACC	211	Principles of Accounting I	3	O19NE		Virtual			Virtual	1252234	Online	Regular
41547	ACC	212	Principles of Accounting II	3	D01NE	ACC 211	MoWe	12/30/99	12/30/99	H214	1478893	Lecture	Regular
41568	ACC	212	Principles of Accounting II	3	D02NE	ACC 211	MoWe	12/30/99	12/30/99	H214	2584901	Lecture	Regular
41717	ACC	212	Principles of Accounting II	3	D03NE	ACC 211	TuTh	12/30/99	12/30/99	H214	2584901	Lecture	Regular
41829	ACC	212	Principles of Accounting II	3	D04NE	ACC 211	TuTh	12/30/99	12/30/99	H214	2584901	Lecture	Regular
41834	ACC	212	Principles of Accounting II	3	H05NE	ACC 211	Tu	12/30/99	12/30/99	H214	3152998	Hybrid	Regular
41835	ACC	212	Principles of Accounting II	3	N06NE	ACC 211	Mo	12/30/99	12/30/99	H214	1478893	Lecture	Regular
41853	ACC	212	Principles of Accounting II	3	N07NE	ACC 211	We	12/30/99	12/30/99	H214	9999999	Lecture	Regular
41876	ACC	212	Principles of Accounting II	3	N08NE	ACC 211	Th	12/30/99	12/30/99	H214	9999999	Lecture	Regular
41911	ACC	212	Principles of Accounting II	3	N09NE	ACC 211	MoWe	12/30/99	12/30/99	H210	9999999	Lecture	2nd 8 weeks
41940	ACC	212	Principles of Accounting II	3	N10NE	ACC 211	MoWe	12/30/99	12/30/99	G106	9999999	Lecture	2nd 8 weeks
42028	ACC	212	Principles of Accounting II	3	N11NE	ACC 211	Th	12/30/99	12/30/99	TBA	9999999	Lecture	WFD
42030	ACC	212	Principles of Accounting II	3	O12NE	ACC 211	Virtual			Virtual	1478893	Online	Regular
42154	ACC	215	Computerized Accounting	3	H01NE		Mo	12/30/99	12/30/99	H214	3102555	Hybrid	Regular
42273	ACC	220	Accounting for Small Business	3	N01NE		Tu	12/30/99	12/30/99	H226	3152998	Lecture	Regular
42316	ACC	221	Intermediate Accounting I	4	O01NE	ACC 212	Virtual			Virtual	1478893	Online	Regular
42405	ACC	222	Intermediate Accounting II	4	H01NE	ACC 221	Mo	12/30/99	12/30/99	H225	1478893	Hybrid	Regular
42553	ACC	222	Intermediate Accounting II	4	O02NE	ACC 221	Virtual			Virtual	1478893	Online	Regular
42577	ACC	241	Auditing I	3	N01NE	ACC 212	Th	12/30/99	12/30/99	H210	3152998	Lecture	Regular
42596	ACC	241	Auditing I	3	O02NE	ACC 212	Virtual			Virtual	3152998	Online	Regular
42646	ACC	261	Federal Taxation I	3	N01NE	ACC 211	Tu	12/30/99	12/30/99	H214	2584901	Lecture	Regular
42662	ACC	261	Federal Taxation I	3	O02NE	ACC 211	Virtual			Virtual	2584901	Online	Regular
42721	ACQ	221	Advanced Acquisitions	3	N01NE	ACQ 121	We	12/30/99	12/30/99	G104	5087223	Lecture	Regular
42731	ACQ	231	Contract Pricing & Negotiations I	3	N01NE		Mo	12/30/99	12/30/99	G104	5087223	Lecture	Regular
42790	AST	101	Keyboarding I	3	D01NE		MoWe	12/30/99	12/30/99	H124	7222244	Lecture	Regular
42800	AST	101	Keyboarding I	3	D02NE		TuTh	12/30/99	12/30/99	H124	9999999	Lecture	Regular
42824	AST	101	Keyboarding I	3	W03NE		Sa	12/30/99	12/30/99	H124	9999999	Lecture	Regular
42837	AST	102	Keyboarding II	3	D01NE	AST 101	MoWe	12/30/99	12/30/99	H124	6145288	Lecture	Regular
42866	AST	102	Keyboarding II	3	N02NE	AST 101	TuTh	12/30/99	12/30/99	H124	9999999	Lecture	Regular
42930	AST	141	Advanced Word Processing		H01NE	AST 101	We	12/30/99	12/30/99	H124	6145288	Hybrid	Regular
42972	AST	201	Keyboarding III	3	O01NE	AST 102	Virtual			Virtual	7222244	Online	Regular
42975	AST	205	Business Communications	3	D01NE	ENG 111	TuTh	12/30/99	12/30/99	H124	9999999	Lecture	Regular
43022	AST	205	Business Communications	3	N02NE	ENG 111	Tu	12/30/99	12/30/99	H205	9999999	Lecture	Regular
43066	AST	205	Business Communications	3	O03NE	ENG 111	Virtual			Virtual	1922377	Online	Regular
43223	AST	234	Records & DB Management	3	H01NE		We	12/30/99	12/30/99	H124	9999999	Hybrid	Regular
43272	AST	236	Specialized Software Apps	4	O01NE	AST 101	Virtual			Virtual	7222244	Online	Regular
43435	AST	244	Office Administration II	3	N01NE	AST 243	MoWe	12/30/99	12/30/99	H124	9999999	Lecture	Regular
43481	BUS	100	Introduction to Business	3	D01NE		MoWe	12/30/99	12/30/99	G129	1578523	Lecture	Regular
43498	BUS	100	Introduction to Business	3	D02NE		TuTh	12/30/99	12/30/99	G129	1578523	Lecture	Regular
43534	BUS	100	Introduction to Business	3	D03NE		MoWe	12/30/99	12/30/99	G129	1578523	Lecture	Regular
43747	BUS	100	Introduction to Business	3	D04NE		TuTh	12/30/99	12/30/99	G129	1566543	Lecture	Regular
43830	BUS	100	Introduction to Business	3	D05NE		MoWe	12/30/99	12/30/99	G129	1566543	Lecture	Regular
43842	BUS	100	Introduction to Business	3	D06NE		TuTh	12/30/99	12/30/99	G129	1566543	Lecture	Regular
43892	BUS	100	Introduction to Business	3	D07NE		TuTh	12/30/99	12/30/99	G129	1566543	Lecture	Regular
43961	BUS	100	Introduction to Business	3	N08NE		Mo	12/30/99	12/30/99	G122	9999999	Lecture	Regular
43972	BUS	100	Introduction to Business	3	N09NE		We	12/30/99	12/30/99	G129	9999999	Lecture	Regular
44006	BUS	100	Introduction to Business	3	N10NE		Tu	12/30/99	12/30/99	G129	3233995	Lecture	Regular
44085	BUS	100	Introduction to Business	3	N11NE		Th	12/30/99	12/30/99	G124	3233995	Lecture	Regular
44140	BUS	100	Introduction to Business	3	O12NE		Virtual			Virtual	1922377	Online	Regular
44229	BUS	100	Introduction to Business	3	O13NE		Virtual			Virtual	1578523	Online	Regular
44239	BUS	100	Introduction to Business	3	O14NE		Virtual			Virtual	1578523	Online	Regular
44294	BUS	100	Introduction to Business	3	W15NE		Sa	12/30/99	12/30/99	G129	3233995	Lecture	Regular
44454	BUS	125	Business Mathematics	3	D01NE	MTH 121 or higher	MoWe	12/30/99	12/30/99	G122	3233995	Lecture	Regular
44456	BUS	125	Business Mathematics	3	N02NE	MTH 121 or higher	Th	12/30/99	12/30/99	G122	3233995	Lecture	Regular
44468	BUS	125	Business Mathematics	3	O03NE	MTH 121 or higher	Virtual			Virtual	3233995	Online	Regular
44646	BUS	165	Small Business Management	3	H01NE		Mo	12/30/99	12/30/99	G113	1922377	Hybrid	Regular
44781	BUS	200	Principles of Management	3	D01NE		TuTh	12/30/99	12/30/99	G130	1566543	Lecture	Regular
44824	BUS	200	Principles of Management	3	D02NE		MoWe	12/30/99	12/30/99	G122	1566543	Lecture	Regular
44888	BUS	200	Principles of Management	3	N03NE		Mo	12/30/99	12/30/99	G122	1922377	Lecture	Regular
45184	BUS	200	Principles of Management	3	O04NE		Virtual			Virtual	9999999	Online	Regular
45212	BUS	201	Organizational Behavior	3	D01NE		TuTh	12/30/99	12/30/99	G122	9999999	Lecture	Regular
45228	BUS	201	Organizational Behavior	3	N02NE		TuTh	12/30/99	12/30/99	G122	9999999	Lecture	Regular
45239	BUS	205	Human Resources Management	3	D01NE		TuTh	12/30/99	12/30/99	G122	1922377	Lecture	Regular
45270	BUS	205	Human Resources Management	3	N02NE		We	12/30/99	12/30/99	G122	9999999	Lecture	Regular
45285	BUS	216	Business Statistics & Probability	3	D01NE	ITE 115, MTH 163	TuTh	12/30/99	12/30/99	G130	1578223	Lecture	Regular
45436	BUS	216	Business Statistics & Probability	3	D02NE	ITE 115, MTH 163	MoWe	12/30/99	12/30/99	G130	1578223	Lecture	Regular
45443	BUS	216	Business Statistics & Probability	3	D03NE	ITE 115, MTH 163	TuTh	12/30/99	12/30/99	G130	1578223	Lecture	Regular
45567	BUS	216	Business Statistics & Probability	3	N04NE	ITE 115, MTH 163	Mo	12/30/99	12/30/99	G130	9999999	Lecture	Regular
45600	BUS	216	Business Statistics & Probability	3	N05NE	ITE 115, MTH 163	Tu	12/30/99	12/30/99	G130	9999999	Lecture	Regular
45604	BUS	216	Business Statistics & Probability	3	O06NE	ITE 115, MTH 163	Virtual			Virtual	1578223	Online	Regular
45668	BUS	220	Introduction to Business Statistics	3	N01NE	MTH 121 or higher	Tu	12/30/99	12/30/99	G130	9999999	Lecture	Regular
45679	BUS	220	Introduction to Business Statistics	3	O02NE	MTH 121 or higher	Virtual			Virtual	1578223	Online	Regular
45905	BUS	241	Business Law I	3	D01NE		TuTh	12/30/99	12/30/99	G122	9999999	Lecture	Regular
46044	BUS	241	Business Law I	3	N02NE		We	12/30/99	12/30/99	G122	9999999	Lecture	Regular
46228	BUS	242	Business Law II	3	N01NE	BUS 241	Mo	12/30/99	12/30/99	G124	9999999	Lecture	Regular
46352	GIS	200	Geographic Information Systems I	4	O01NE	ITE 115	Virtual			Virtual	9999999	Online	Regular
46417	GIS	201	Geographic Information Systems II	4	O01NE	GIS 200	Virtual			Virtual	9999999	Online	Regular
46444	HRI	119	Nutrition	3	D01NE		TuTh	12/30/99	12/30/99	H220	2109876	Lecture	Regular
46499	HRI	150	Hospitality Ownership	3	D01NE		TuTh	12/30/99	12/30/99	H220	2109876	Lecture	Regular
46597	HRI	154	Hospitality Management	3	D01NE		TuTh	12/30/99	12/30/99	H220	2109876	Lecture	Regular
46642	HRI	154	Hospitality Management	3	N02NE		Tu	12/30/99	12/30/99	G113	1228964	Lecture	Regular
46658	HRI	154	Hospitality Management	3	O03NE		Virtual			Virtual	1228964	Online	Regular
46734	HRI	158	Sanitation & Safety	3	D01NE		MoWe	12/30/99	12/30/99	H220	2109876	Lecture	Regular
46834	HRI	158	Sanitation & Safety	3	N02NE		Tu	12/30/99	12/30/99	G113	1228964	Lecture	Regular
46842	HRI	158	Sanitation & Safety	3	O03NE		Virtual			Virtual	1228964	Online	Regular
46875	HRI	160	Executive Housekeeping		N01NE		Th	12/30/99	12/30/99	G113	5012877	Lecture	Regular
46928	HRI	180	Convention Management	3	N01NE		We	12/30/99	12/30/99	G113	5012877	Lecture	Regular
46937	HRI	215	Food Purchasing	3	D01NE		MoWe	12/30/99	12/30/99	H220	2109876	Lecture	Regular
46944	HRI	215	Food Purchasing	3	N02NE		We	12/30/99	12/30/99	G113	5012877	Lecture	Regular
47119	HRI	215	Food Purchasing	3	O03NE		Virtual			Virtual	5012877	Online	Regular
47130	HRI	224	Recipe & Menu Management	3	D01NE		MoWe	12/30/99	12/30/99	H220	2109876	Lecture	Regular
47174	HRI	224	Recipe & Menu Management	3	O02NE		Virtual			Virtual	5012877	Online	Regular
47203	HRI	235	Hospitality Marketing	3	N01NE		Mo	12/30/99	12/30/99	G113	9999999	Lecture	Regular
47269	HRI	251	Food & Beverage Cost Control	3	O01NE	MTH 121 or higher	Virtual			Virtual	1228964	Online	Regular
47445	ITD	110	Web Page Design I	4	N01NE		We	12/30/99	12/30/99	H212	2912398	Lecture	Regular
47458	ITD	112	Designing Web Page Graphics	4	D01NE		TuTh	12/30/99	12/30/99	H212	2715255	Lecture	Regular
47689	ITD	112	Designing Web Page Graphics	4	O02NE		Virtual			Virtual	2715255	Online	Regular
47715	ITD	132	Structured Query Language	4	H01NE		We	12/30/99	12/30/99	H207	2312375	Hybrid	Regular
47857	ITD	132	Structured Query Language	4	N02NE		Th	12/30/99	12/30/99	H207	2988821	Lecture	Regular
47959	ITD	134	PL/SQL Programming	4	H01NE	ITD 132	We	12/30/99	12/30/99	H207	2312375	Hybrid	Regular
48027	ITD	136	Database Management Software	4	H01NE	ITD 132	Mo	12/30/99	12/30/99	H207	2312375	Hybrid	2nd 8 weeks
48072	ITD	210	Web Page Design II	4	N01NE	ITD 110	Mo	12/30/99	12/30/99	H212	2912398	Lecture	Regular
48079	ITD	212	Interactive Web Design	4	O01NE	ITD 112	Virtual			Virtual	2715255	Online	Regular
48081	ITD	250	Database Architecture & Administration	4	N01NE		We	12/30/99	12/30/99	H205	2988821	Lecture	Regular
48259	ITD	251	Database System Development	4	H01NE		Tu	12/30/99	12/30/99	H207	2988821	Hybrid	2nd 8 weeks
48264	ITD	252	Database Backup & Recovery	4	H01NE		Mo	12/30/99	12/30/99	H207	2988821	Hybrid	1st 8 weeks
48393	ITE	109	Information Systems for Legal Assistants		D01NE		Fr	12/30/99	12/30/99	H124	7222244	Lecture	Regular
48503	ITE	109	Information Systems for Legal Assistants		N01NE		Th	12/30/99	12/30/99	H124	7222244	Lecture	Regular
48513	ITE	115	Intro to Computer Applications & Concepts		D01NE		MoWe	12/30/99	12/30/99	H224	9999999	Lecture	Regular
48529	ITE	115	Intro to Computer Applications & Concepts	4	D02NE		MoWe	12/30/99	12/30/99	H226	9999999	Lecture	Regular
48534	ITE	115	Intro to Computer Applications & Concepts	4	D03NE		TuTh	12/30/99	12/30/99	H224	9999999	Lecture	Regular
48539	ITE	115	Intro to Computer Applications & Concepts	4	D04NE		Fr	12/30/99	12/30/99	H224	9999999	Lecture	Regular
48625	ITE	115	Intro to Computer Applications & Concepts	4	D05NE		MoWe	12/30/99	12/30/99	H205	9999999	Lecture	Regular
48644	ITE	115	Intro to Computer Applications & Concepts	4	D06NE		TuTh	12/30/99	12/30/99	H205	9999999	Lecture	Regular
48703	ITE	115	Intro to Computer Applications & Concepts	4	D07NE		Fr	12/30/99	12/30/99	H226	9999999	Lecture	Regular
48928	ITE	115	Intro to Computer Applications & Concepts	4	D08NE		MoWe	12/30/99	12/30/99	H224	2912398	Lecture	Regular
48965	ITE	115	Intro to Computer Applications & Concepts	4	D09NE		MoWe	12/30/99	12/30/99	H226	9999999	Lecture	Regular
49103	ITE	115	Intro to Computer Applications & Concepts	4	D10NE		TuTh	12/30/99	12/30/99	H224	2278662	Lecture	Regular
49244	ITE	115	Intro to Computer Applications & Concepts	4	D11NE		MoWe	12/30/99	12/30/99	H224	2912398	Lecture	Regular
49263	ITE	115	Intro to Computer Applications & Concepts	4	D12NE		Mo	12/30/99	12/30/99	H226	9999999	Lecture	Regular
49328	ITE	115	Intro to Computer Applications & Concepts	4	D13NE		MoWe	12/30/99	12/30/99	H224	9999999	Lecture	Regular
49585	ITE	115	Intro to Computer Applications & Concepts	4	D14NE		TuTh	12/30/99	12/30/99	H226	9999999	Lecture	Regular
49744	ITE	115	Intro to Computer Applications & Concepts	4	D15NE		Tu	12/30/99	12/30/99	H226	2278662	Lecture	Regular
49891	ITE	115	Intro to Computer Applications & Concepts	4	D16NE		MoWe	12/30/99	12/30/99	H226	9999999	Lecture	Regular
49920	ITE	115	Intro to Computer Applications & Concepts	4	D17NE		TuTh	12/30/99	12/30/99	H224	9999999	Lecture	Regular
49936	ITE	115	Intro to Computer Applications & Concepts	4	D18NE		TuTh	12/30/99	12/30/99	H226	9999999	Lecture	1st 8 weeks
49947	ITE	115	Intro to Computer Applications & Concepts	4	D19NE		TuTh	12/30/99	12/30/99	H226	9999999	Lecture	2nd 8 weeks
50247	LGL	238	Bankruptcy	3	O02NE	ITE 115	Virtual			Virtual	1922322	Online	Regular
50314	ITN	106	Microcomputer Operating Systems	4	O04NE		Virtual			Virtual	2388652	Online	Regular
50329	ITE	150	Advanced Database Software	4	H01NE	ITE 115	Tu	12/30/99	12/30/99	H235	2034681	Hybrid	Regular
50331	ITP	132	C++ Programming	4	O01NE	ITP 100	Virtual			Virtual	3033300	Online	1st 8 weeks
50352	ITE	141	Spreadsheet Software	1	W01NE		Sa	12/30/99	12/30/99	H225	9999999	Lecture	Regular
50417	ITE	215	Advanced Computer Applications	4	H01NE	ITE 115	Th	12/30/99	12/30/99	H205	2034681	Hybrid	Regular
50475	MKT	100	Principles of Marketing	3	D01NE		MoWe	12/30/99	12/30/99	G130	4856545	Lecture	Regular
50643	MKT	100	Principles of Marketing	3	N03NE		We	12/30/99	12/30/99	G130	2013987	Lecture	Regular
50657	LGL	238	Bankruptcy	3	N01NE		Mo	12/30/99	12/30/99	G129	9999999	Lecture	Regular
50697	ITE	115	Intro to Computer Applications & Concepts	4	O31NE		Virtual			Virtual	2034681	Online	Regular
50755	ITN	107	PC Hardware & Troubleshooting	4	D01NE		TuTh	12/30/99	12/30/99	H271	2621133	Lecture	Regular
50834	ITE	115	Intro to Computer Applications & Concepts	4	H20NE		We	12/30/99	12/30/99	H226	2388652	Hybrid	Regular
50853	ITN	101	Introduction to Network Concepts	4	N02NE	ITN 106 or ITN 170	Tu	12/30/99	12/30/99	H272	2643912	Lecture	Regular
50886	ITP	100	Introduction to Computer Programming	4	O04NE		Virtual			Virtual	3033300	Online	Regular
50963	LGL	200	Ethics for the Legal Assistant	3	D01NE	LGL 110	We	12/30/99	12/30/99	G124	9999999	Lecture	1st 8 weeks
51099	ITE	151	Database Software	1	W01NE		Sa	12/30/99	12/30/99	H225	9999999	Lecture	Regular
51113	LGL	216	Trial Preparation & Discovery	3	N01NE	LGL 110	We	12/30/99	12/30/99	G122	1224567	Lecture	Regular
51129	LGL	110	Introduction to Law & the Legal Assistant	3	D01NE		Th	12/30/99	12/30/99	G124	1922322	Lecture	Regular
51151	ITP	120	Java Programming I	4	H01NE	ITP 100	We	12/30/99	12/30/99	H222	2810005	Hybrid	Regular
51187	LGL	215	Torts	3	N01NE	LGL 110	Tu	12/30/99	12/30/99	G124	1224567	Lecture	Regular
51201	LGL	110	Introduction to Law & the Legal Assistant	3	O03NE		Virtual			Virtual	1922322	Online	Regular
51233	LGL	225	Estate Planning & Probate	3	N01NE	LGL 110	Th	12/30/99	12/30/99	G130	9999999	Lecture	Regular
51251	ITE	115	Intro to Computer Applications & Concepts	4	O37NE		Virtual			Virtual	9999999	Online	Regular
51286	ITE	115	Intro to Computer Applications & Concepts	4	O39NE		Virtual			Virtual	9999999	Online	2nd 8 weeks
51447	MKT	100	Principles of Marketing	3	N04NE		Tu	12/30/99	12/30/99	G121	2013987	Lecture	Regular
51458	LGL	117	Family Law	3	N02NE	LGL 110	Tu	12/30/99	12/30/99	G116	1224567	Lecture	Regular
51483	ITE	115	Intro to Computer Applications & Concepts	4	O41NE		Virtual			Virtual	2034681	Online	1st 8 weeks
51546	ITP	112	Visual Basic.NET I	4	H01NE	ITP 100	Th	12/30/99	12/30/99	H222	3033300	Hybrid	1st 8 weeks
51605	LGL	110	Introduction to Law & the Legal Assistant	3	N02NE		Mo	12/30/99	12/30/99	G116	1922322	Lecture	Regular
51618	ITE	115	Intro to Computer Applications & Concepts	4	H22NE		Tu	12/30/99	12/30/99	H272	2643912	Hybrid	Regular
51670	ITE	115	Intro to Computer Applications & Concepts	4	N25NE		We	12/30/99	12/30/99	H224	9999999	Lecture	Regular
51724	ITP	100	Introduction to Computer Programming	4	N03NE		Tu	12/30/99	12/30/99	H222	9999999	Lecture	Regular
51734	LGL	218	Criminal Law	3	N01NE	LGL 110	Th	12/30/99	12/30/99	G122	9999999	Lecture	Regular
51769	LGL	235	Business Organizations Legal Aspects	3	N01NE	LGL 110	We	12/30/99	12/30/99	G130	9999999	Lecture	Regular
51802	ITP	240	Server Side Programming	4	N01NE	ITP 100, ITD 110, ITD 132	Tu	12/30/99	12/30/99	H270	2278662	Lecture	Regular
51821	ITE	115	Intro to Computer Applications & Concepts	4	N29NE		Th	12/30/99	12/30/99	H224	9999999	Lecture	Regular
51888	ITN	106	Microcomputer Operating Systems	4	D01NE		TuTh	12/30/99	12/30/99	H271	2543991	Lecture	Regular
51895	MKT	100	Principles of Marketing	3	O05NE		Virtual			Virtual	2013987	Online	Regular
51918	ITE	115	Intro to Computer Applications & Concepts	4	O35NE		Virtual			Virtual	2388652	Online	Regular
51949	ITE	115	Intro to Computer Applications & Concepts	4	O32NE		Virtual			Virtual	2912338	Online	Regular
51965	ITE	115	Intro to Computer Applications & Concepts	4	O33NE		Virtual			Virtual	3033300	Online	Regular
51971	ITE	115	Intro to Computer Applications & Concepts	4	H23NE		Mo	12/30/99	12/30/99	H226	9999999	Hybrid	Regular
52222	LGL	125	Legal Research	3	N01NE	LGL 110	Mo	12/30/99	12/30/99	LLib	9999999	Lecture	Regular
52240	ITE	115	Intro to Computer Applications & Concepts	4	N28NE		Th	12/30/99	12/30/99	H226	9999999	Lecture	Regular
52293	LGL	126	Legal Writing	3	N02NE	LGL 125	Th	12/30/99	12/30/99	LLib	9999999	Lecture	Regular
52304	ITN	170	UNIX I	4	H01NE		Th	12/30/99	12/30/99	H272	9999999	Hybrid	Regular
52325	ITN	107	PC Hardware & Troubleshooting	4	O04NE		Virtual			Virtual	2912338	Online	Regular
52338	ITE	115	Intro to Computer Applications & Concepts	4	W41NE		Sa	12/30/99	12/30/99	H224	9999999	Lecture	Regular
52506	ITE	115	Intro to Computer Applications & Concepts	4	N30NE		MoWe	12/30/99	12/30/99	H235	9999999	Lecture	2nd 8 weeks
52535	ITE	115	Intro to Computer Applications & Concepts	4	N27NE		We	12/30/99	12/30/99	H226	9999999	Lecture	Regular
52573	LGL	125	Legal Research	3	W02NE	LGL 110	Sa	12/30/99	12/30/99	LLib	9999999	Lecture	Regular
52607	ITN	260	Network Security Basics	4	O02NE	ITN 101	Virtual			Virtual	9999999	Online	Regular
52730	ITE	140	Advanced Spreadsheet Software	4	H01NE	ITE 115	Tu	12/30/99	12/30/99	H235	2034681	Hybrid	Regular
52740	ITE	115	Intro to Computer Applications & Concepts	4	O34NE		Virtual			Virtual	2912338	Online	Regular
52741	LGL	250	Immigration Law	3	H01NE	LGL 110	Mo	12/30/99	12/30/99	G124	1224567	Lecture	Regular
52899	ITN	107	PC Hardware & Troubleshooting	4	N03NE		Th	12/30/99	12/30/99	H271	9999999	Lecture	Regular
52955	ITE	215	Advanced Computer Applications	4	O02NE	ITE 115	Virtual			Virtual	2034681	Online	Regular
52986	ITE	130	Introduction to Internet Services	4	D01NE		MoWe	12/30/99	12/30/99	H212	2621133	Lecture	Regular
53048	ITN	110	Client Operating System	4	N01NE	ITN 106, ITN 101	We	12/30/99	12/30/99	H209	2278662	Lecture	Regular
53158	LGL	115	Real Estate & the Legal Assistant	3	O01NE	LGL 110	Virtual			Virtual	1922322	Online	Regular
53173	ITN	101	Introduction to Network Concepts	4	O03NE	ITN 106 or ITN 170	Virtual			Virtual	2643912	Online	Regular
53346	ITN	107	PC Hardware & Troubleshooting	4	N02NE		Tu	12/30/99	12/30/99	H271	2621133	Lecture	Regular
53374	ITN	224	Web Server Management	4	N01NE	ITN 109	Tu	12/30/99	12/30/99	H212	2312375	Lecture	Regular
53465	ITP	212	Visual Basic.NET II	4	H01NE	ITP 112	Th	12/30/99	12/30/99	H222	3033300	Hybrid	2nd 8 weeks
53527	ITP	100	Introduction to Computer Programming	4	D01NE		MoWe	12/30/99	12/30/99	H222	2810005	Lecture	Regular
53531	LGL	218	Criminal Law	3	O02NE	LGL 110	Virtual			Virtual	9999999	Online	Regular
53572	MKT	220	Principles of Advertising	3	N01NE		Th	12/30/99	12/30/99	G129	2013987	Lecture	Regular
53806	ITE	115	Intro to Computer Applications & Concepts	4	O38NE		Virtual			Virtual	2034681	Online	1st 8 weeks
53831	ITN	173	Switching & Routing - Cisco	4	N01NE	ITN 172	We	12/30/99	12/30/99	H270	2912338	Lecture	Regular
47362	HRI	265	Hotel Front End Operations	3	N01NE		Th	12/30/99	12/30/99	G113	9999999	Lecture	Regular
53849	ITP	232	C++ Programming II	4	O01NE	ITP 132	Virtual			Virtual	2810005	Online	2nd 8 weeks
53869	ITN	109	Internet & Network Foundations	4	N01NE		Th	12/30/99	12/30/99	H212	2715255	Lecture	Regular
53973	LGL	230	Legal Transactions	3	N01NE	LGL 110	We	12/30/99	12/30/99	G116	9999999	Lecture	Regular
53998	ITN	172	Networking Fundamentals - Cisco	4	N01NE		Mo	12/30/99	12/30/99	H270	9999999	Lecture	Regular
54024	ITE	200	Technology for Teachers	4	N01NE	ITE 115	Tu	12/30/99	12/30/99	H124	9999999	Lecture	Regular
54048	ITN	260	Network Security Basics	4	H01NE	ITN 101	We	12/30/99	12/30/99	H272	9999999	Hybrid	Regular
54056	ITE	115	Intro to Computer Applications & Concepts	4	W43NE		Sa	12/30/99	12/30/99	H226	9999999	Lecture	2nd 8 weeks
54184	REA	100	Principles of Real Estate	3	D01NE		Fr	12/30/99	12/30/99	H222	9999999	Lecture	Regular
54283	ITE	115	Intro to Computer Applications & Concepts	4	O36NE		Virtual			Virtual	2388652	Online	Regular
54297	ITE	130	Introduction to Internet Services	4	O02NE		Virtual			Virtual	2621133	Online	Regular
54355	ITE	115	Intro to Computer Applications & Concepts	4	H21NE		Th	12/30/99	12/30/99	H226	2388652	Hybrid	Regular
54422	ITP	100	Introduction to Computer Programming	4	D02NE		TuTh	12/30/99	12/30/99	H222	2810005	Lecture	Regular
54522	ITN	101	Introduction to Network Concepts	4	D01NE	ITN 106 or ITN 170	TuTh	12/30/99	12/30/99	H272	2643912	Lecture	Regular
54603	ITN	111	Server Administration	4	N01NE	ITN 110	Mo	12/30/99	12/30/99	H209	2543991	Lecture	Regular
54665	ITE	115	Intro to Computer Applications Concepts	4	W42NE		Sa	12/30/99	12/30/99	H226	9999999	Lecture	1st 8 weeks
54685	MKT	100	Principles of Marketing	3	D02NE		TuTh	12/30/99	12/30/99	G130	4856545	Lecture	Regular
54780	ITN	106	Microcomputer Operating Systems	4	H02NE		Mo	12/30/99	12/30/99	H271	2621133	Hybrid	Regular
54781	ITN	106	Microcomputer Operating Systems	4	N03NE		We	12/30/99	12/30/99	H271	2543991	Lecture	Regular
54786	ITE	131	Survey of Internet Services	1	W01NE		Sa	12/30/99	12/30/99	H212	9999999	Lecture	Regular
54845	ITE	115	Intro to Computer Applications & Concepts	4	N26NE		Tu	12/30/99	12/30/99	H224	9999999	Lecture	Regular
54872	LGL	126	Legal Writing	3	N01NE	LGL 125	We	12/30/99	12/30/99	LLib	9999999	Lecture	Regular
54935	LGL	117	Family Law	3	D01NE	LGL 110	We	12/30/99	12/30/99	G124	1224567	Lecture	Regular
54937	ITE	115	Intro to Computer Applications & Concepts	4	N24NE		Mo	12/30/99	12/30/99	H224	9999999	Lecture	Regular

a02_student_files/a02B_Athletes.xlsx

Student Athletes

Student ID	First Name	Last Name	Gender	Address	City	State	Postal Code	Home Phone	College Email
3768532	Rebekah	Alexander	F	218 Chapparal Trl	Dale	TX	78616	(512) 555-1017	[email protected]
3905345	Oscar	Alvarado	M	214B Bluff St	Buda	TX	78610	(512) 555-1022	[email protected]
3802483	Maria	Alvarez	F	3590 Longhorn Trl	Round Rock	TX	78681	(512) 555-2026	[email protected]
4739502	Eliza	Alvarez	F	3590 Longhorn Trl	Round Rock	TX	78681	(512) 555-2025	[email protected]
2834850	Ryan	Asfar	M	1325 Drifting Wind Run	Dripping Springs	TX	78620	(512) 555-0308	[email protected]
2834953	Chinonso	Austin	M	123 Wild Buffalo Dr	Kyle	TX	78640	(512) 555-1012	[email protected]
5867384	Hashem	Avis	M	532 Virginia St	San Marcos	TX	78666	(512) 555-9363	[email protected]
1034823	Joel	Barthmaier	M	188 Rockwood Dr	Wimberley	TX	78676	(512) 555-2320	[email protected]
8567302	Daniel	Bean	M	1433 Walpole Ln	Austin	TX	78739	(512) 555-2100	[email protected]
3856958	Danila	Bennett	F	808 Springbrook Ln	Leander	TX	78641	(512) 555-9364	[email protected]
1284734	Marianne	Berguin	F	180 Snyder Trl	Liberty Hill	TX	78642	(512) 555-1006	[email protected]
1298345	Shawn	Boulward	F	5689 Wild Foxglove Rd	Spicewood	TX	78669	(512) 555-2321	[email protected]
4352863	Christine	Bradley	F	2708 Kickapoo Cavern Dr	Pflugerville	TX	78660	(512) 555-2013	[email protected]
9348572	Pablo	Brandozzi	M	10006 Woodland Village Dr	Austin	TX	78750	(512) 555-1009	[email protected]
6739256	Katherine	Brown	F	707 Walnut St	Bastrop	TX	78602	(512) 555-2012	[email protected]
5860300	Daria	Campbell	F	162 Rockwood Dr	Wimberley	TX	78674	(512) 555-1016	[email protected]
3458632	Stephanie	Caputo	F	1731 Primrose Tr	Round Rock	TX	78665	(512) 555-2330	[email protected]
3842958	McCall	Cheney	M	1053 Tumbleweed Dr	Dale	TX	78616	(512) 555-1023	[email protected]
5738495	Robert	Chun	M	786 W Live Oak St	Lockhart	TX	78644	(512) 555-2331	[email protected]
5748392	Renato	Cildaro	M	334 Sand Hills Rd	Red Rock	TX	78662	(512) 555-2318	[email protected]
7384952	Christopher	Darko	M	240 Washington St	Smithville	TX	78657	(512) 555-1008	[email protected]
2938593	Curtis	Dawson	M	10344 Yellowstone Dr	Austin	TX	78747	(512) 555-2015	[email protected]
4719238	Avelina	DiAntonio	F	1008 Sunset Canyon Dr	Dripping Springs	TX	78620	(512) 555-2319	[email protected]
3829465	Tony	Downey	M	113 Zarogoza St	Elgin	TX	78621	(512) 555-1013	[email protected]
2839403	Nicole	Dutton	F	122 Whispering Spring Ln	Georgetown	TX	78633	(512) 555-2315	[email protected]
1284354	Katie	Eckert	F	10305 Windstone Ct	Manor	TX	78653	(512) 555-9357	[email protected]
2845209	Stephan	Elraheb	M	351 Wild Senna Dr	Pflugerville	TX	78660	(512) 555-1011	[email protected]
3829356	Marcel	Enescu	M	1900 White Oak Loop	Round Rock	TX	78681	(512) 555-1007	[email protected]
2849523	Moises	Fernandez	M	124 Woodland Ln	Round Rock	TX	78665	(512) 555-2320	[email protected]
3957203	Howard	Fishman	M	1842 Sorghum Hill Dr	Austin	TX	78754	(512) 555-2062	[email protected]
3948506	Kerry	Fleischer	M	2984 Piping Rock Trl	Austin	TX	78748	(512) 555-0309	[email protected]
3847589	Prince	Flitcroft	M	7821 Winsted Ln	Austin	TX	78703	(512) 555-1021	[email protected]
5730483	Clement	Forrester	M	1506 Wilshire Blvd	Austin	TX	78722	(512) 555-2018	[email protected]
9340582	Howard	Fouladi	M	276 Bayou Bend Dr	Buda	TX	78610	(512) 555-0310	[email protected]
4769304	Jana	Furfy	F	2107 Edenwood Dr	Austin	TX	78745	(512) 555-2064	[email protected]
2847194	Ginetta	Gant	F	100B W Mercer St	Dripping Springs	TX	78620	(512) 555-2321	[email protected]
1846834	Lan	Geng	M	170 Goldenrod St	Kyle	TX	78640	(512) 555-1005	[email protected]
1102544	Hugh	Goldstein	M	925 Conway Dr	San Marcos	TX	78666	(512) 555-0300	[email protected]
3849234	Donald	Hanby	M	334 Blue Heron Run	Wimberley	TX	78676	(512) 555-2316	[email protected]
8495034	Jason	Harden	M	9009 Bolton St	Austin	TX	78739	(512) 555-2319	[email protected]
2837490	Caitlyn	Hardy	F	359 Bentwood Dr	Leander	TX	78646	(512) 555-2310	[email protected]
7481938	Jamal	Hardy	M	664 Carson Ave	Liberty Hill	TX	78642	(512) 555-2318	[email protected]
8273409	Naomi	Henigson	F	22568 Briarcliff Dr	Spicewood	TX	78669	(512) 555-2014	[email protected]
3593653	Anna	Hernandez	F	2132 Mesquite Ln	Georgetown	TX	78626	(512) 555-0301	[email protected]
6753841	Jill	Hutzell	F	6462 Bisview Dr	Austin	TX	78730	(512) 555-9361	[email protected]
2738473	Ahjamu	Ibtehal	M	510 Buttonwood St	Bastrop	TX	78602	(512) 555-2020	[email protected]
5834924	Anastasia	Kakaulian	F	4822 Turtle Mound Bnd	Austin	TX	78748	(512) 555-2031	[email protected]
8751243	Fredric	Kerrison	M	278 Chapparral Trl	Dale	TX	78616	(512) 555-9358	[email protected]
2845721	Dana	Larsen	F	789 Bois Darc St	Lockhart	TX	78644	(512) 555-2314	[email protected]
3829476	Xifeng	Lau	M	127 Bateman Rd	Red Rock	TX	78662	(512) 555-2317	[email protected]
8473849	Yuri	Lau	M	367 1st Ave	Smithville	TX	78657	(512) 555-2021	[email protected]
3847563	Andrew	Lee	M	14010 Big Thicket Dr	Austin	TX	78747	(512) 555-1002	[email protected]
6738419	Kevin	Leopoldo	M	476 Beaukiss Ln	Elgin	TX	78621	(512) 555-1019	[email protected]
9583924	Moniquin	Lett	M	1121 Ascot St	Georgetown	TX	78627	(512) 555-2016	[email protected]
3819375	Jennifer	Locanda	F	10543 Blake Manor Rd	Manor	TX	78653	(512) 555-2311	[email protected]
6739234	Janie	Martinez	F	840 Abbey Glen Castle Dr	Pflugerville	TX	78660	(512) 555-2027	[email protected]
8247593	Patrice	Martinez	F	3632 Castle Path	Round Rock	TX	78681	(512) 555-2022	[email protected]
7348502	Yianna	Mathis	F	1187 Barilla Mountain Trl	Round Rock	TX	78665	(512) 555-0303	[email protected]
2903485	Jalpit	Matson	M	3204 Bird Call Pass	Austin	TX	78754	(512) 555-2028	[email protected]
2583697	Cleta	McElaney	F	132 Copperfield Dr	Austin	TX	78753	(512) 555-0305	[email protected]
3852938	Atonye	Morris	M	1172 Buttonwood St	Bastrop	TX	78602	(512) 555-1018	[email protected]
3859375	Nancy	Morrissey	F	903 Alpine Rd	Austin	TX	78704	(512) 555-2061	[email protected]
9385602	Lloyd	Murphy	M	657 Newfield Ln	Austin	TX	78703	(512) 555-0306	[email protected]
3856930	Cong	Nguyen	M	444 E Alamo St	Elgin	TX	78621	(512) 555-1004	[email protected]
8572034	Jonathan	Ninomiya	M	632 Langston Dr	Austin	TX	78723	(512) 555-2023	[email protected]
3857493	Sonia	Olson	F	193 Middle Creek Dr	Buda	TX	78610	(512) 555-2024	[email protected]
8273438	Edgardo	Pabelonia	M	894 Hidden Hills Dr	Dripping Springs	TX	78620	(512) 555-2322	[email protected]
9183467	Martin	Paffenroth	M	553 Silverado Dr	Kyle	TX	78640	(512) 555-2317	[email protected]
4852384	James	Parkhill	M	105 E Myrtle St	Liberty Hill	TX	78642	(512) 555-2323	[email protected]
5835035	Laurence	Poon	M	263 Caddis Cv	Kyle	TX	78640	(512) 555-0304	[email protected]
7583249	Betty	Poon	F	263 Caddis Cv	Kyle	TX	78640	(512) 555-1001	[email protected]
2840583	Oscar	Prince	M	367 Encino St	San Marcos	TX	78666	(512) 555-1014	[email protected]
8394284	Nora	Ramos	F	234 Melody Way	Wimberley	TX	78676	(512) 555-2325	[email protected]
9039453	Carlito	Ramos	M	6432 Old Harbor La	Austin	TX	78739	(512) 555-2324	[email protected]
3572184	Carla	Reid	F	715 Pampas Ricas Dr	Leander	TX	78641	(512) 555-2026	[email protected]
3852349	Kirsten	Riccardi	F	632 Ranchero Rd	Leander	TX	78645	(512) 555-9359	[email protected]
3859323	Micah	Rosario	M	376 Grange St	Liberty Hill	TX	78642	(512) 555-1015	[email protected]
5820384	Edward	Rose	M	555 S Blanco St	Lockhart	TX	78644	(512) 555-2019	[email protected]
6739319	Zack	Rowe	M	8728 Texas Bluebell Dr	Spicewood	TX	78669	(512) 555-1020	[email protected]
3859305	Mildred	Santangelo	F	687 Horseback Hollow	Austin	TX	78732	(512) 555-0307	[email protected]
5720358	Margot	Schneider	F	628C Farm St	Bastrop	TX	78602	(512) 555-2101	[email protected]
3802843	Anthony	Scott	M	65 Oakwood Dr	Dale	TX	78616	(512) 555-2326	[email protected]
2849201	Lisa	Sharpe	F	567 N Pecos St	Lockhart	TX	78644	(512) 555-2313	[email protected]
2595304	Joyce	Siegel	F	2678 Pettytown Rd	Red Rock	TX	78662	(512) 555-0302	[email protected]
5849320	Reza	Soltan	M	5498 Wild Foxglove Rd	Spicewood	TX	78669	(512) 555-9362	[email protected]
5739437	Eugene	Sotova	M	130 Garwood St	Smithville	TX	78657	(512) 555-2030	[email protected]
3857684	Michael	Stanton	M	6732 Langhorn St	Austin	TX	78741	(512) 555-2327	[email protected]
3586943	Joseph	Stavish	M	660 Bayou Bend Dr	Buda	TX	78610	(512) 555-9360	[email protected]
3845724	Mihir	Subramanian	M	670 Mogonye Ln	Elgin	TX	78621	(512) 555-2029	[email protected]
2034834	Larry	Telfer	M	162 Rattlesnake Ln	Red Rock	TX	78662	(512) 555-2017	[email protected]
8374853	Hendrick	Themis	M	2590 Mesquite Ln	Georgetown	TX	78226	(512) 555-1010	[email protected]
3569325	Carlis	Thomas	F	28A 4th Ave	Smithville	TX	78657	(512) 555-0301	[email protected]
2934853	Khrystyna	Tilson	F	11520 Oaklynn Ct	Manor	TX	78653	(512) 555-2328	[email protected]
8273485	Pei	Tram	F	3567 Vanderbilt Cir	Pflugerville	TX	78660	(512) 555-2027	[email protected]
8347568	Yolanda	Tram	F	3152 Homewood Cir	Round Rock	TX	78665	(512) 555-2025	[email protected]
2349535	Ashwin	Vohra	M	316 Lost Cove Dr	Spicewood	TX	78669	(512) 555-0302	[email protected]
3128456	WenLi	Wall	F	14380 Ceylon Tea Cir	Pflugerville	TX	78660	(512) 555-2329	[email protected]
3824752	Jaehee	Wang	M	2508 Falcon Dr	Round Rock	TX	78681	(512) 555-1003	[email protected]
9375202	Marilyn	Youson	F	8723 Leisure Dr	Austin	TX	78754	(512) 555-2063	[email protected]
1728193	Jean	Zadro	F	4345 Palacios Cir	Austin	TX	78749	(512) 555-2312	[email protected]
8938456	Florence	Zimmerman	F	98 San Jacinto Blvd	Austin	TX	78701	(512) 555-9356	[email protected]

a02_student_files/a02B_Athletes_Scholarships.accdb

Scholarship Name	Amount	Sport	Team	Award Date	Student ID	Awarding Organization	Scholarship ID
Austin Jump Ball Award	¤ 300.00	Basketball	Men's	9/30/18	1034823	Texas Lakes CC Foundation	S-01
Texas Lakes Sportsmanship Award	¤ 100.00	Swimming	Men's	5/23/18	3586943	Texas Lakes CC Foundation	S-02
Austin Sports Fellowship Award	¤ 500.00	Football	Men's	5/1/18	3802843	Texas Lakes CC Foundation	S-03
Round Rock Country Club Award	¤ 300.00	Golf	Men's	5/23/18	8751243	Round Rock Country Club	S-04
Austin Sports Fellowship Award	¤ 500.00	Basketball	Men's	2/15/18	7384952	Texas Lakes CC Foundation	S-05
Rivers and Parks Foundation Award	¤ 750.00	Swimming	Women's	3/22/18	3572184	Foundation for Rivers and Parks	S-06
Austin Country Club Award	¤ 200.00	Golf	Women's	6/25/18	3856958	Austin Country Club	S-07
Texas State Baseball Association	¤ 500.00	Baseball	Men's	1/16/18	3802843	Texas Lakes CC Foundation	S-08
Texas State Baseball Association	¤ 300.00	Baseball	Men's	10/30/18	4852384	Texas Lakes CC Foundation	S-09
District Tennis Club Leadership Award	¤ 200.00	Tennis	Women's	5/6/18	5748392	District Volleyball Club	S-10
Presidential Memorial Award	¤ 200.00	Volleyball	Women's	11/4/18	5834924	Presidential Memorial Fund	S-11
Texas Sportswomen Foundation Award	¤ 300.00	Basketball	Women's	5/6/18	3852938	Texas Lakes CC Foundation	S-12
Home Run Foundation Award	¤ 200.00	Baseball	Men's	8/4/18	3829356	Texas Lakes CC Foundation	S-13
Texas Science Achievement Award	¤ 750.00	Football	Men's	11/12/18	9583924	Texas Lakes CC Foundation	S-14
Roundball Academic Achievement Award	¤ 500.00	Basketball	Men's	1/25/18	6739319	Texas Lakes CC Foundation	S-15
Bluebonnet Country Club Foundation Award	¤ 400.00	Swimming	Women's	5/23/18	8394284	Texas Lakes Country Club	S-16
Go To The Net Award	¤ 200.00	Tennis	Men's	7/29/18	5739437	Rotary Club of Round Rock	S-17
Pflugerville Academic Achievement Award	¤ 250.00	Volleyball	Women's	5/21/18	1298345	Pflugerville County Foundation for Education	S-18
Capital Cities Country Club Foundation Award	¤ 200.00	Golf	Men's	12/6/18	2845209	Texas Lakes CC Foundation	S-19
Michael Fresch Foundation Award	¤ 400.00	Tennis	Women's	4/14/18	3572184	Michael Fresch Family Foundation	S-20
Gold Helmet Award	¤ 100.00	Football	Men's	7/12/18	3957203	Texas Lakes CC Foundation	S-21
Spike It Award	¤ 200.00	Volleyball	Women's	2/22/18	2934853	Rotary Club of San Marcos	S-22
Hoops Sports Award	¤ 500.00	Basketball	Men's	8/15/18	3847589	Texas Lakes CC Foundation	S-23
Hoops Fellowship Award	¤ 500.00	Basketball	Women's	4/10/18	3859305	Texas Lakes CC Foundation	S-24
Hoops National Winner Award	¤ 400.00	Basketball	Women's	12/22/18	5720358	Texas Lakes CC Foundation	S-25
Dolphin Club Award	¤ 300.00	Swimming	Women's	10/24/18	8938456	Texas Lakes CC Foundation	S-26
Joseph Ingram Memorial Award	¤ 400.00	Tennis	Women's	12/1/18	8938456	Texas Lakes CC Foundation	S-27
First Down Award	¤ 200.00	Football	Men's	3/27/18	1846834	Rotary Club of Elgin	S-28
The Touchdown Alumni Association Award	¤ 600.00	Football	Men's	2/12/18	2849523	Texas Lakes CC Foundation	S-29
Austin Sports Award	¤ 500.00	Basketball	Women's	7/18/18	4352863	Texas Lakes CC Foundation	S-30

a02_student_files/a02C_Freshman_Orientation.accdb

Student ID	State	Postal Code	Phone Number	Orientation ID	First Name	Last Name	Address	City	Email Address
4310244	TX	78666	(512) 555-0054	O-1	Tara	Shorecrest	105 Travis St	San Marcos	[email protected]
4310245	TX	78620	(512) 555-0071	O-002	Charlie	Campbell	215C W Mercer St	Dripping Springs	[email protected]
4310246	TX	78676	(512) 555-0063	O-003	Mark	Curtis	112 Green Acres Dr	Wimberley	[email protected]
3593654	TX	78626	(512) 555-0301	O-004	Carlos	Hernandez	2132 Mesquite Ln	Georgetown	[email protected]
4310248	TX	78745	(512) 555-0041	O-005	Ben	Marsh	5804 Burnhill Dr	Austin	[email protected]
4310249	TX	78745	(512) 555-0051	O-1	Darcy	McDougal	632 Dittmer Rd	Austin	[email protected]
4310250	TX	78733	(512) 555-0065	O-002	Edith	Reid	15456 Indigo Broom Loop	Austin	[email protected]
4310251	TX	78676	(512) 555-0098	O-003	Jessica	Lee	369 Dobie Dr	Wimberley	[email protected]
4310252	TX	78736	(512) 555-0064	O-004	George	Thompson	11234 Tangleridge Cir	Austin	[email protected]
4310253	TX	78620	(512) 555-0063	O-005	Sophie	Goetz	101 Drifting Wind Run	Dripping Springs	[email protected]
4310254	TX	78610	(512) 555-0013	O-1	Emily	Allen	2122 Cole Springs Rd	Buda	[email protected]
4310255	TX	78749	(512) 555-0031	O-002	Sara	Montague	5444 Lomita Verde Cir	Austin	[email protected]
1034823	TX	78676	(512) 555-2320	O-004	Joel	Barthmaier	1887 Rockwood Dr	Wimberly	[email protected]
4310257	TX	78666	(512) 555-0073	O-003	Carl	Chapman	2586 Sunflower Ln	San Marcos	[email protected]
4310258	TX	78749	(512) 555-0072	O-004	Jeremy	Matthews	8278 Nairn Dr	Austin	[email protected]
4310259	TX	78610	(512) 555-0062	O-005	Jessica	Rhoades	625 Clarence Ct	Buda	[email protected]
4310260	TX	78676	(512) 555-0060	O-1	Sara	Miller	1504 River Rd	Wimberley	[email protected]
4310261	TX	78620	(512) 555-0021	O-002	George	Sanders	187B E Mercer St	Dripping Springs	[email protected]
4310262	TX	78640	(512) 555-0089	O-003	Lisa	Inaba	132 S Main St	Kyle	[email protected]
2034834	TX	78662	(512) 555-2017		Larry	Telfer	162 Rattlesnake Ln	Red Rock	[email protected]
4310264	TX	78749	(512) 555-0061	O-004	Victoria	D'Amato	66214 Ruxton Ln	Austin	[email protected]
4310265	TX	78749	(512) 555-0076	O-005	Angela	Vroom	4618 Moose Dr	Austin	[email protected]
4310266	TX	78640	(512) 555-0067	O-1	Kristin	Schultz	476 Silverado Dr	Kyle	[email protected]
4310267	TX	78676	(512) 555-0088	O-002	Rosa	Suarez	635 Rhodes Ln	Wimberley	[email protected]
2349535	TX	78669	(512) 555-0302	O-004	Ashwin	Vohra	316 Lost Cove Dr	Spicewood	[email protected]
5834924	TX	78748	(512) 555-2031	O-005	Anastasia	Kakaulian	4822 Turtle Mound Bnd	Austin	[email protected]
2583697	TX	78753	(512) 555-0305	O-1	Cleta	McElaney	132 Copperfield Dr	Austin	[email protected]
3128456	TX	78660	(512) 555-2329	O-005	WenLi	Wall	14380 Ceylon Tea Cir	Pflugerville	[email protected]
3458632	TX	78665	(512) 555-2330	O-004	Stephanie	Caputo	1731 Primrose Trl	Round Rock	[email protected]
3569325	TX	78657	(512) 555-0301	O-1	Carlis	Thomas	28A 4th Ave	Smithville	[email protected]
3572184	TX	78641	(512) 555-2026	O-005	Carla	Reid	715 Pampas Ricas Dr	Leander	[email protected]
3586943	TX	78610	(512) 555-9360	O-003	Joseph	Stavish	660 Bayou Bend Dr	Buda	[email protected]
3593653	TX	78626	(512) 555-0301	O-003	Anna	Hernandez	2132 Mesquite Ln	Georgetown	[email protected]
3768532	TX	78616	(512) 555-1017	O-1	Rebekah	Alexander	218 Chapparal Trl	Dale	[email protected]
3852938	TX	78602	(512) 555-1018	O-002	Atonye	Morris	1172 Buttonwood St	Bastrop	[email protected]
3856930	TX	78621	(512) 555-1004	O-003	Cong	Nguyen	444 E Alamo St	Elgin	[email protected]
4352863	TX	78660	(512) 555-2013	O-005	Christine	Bradley	2708 Kickapoo Cavern Dr	Pflugerville	[email protected]
4719238	TX	78620	(512) 555-2319	O-003	Avelina	DiAntonio	1008 Sunset Canyon Dr	Dripping Springs	[email protected]
4739502	TX	78681	(512) 555-2025	O-002	Eliza	Alvarez	3590 Longhorn Trl	Round Rock	[email protected]
4769304	TX	78745	(512) 555-2064	O-005	Jana	Furfy	2107 Edenwood Dr	Austin	[email protected]
4852384	TX	78642	(512) 555-2323	O-005	James	Parkhill	105 E Myrtle St	Liberty Hill	[email protected]
5820384	TX	78644	(512) 555-2019	O-002	Edward	Rose	555 S Blanco St	Lockhart	[email protected]
4310286	TX	78735	(512) 555-2031		Marquita	Esposito	5212 Concho Creek Blvd	Austin	[email protected]
5835035	TX	78640	(512) 555-0304	O-002	Laurence	Poon	263 Caddis Cv	Kyle	[email protected]
5849320	TX	78669	(512) 555-9362	O-005	Reza	Soltan	5498 Wild Foxglove Rd	Spicewood	[email protected]
5860300	TX	78674	(512) 555-1016	O-002	Daria	Campbell	162 Rockwood Dr	Wimberley	[email protected]
4310290	TX	78610	(512) 555-2323	O-1	James	Frank	564 Middle Creek Dr	Buda	[email protected]
4310291	TX	78644	(512) 555-2019	O-002	Marsha	Rose	555 S Blanco St	Lockhart	[email protected]
5720358	TX	78602	(512) 555-2101	O-004	Margot	Schneider	628C Farm St	Bastrop	[email protected]
5738495	TX	78644	(512) 555-2331	O-005	Robert	Chun	786 W Live Oak St	Lockhart	[email protected]
5748392	TX	78662	(512) 555-2318	O-1	Renato	Cildaro	334 Sand Hills Rd	Red Rock	[email protected]
4310295	TX	78666	(512) 555-0304		Valerie	Jones	721Viola St	San Marcos	[email protected]
4310296	TX	78739	(512) 555-9362	O-1	Reba	Sullivan	7865 Cherisse Dr	Austin	[email protected]
5867384	TX	78666	(512) 555-9363	O-003	Hashem	Avis	532 Virginia St	San Marcos	[email protected]
6738419	TX	78621	(512) 555-1019	O-002	Kevin	Leopoldo	476 Beaukiss Ln	Elgin	[email protected]
6739234	TX	78660	(512) 555-2027	O-003	Janie	Martinez	840 Abbey Glen Castle Dr	Pflugerville	[email protected]
6739256	TX	78602	(512) 555-2012	O-1	Katherine	Brown	707 Walnut St	Bastrop	[email protected]
6739319	TX	78669	(512) 555-1020	O-003	Zack	Rowe	8728 Texas Bluebell Dr	Spicewood	[email protected]
6753841	TX	78730	(512) 555-9361	O-004	Jill	Hutzell	6462 Bisview Dr	Austin	[email protected]
4310303	TX	78640	(512) 555-1016	O-003	Naveah	Campbell	352 Tower Dr	Kyle	[email protected]
7348502	TX	78665	(512) 555-0303	O-005	Yianna	Mathis	1187 Barilla Mountrain Trl	Round Rock	[email protected]
7384952	TX	78657	(512) 555-1008	O-002	Christopher	Darko	240 Washington St	Smithville	[email protected]
7481938	TX	78642	(512) 555-2318	O-1	Jamal	Hardy	664 Carson Ave	Liberty Hill	[email protected]
7583249	TX	78640	(512) 555-0304	O-004	Betty	Poon	263 Caddis Cv	Kyle	[email protected]
8247593	TX	78681	(512) 555-2022	O-004	Patrice	Martinez	3632 Castle Path	Round Rock	[email protected]
8273409	TX	78669	(512) 555-2014	O-002	Naomi	Henigson	22568 Briarcliff Dr	Spicewood	[email protected]
8273438	TX	78620	(512) 555-2322	O-004	Edgardo	Pabelonia	894 Hidden Hills Dr	Dripping Springs	[email protected]
8273485	TX	78660	(512) 555-2027	O-010	Pei	Tram	3567 Vanderbilt Cir	Pflugerville	[email protected]
8347868	TX	78665	(512) 555-2025	O-003	Yolanda	Tram	3152 Homewood Cir	Round Rock	[email protected]
8374853	TX	78226	(512) 555-1010	O-005	Hendrick	Themis	2590 Mesquite Ln	Georgetown	[email protected]
5730483	TX	78722	(512) 555-2018	O-004	Clement	Forrester	1506 Wilshire Blvd	Austin	[email protected]
5739437	TX	78657	(512) 555-2030	O-002	Eugene	Sotova	130 Garwood St	Smithville	[email protected]

Date	Day of Week	Orientation ID	Time	Room
7/11/18	Monday	O-1	9:00 a.m. - 1:00 p.m.	Library (Room 201)
7/13/18	Wednesday	O-002	9:00 a.m. - 1:00 p.m.	Library (Room 201)
7/18/18	Monday	O-003	5:30 p.m. - 9:30 p.m.	Library (Room 203)
7/19/18	Tuesday	O-004	9:00 a.m. - 1:00 p.m.	Library (Room 202)
7/21/18	Thursday	O-005	10:00 a.m. - 1:00 p.m.	Library (Room 202)
7/27/18	Wednesday	O-006	2:00 p.m. - 6:00 p.m.	Library (Room 203)
7/28/18	Thursday	O-007	9:00 a.m. - 1:00 p.m.	Library (Room 202)
8/1/18	Monday	O-008	12:30 p.m. - 4:30 p.m.	Library (Room 201)
8/2/18	Tuesday	O-009	9:00 a.m. - 1:00 p.m.	Library (Room 202)
8/3/18	Wednesday	O-010	9:00 a.m. - 1:00 p.m.	Library (Room 203)

a02_student_files/a02D_Club_Fundraisers.accdb

Date	Fundraiser Location	Donation	Fundraiser ID	Fundraiser Name	Club ID
2/5/18	Austin Events Center	¤ 625.00	FR-101	Stronger Community Partnership	CLUB-101
10/13/18	Texas Arts Center	¤ 530.00	FR-119	Pink Tie Charity Ball	CLUB-101
5/18/18	City Park, Manor	¤ 258.00	FR-110	YMCA Walk for Kids	CLUB-115
9/20/18	Austin Events Center	¤ 3,050.00	FR-118	Austin Challenge	CLUB-115
2/27/18	Pflugerville Convention Center	¤ 1,000.00	FR-103	Texas Lakes Heart Ball	CLUB-116
2/13/18	Georgetown Town Hall	¤ 1,500.00	FR-102	Georgetown Food Assistance Center	CLUB-106
3/10/18	Arena Stage	¤ 250.00	FR-104	Annual Benefit at Arena Stage	CLUB-108
3/19/18	Bastrop Town Hall	¤ 2,500.00	FR-105	Habitat for Humanity	CLUB-102
6/10/18	Austin Events Center	¤ 760.00	FR-112	Leukemia Ball	CLUB-103
3/27/18	Austin	¤ 740.00	FR-106	Juvenile Diabetes 1K	CLUB-110
4/9/18	Rock and Bowl, Kyle	¤ 1,200.00	FR-107	Children's Medical Center	CLUB-107
4/24/18	Dripping Springs	¤ 360.00	FR-108	Dripping Springs Kidney Walk	CLUB-111
5/15/18	Austin	¤ 900.00	FR-109	Great Strides 5K	CLUB-105
6/20/18	Central Library, Red Rock	¤ 450.00	FR-113	Books for Children	CLUB-107
9/13/18	Austin Events Center	¤ 850.00	FR-117	Austin Sports Alliance	CLUB-112
11/24/18	Southwest Campus	¤ 184.00	FR-121	Save Our Museums	CLUB-104
7/15/18	Liberty Hill	¤ 1,362.00	FR-114	Liberty Hill Shelter for Homeless	CLUB-104
5/22/18	San Marcos	¤ 750.00	FR-111	Lakes Run	CLUB-114
7/20/18	Bark'N Bathe Dog Wash	¤ 550.00	FR-115	Lather Up Lassie Animal Protection	CLUB-113
8/14/18	Elgin	¤ 254.00	FR-116	Walk for Food Allergy	CLUB-109
11/17/18	Northwest Campus	¤ 120.00	FR-120	GIVE PIE for Thanksgiving	CLUB-109
12/10/18	The Mall at Austin	¤ 2,066.00	FR-122	Operation Christmas Miracle	CLUB-109

a02_student_files/a02D_Clubs.xlsx

Clubs

Club ID	Club Name	Campus	Treasurer First Name	Treasurer Last Name	Club Email
CLUB-101	Northwest Student Government Association	Northwest	Shanta	Brickhouse	[email protected]
CLUB-102	Southeast Student Government Association	Southeast	Heather	West	[email protected]
CLUB-103	Northeast Student Government Association	Northeast	Anthony	McLaurin	[email protected]
CLUB-104	Southwest Student Government Association	Southwest	Derrick	Copeland	[email protected]
CLUB-105	Beating the Odds	Southwest	Jevon	Saunders	[email protected]
CLUB-106	Chess Club	Northwest	Monica	Greer	[email protected]
CLUB-107	Early Childhood Education Club	Northeast	Helene	Fernandez	[email protected]
CLUB-108	Echoes of Excellence	Southeast	Joseph	Gaskins	[email protected]
CLUB-109	Business Club	Southeast	Kimberly	Branham	[email protected]
CLUB-110	Team Texas Lakes CC	Northwest	Valentine	Aikhu	[email protected]
CLUB-111	Phi Theta Kappa - PSI Upsilon Chapter	Northeast	Desiree	Johnson	[email protected]
CLUB-112	International Student Alliance	Southwest	Kiana	Carpenter	[email protected]
CLUB-113	Phi Theta Kappa - Alpha Zeta Lambda Chapter	Southeast	Jared	Whittington	[email protected]
CLUB-114	Engineering Club	Northwest	Sherman	Nelson	[email protected]
CLUB-115	Phi Theta Kappa - Chi Mu Chapter	Southwest	Sridharan	Krishwami	[email protected]
CLUB-116	Phi Theta Kappa - Beta Zeta Upsilon Chapter	Northwest	Angela	Nickelsburg	[email protected]

a02_student_files/a02E_Biology_Supplies.accdb

Price Per Item	Item ID	Item Name	Category	Room	Location	Vendor ID	Quantity in Stock
¤ 34.50	ITEM-0100	0.1% Thymol Blue, 120 ml	Chemicals	B208A	D17	V-100	10
¤ 6.50	ITEM-0101	0.9% Saline	Liquids	B117A	CAT Cooler	V-100	25
¤ 8.50	ITEM-0102	10% Bleach	Liquids	B208A	A6	V-003	30
¤ 4.95	ITEM-0103	10% Bleach Spray Bottles	Bottles	B208A	A6	V-002	50
¤ 9.95	ITEM-0104	10% NaCL	Chemicals	B117A	Refrigerator	V-100	70
¤ 91.25	ITEM-0105	Photosynthesis Kit	Kits	B105	Cabinet	V-004	75
¤ 4.70	ITEM-0106	Algae Red	Slides	B105	Cabinet	V-009	100
¤ 20.95	ITEM-0107	Animal Cells	Slides	B105	Cabinet	V-009	100
¤ 26.95	ITEM-0108	Amphibian Kit	Kits	B105	Cabinet	V-004	150
¤ 8.15	ITEM-0109	Slide Trays	Slides	B105	Cabinet	V-009	50
¤ 2.30	ITEM-0110	Beakers, 250 ml	Beakers	B208A	F3	V-002	200
¤ 10.25	ITEM-0111	Beakers, 50 ml	Beakers	B208A	F2	V-002	100
¤ 39.95	ITEM-0112	Pig Kit	Kits	B105	Cabinet	V-004	130
¤ 38.95	ITEM-0113	Shark Kit	Kits	B105	Cabinet	V-004	100
¤ 25.50	ITEM-0114	Simple Stain Kit	Chemicals	B117A	D13	V-100	110
¤ 23.30	ITEM-0115	Culture Tubes	Test Tubes	B208A	G23	V-002	240
¤ 10.75	ITEM-0116	Dissecting Kit	Kits	B105	Cabinet	V-004	125
¤ 2.30	ITEM-0117	Forceps	Instruments	B208A	G2	V-006	100
¤ 11.25	ITEM-0118	Insect Pins	Miscellaneous	B211	D1	V-007	50
¤ 679.00	ITEM-0119	Microscopes Binocular	Microscopes	B204	Cabinet	V-008	40
¤ 269.00	ITEM-0120	Microscopes Digital	Microscopes	B204	Cabinet	V-008	40
¤ 182.00	ITEM-0121	Magnetic Water Kit	Kits	B105	Cabinet	V-004	35
¤ 2.85	ITEM-0122	Scalpels	Scalpels	B208A	D11	V-006	120
¤ 199.00	ITEM-0123	Skeleton, Cat	Skeleton	B105	Cabinet	V-005	5
¤ 249.00	ITEM-0124	Skeleton, Snake	Skeleton	B105	Cabinet	V-005	5

Vendor ID	Vendor Name	Address	City	State	Postal Code	Phone	Email Address
V-002	Biology Supplies Inc	268 Market St	Dallas	TX	75214	(214) 555-8200	[email protected]
V-003	Sanitizer Corp	9854 Main St	Los Angeles	CA	90007	(424) 555-4927	[email protected]
V-004	Science Kits for Labs	23 Lackland Blvd	Richmond	VA	23226	(804) 555-2126	[email protected]
V-005	Skeletal Parts Co	47 Monterrey Ct	Providence	RI	02909		[email protected]
V-006	Blades and Scalpels for Labs	832A Denning La	Atlanta	GA	30304	(678) 555-0505	supplies@blades_scalpels_labs.biz
V-007	Insect Mounting Supplies	763 Atlantic Hwy	Ft Lauderdale	FL	33305	(954) 555-8159	[email protected]
V-008	Texas Lab Equipment	112 E Main St	Austin	TX	78749		[email protected]
V-009	Biology Mounted Slides	674 Park Ave	Houston	TX	77010	(713) 555-3996	[email protected]
V-100	Parker-Cole Solutions	4536 Short Hill Rd	Columbia	SC	29203	(803) 555-7191	[email protected]

a02_student_files/a02F_Student_Papers.xlsx

Student Papers

Paper ID	Home Campus	Paper Name	Category	Publisher ID	Publication Date	Award Paid	Student ID
P-01	Northwest	About the Forgotten Mother	Fiction	PUB-1121	2/9/18	$40.00	4852384
P-02	Northeast	Life and Times of a Range Cowboy	History	PUB-1257	5/23/18	$20.00	5720358
P-03	Northwest	Whales and Low Frequency Sounds	Science	PUB-1410	5/1/18	$35.00	5730483
P-04	Southwest	Student Services and Student Success	Student Life	PUB-1250	5/23/18	$50.00	5738495
P-05	Southeast	Protect Your Home Computer	Technology	PUB-1411	2/15/18	$10.00	5739437
P-06	Northeast	Texas Trails	History	PUB-1501	3/22/18	$40.00	5748392
P-07	Southeast	Balancing Technology and Life	Technology	PUB-1510	6/25/18	$10.00	5820384
P-08	Southeast	Television Causes Crime	Prose	PUB-1185	1/16/18	$20.00	7348502
P-09	Southwest	Rock and Roll is the Best Music	Prose	PUB-1571	10/30/18	$30.00	3593653
P-10	Northeast	Texas Hill Living	Prose	PUB-1415	5/6/18	$100.00	3569325
P-11	Northeast	Man on Fire	Poetry	PUB-1244	11/4/18	$10.00	3569325
P-12	Northwest	Texas Heroes	History	PUB-1245	5/6/18	$30.00	1102544
P-13	Southeast	How the Women's Center Saved Me	Student Life	PUB-1571	8/4/18	$150.00	9385602
P-14	Southwest	Roaming the Museum of Natural Science	Nonfiction	PUB-1411	11/12/18	$40.00	8938456
P-15	Northwest	Purple Mountains	Poetry	PUB-1415	1/25/18	$20.00	4739502
P-16	Southwest	Why I Love Austin	Prose	PUB-1185	5/23/18	$25.00	1284354
P-17	Northeast	Questions to Ask When Buying a Computer	Technology	PUB-1250	7/29/18	$50.00	8751243
P-18	Southeast	History of River Music	History	PUB-1355	5/21/18	$25.00	3857493
P-19	Southeast	Algae Growth	Science	PUB-1257	12/6/18	$10.00	8273438
P-20	Northwest	Strength of Character	Student Life	PUB-1244	4/14/18	$45.00	7481938
P-21	Northeast	Sticks and Stones	Poetry	PUB-1341	7/12/18	$200.00	3845724
P-22	Southwest	My Family Situation	Nonfiction	PUB-1257	2/2/18	$10.00	9385602
P-23	Southwest	The Sooner the Better	Student Life	PUB-1410	9/15/18	$20.00	3852938
P-24	Southwest	College Essays: The Harsh Truth	Nonfiction	PUB-1571	4/10/18	$25.00	1728193
P-25	Southeast	Brazos River Fish	Science	PUB-1501	10/24/18	$30.00	9375202

a02_student_files/a02F_Student_Publications.accdb

Publisher ID	Publisher Name	Address	City	State	Postal Code	Contact Name	Contact Phone
PUB-1501	Los Brazos Stories	4228 E Market St	San Antonio	TX	78216	Zania Bodenschatz	(210) 555-1589
PUB-1510	Currents Magazine	1205 W Delaware Dr	Washington	DC	20010	Nate Hoffa	(202) 555-9505
PUB-1341	Bluebonnet Review	211 Sam Houston Blvd	San Antonio	TX	78216	Crissy Verschooris	(210) 555-4602
PUB-1355	Literary Society of Texas	1458 W Elm St	Austin	TX	78747	Janice Zielinski	(512) 555-3403
PUB-1571	College Expressions	356 College Crescent	Austin	TX	78750	Nicole Thomas	(512) 555-2032
PUB-1185	Texas Star	5111 3rd Ave	Austin	TX	78748	Ran Yin	(512) 555-8906
PUB-1411	Texas Measure	716 Tower Dr	Austin	TX	78744	Kevin Schafferman	(512) 555-9060
PUB-1410	Lion's Roar	1802 Southcreek Dr	Leander	TX	78646	Chris Cabrera	512) 555-3540
PUB-1121	Texas Literary Magazine	1502 Main St	Austin	TX	78749	Belo Zagrib	(512) 555-5045
PUB-1244	Literacy Press	2235 East 64th St	New York	NY	10010	Branden Bowie	(212) 555-8607
PUB-1245	The Lakes Newspaper	15 Oak St	Austin	TX	78703	Jenna Price	(512) 555-2401
PUB-1250	Gavel	1922 Connecticut Ave	Washington	DC	20298	Jake Kleine	(202) 555-5804
PUB-1256	Obsidian	8214 Park Ave	Bastrop	TX	78602	Andrew Tison	(512) 555-8908
PUB-1415	Texas Hills	3219 North St	New Braunfels	TX	78132	Josh Haas	(830) 555-9810
PUB-1257	Range Riders	7152 Kiley Ave	Dallas	TX	75211	Jazmin Barnum	(972) 555-2223

a02_student_files/a02G_Student_Scholarships.accdb

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
9999999	Nicole	Dutton	122 Whispering Spring Ln	Georgetown	TX	78633
2840583	Oscar	Prince	367 Encino St	San Marcos	TX	78666
2845209	Stephan	Elraheb	351 Wild Senna Dr	Pflugerville	TX
2845721	Dana	Larsen	789 Bois Darc St	Lockhart	TX	78644
2847194	Ginetta	Gant	100B W Mercer St	Dripping Springs	TX	78620
2849201	Lisa	Sharpe	567 N Pecos St	Lockhart	TX	78644
2849523	Moises	Fernandez	124 Woodland Ln	Round Rock	TX	78681
2903485	Jalpit	Matson	3204 Bird Call Pass	Austin	TX	78754
2934853	Khrystyna	Tilson	11520 Oaklynn Ct	Manor	TX	78653
2938593	Curtis	Dawson	10344 Yellowstone Dr	Austin	TX	78747
3128456	WenLi	Wall	14380 Ceylon Tea Cir	Pflugerville	TX	78660
3458632	Stephanie	Caputo	1731 Primrose Trl	Round Rock	TX	78665
3569325	Carlis	Thomas	28A 4th Ave	Smithville	TX	78657
3572184	Carla	Reid	715 Pampas Ricas Dr	Leander	TX	78641
3586943	Joseph	Stavish	660 Bayou Bend Dr	Buda	TX	78610
3842958	McCall	Cheney	1053 Tumbleweed Dr	Dale	TX	78616
3845724	Mihir	Subramanian	670 Mogonye Ln	Elgin	TX
3847563	Andrew	Lee	14010 Big Thicket Dr	Austin	TX	78747
3847589	Prince	Flitcroft	7821 Winsted Ln	Austin	TX	78703
3849234	Donald	Hanby	334 Blue Heron run	Wimberley	TX	78676
3852349	Kirsten	Riccardi	632 Ranchero Rd	Leander	TX
3852938	Atonye	Morris	1172 Buttonwood St	Bastrop	TX	78602
3856930	Cong	Nguyen	444 E Alamo St	Elgin	TX	78621
3856958	Danila	Bennett	808 Springbrook Ln	Leander	TX	78641
3857493	Sonia	Olson	193 Middle Creek Rd	Buda	TX	78610

a02_student_files/a02H_Social_Sciences.accdb

Section	Instructor ID	Course Number	Course Name	Units	Days	Classroom	Start Time	End Time
1061	5017501	ANTH 1	Biological Anthropology	3	MW	H-2130	12/30/99	12/30/99
1062	1436143	ANTH 1	Biological Anthropology	3	MW	H-2130	12/30/99	12/30/99
1063	5017501	ANTH 1	Biological Anthropology	3	TTh	H-2130	12/30/99	12/30/99
1064	5017501	ANTH 1L	Biological Anthropology Lab	2	F	B-5005	12/30/99	12/30/99
1065	5017501	ANTH 2	Cultural Anthropology	3	MW	H-2132	12/30/99	12/30/99
1066	5017501	ANTH 2	Cultural Anthropology	3	TTh	H-2132	12/30/99	12/30/99
1067	2044204	ANTH 2	Cultural Anthropology	3	TTh	H-2131	12/30/99	12/30/99
1068	4048404	ANTH 2	Cultural Anthropology	3	TTh	H-2132	12/30/99	12/30/99
1069	4048404	ANTH 2	Cultural Anthropology	3	M	H-2132	12/30/99	12/30/99
1070	4048404	ANTH 2L	Cultural Anthropology Lab	3	Th	H-2132	12/30/99	12/30/99
1071	1436143	ANTH 4	Archaeology	4	TTh	H-2135	12/30/99	12/30/99
1072	4048404	ANTH 4	Archaeology	4	MW	H-2135	12/30/99	12/30/99
1073	1436143	ANTH 4L	Archaeology Lab	4	T	H-2135	12/30/99	12/30/99
1074	2044204	ANTH 5	Ethnology	4	W	H-2131	12/30/99	12/30/99
1075	2044204	ANTH 6	Human Ecology	3	W	H-2131	12/30/99	12/30/99
1076	1436143	ANTH 9	Evolutionary Anthropology	2	W	H-2060	12/30/99	12/30/99

Instructor ID	Last Name	First Name	Academic Rank	Discipline	Date Hired	Base Salary	Office Address	Office Phone	Email Address
0757075	Blutoski	Robert	Professor	Psychology	9/4/95	¤ 103,500.00	Faculty Hall 2003	555-3603	[email protected]
0861086	Green	Ruby	Professor	Psychology	9/5/96	¤ 102,000.00	Faculty Hall 2013	555-3608	[email protected]
0932093	Pappas	Nicola	Professor	Sociology	1/30/97	¤ 101,500.00	Faculty Hall 2101	555-3803	[email protected]
1268126	Frink	Jonathan	Professor	Psychology	9/3/98	¤ 99,800.00	Faculty Hall 2010	555-3606	[email protected]
1395139	Jefferson	Maybin	Professor	Psychology	1/28/06	¤ 98,300.00	Faculty Hall 2008	555-3609	[email protected]
1436143	Hardin	Wesley	Professor	Anthropology	9/5/07	¤ 99,500.00	Faculty Hall 2113	555-3109	[email protected]
1438143	Washington	Lincoln	Professor	Political Science	9/7/07	¤ 98,000.00	Faculty Hall 2227	555-3408	[email protected]
1522152	Clyde	Burgess	Professor	Social Science	1/29/94	¤ 97,300.00	Faculty Hall 2036	555-3703	[email protected]
1701070	Verplunkt	Hijron	Professor	Economics	9/4/95	¤ 96,800.00	Faculty Hall 2201	555-3301	[email protected]
1832183	Churnowitz	Homero	Professor	Economics	9/3/96	¤ 95,500.00	Faculty Hall 2212	555-3302	[email protected]
2041204	Gurschwen	Georgia	Professor	Sociology	9/7/98	¤ 91,000.00	Faculty Hall 2107	555-3802	[email protected]
2044204	Perkowsky	Stanislaw	Professor	Anthropology	9/7/98	¤ 92,800.00	Faculty Hall 2112	555-3108	[email protected]
2387238	Reimandt	Helmut	Professor	Political Science	9/5/07	¤ 89,500.00	Faculty Hall 2228	555-3405	[email protected]
2563256	Drinnan	Floyd	Professor	Sociology	9/6/94	¤ 88,300.00	Faculty Hall 2106	555-3804	[email protected]
2865286	Sazerac	Rene	Professor	Political Science	9/4/96	¤ 86,000.00	Faculty Hall 2224	555-3404	[email protected]
2867286	Jonson	Franklin	Professor	Economics	9/7/96	¤ 86,500.00	Faculty Hall 2213	555-3310	[email protected]
3009300	Nguen	Francois	Professor	Psychology	9/5/97	¤ 86,500.00	Faculty Hall 2017	555-3621	[email protected]
3216321	Karastolian	Aram	Professor	Political Science	1/28/06	¤ 84,000.00	Faculty Hall 2236	555-3412	[email protected]
3532353	Duffy	Anita	Associate Professor	Political Science	8/13/97	¤ 80,500.00	Faculty Hall 2232	555-3411	[email protected]
3682368	Johnson	Leota	Associate Professor	Sociology	8/14/98	¤ 78,800.00	Faculty Hall 2110	555-3807	[email protected]
3685368	Zyzek	Marilynn	Associate Professor	Psychology	8/14/98	¤ 78,800.00	Faculty Hall 2016	555-3616	[email protected]
3729272	Lee	Jingwan	Associate Professor	Economics	3/12/06	¤ 79,300.00	Faculty Hall 2216	555-3311	[email protected]
3848284	Fabian	Stephen	Associate Professor	Political Science	8/17/06	¤ 77,500.00	Faculty Hall 2234	555-3403	[email protected]
3849384	McAdoo	Carolyn	Associate Professor	Sociology	8/17/06	¤ 77,500.00	Faculty Hall 2108	555-3806	[email protected]
3856385	Mwry	Ngume	Associate Professor	Political Science	9/15/06	¤ 77,500.00	Faculty Hall 2230	555-3407	[email protected]
3900390	Stipe	John	Associate Professor	Psychology	12/15/06	¤ 75,800.00	Faculty Hall 2004	555-3610	[email protected]
3913391	Tyler	Frances	Associate Professor	Economics	2/6/07	¤ 76,300.00	Faculty Hall 2217	555-3316	[email protected]
4042404	Incontreras	Florinda	Associate Professor	Political Science	8/15/07	¤ 75,500.00	Faculty Hall 2235	555-3406	[email protected]
4047404	Power	Jackson	Associate Professor	Social Science	8/15/07	¤ 74,250.00	Faculty Hall 2035	555-3702	[email protected]
4048404	Rogodiva	Rajiv	Associate Professor	Anthropology	8/15/07	¤ 74,250.00	Faculty Hall 2114	555-3105	[email protected]
4203420	Sawyer	Rebecca	Associate Professor	Sociology	1/17/08	¤ 73,000.00	Faculty Hall 2109	555-3801	[email protected]
4428442	Childers	Wilma	Associate Professor	Economics	8/16/08	¤ 72,500.00	Faculty Hall 2208	555-3307	[email protected]
4431443	Freeman	Ray Lee	Associate Professor	Economics	8/16/08	¤ 72,500.00	Faculty Hall 2206	555-3308	[email protected]
4434433	Hurley	Rowena	Associate Professor	Social Science	8/16/08	¤ 71,250.00	Faculty Hall 2034	555-3704	[email protected]
4437443	Peters	Jamal	Associate Professor	Sociology	8/16/08	¤ 71,250.00	Faculty Hall 2105	555-3809	[email protected]
4579457	Green	Jennifer	Associate Professor	Sociology	1/16/09	¤ 69,500.00	Faculty Hall 2104	555-3808	[email protected]
4640464	Alford	Sonia	Associate Professor	Psychology	8/15/09	¤ 67,800.00	Faculty Hall 2015	555-3612	[email protected]
4644464	Harper	Theotis	Associate Professor	Political Science	8/15/09	¤ 68,250.00	Faculty Hall 2233	555-3402	[email protected]
4793479	Portevandt	LaSalle	Assistant Professor	Economics	8/14/10	¤ 65,300.00	Faculty Hall 2218	555-3313	[email protected]
4941494	Mykel	Sean	Assistant Professor	Economics	8/13/11	¤ 64,500.00	Faculty Hall 2215	555-3312	[email protected]
5017501	Alvarez	Marcia	Assistant Professor	Anthropology	1/6/12	¤ 63,250.00	Faculty Hall 2111	555-3106	[email protected]
5192519	Uchack	Vi	Assistant Professor	Social Science	7/14/12	¤ 62,750.00	Faculty Hall 2033	555-3705	[email protected]
5202520	Goebel	Paul	Assistant Professor	Political Science	8/14/12	¤ 63,500.00	Faculty Hall 2229	555-3410	[email protected]
5203520	Hope	Davinda	Assistant Professor	Psychology	8/14/12	¤ 62,750.00	Faculty Hall 2007	555-3620	[email protected]
5206520	Nagurski	Brenda	Assistant Professor	Economics	8/14/12	¤ 63,500.00	Faculty Hall 2214	555-3304	[email protected]
5208520	Sartran	John	Assistant Professor	Psychology	8/14/12	¤ 62,750.00	Faculty Hall 2006	555-3618	[email protected]
5314531	Durkee	Amanda	Assistant Professor	Economics	1/7/13	¤ 60,275.00	Faculty Hall 2205	555-3309	[email protected]
5489548	Dolittle	Roberta	Assistant Professor	Psychology	8/17/13	¤ 59,500.00	Faculty Hall 2019	555-3613	[email protected]
5717571	Jurgensen	Christov	Assistant Professor	Psychology	8/14/14	¤ 57,800.00	Faculty Hall 2005	555-3626	[email protected]
5835583	Taylor	Tamara	Assistant Professor	Psychology	1/17/15	¤ 56,250.00	Faculty Hall 2009	555-3622	[email protected]

SELECT Sum([2H Social Sciences Faculty].[Base Salary]) AS [SumOfBase Salary] FROM [2H Social Sciences Faculty];

SELECT [2H Social Sciences Faculty].Discipline, [2H Social Sciences Faculty].[Last Name], [2H Social Sciences Faculty].[First Name] FROM [2H Social Sciences Faculty] WHERE ((([2H Social Sciences Faculty].Discipline)="anthropology" And ([2H Social Sciences Faculty].Discipline)="ecnomics")) ORDER BY [2H Social Sciences Faculty].Discipline, [2H Social Sciences Faculty].[Last Name], [2H Social Sciences Faculty].[First Name];

SELECT [2H Social Sciences Faculty].[Last Name], [2H Social Sciences Faculty].[First Name] FROM [2H Social Sciences Faculty] WHERE ((([2H Social Sciences Faculty].[Academic Rank])="assistant professor")) ORDER BY [2H Social Sciences Faculty].[Last Name], [2H Social Sciences Faculty].[First Name];

SELECT [2H Anthropology Dept Course Schedule].[Course Number], [2H Anthropology Dept Course Schedule].[Course Name] FROM [2H Anthropology Dept Course Schedule] WHERE ((([2H Anthropology Dept Course Schedule].[Course Name]) Like "biological*"));

SELECT [2H Social Sciences Faculty].[Instructor ID], [2H Social Sciences Faculty].[Last Name], [2H Social Sciences Faculty].[First Name], [2H Social Sciences Faculty].Discipline FROM [2H Social Sciences Faculty] WHERE ((([2H Social Sciences Faculty].Discipline)="Enter a Discipline")) ORDER BY [2H Social Sciences Faculty].[Last Name], [2H Social Sciences Faculty].[First Name];

a02_student_files/a02I_Faculty_Awards.accdb

First Name	Last Name	Phone Number	Email Address	Division	Department	Rank	Faculty ID#
Julie	Anderson	(512) 555-0211	[email protected]	Science	Biology	Instructor	2389523
Eric	Ayub	(512) 555-0331	[email protected]	Science	Biology	Professor	2723227
Sanjay	Chandar	(512) 555-0063	[email protected]	Science	Biology	Professor	4167141
Loretta	Sepetta	(512) 555-0215	[email protected]	Science	Biology	Instructor	4325843
Joe	Finnegan	(512) 555-0346	[email protected]	Science	Biology	Associate Professor	4568945
William	Grigsby	(512) 555-0126	[email protected]	Science	Biology	Associate Professor	5454254
Paul	Jurewicz	(512) 555-0612	[email protected]	Science	Chemistry	Professor	5478354
Abdul	Kamiar	(512) 555-0202	[email protected]	Science	Chemistry	Professor	5692556
Kim	Wong	(512) 555-0123	[email protected]	Science	Chemistry	Instructor	6312963
Jose	Villela	(512) 555-0710	[email protected]	Science	Chemistry	Associate Professor	6325763
Vincent	Lelong	(512) 555-0313	[email protected]	Science	Physics	Instructor	6458964
Michael	Baumgarten	(512) 555-0506	[email protected]	Science	Physics	Associate Professor	7452774
Michelle	Wong	(512) 555-0005	[email protected]	Science	Physics	Professor	8965489
David	Cheng	(512) 555-0485	[email protected]	Science	Physics	Instructor	9210892
Armand	Steinberg	(512) 555-0222	[email protected]	Science	Physics	Professor	9587495

Award ID	Award Name	Award Date	Award Amount	Faculty ID#
AW-01	Mark of Excellence	5/1/18	¤ 4,000.00	2389523
AW-02	Leading Learning	6/15/18	¤ 1,000.00	2723227
AW-03	Mark of Excellence	10/10/18	¤ 2,000.00	4167141
AW-04	Leading Learning	10/1/18	¤ 1,000.00	4325843
AW-05	Leading Learning	12/15/18	¤ 1,000.00	4568945
AW-06	Mark of Excellence	4/30/18	¤ 2,500.00	6458964
AW-07	TLCC Presidential Award	1/15/18	¤ 3,000.00	5478354
AW-08	TLCC Presidential Award	1/15/18	¤ 3,000.00	5692556
AW-09	Mark of Excellence	10/20/18	¤ 2,000.00	6312963
AW-10	Mark of Excellence	2/15/18	¤ 2,500.00	6325763
AW-11	TLCC Presidential Award	4/20/18	¤ 3,000.00	6458964
AW-12	Mark of Excellence	2/15/18	¤ 2,000.00	7452774
AW-13	Mark of Excellence	1/15/18	¤ 2,000.00	8965489
AW-14	Mark of Excellence	2/24/18	¤ 2,000.00	9210892
AW-15	TLCC Presidential Award	11/18/18	¤ 3,000.00	9587495
AW-16	Leading Learning	2/15/18	¤ 1,000.00	2389523

a02_student_files/a02J_Student_Refunds.accdb

Transaction ID	Student ID#	Refund	Refund Eligibility Date	Enrollment Status
T-001	1018101	¤ 50.85	9/22/18	Full Time
T-002	1211122	¤ 670.75	2/23/18	Full Time
T-003	1222123	¤ 15.50	8/1/18	Full Time
T-004	1223122	¤ 100.00	4/23/18	Part Time
T-005	1265126	¤ 625.50	2/15/18	Part Time
T-006	1514151	¤ 400.50	6/22/18	Full Time
T-007	1018101	¤ 225.75	6/25/18	Part Time
T-008	1587158	¤ 22.75	1/16/18	Full Time
T-009	1111111	¤ 714.55	2/6/18	Part Time
T-010	1112111	¤ 450.50	9/15/18	Full Time
T-011	1125112	¤ 815.75	12/22/18	Full Time
T-012	1150115	¤ 65.45	10/24/18	Full Time
T-013	1155115	¤ 180.75	12/1/18	Full Time
T-014	1167116	¤ 42.50	2/27/18	Part Time
T-015	1180118	¤ 770.45	5/12/18	Part Time
T-016	1209120	¤ 432.00	7/18/18	Full Time

Student ID#	First Name	Last Name	Address	City	State	Postal Code
1018101	Julia	Hill	1165 Camino Alto Dr	Leander	TX	78646
1111111	Tony	Gomez	211 Forrest St	Liberty Hill	TX	78642
1112111	Sheldon	Stein	25 Mari Ln	Spicewood	TX	78669
1125112	Steve	Granger	443 Savannah Ridge Dr	Austin	TX	78726
1150115	Marcia	Liu	1205 Heep Run	Buda	TX	78610
1155115	Jacque	Dubois	511 Creek Dr	Dripping Springs	TX	78620
1167116	Ramona	Byrd	154 Silverado Dr	Kyle	TX	78640
1180118	Kevin	Frye	2180 Travis St	San Marcos	TX	78666
1209120	Kendra	Locke	2009 Blue Heron Run	Wimberley	TX	78676
1211122	Brittany	Wheeler	2235 Ruxton Ln	Austin	TX	78749
1222123	Nathan	Reeves	7621 Turtle Mound Bnd	Austin	TX	78748
1223122	Johanna	Ronstern	2310 Moulin Dr	Spicewood	TX	78669
1265126	Ryan	Richardson	8015 Osprey Ct	Austin	TX	78750
1514151	Jason	Woodard	5100 Lion Dr	Leander	TX	78647
1576157	Larry	Orvitz	1571 Texas Bluebell Dr	Spicewood	TX	78669
1587158	Sergei	Voskanov	5810 River Road	Wimberley	TX	78676

a02_student_files/a02K_Leave.accdb

Employee#	First Name	Last Name	Phone Number	Email Address
0703070	Annette	Kim	(512) 555-0123	[email protected]
0752075	Jose	Villela		[email protected]
0842084	Joel	Fisher	(512) 555-0346	[email protected]
1136113	Sanjay	Chandar	(512) 555-0063	[email protected]
1178117	Vincent	Lelong	(512) 555-0313	[email protected]
1299129	Julie	Adeeb	(512) 555-0211	[email protected]
1320132	Edythe	Ayub	(512) 555-0331	[email protected]
1329132	Armando	Acosta	(512) 555-0222	[email protected]
2050205	William	Grigsby		[email protected]
4205420	Loretta	Figueroa	(512) 555-0215	[email protected]
5647564	Michael	Baumgartner	(512) 555-0506	[email protected]
8723872	David	Siu	(512) 555-0485	[email protected]
8912891	Paula	Jurewicz	(512) 555-0612	[email protected]
9213921	Michelle	Wong	(512) 555-0005	[email protected]
9921992	Abdul	Kamiar	(512) 555-0202	[email protected]

Leave Transaction ID	Employee#	Date Off	Date Returned	Leave Classification
LV-001	1299129	1/26/18	1/27/18	Sick
LV-002	0752075	2/7/18	2/14/18	Vacation
LV-003	1178117	2/14/18	2/16/18	Vacation
LV-004	1136113	3/14/18	3/21/18	Vacation
LV-005	1299129	4/5/18	4/12/18	Vacation
LV-006	1178117	4/12/18	4/14/18	Sick
LV-007	1320132	4/18/18	4/25/18	Vacation
LV-008	1136113	4/22/18	4/25/18	Vacation
LV-009	2050205	5/2/18	5/9/18	Vacation
LV-010	0842084	5/2/18	5/3/18	Personal
LV-011	1320132	6/1/18	6/8/18	Vacation
LV-012	2050205	7/19/18	7/26/18	Vacation
LV-013	1136113	7/21/18	7/26/18	Sick
LV-014	0752075	8/16/18	8/23/18	Vacation
LV-015	0842084	9/27/18	10/11/18	Vacation
LV-016	1299129	9/28/18	10/4/18	Sick
LV-017	0752075	10/13/18	10/14/18	Personal
LV-018	1178117	10/20/18	10/21/18	Personal
LV-019	2050205	11/15/18	11/16/18	Personal

a02_student_files/a02L_Coaches.accdb

Activity ID	Office#	Coach ID#	Activity Name	Department	Division
ACT-100	B234	2111211	Varsity Football Team	Men's Athletics	Athletics
ACT-101	A133	2111211	Jr. Varsity Football Team	Men's Athletics	Athletics
ACT-102	A132	2110211	Tennis Team - Men	Men's Athletics	Athletics
ACT-103	A133	2120212	Tennis Team - Women	Women's Athletics	Athletics
ACT-104	A133	2118211	Basketball Team - Women	Women's Athletics	Athletics
ACT-105	C210	2115211	Basketball Team - Men	Men's Athletics	Athletics
ACT-106	D110	2113211	Baseball Team	Men's Athletics	Athletics
ACT-107	C210	2117211	Cheer Squad	Activities	Activity
ACT-108	D112	2120212	Soccer Team	Men's Athletics	Athletics
ACT-109	C210	2119211	Softball Team	Women's Athletics	Athletics
ACT-110	B210	2116211	Volleyball Team	Women's Athletics	Athletics
ACT-111	B234	2123212	Swim Team - Men	Men's Athletics	Athletics
ACT-112	C210	2123212	Swim Team - Women	Women's Athletics	Athletics
ACT-113	C213	2124212	Dive Team - Men	Men's Athletics	Athletics
ACT-114	B220	2121212	Dive Team - Women	Women's Athletics	Athletics
ACT-115	B313	2113211	Water Polo Team	Men's Athletics	Athletics
ACT-116	A145	2122212	Lacrosse Team	Men's Athletics	Athletics
ACT-117	M214	2121212	Trainer Squad	Sports Science	Science
ACT-118	D218	2117211	Dance Team	Activities	Activity
ACT-119	S212	2114211	Gymnastics Team	Women's Athletics	Athletics
ACT-120	S214	2117211	Drill Team	Activities	Activity

Coach ID#	First Name	Last Name	Phone Number	Email Address	Position	Skill Specialty
2110211	Jennifer	Foster	(512) 555-0219	[email protected]	Coach	Tennis
2111211	Josh	Engle	(512) 555-0338	[email protected]	Coach	Football
2112211	Sun	Lee	(512) 555-0066	[email protected]	Assistant Coach	Water Polo
2113211	Kyle	White	(512) 555-0211	[email protected]	Coach	Baseball
2114211	Joey	Goodwin	(512) 555-0342	[email protected]	Director	Gymnastics
2115211	Adam	Fulton	(512) 555-0125	[email protected]	Director	Basketball
2116211	Nayla	Ruiz	(512) 555-0616	[email protected]	Coach	Volleyball
2117211	Anna	Peterson	(512) 555-0200	[email protected]	Coach	Cheering
2118211	Rachael	Polansky	(512) 555-0125	[email protected]	Trainer	Basketball
2119211	Marta	Williams	(512) 555-0712	[email protected]	Director	Softball
2120212	Evan	Murphy	(512) 555-0319	[email protected]	Director	Soccer
2121212	Sasha	Henkel	(512) 555-0505	[email protected]	Trainer	Training
2122212	Hoan	Tran	(512) 555-0007	[email protected]	Coach	Lacrosse
2123212	Jack	Rentz	(512) 555-0480	[email protected]	Assistant Coach	Swimming
2124212	Victor	Hyeng	(512) 555-0220	[email protected]	Coach	Diving

a02_student_files/a02M_Club_Donations.accdb

Student ID#	First Name	Last Name	Phone	Email Address
1011510	Ranjan	Biswas	(512) 555-0054	[email protected]
1015710	Carlos	Hernandez	(512) 555-0012	[email protected]
1077610	Jessica	Lee	(512) 555-0041	[email protected]
1099810	Quan	Nguyen	(512) 555-0051	[email protected]
1143211	Jeffery	Butler	(512) 555-0098	[email protected]
2016120	Michael	Bryant	(512) 555-0063	[email protected]
2020120	Amanda	King	(512) 555-0013	[email protected]
2033620	Alphonse	Moore	(512) 555-0031	[email protected]
2145121	Emily	Allen	(512) 555-0021	[email protected]
2176421	Sandra	Washington	(512) 555-0089	[email protected]
2205522	Emmeline	Flores	(512) 555-0076	[email protected]
2210122	Justin	Hill	(512) 555-0067	[email protected]

Donation ID#	Student ID#	Club Affiliation	Donor Last Name	Donor First Name	Donor Phone	Donation
1	1015710	Accounting Student Association	Hernandez	Carlos	(512) 555-0012	¤ 20.00
2	1011510	Student Texas Art Association	Marsico	Sallie	(512) 555-0013	¤ 35.00
3	2016120	Radio, TV, & Film Club	Miller	Sara	(512) 555-0044	¤ 15.00
4	1099810	Chess Club	Matthews	Jeremy	(512) 555-0013	¤ 30.00
5	1015710	International Business Student Association	Rodriquez	Sophia	(512) 555-0020	¤ 25.00
6	1077610	Radio, TV, & Film Club	Gingles	Carl	(512) 555-0089	¤ 25.00
7	1077610	Radio, TV, & Film Club	Winters	Connie	(512) 555-0018	¤ 25.00
8	1077610	Chess Club	Babcock	Larry	(512) 555-0055	¤ 15.00
9	1099810	International Business Student Association	Nguyen	Susie	(512) 555-0051	¤ 25.00
10	1099810	Chess Club	Lawrence	Emily	(512) 555-0076	¤ 5.00
11	2176421	Student Government Association	Vroom	Angela	(512) 555-0026	¤ 10.00
12	1143211	Culinary Arts Club	Rhoades	Judy	(512) 555-0022	¤ 35.00
13	1143211	Culinary Arts Club	Butler	Julie	(512) 555-0098	¤ 40.00
14	1143211	Culinary Arts Club	Meyers	John	(512) 555-0067	¤ 15.00
15	2020120	Culinary Arts Club	Soto	George	(512) 555-0029	¤ 25.00
16	2020120	Culinary Arts Club	Goetz	Sophia	(512) 555-0033	¤ 5.00
17	2145121	Culinary Arts Club	D'Amato	Victoria	(512) 555-0036	¤ 10.00
18	2020120	Culinary Arts Club	Reid	Edith	(512) 555-0042	¤ 5.00
19	2020120	Entrepreneurs of Texas Lakes CC	Allen	Emily	(512) 555-0021	¤ 25.00
20	2020120	Entrepreneurs of Texas Lakes CC	Lee	Jessica	(512) 555-0041	¤ 25.00
21	2033620	Entrepreneurs of Texas Lakes CC	Moore	Alphonse	(512) 555-0031	¤ 10.00
22	2016120	Student Government Association	Traver	Gloria	(512) 555-0078	¤ 30.00
23	2176421	Student Government Association	Springs	Micah	(512) 555-0034	¤ 25.00
24	2176421	Student Government Association	Knight	Terry	(512) 555-0021	¤ 15.00
25	2210122	Accounting Student Association	Castaneda	Jose	(512) 555-0060	¤ 50.00
26	2205522	Student Vocational Nursing Association	Schultz	Josephine	(512) 555-0036	¤ 10.00
27	2205522	Student Vocational Nursing Association	Stevens	Tracey	(512) 555-0055	¤ 15.00
28	2210122	Entrepreneurs of Texas Lakes CC	Biswas	Ranjan	(512) 555-0054	¤ 100.00
29	2033620	Entrepreneurs of Texas Lakes CC	Bryant	Michael	(512) 555-0063	¤ 60.00
30	2210122	Accounting Student Association	McDougal	Darcy	(512) 555-0077	¤ 25.00

a03_student_files.zip

a03_student_files/a03A_Students_Majors.accdb

Major Name	Major ID
Diagnostic Medical Sonography	105
Emergency Medical Services	158
Emergency Medical Technician	158.100.07
Paramedic	158.101.07
Critical Care	158.551.03
Human Services	159
Financial Services	160.330.33
Automotive Technology	200
Business Administration	213
Nursing	215
Auto Parts Management	220.201.03
Automotive Brakes/Suspension/Inspections	220.233.05
Automotive Electrical and Electronics	220.253.10
Automotive Engine Diagnosis	220.254.33
Diesel and Industrial Machine Repair	220.611.45
American Sign Language	225.03.01
Horticulture	298
Greenhouse Production and Garden Center Management	298.05
Turfgrass Management	298.310.70
Landscape Design and Management	298.67
Accounting	300
Accounting Specialist	300.01
Accounting Technician	300.302.01
Administration of Justice	303
Paralegal Studies	320
Legal Assistant	320.11
General Practice Paralegal	320.26
Litigation Paralegal	320.55
Developmental Disabilities Specialist	338.821.03
Information Systems Technology	339
Database Specialist	339.123.78
Web Development Specialist	339.511.01
Network Engineer	339.781.23
Health Information Technology	367
Health Sciences	369
Administrative Support Technology	400
Medical Technology Support	400.01
Administrative Assistant	400.03
Graphic Design	415.01
Graphic Design for Advertising	415.03
Graphic Design for Multimedia	415.07
General Studies	421
Business Information Specialist	440.303.01
Civil Engineering	551
Civil Engineering Technician	551.003.55
Land Surveying	551.451.23
Laboratory Technology	551.887.62
Early Childhood Development	656
Early Childhood Instruction	656.01
Child Development	656.154.99
Youth Program Administration	656.332.23
Early Education Support Specialist	656.432.786
Computer Aided Drafting and Design	700
Architectural Drafting and Design	729.03
Mechanical Drafting and Design	729.33
Hospitality Management	785
Culinary Arts	785.06
Food Service Management	785.07
Catering	785.070.87
Lodging Management	785.45
Air Conditioning and Refrigeration	800
ACR Technician	800.03
Physical Therapist Assistant	820
Occupational Therapy Assistant	821
Electromechanical Controls Technology	900
Electrical Wiring	900.76
Electromechanical Controls	900.78.65
Electronics Technology	951.03
Electronics Engineering Technology	951.06
Welding	965

Student ID	First Name	Last Name	Address	City	State	Postal Code	Home Phone	College Email	Major ID
3768532	Rebekah	Alexander	218 Chapparal Trl	Dale	TX	78616	(512) 555-1017	[email protected]	339.123.78
3905345	Oscar	Alvarado	214B Bluff St	Buda	TX	78610	(512) 555-1022	[email protected]	421
3802483	Maria	Alvarez	3590 Longhorn Trl	Round Rock	TX	78681	(512) 555-2026	[email protected]	415.03
4739502	Eliza	Alvarez	3590 Longhorn Trl	Round Rock	TX	78681	(512) 555-2025	[email protected]	298
2834850	Ryan	Asfar	1325 Drifting Wind Run	Dripping Springs	TX	78620	(512) 555-0308	[email protected]	200
2834953	Chinonso	Austin	123 Wild Buffalo Dr	Kyle	TX	78640	(512) 555-1012	[email protected]	320.55
5867384	Hashem	Avis	532 Virginia St	San Marcos	TX	78666	(512) 555-9363	[email protected]	785.45
1034823	Jordan	Bass	188 Rockwood Dr	Wimberley	TX	78676	(512) 555-2320	[email protected]	105
8567302	Daniel	Bean	1433 Walpole Ln	Austin	TX	78739	(512) 555-2100	[email protected]	159
3856958	Danila	Bennett	808 Springbrook Ln	Leander	TX	78641	(512) 555-9364	[email protected]	159
1284734	Marianne	Berguin	180 Snyder Trl	Liberty Hill	TX	78642	(512) 555-1006	[email protected]	320.55
1298345	Shawn	Boulward	5689 Wild Foxglove Rd	Spicewood	TX	78669	(512) 555-2321	[email protected]	200
4352863	Christine	Bradley	2708 Kickapoo Cavern Dr	Pflugerville	TX	78660	(512) 555-2013	[email protected]	215
9348572	Pablo	Brandozzi	10006 Woodland Village Dr	Austin	TX	78750	(512) 555-1009	[email protected]	415.03
6739256	Katherine	Brown	707 Walnut St	Bastrop	TX	78602	(512) 555-2012	[email protected]	339
5860300	Daria	Campbell	162 Rockwood Dr	Wimberley	TX	78674	(512) 555-1016	[email protected]	300.01
3458632	Stephanie	Caputo	1731 Primrose Tr	Round Rock	TX	78665	(512) 555-2330	[email protected]	900
3842958	McCall	Cheney	1053 Tumbleweed Dr	Dale	TX	78616	(512) 555-1023	[email protected]	225.03.01
5738495	Robert	Chun	786 W Live Oak St	Lockhart	TX	78644	(512) 555-2331	[email protected]	369
5748392	Renato	Cildaro	334 Sand Hills Rd	Red Rock	TX	78662	(512) 555-2318	[email protected]	298.05
7384952	Christopher	Darko	240 Washington St	Smithville	TX	78657	(512) 555-1008	[email protected]	300
2938593	Curtis	Dawson	10344 Yellowstone Dr	Austin	TX	78747	(512) 555-2015	[email protected]	900
4719238	Avelina	DiAntonio	1008 Sunset Canyon Dr	Dripping Springs	TX	78620	(512) 555-2319	[email protected]	339
3829465	Tony	Downey	113 Zarogoza St	Elgin	TX	78621	(512) 555-1013	[email protected]	700
2839403	Nicole	Dutton	122 Whispering Spring Ln	Georgetown	TX	78633	(512) 555-2315	[email protected]	215
1284354	Katie	Eckert	10305 Windstone Ct	Manor	TX	78653	(512) 555-9357	[email protected]	303
2845209	Stephan	Elraheb	351 Wild Senna Dr	Pflugerville	TX	78660	(512) 555-1011	[email protected]	415.03
3829356	Marcel	Enescu	1900 White Oak Loop	Round Rock	TX	78681	(512) 555-1007	[email protected]	200
2849523	Moises	Fernandez	124 Woodland Ln	Round Rock	TX	78665	(512) 555-2320	[email protected]	700
3957203	Howard	Fishman	1842 Sorghum Hill Dr	Austin	TX	78754	(512) 555-2062	[email protected]	785.070.87
3948506	Kerry	Fleischer	2984 Piping Rock Trl	Austin	TX	78748	(512) 555-0309	[email protected]	339
3847589	Prince	Flitcroft	7821 Winsted Ln	Austin	TX	78703	(512) 555-1021	[email protected]	900
5730483	Clement	Forrester	1506 Wilshire Blvd	Austin	TX	78722	(512) 555-2018	[email protected]	339
9340582	Howard	Fouladi	276 Bayou Bend Dr	Buda	TX	78610	(512) 555-0310	[email protected]	213
4769304	Jana	Furfy	2107 Edenwood Dr	Austin	TX	78745	(512) 555-2064	[email protected]	821
2847194	Ginetta	Gant	100B W Mercer St	Dripping Springs	TX	78620	(512) 555-2321	[email protected]	400
1846834	Lan	Geng	170 Goldenrod St	Kyle	TX	78640	(512) 555-1005	[email protected]	551
1102544	Hugh	Goldstein	925 Conway Dr	San Marcos	TX	78666	(512) 555-0300	[email protected]	785
3849234	Donald	Hanby	334 Blue Heron Run	Wimberley	TX	78676	(512) 555-2316	[email protected]	158
8495034	Jason	Harden	9009 Bolton St	Austin	TX	78739	(512) 555-2319	[email protected]	213
2837490	Caitlyn	Hardy	359 Bentwood Dr	Leander	TX	78646	(512) 555-2310	[email protected]	700
7481938	Jamal	Hardy	664 Carson Ave	Liberty Hill	TX	78642	(512) 555-2318	[email protected]	158
8273409	Naomi	Henigson	22568 Briarcliff Dr	Spicewood	TX	78669	(512) 555-2014	[email protected]	440.303.01
3593653	Anna	Hernandez	2132 Mesquite Ln	Georgetown	TX	78626	(512) 555-0301	[email protected]	367
6753841	Jill	Hutzell	6462 Bisview Dr	Austin	TX	78730	(512) 555-9361	[email protected]	785.070.87
2738473	Ahjamu	Ibtehal	510 Buttonwood St	Bastrop	TX	78602	(512) 555-2020	[email protected]	551
5834924	Anastasia	Kakaulian	4822 Turtle Mound Bnd	Austin	TX	78748	(512) 555-2031	[email protected]	821
8751243	Fredric	Kerrison	278 Chapparral Trl	Dale	TX	78616	(512) 555-9358	[email protected]	213
2845721	Dana	Larsen	789 Bois Darc St	Lockhart	TX	78644	(512) 555-2314	[email protected]	551
3829476	Xifeng	Lau	127 Bateman Rd	Red Rock	TX	78662	(512) 555-2317	[email protected]	160.330.33
8473849	Yuri	Lau	367 1st Ave	Smithville	TX	78657	(512) 555-2021	[email protected]	213
3847563	Andrew	Lee	14010 Big Thicket Dr	Austin	TX	78747	(512) 555-1002	[email protected]	785.070.87
6738419	Kevin	Leopoldo	476 Beaukiss Ln	Elgin	TX	78621	(512) 555-1019	[email protected]	656
9583924	Moniquin	Lett	1121 Ascot St	Georgetown	TX	78627	(512) 555-2016	[email protected]	159
3819375	Jennifer	Locanda	10543 Blake Manor Rd	Manor	TX	78653	(512) 555-2311	[email protected]	656
6739234	Janie	Martinez	840 Abbey Glen Castle Dr	Pflugerville	TX	78660	(512) 555-2027	[email protected]	785.07
8247593	Patrice	Martinez	3632 Castle Path	Round Rock	TX	78681	(512) 555-2022	[email protected]	821
7348502	Yianna	Mathis	1187 Barilla Mountain Trl	Round Rock	TX	78665	(512) 555-0303	[email protected]	785.07
2903485	Jalpit	Matson	3204 Bird Call Pass	Austin	TX	78754	(512) 555-2028	[email protected]	105
2583697	Cleta	McElaney	132 Copperfield Dr	Austin	TX	78753	(512) 555-0305	[email protected]	421
3852938	Atonye	Morris	1172 Buttonwood St	Bastrop	TX	78602	(512) 555-1018	[email protected]	160.330.33
3859375	Nancy	Morrissey	903 Alpine Rd	Austin	TX	78704	(512) 555-2061	[email protected]	105
9385602	Lloyd	Murphy	657 Newfield Ln	Austin	TX	78703	(512) 555-0306	[email protected]	300.01
3856930	Cong	Nguyen	444 E Alamo St	Elgin	TX	78621	(512) 555-1004	[email protected]	339
8572034	Jonathan	Ninomiya	632 Langston Dr	Austin	TX	78723	(512) 555-2023	[email protected]	339.123.78
3857493	Sonia	Olson	193 Middle Creek Dr	Buda	TX	78610	(512) 555-2024	[email protected]	200
8273438	Edgardo	Pabelonia	894 Hidden Hills Dr	Dripping Springs	TX	78620	(512) 555-2322	[email protected]	298
9183467	Martin	Paffenroth	553 Silverado Dr	Kyle	TX	78640	(512) 555-2317	[email protected]	421
4852384	James	Parkhill	105 E Myrtle St	Liberty Hill	TX	78642	(512) 555-2323	[email protected]	105
5835035	Laurence	Poon	263 Caddis Cv	Kyle	TX	78640	(512) 555-0304	[email protected]	785.45
7583249	Betty	Poon	263 Caddis Cv	Kyle	TX	78640	(512) 555-1001	[email protected]	421
2840583	Oscar	Prince	367 Encino St	San Marcos	TX	78666	(512) 555-1014	[email protected]	785
8394284	Nora	Ramos	234 Melody Way	Wimberley	TX	78676	(512) 555-2325	[email protected]	213
9039453	Carlito	Ramos	6432 Old Harbor La	Austin	TX	78739	(512) 555-2324	[email protected]	298
3572184	Carla	Reid	715 Pampas Ricas Dr	Leander	TX	78641	(512) 555-2026	[email protected]	160.330.33
3852349	Kirsten	Riccardi	632 Ranchero Rd	Leander	TX	78645	(512) 555-9359	[email protected]	300
3859323	Micah	Rosario	376 Grange St	Liberty Hill	TX	78642	(512) 555-1015	[email protected]	225.03.01
5820384	Edward	Rose	555 S Blanco St	Lockhart	TX	78644	(512) 555-2019	[email protected]	339.511.01
6739319	Zack	Rowe	8728 Texas Bluebell Dr	Spicewood	TX	78669	(512) 555-1020	[email protected]	298.05
3859305	Mildred	Santangelo	687 Horseback Hollow	Austin	TX	78732	(512) 555-0307	[email protected]	339.511.01
5720358	Margot	Schneider	628C Farm St	Bastrop	TX	78602	(512) 555-2101	[email protected]	421
3802843	Anthony	Scott	65 Oakwood Dr	Dale	TX	78616	(512) 555-2326	[email protected]	369
2849201	Lisa	Sharpe	567 N Pecos St	Lockhart	TX	78644	(512) 555-2313	[email protected]	320.55
2595304	Joyce	Siegel	2678 Pettytown Rd	Red Rock	TX	78662	(512) 555-0302	[email protected]	105
5849320	Reza	Soltan	5498 Wild Foxglove Rd	Spicewood	TX	78669	(512) 555-9362	[email protected]	339.511.01
5739437	Eugene	Sotova	130 Garwood St	Smithville	TX	78657	(512) 555-2030	[email protected]	339
3857684	Michael	Stanton	6732 Langhorn St	Austin	TX	78741	(512) 555-2327	[email protected]	367
3586943	Joseph	Stavish	660 Bayou Bend Dr	Buda	TX	78610	(512) 555-9360	[email protected]	158.101.07
3845724	Mihir	Subramanian	670 Mogonye Ln	Elgin	TX	78621	(512) 555-2029	[email protected]	320.11
2034834	Larry	Telfer	162 Rattlesnake Ln	Red Rock	TX	78662	(512) 555-2017	[email protected]	303
8374853	Hendrick	Themis	2590 Mesquite Ln	Georgetown	TX	78226	(512) 555-1010	[email protected]	400
3569325	Carlis	Thomas	28A 4th Ave	Smithville	TX	78657	(512) 555-0301	[email protected]	421
2934853	Khrystyna	Tilson	11520 Oaklynn Ct	Manor	TX	78653	(512) 555-2328	[email protected]	225.03.01
8273485	Pei	Tram	3567 Vanderbilt Cir	Pflugerville	TX	78660	(512) 555-2027	[email protected]	440.303.01
8347568	Yolanda	Tram	3152 Homewood Cir	Round Rock	TX	78665	(512) 555-2025	[email protected]	298.67
2349535	Ashwin	Vohra	316 Lost Cove Dr	Spicewood	TX	78669	(512) 555-0302	[email protected]	215
3128456	WenLi	Wall	14380 Ceylon Tea Cir	Pflugerville	TX	78660	(512) 555-2329	[email protected]	158
3824752	Jaehee	Wang	2508 Falcon Dr	Round Rock	TX	78681	(512) 555-1003	[email protected]	320.11
9375202	Marilyn	Youson	8723 Leisure Dr	Austin	TX	78754	(512) 555-2063	[email protected]	213
1728193	Jean	Zadro	4345 Palacios Cir	Austin	TX	78749	(512) 555-2312	[email protected]	421
8938456	Florence	Zimmerman	98 San Jacinto Blvd	Austin	TX	78701	(512) 555-9356	[email protected]	213

a03_student_files/a03B_Job_Openings.accdb

Fee Paid	Employer ID	Employer Name	Industry	Contact First Name	Contact Last Name	Contact Title	Address	City	State	Postal Code	Phone
¤ 1,500.00	1000	Texas Lakes Energy	Environmental Technology	Joe	Hazelton	Director of Human Resources	882 Jorwoods Dr	Austin	TX	78745	(512) 555-0032
¤ 1,200.00	1003	Georgetown Medical Center	Health Care	Sun	Chong	Director, Professional Recruit	4421 Medical Pl	Georgetown	TX	78627	(512) 555-0055
¤ 500.00	1121	Round Rock Business Systems	General Administrative	Julio	Garcia	VP, Administration	974 Dixie Ln	Round Rock	TX	78681	(512) 555-0112
¤ 200.00	1222	Elgin Business Corporation	Insurance	Stan	Schinglman	HR Director	696 Red Town Rd	Elgin	TX	78621	(512) 555-0199
¤ 1,000.00	1223	Hi-Tech Solutions	Computer Software	Jared	Simmons	HR Representative	814 N 15th St	Austin	TX	78766	(512) 555-0155
¤ 600.00	1300	Underwood Medical Systems	Health Care	Bilal	Hadad	Medical Technology Recruiter	9103 Campanula St	Pflugerville	TX	78660	(512) 555-0049
¤ 300.00	1522	Robyn Rostamo Associates	Hotel and Food Service	Debra	Breamer	Director of Recruiting	377 Camino Alto Dr	Leander	TX	78641	(512) 555-0011
¤ 900.00	1788	Monroe Heating & Air Conditioning	Construction	Myra	Blake	Office Manager	7846 Pitt St	Bastrop	TX	78602	(512) 555-0095
¤ 500.00	2155	Van Etten Consulting	Hotel and Food Service	Carl	Fulton	Director of Human Resources	775 Bolton St	Austin	TX	78739	(512) 555-0099
¤ 300.00	2211	Buda Corporation	Pharmaceutical	Gail	Bradley	VP, Human Resources	443 S Main St	Buda	TX	78610	(512) 555-0088
¤ 1,200.00	2215	Freedom Data Storage	Computer Hardware	Stella	Williams	Recruiting Representative	6788 Harmon Ave	Austin	TX	78751	(512) 555-0044
¤ 200.00	2376	Woodward Brothers Construction	Construction	Glenn	Carlson	Director of Operations	731 Hackberry St	Lockhart	TX	78644	(512) 555-0167
¤ 800.00	3198	Capital Insurance Brokers	Insurance	Christa	Jakabowski	VP Administration	9983 W 96th St	Austin	TX	78741	(512) 555-0132
¤ 300.00	3288	Capital Eastern Bank	Banking and Finance	Sean	McDonald	Recruiting Representative	212 E 10th St	Austin	TX	78736	(512) 555-0187
¤ 300.00	3415	Roberta Cool Travel	Travel and Tourism	Lindsay	Schafer	Vice President	678 Red Rock Rd	Red Rock	TX	78662	(512) 555-0008
¤ 900.00	3534	Smithville Management Association	General Administrative	Gary	Caldwell	VP Human Resources	114 4th Ave	Smithville	TX	78657	(512) 555-0012
¤ 800.00	3666	Snyder Industrial	Construction	Brian	Blackgrove	Director of Human Resources	7554 Carson Ave	Liberty Hill	TX	78642	(512) 555-0045
¤ 1,000.00	3676	Pinewood Wireless	Computer Hardware	Kavi	Chandler	Sales Recruiter	113 Weller Dr	Austin	TX	78750	(512) 555-0010
¤ 800.00	3786	Dale Accounting Partners	Banking and Finance	Tran	Truc	Office Manager	4088 Dale Ln	Dale	TX	78616	(512) 555-0089
¤ 1,000.00	3876	Southwest Bank	Banking and Finance	Luis	Torres	Director of Recruiting	98 W Mercer St	Dripping Springs	TX	78620	(512) 555-0013
¤ 700.00	4515	Synergy Consulting	General Administrative	Marta	Winslow	Office Manager	103 Tower Dr	Kyle	TX	78640	(512) 555-0122
¤ 1,000.00	4516	Greene Global Energy	Environmental Technology	George	Phillips	Director of Administration	642 Travis St	San Marcos	TX	78666	(512) 555-0009
¤ 300.00	4544	Manor Pharmaceuticals	Pharmaceutical	Hannah	Gregerson	Director of Human Resources	4782 Liberty St	Manor	TX	78653	(512) 555-0021
¤ 1,000.00	4555	Austin Medical Technologies Corp	Health Care	Josefina	Hernandez	VP, Human Resources	9822 Fresco Dr	Austin	TX	78731	(512) 555-0067
¤ 2,300.00	4689	Wimberley Bank and Trust Co	Banking and Finance	Megan	Snyder	Office Manager	876 Oak Dr	Wimberley	TX	78676	(512) 555-3218
¤ 500.00	4790	Sweeney Catering	Hotel and Food Service	Michael	Sweeney	Owner	45 Highview Rd	Georgetown	TX	78627	(512) 555-1689
¤ 300.00	4795	Hart Computing	Computer Hardware	Robert	Hart	Manager	1205 Hidalgo St	Austin	TX	78702	(512) 555-4820

# Openings	Annual Salary	Hrs Per Wk	Job ID	Employer ID	Position
5	¤ 78,000.00	40	J-001	1223	SQL/Unix Programmer
3	¤ 95,000.00	40	J-002	1003	Assistant Director of Pharmacy
10	¤ 62,000.00	40	J-003	1003	Nursing Supervisor
3	¤ 50,200.00	50	J-004	2155	Catering Manager
5	¤ 35,000.00	50	J-005	2155	Gift Shop Manager
10	¤ 30,500.00	40	J-006	2376	Cabinetmaker/Carpenter
5	¤ 80,000.00	40	J-007	2376	Civil Engineering Supervisor
15	¤ 35,000.00	40	J-008	2155	Senior Accounting Clerk
5	¤ 40,000.00	40	J-009	2155	Executive Assistant
5	¤ 50,225.00	40	J-010	2211	Biostatistician, Entry Level
3	¤ 54,000.00	40	J-011	3786	Internal Auditor
1	¤ 65,000.00	40	J-012	1223	Senior Web Designer
15	¤ 36,000.00	40	J-013	3786	Accountant, Entry Level
5	¤ 36,000.00	40	J-014	1788	Electrician, Entry Level
6	¤ 60,000.00	40	J-015	1788	Estimating Manager
10	¤ 28,000.00	40	J-016	1522	Travel Clerk
3	¤ 45,000.00	40	J-017	1000	Geologist
5	¤ 70,000.00	40	J-018	1000	Petroleum Engineer , Mid Level
3	¤ 65,000.00	40	J-019	2211	Senior Accountant
1	¤ 57,000.00	50	J-020	4555	Clinical Studies Manager
3	¤ 66,000.00	40	J-021	2215	Network Engineer
2	¤ 82,000.00	40	J-022	1003	Emergency Room Supervisor
2	¤ 105,000.00	50	J-023	2215	Electrical Engineer
5	¤ 42,000.00	40	J-024	2155	Human Resources Technician
2	¤ 78,450.00	40	J-025	3666	Construction Site Manager
2	¤ 59,800.00	40	J-026	4544	Clinical Studies Manager
15	¤ 32,250.00	40	J-027	3288	Teller Trainee
1	¤ 85,500.00	40	J-028	4555	Quality Assurance Manager
5	¤ 34,000.00	40	J-029	3876	Teller Trainee
1	¤ 42,000.00	40	J-030	3676	Network Engineer
1	¤ 61,000.00	40	J-031	4516	Executive Assistant
2	¤ 75,000.00	40	J-032	4515	Management Consultant
2	¤ 31,250.00	40	J-033	1121	Human Resources Technician
2	¤ 65,000.00	40	J-034	3534	Compensation Administrator
4	¤ 65,000.00	40	J-035	1300	Physician Assistant
2	¤ 83,450.00	40	J-036	1222	Actuary, Senior
1	¤ 55,000.00	40	J-037	3415	Cruise Manager
2	¤ 45,000.00	40	J-038	3288	Branch Manager
1	¤ 60,000.00	40	J-039	3288	ATM Operations Manager
5	¤ 43,000.00	40	J-040	3198	Actuary, Entry Level
3	¤ 98,000.00	40	J-041	3198	Actuary, Senior
1	¤ 75,000.00	40	J-042	4555	Nuclear Medicine Director

SELECT [3B Job Openings].[Job ID], [3B Job Openings].Position, [3B Employers].[Employer Name], [3B Job Openings].[# Openings], [3B Job Openings].[Annual Salary] FROM [3B Employers] INNER JOIN [3B Job Openings] ON [3B Employers].[Employer ID] = [3B Job Openings].[Employer ID] WHERE ((([3B Job Openings].[Annual Salary])>=40000)) ORDER BY [3B Job Openings].Position, [3B Employers].[Employer Name];

a03_student_files/a03C_Student_Internships.accdb

Employer Name	Hrs Per Week	Internship ID	Contact First Name	Contact Last Name	Address	City	State	Postal Code	Phone
Lakes Realty Inc	10	INTERN-1000	Ernest	Kender	882 Belfast Dr	Austin	TX	78723	(512) 555-0032
Georgetown Medical Center	15	INTERN-1007	Chen	Yuan	4421 Medical Pl	Georgetown	TX	78627	(512) 555-0055
Round Rock Business Systems	10	INTERN-1013	Jason	Whitley	974 Dixie Ln	Round Rock	TX	78681	(512) 555-0112
Elgin Business Corporation	10	INTERN-1010	Micah	Rodby	696 Red Town Rd	Elgin	TX	78621	(512) 555-0199
Hi-Tech Solutions	15	INTERN-1017	Daniel	Gray	814 N 15th St	Austin	TX	78766	(512) 555-0155
Carliz Medical Systems	10	INTERN-1003	Ryan	Michaels	910 Wild Buffalo Dr	Austin	TX	78744	(512) 555-0049
Deborah Lynne Associates	15	INTERN-1019	Emily	Hicks	377 Canyon Bend Rd	Pflugerville	TX	78660	(512) 555-0011
Dale Accounting Partners	15	INTERN-1012	Brittany	Rossi	4088 Dale Ln	Dale	TX	78616	(512) 555-0095
Jones Consulting	10	INTERN-1006	Mark	Jones	775 Bolton St	Austin	TX	78739	(512) 555-0099
Elgin Business Corporation	20	INTERN-1021	Alecia	Steed	696 Red Town Rd	Elgin	TX	78621	(512) 555-0088
Freedom Data Storage	20	INTERN-1015	Navjot	Kaur	6788 Harmon Ave	Austin	TX	78751	(512) 555-0044
Ingram Brothers Construction	20	INTERN-1025	Jason	Ingram	731 N Oaks Dr	Austin	TX	78753	(512) 555-0167
Texas Insurers	20	INTERN-1002	Stephanie	Josey	9983 Ruxton St	Austin	TX	78749	(512) 555-0132
Georgetown Medical Center	10	INTERN-1022	Ricardo	Lopez	4421 Medical Pl	Georgetown	TX	78627	(512) 555-0187
Roberta Cool Travel	20	INTERN-1011	Chelsea	Reid	678 Red Rock Rd	Red Rock	TX	78662	(512) 555-0008
Smithville Management Association	10	INTERN-1008	Justin	Henaghan	114 4th Ave	Smithville	TX	78657	(512) 555-0012
Snyder Industrial	15	INTERN-1018	Steven	Biagoni	7554 Carson Ave	Liberty Hill	TX	78642	(512) 555-0045
Pinewood Wireless	25	INTERN-1004	Osiris	Cooper	113 Weller St	Austin	TX	78750	(512) 555-0010
Dale Accounting Partners	15	INTERN-1023	Sedale	Brooks	4088 Dale Ln	Dale	TX	78616	(512) 555-0089
Southwest Bank	15	INTERN-1014	Benjamin	Butler	98 W Mercer St	Dripping Springs	TX	78620	(512) 555-0013
Synergy Consulting	10	INTERN-1026	Cassandra	Moyer	103 Tower Dr	Kyle	TX	78640	(512) 555-0122
Rider Renewable Energy	15	INTERN-1001	Ashton	Allen	642 Sunflower Ln	San Marcos	TX	78666	(512) 555-0009
Manor Pharmaceuticals	10	INTERN-1016	Julianna	Taylor	4782 Liberty St	Manor	TX	78653	(512) 555-0021
Austin Medical Technologies Corp	10	INTERN-1024	Lakita	Ferrara	9822 Fresco Dr	Austin	TX	78731	(512) 555-0067
Wimberley Bank and Trust Co	20	INTERN-1005	Sarah	Graff	876 Oak St	Wimberley	TX	78676	(512) 555-3218
Sweeney Catering	10	INTERN-1020	Kyle	Wiseman	45 Highview Rd	Georgetown	TX	78627	(512) 555-1689
Hart Computing	10	INTERN-1009	Robert	Hart	1205 Hidalgo St	Austin	TX	78702	(512) 555-4820

Student ID	Last Name	First Name	Phone Number	Email	Internship ID
1010101	Bass	Jordan	(512) 555-2320	[email protected]	INTERN-1025
1382572	Fresch	Michael	(512) 555-0234	[email protected]	INTERN-1009
2034834	Taruc	Ian	(512) 555-2017	[email protected]	INTERN-1024
2458622	Ingram	Joseph	(512) 555-0177	[email protected]	INTERN-1021
1856433	Vargas	Vanessa	(512) 555-0302	[email protected]	INTERN-1020
1454588	Mathurim	Yvette	(512) 555-0305	[email protected]	INTERN-1007
1228463	Williams	Jade	(512) 555-2329	[email protected]	INTERN-1000
1254568	Snyder	Amanda	(512) 555-0192	[email protected]	INTERN-1015
2347832	Ciocco	Heather	(512) 555-2330	[email protected]	INTERN-1005
2223334	Taiwo	Akinrayo	(512) 555-0301	[email protected]	INTERN-1003
2352184	Ramstad	Hana	(512) 555-2026	[email protected]	INTERN-1013
2581478	Stille	Zachary	(512) 555-9360	[email protected]	INTERN-1025
2147852	Leshkow	Katherine	(512) 555-0301	[email protected]	INTERN-1001
1789652	Akkina	Padmaja	(512) 555-1017	[email protected]	INTERN-1016
1654823	Sweeney	Megan	(512) 555-1018	[email protected]	INTERN-1010
2369854	Nguyen	Trang	(512) 555-1004	[email protected]	INTERN-1019
2146873	Smith	Chauncey	(512) 555-2013	[email protected]	INTERN-1026
1856422	Pearson	Amber	(512) 555-2319	[email protected]	INTERN-1018
1548963	Fresch	Jenna	(512) 555-2025	[email protected]	INTERN-1008
2478912	McLin	Molly	(512) 555-2064	[email protected]	INTERN-1023
2361258	Perales	Edward	(512) 555-2323	[email protected]	INTERN-1017
1542873	Rodriguez	Elisha	(512) 555-2019	[email protected]	INTERN-1002
1323215	Williams	Tarsha	(512) 555-2031	[email protected]	INTERN-1012
1465239	Gillotte	Tyler	(512) 555-0304	[email protected]	INTERN-1014
2982354	Akers	Aimee	(512) 555-9362	[email protected]	INTERN-1010
1122845	Porter	James	(512) 555-1016	[email protected]	INTERN-1011
1054333	Appel	Meagan	(512) 555-3334	[email protected]	INTERN-1026
1214566	Blackmon	Tianna	(512) 555-6645	[email protected]	INTERN-1001
1236547	Collins	John	(512) 555-4765	[email protected]	INTERN-1013
1264444	Dolensky	Adam	(512) 555-4412	[email protected]	INTERN-1022
1242586	Elliott	Shannon	(512) 555-8752	[email protected]	INTERN-1003
1273625	Felton	Aujah	(512) 555-2536	[email protected]	INTERN-1022
1291112	Gray	Nakindria	(512) 555-2111	[email protected]	INTERN-1011
1268855	Holtzinger	Jeremy	(512) 555-5858	[email protected]	INTERN-1016
1252233	Isberto	Dianah	(512) 555-3232	[email protected]	INTERN-1008
1281285	Jones	Timothy	(512) 555-8521	[email protected]	INTERN-1025
1353512	Kirkwood	Audrey	(512) 555-1235	[email protected]	INTERN-1018
1404125	Lewis	Christopher	(512) 555-1254	[email protected]	INTERN-1019
1502581	Miller	Kari	(512) 555-8152	[email protected]	INTERN-1020
1603214	Nichols	Anya	(512) 555-1423	[email protected]	INTERN-1017
1708529	Olds	Velide	(512) 555-2948	[email protected]	INTERN-1002
1806543	Parker	Andre	(512) 555-4356	[email protected]	INTERN-1016
1961678	Nguyen	Thu Ho Anh	(512) 555-7861	[email protected]	INTERN-1009
2000036	Quinn	Patrick	(512) 555-2063	[email protected]	INTERN-1004
2171741	Roberts	Franjellica	(512) 555-4117	[email protected]	INTERN-1008
2200009	Spruill	Kameron	(512) 555-2090	[email protected]	INTERN-1004
2506213	Temple	Nigel	(512) 555-3125	[email protected]	INTERN-1007
2660018	Underwood	Michelle	(512) 555-1806	[email protected]	INTERN-1000
1652482	Vick	Leann	(512) 555-8224	[email protected]	INTERN-1002
2468755	Williams	Jordan	(512) 555-5587	[email protected]	INTERN-1005
1546822	Zornes	Emily	(512) 555-2862	[email protected]	INTERN-1014

a03_student_files/a03D_Student_Parking.accdb

Lot ID	Capacity	Lot Location	Semester Fee	# Handicap Spots
LOT-1A	100	Front of Building E	¤ 100.00	4
LOT-2A	200	Front of Building C, Rows 1-20	¤ 100.00	8
LOT-2B	160	Front of Building C, Rows 21-40	¤ 75.00	0
LOT-3A	250	Between Buildings A and C	¤ 100.00	7
LOT-4A	300	Front of Building A - Faculty only	¤ 0.00	7
LOT-5A	200	Front of Building D -Rows 1-20	¤ 100.00	10
LOT-5B	160	Front of Building D - Rows 21-40	¤ 75.00	0
LOT-5C	160	Front of Building D - Rows 41-60	¤ 50.00	0
LOT-6A	200	Front of Building G -Rows 1-20	¤ 100.00	10
LOT-6B	160	Front of Building G - Rows 21-40	¤ 75.00	0
LOT-6C	140	Front of Building G - Rows 41-60	¤ 50.00	0
GAR-1A	725	Next to Library	¤ 100.00	25

Student ID	State	Last Name	First Name	Email	License Plate	Lot ID	Phone Number
1010101	TX	Bass	Jordan	[email protected]	ABC-1000	LOT-2A	(512) 555-2320
1382572	TX	Fresch	Jenna	[email protected]	IWX-6345	LOT-6B	(512) 555-0234
2034834	TX	Taruc	Ian	[email protected]	TCR-1720	GAR-1A	(512) 555-2017
2458622	LA	Ingram	Joseph	[email protected]	JGR-1071	LOT-6C	(512) 555-0177
1856433	TX	Vargas	Vanessa	[email protected]	VAN-3200	LOT-5B	(512) 555-0302
1454588	TX	Mathurim	Yvette	[email protected]	KTQ-8567	LOT-6B	(512) 555-0305
1228463	TX	Woodward	Jean	[email protected]	HBA-5882	LOT-3A	(512) 555-2329
1254568	TX	Snyder	Amanda	[email protected]	RRR-9384	LOT-5B	(512) 555-0192
2347832	TX	Ciocco	Heather	[email protected]	HCC-0323	LOT-5B	(512) 555-2330
2223334	TX	Taiwo	Akinrayo	[email protected]	TKY-1033	GAR-1A	(512) 555-0301
2352184	TX	Ramstad	Hana	[email protected]	HRD-2602	LOT-6A	(512) 555-2026
2581478	TX	Stille	Zachary	[email protected]	ZST-0366	GAR-1A	(512) 555-9360
2147852	LA	Leshkow	Katherine	[email protected]	LKK-1003	GAR-1A	(512) 555-0301
1789652	TX	Akkina	Padmaja	[email protected]	AQR-1044	LOT-3A	(512) 555-1017
1654823	LA	Snyder	Mandy	[email protected]	HBB-3335	LOT-5A	(512) 555-1018
2369854	TX	Nguyen	Trang	[email protected]	TNG-4010	LOT-2A	(512) 555-1004
2146873	TX	Smith	Chauncey	[email protected]	CHS-3201	LOT-5C	(512) 555-2013
1856422	TX	Pearson	Amber	[email protected]	AUM-4638	LOT-5A	(512) 555-2319
1548963	TX	Allen	Stacey	[email protected]	WRB-8536	LOT-6A	(512) 555-2025
2478912	LA	McLin	Molly	[email protected]	MML-6244	LOT-2B	(512) 555-2064
2361258	TX	Perales	Edward	[email protected]	EPR-3223	GAR-1A	(512) 555-2323
1542873	TX	Rodriguez	Elisha	[email protected]	SNZ-0246	LOT-1A	(512) 555-2019
1323215	TX	Williams	Tarsha	[email protected]	EEZ-4123	LOT-6C	(512) 555-2031
1465239	TX	Gillotte	Tyler	[email protected]	MRT-9678	LOT-2A	(512) 555-0304
2982354	LA	Akers	Aimee	[email protected]	AAK-2233	LOT-1A	(512) 555-9362
1122845	TX	Porter	James	[email protected]	JKK-3022	LOT-2B	(512) 555-1016
1054333	TX	Appel	Meagan	[email protected]	DEX-2837	LOT-6B	(512) 555-3334
1214566	TX	Blackmon	Tianna	[email protected]	FLO-4488	LOT-2A	(512) 555-6645
1236547	LA	Collins	John	[email protected]	LAQ-6345	LOT-6C	(512) 555-4765
1264444	TX	Dolensky	Adam	[email protected]	TCO-3892	GAR-1A	(512) 555-4412
1242586	TX	Elliott	Shannon	[email protected]	NEY-7258	LOT-6A	(512) 555-8752
1273625	TX	Felton	Aujah	[email protected]	ZPN-1256	LOT-2A	(512) 555-2536
1291112	LA	Gray	Nakindria	[email protected]	CUA-3123	LOT-6A	(512) 555-2111
1268855	TX	Holtzinger	Jeremy	[email protected]	VVY-2322	LOT-6B	(512) 555-5858
1252233	TX	Isberto	Dianah	[email protected]	PAB-8986	LOT-5C	(512) 555-3232
1281285	TX	Jones	Timothy	[email protected]	BCM-2134	LOT-5B	(512) 555-8521
1353512	TX	Kirkwood	Audrey	[email protected]	GLL-5234	LOT-2B	(512) 555-1235
1404125	TX	Lewis	Christopher	[email protected]	JJK-7456	GAR-1A	(512) 555-1254
1502581	TX	Miller	Kari	[email protected]	QSS-0789	LOT-6B	(512) 555-8152
1603214	LA	Nichols	Anya	[email protected]	YQW-3958	LOT-3A	(512) 555-1423
1708529	TX	Olds	Velide	[email protected]	ETU-1010	LOT-1A	(512) 555-2948
1806543	TX	Parker	Andre	[email protected]	NPG-2501	LOT-3A	(512) 555-4356
1961678	TX	Nguyen	Thu Ho Anh	[email protected]	HHT-6178	LOT-5C	(512) 555-7861
2000036	TX	Quinn	Patrick	[email protected]	PQD-0027	LOT-6C	(512) 555-2063
2171741	TX	Roberts	Franjellica	[email protected]	JRF-1174	LOT-5B	(512) 555-4117
2200009	LA	Spruill	Kameron	[email protected]	KSP-9002	LOT-6A	(512) 555-2090
2506213	TX	Temple	Nigel	[email protected]	NGT-1235	LOT-5A	(512) 555-3125
2660018	TX	Underwood	Michelle	[email protected]	MCU-0681	GAR-1A	(512) 555-1806
1652482	TX	Vick	Leann	[email protected]	AKN-2564	LOT-2B	(512) 555-8224
2468755	TX	Williams	Jordan	[email protected]	JWW-8447	LOT-5C	(512) 555-5587
1546822	TX	Zornes	Emily	[email protected]	UMV-9158	LOT-3A	(512) 555-2862

SELECT [3D Parking Lots].[Lot ID], [3D Parking Lots].[Lot Location], [3D Students].[Student ID], [3D Students].[Last Name], [3D Students].[First Name], [3D Students].[License Plate], [3D Parking Lots].[Semester Fee] FROM [3D Parking Lots] INNER JOIN [3D Students] ON [3D Parking Lots].[Lot ID] = [3D Students].[Lot ID] WHERE ((([3D Parking Lots].[Lot Location]) Like "*building g*")) ORDER BY [3D Students].[Last Name];

SELECT [3D Parking Lots].[Lot ID], [3D Students].[Student ID], [3D Students].[Last Name], [3D Students].[First Name], [3D Students].[License Plate], [3D Students].State, [3D Parking Lots].[Semester Fee] FROM [3D Parking Lots] INNER JOIN [3D Students] ON [3D Parking Lots].[Lot ID] = [3D Students].[Lot ID];

a03_student_files/a03E_Textbook_Publishers.accdb

Publisher ID	Publisher Name	Address	City	State	Publisher Web Site	Postal Code	Phone Number
PUB-1001	Science Books Galore	525 Allen St	Trenton	NJ	http://www.sciencebooksgalore.pub	08620	(609) 555-2554
PUB-1002	Books for Chemistry Students Ltd	142 N Spring St	Los Angeles	CA	http://www.chemistrybooks.pub	90012	(213) 555-8362
PUB-1003	Carliz Publishers Corp	24 King Ave	Columbus	OH	http://www.carlizpublishingcorp.pub	43201	(614) 555-3322
PUB-1004	Austin Publishing Co	2231 W Alamo Rd	Austin	TX	http://www.austinpublishingco.pub	78750	(512) 555-3735
PUB-1005	Galaxy Publishing House	5644 E Houston St	New York	NY	http://www.galaxypublishinghouse.pub	10012	(212) 555-1122
PUB-1006	Two Sisters Publishing	7852 Lucerne Ter	Orlando	FL	http://www.2sisterspublishing.pub	32801	(321) 555-3809
PUB-1007	College Textbook Publishers	12 Essex St	Boston	MA	http://www.collegetextbookpublishers.pub	02111	(339) 555-9393

# Books	Textbook ID	Textbook Name	Course(s)	Price Per Book	Publisher ID
40.0	TEXT-0007	Organic Chemistry	CHM-121-122	¤ 216.52	PUB-1001
120.0	TEXT-0008	Organic Chemistry Experiments	CHM-241-242	¤ 150.10	PUB-1001
400.0	TEXT-0002	Chemistry for Biology Students	BIO-101-102	¤ 105.30	PUB-1002
30.0	TEXT-0005	Chemistry Principles	CHM-110	¤ 110.63	PUB-1002
250.0	TEXT-0006	General Chemistry	CHM-111-112	¤ 203.96	PUB-1002
400.0	TEXT-0001	Basic Anatomy and Physiology	BIO-100	¤ 94.00	PUB-1003
30.0	TEXT-0016	Physics for Engineers	PHY-241-242	¤ 187.07	PUB-1003
120.0	TEXT-0010	Principles of Oceanography	GOL-111-112	¤ 113.48	PUB-1004
30.0	TEXT-0013	Kinesiology Principles	NAS-177	¤ 58.26	PUB-1004
120.0	TEXT-0004	Microbiology Principles	BIO-150	¤ 149.80	PUB-1005
30.0	TEXT-0011	Principles of Meteorology	NAS-120	¤ 112.35	PUB-1005
200.0	TEXT-0012	Essentials of Astronomy	NAS-132-132	¤ 123.20	PUB-1005
330.0	TEXT-0003	Anatomy and Physiology	BIO-141-142	¤ 159.75	PUB-1003
200.0	TEXT-0009	Geology - Historical and Physical Perspectives	GOL-105-106	¤ 127.00	PUB-1007
80.0	TEXT-0014	Physics Concepts	PHY-100	¤ 123.56	PUB-1007
40.0	TEXT-0015	Principles of Physics	PHY-201-202	¤ 116.40	PUB-1007

a03_student_files/a03F_Degrees_Students.accdb

Degree ID	Degree	Program
146	AAS	Emergency Medical Services
152	AAS	Health Information Management
163	AAS	Medical Laboratory Technician
275	AAS	Nursing
310	AAS	Radiography
340	AAS	Polysomnography
522	AAS	Biotechnology
636	AAS	Orthotics

GPA	Student ID	Last Name	First Name	Phone Number	Email	Degree ID
3.2	1010101	Bass	Jordan	(512) 555-2320	[email protected]	146
3.22	1054333	Appel	Meagan	(512) 555-3334	[email protected]	152
3.24	1122845	Porter	James	(512) 555-1016	[email protected]	163
3.26	1214566	Blackmon	Tianna	(512) 555-6645	[email protected]	275
3.28	1228463	Snyder	Amanda	(512) 555-2329	[email protected]	310
3.46	1291112	Gray	Nakindria	(512) 555-2111	[email protected]	340
3.48	1323215	Williams	Tarsha	(512) 555-2031	[email protected]	522
3.52	1382572	Fresch	Jenna	(512) 555-0234	[email protected]	636
3.86	2000036	Quinn	Patrick	(512) 555-2063	[email protected]	146
3.88	2034834	Taruc	Ian	(512) 555-2017	[email protected]	152
3.9	2146873	Smith	Chauncey	(512) 555-2013	[email protected]	163
3.92	2147852	Leshkow	Katherine	(512) 555-0301	[email protected]	275
3.9	2369854	Nguyen	Trang	(512) 555-1004	[email protected]	340
3.85	2458622	Ingram	Joseph	(512) 555-0177	[email protected]	522
3.75	2478912	McLin	Molly	(512) 555-2064	[email protected]	636
3.26	3110253	Goetz	Sophie	(512) 555-0063	[email protected]	275
3.28	3850254	Allen	Emily	(512) 555-0013	[email protected]	146
3.3	3640255	Montague	Sara	(512) 555-0031	[email protected]	636
3.4	3020260	Miller	Sara	(512) 555-0060	[email protected]	310
3.6	3510270	McElaney	Cleta	(512) 555-0305	[email protected]	522
3.62	3560271	Wall	WenLi	(512) 555-2329	[email protected]	163
3.64	3010272	Woodward	Jean	(512) 555-2330	[email protected]	163
3.72	2000276	Hernandez	Anna	(512) 555-0301	[email protected]	152
3.84	2500282	Alvarez	Eliza	(512) 555-2025	[email protected]	340
3.86	2400283	Snyder	Megan	(512) 555-2064	[email protected]	522

SELECT [3F Students].GPA, [3F Students].[Student ID], [3F Students].[Last Name], [3F Students].[First Name], [3F Degrees].Degree, [3F Degrees].Program FROM [3F Degrees] INNER JOIN [3F Students] ON [3F Degrees].[Degree ID] = [3F Students].[Degree ID] WHERE ((([3F Students].GPA)>=3.8)) ORDER BY [3F Students].GPA DESC, [3F Students].[Last Name];

SELECT [3F Degrees].Program, [3F Students].[Last Name], [3F Students].[First Name], [3F Students].GPA FROM [3F Degrees] INNER JOIN [3F Students] ON [3F Degrees].[Degree ID] = [3F Students].[Degree ID] ORDER BY [3F Degrees].Program, [3F Students].[Last Name];

a03_student_files/a03G_Career_Books.accdb

Copies On Hand	Value of Books	Title ID	Title	Author Last Name	Author First Name	Publisher ID	Category
4	¤ 175.00	T-01	Competitive Interview Prep	Hubert	Gretchen	PUB-100	Interviewing Strategies
1	¤ 90.00	T-02	Conversation Ice Breakers	Stein	Herbert	PUB-108	Interviewing Strategies
4	¤ 175.00	T-03	Dressing for Interview Success	Thornton	Perry	PUB-102	Interviewing Strategies
8	¤ 250.00	T-04	Fifty Standard Interview Questions	Becker	Colin	PUB-103	Job Search
3	¤ 200.00	T-05	Hot Jobs	Sinclair	Janice	PUB-104	Job Search
10	¤ 450.00	T-06	Job Fair Success	Cunningham	Charise	PUB-105	Job Search
10	¤ 420.00	T-07	Phone Interview Success	Chu	Fong	PUB-100	Interviewing Strategies
12	¤ 525.00	T-08	After the Interview	Ramirez	Raphael	PUB-102	Interviewing Strategies
5	¤ 325.00	T-09	Entry Level Job Search	Doyle	Caryn	PUB-103	Job Search
4	¤ 400.00	T-10	Internship Search	Boykin	Dimitri	PUB-104	Job Search
6	¤ 300.00	T-11	Professional-Level Job Search	Ortiz	Ricardo	PUB-105	Job Search
10	¤ 325.00	T-12	The Best Use of a Cover Letter	Burke	Kay	PUB-106	Job Search
7	¤ 275.00	T-13	Finding Hiring Employers	Blanchett	Donald	PUB-107	Job Search
12	¤ 525.00	T-14	New Dress for Success	Gregerson	Margo	PUB-108	Interviewing Strategies
10	¤ 420.00	T-15	First Impressions	Epstein	Lonnie	PUB-109	Interviewing Strategies
13	¤ 525.00	T-16	Interview Techniques and Resume Tips	Erwin	Paulette	PUB-109	Resumes
11	¤ 420.00	T-17	Resumes in Cyberspace	Smith	John	PUB-107	Resumes
2	¤ 125.00	T-18	Mastering the Interview	Jameson	Susanna	PUB-101	Interviewing Strategies
1	¤ 75.00	T-19	Smart Answers to Tough Questions	Smith	Gary	PUB-100	Interviewing Strategies
3	¤ 325.00	T-20	Jobs of the Future	Greene	Sharon	PUB-104	Job Search
3	¤ 400.00	T-21	Mastering the Job Market	Khan	Alexis	PUB-102	Job Search
5	¤ 300.00	T-22	High Tech Jobs	Peterson	Karen	PUB-103	Job Search
3	¤ 200.00	T-23	Find the Right Job for You	Lufton	Louisa	PUB-100	Job Search
6	¤ 400.00	T-24	High Tech Career Paths	London	Eric	PUB-102	Job Search

Publisher ID	Company Name	Rep Last Name	Rep First Name	Job Title	Phone Number
PUB-100	AAA Career Books	Visyas	Victoria	Sales Representative	(512) 555-0054
PUB-101	Career Consultants Inc	King	James	Sales Associate	(512) 555-0071
PUB-102	Executive Press Associates	Phelps	Pauline	Regional Manager	(512) 555-0063
PUB-103	Conner, Dunne, & Murphy Publishers	Hernandez	Hector	Sales Representative	(512) 555-0012
PUB-104	Employment Central Ltd	Mizumori	Raymond	Sales Representative	(512) 555-0041
PUB-105	Yellow Rose Publications	Nguyen	Timothy	Sales Representative	(512) 555-0051
PUB-106	Woodward Publishers	Lamb	Anne	Technical Sales Rep	(512) 555-0065
PUB-107	Careers R Us	Butler	Benjamin	Sales Associate	(512) 555-0098
PUB-108	Austin Publishing	Soto	Jacob	Sales Associate	(512) 555-0064
PUB-109	Carliz Publications Inc	Bryant	Robert	Sales Representative	(512) 555-0063
PUB-110	Kyle Tyler of New York	Molvik	Sergei	Sales Representative	(512) 555-0072

SELECT [3G Publishers].[Publisher ID], [3G Career Books].Category, [3G Career Books].Title, [3G Career Books].[Author Last Name], [3G Career Books].[Author First Name], [3G Publishers].[Company Name] FROM [3G Publishers] INNER JOIN [3G Career Books] ON [3G Publishers].[Publisher ID] = [3G Career Books].[Publisher ID] WHERE ((([3G Career Books].Category) Like "*res*" Or ([3G Career Books].Category) Like "*interview*")) ORDER BY [3G Career Books].Category, [3G Career Books].Title;

a03_student_files/a03H_Resume_Workshops.accdb

Workshop Fee	Date Fee Received	Workshop ID	Participant ID	Participant First Name	Participant Last Name	Phone Number
¤ 25.00	10/14/18	R-002	00000	Firstname	Lastname	(512) 555-5555
¤ 35.00	10/2/18	R-001	10115	Sally	Marques	(512) 555-0054
¤ 30.00	10/6/18	R-005	10155	Tracey	Stevens	(512) 555-0071
¤ 25.00	9/30/18	R-003	10156	Mark	Curtis	(512) 555-0063
¤ 30.00	10/2/18	R-005	10157	Carlos	Hernandez	(512) 555-0012
¤ 25.00	10/5/18	R-003	10177	Ben	Marsh	(512) 555-0041
¤ 30.00	9/28/18	R-005	10190	Darcy	McDougal	(512) 555-0051
¤ 35.00	10/2/18	R-001	10207	Edith	Reid	(512) 555-0065
¤ 30.00	10/6/18	R-005	10209	Jessica	Lee	(512) 555-0098
¤ 35.00	10/2/18	R-001	10234	George	Soto	(512) 555-0064
¤ 25.00	10/5/18	R-009	10235	Sophie	Goetz	(512) 555-0063
¤ 20.00	9/28/18	R-006	10255	Emily	Allen	(512) 555-0013
¤ 25.00	10/6/18	R-010	10263	Sara	Montague	(512) 555-0013
¤ 30.00	10/7/18	R-005	10776	Carl	Gingles	(512) 555-0073
¤ 20.00	9/30/18	R-006	10998	Jeremy	Matthews	(512) 555-0072
¤ 35.00	9/28/18	R-001	11432	Jessica	Rhoades	(512) 555-0062
¤ 30.00	10/2/18	R-005	20161	Sara	Miller	(512) 555-0060
¤ 25.00	10/4/18	R-004	20207	George	Sanders	(512) 555-0021
¤ 25.00	10/4/18	R-007	20336	Lisa	Inaba	(512) 555-0089
¤ 35.00	10/13/18	R-001	21451	Victoria	D'Amato	(512) 555-0061
¤ 25.00	10/12/18	R-007	21764	Angela	Vroom	(512) 555-0076
¤ 30.00	10/1/18	R-005	22055	Kristin	Schultz	(512) 555-0067
¤ 25.00	9/27/18	R-002	22101	Jose	Castandea	(512) 555-0088

Workshop Date	Time	Workshop ID	Workshop Name	Room
10/15/18	12/30/99	R-001	Banking and Finance	J100
10/16/18	12/30/99	R-002	Computer Hardware	J100
10/15/18	12/30/99	R-003	Pharmaceuticals	E14
10/15/18	12/30/99	R-004	Environmental Technology	C240
10/15/18	12/30/99	R-005	Health Care	W322
10/15/18	12/30/99	R-006	General Administrative	J100
10/16/18	12/30/99	R-007	Travel and Tourism	C240
10/16/18	12/30/99	R-008	Insurance	E14
10/16/18	12/30/99	R-009	Hotel and Food Service	W322
10/16/18	12/30/99	R-010	Computer Software	J100

SELECT DISTINCTROW * FROM [3H Resume Workshops];

PARAMETERS __Workshop ID Value; SELECT DISTINCTROW * FROM [3H Participants] AS [3H Resume Workshop Form] WHERE ([__Workshop ID] = [Workshop ID]);

SELECT DISTINCTROW * FROM [3H Participants];

SELECT [3H Participants].[Workshop ID], [3H Participants].[Workshop Fee], [3H Participants].[Date Fee Received] FROM [3H Participants];

SELECT [3H Resume Workshops].[Workshop Name], [3H Participants].[Participant Last Name], [3H Participants].[Participant First Name], [3H Participants].[Workshop Fee], [3H Resume Workshops].[Workshop ID] FROM [3H Resume Workshops] INNER JOIN [3H Participants] ON [3H Resume Workshops].[Workshop ID]=[3H Participants].[Workshop ID];

a03_student_files/a03I_Study_Abroad.accdb

Student ID	First Name	Last Name	Trip ID	Deposit Paid	Date Paid
1284354	Katie	Eckert	T-15	¤ 3,000.00	1/4/18
1284734	Carolyn	Judkins	T-02	¤ 2,500.00	1/4/18
1298345	Jordan	Bass	T-13	¤ 2,800.00	1/4/18
1728193	Jean	Zadro	T-15	¤ 4,780.00	1/4/18
1846834	Lan	Geng	T-01	¤ 3,000.00	1/5/18
2034834	Larry	Telfer	T-04	¤ 4,000.00	1/5/18
2349535	Ashwin	Vohra	T-05	¤ 2,000.00	1/5/18
2837490	Caitlyn	Hardy	T-11	¤ 2,800.00	1/5/18
2839403	Nicole	Dutton	T-08	¤ 4,300.00	1/5/18
2840583	Barbara	Ash	T-02	¤ 5,000.00	1/5/18
2845209	Stephan	Elraheb	T-15	¤ 2,500.00	1/5/18
2845721	Megan	Sweeney	T-08	¤ 3,500.00	1/6/18
2847194	Susan	Elkington	T-06	¤ 5,000.00	1/6/18
2849201	Lisa	Sharpe	T-09	¤ 2,000.00	1/6/18
3845724	Mihir	Subramanian	T-01	¤ 2,000.00	1/6/18
3847563	Andrew	Lee	T-11	¤ 3,000.00	1/6/18
3847589	Prince	Flitcroft	T-08	¤ 1,600.00	1/6/18
3849234	Donald	Hanby	T-03	¤ 2,000.00	1/6/18
3852349	Kirsten	Riccardi	T-10	¤ 4,500.00	1/6/18
3852938	Atonye	Morris	T-04	¤ 6,000.00	1/6/18
3856930	Cong	Nguyen	T-15	¤ 3,500.00	1/7/18
3856958	Danila	Bennett	T-06	¤ 4,500.00	1/7/18
3857493	Sonia	Olson	T-01	¤ 1,250.00	1/7/18
3857684	Michael	Stanton	T-12	¤ 6,500.00	1/7/18
5849320	Reza	Soltan	T-13	¤ 3,500.00	1/7/18
5860300	Amanda	Snyder	T-15	¤ 1,000.00	1/7/18
5867384	Hashem	Avis	T-08	¤ 2,890.00	1/7/18
6738419	Kevin	Leopoldo	T-14	¤ 2,500.00	1/7/18
6739234	Janie	Martinez	T-04	¤ 5,500.00	1/7/18
6739256	Katherine	Brown	T-08	¤ 4,000.00	1/7/18
6739319	Zack	Rowe	T-12	¤ 2,000.00	1/7/18
6753841	Jill	Hutzell	T-13	¤ 4,950.00	1/7/18
7348502	Yianna	Mathis	T-14	¤ 3,000.00	1/7/18
7384952	Christopher	Danko	T-12	¤ 5,500.00	1/7/18
7481938	Jamal	Hardy	T-02	¤ 1,500.00	1/8/18
7583249	Betty	Poon	T-02	¤ 3,000.00	1/8/18
8247593	Patrice	Martinez	T-13	¤ 4,000.00	1/8/18
8273409	Naomi	Henigson	T-01	¤ 3,000.00	1/8/18
8273438	Edgardo	Pabelonia	T-03	¤ 2,750.00	1/8/18
8273485	Pei	Tram	T-12	¤ 6,000.00	1/8/18
8347568	Yolanda	Tram	T-07	¤ 5,400.00	1/8/18
8374853	Hendrick	Themis	T-10	¤ 2,500.00	1/8/18
8394284	Nora	Ramos	T-05	¤ 2,000.00	1/8/18
8473849	Yuri	Lau	T-01	¤ 1,500.00	1/8/18
8495034	Jason	Harden	T-12	¤ 7,000.00	1/8/18
8567302	Daniel	Bean	T-06	¤ 6,000.00	1/11/18
8572034	Jonathan	Ninomiya	T-09	¤ 2,900.00	1/11/18
8751243	Fredric	Kerrison	T-10	¤ 6,000.00	1/11/18
8938456	Florence	Zimmerman	T-02	¤ 1,000.00	1/11/18
9039453	Carlito	Ramos	T-07	¤ 2,700.00	1/12/18
9183467	Martin	Paffenroth	T-05	¤ 1,500.00	1/13/18
9340582	Howard	Fouladi	T-03	¤ 4,500.00	1/14/18
9348572	Pablo	Brandozzi	T-15	¤ 3,250.00	1/15/18
9375202	Jenna	Fresch	T-06	¤ 3,000.00	1/18/18
9385602	Lloyd	Murphy	T-10	¤ 5,000.00	1/18/18
9583924	Moniquin	Lett	T-02	¤ 2,500.00	1/18/18

Trip ID	Destination	Cost of Trip	Departure Date	Return Date	Contact Last Name	Contact First Name	Phone
T-01	Costa Rica	¤ 3,000.00	2/15/18	2/25/18	Perez	Juanita	(512) 555-8761
T-02	Ireland	¤ 5,000.00	5/23/18	6/2/18	MacNamara	Kathleen	(512) 555-0937
T-03	Italy	¤ 4,500.00	5/1/18	5/8/18	Marciela	Antonio	(512) 555-4672
T-04	Greece	¤ 6,000.00	5/5/18	5/15/18	Ambrose	Rachel	(512) 555-3684
T-05	Mexico	¤ 2,000.00	2/8/18	2/18/18	Cruz	Monica	(512) 555-1483
T-06	Great Britain	¤ 6,000.00	3/22/18	4/4/18	Woodward	Jean	(512) 555-5546
T-07	Switzerland	¤ 5,400.00	2/25/18	3/3/18	Lufington	Joseph	(512) 555-7124
T-08	Egypt	¤ 4,300.00	2/16/18	2/26/18	Atomili	Christopher	(512) 555-8134
T-09	Panama	¤ 2,900.00	4/30/18	5/5/18	Fresch	Deborah	(512) 555-2218
T-10	Rome	¤ 7,250.00	5/2/18	5/12/18	Comstock	Randy	(512) 555-4672
T-11	Tuscan Valley	¤ 5,600.00	2/4/18	2/14/18	Marciela	Francesca	(512) 555-8741
T-12	Paris	¤ 7,580.00	5/6/18	5/17/18	Fleur	Trisha	(512) 555-6931
T-13	Tokyo	¤ 4,950.00	3/4/18	3/12/18	Bishaki	Stephen	(512) 555-1781
T-14	Singapore	¤ 5,000.00	4/12/18	4/20/18	Michaels	Jason	(512) 555-8199
T-15	South Africa	¤ 4,780.00	3/3/18	3/10/18	Lambert	Susan	(512) 555-9111

a03_student_files/a03J_Job_Offers.accdb

Interview Date	Offer Amount	Offer ID	Student ID	Organization Name	Interviewer First Name	Interviewer Last Name
10/15/18	¤ 36,000.00	101	1011510	Texas Lakes Women's Hospital	Lydia	Cheung
10/16/18	¤ 30,000.00	102	1020710	Leander Federal Employees Credit Union	Stanley	Lynch
10/15/18	¤ 31,500.00	103	1020710	AAA Telecom	Jennifer	Lee
10/15/18	¤ 29,500.00	104	1026310	City of Buda Parks & Recreation	Vanessa	Perrigin
10/16/18	¤ 33,000.00	105	1020710	Texas Lakes Technology	Jeffrey	Davidson
10/16/18	¤ 30,000.00	106	1023510	Health Mfg Inc	Misha	Mason
10/15/18	¤ 29,500.00	107	1023410	Bank of the Southwest	Bryce	Kingston
10/16/18	¤ 34,500.00	108	1011510	Dept of Social & Health Services	William	Brewster
10/16/18	¤ 34,500.00	109	2176421	State of Texas	Kathleen	Fisher
10/15/18	¤ 33,000.00	110	1023410	American Insurance	Whitney	Washington
10/16/18	¤ 34,500.00	111	1020910	Professional Marketing Inc	Alexis	Flores
10/15/18	¤ 31,500.00	112	1020910	Communications Connections	Jason	Meyers
10/15/18	¤ 34,900.00	113	1019010	Global Resources Ltd	Benjamin	Leopold
10/16/18	¤ 33,000.00	114	2210122	Cancer Care and Hope Organization	Sophia	Hernandez
10/15/18	¤ 34,900.00	115	1015510	Texas Healthcare Partners	David	Huntington
10/16/18	¤ 30,000.00	116	1015610	Round Rock Business Solutions	Precious	Torres
10/15/18	¤ 30,000.00	117	1017710	Hinger, Todd, and Bracksford	Melinda	Diaz
10/15/18	¤ 33,000.00	118	1015610	OnCourse Technologies	Grant	Phillips
10/16/18	¤ 29,500.00	119	2210122	SOTEX National Securities	Maggie	Grayson
10/15/18	¤ 35,000.00	120	1019010	Georgetown Equipment	Lee	Woo
10/15/18	¤ 30,000.00	121	1011510	Texas Lakes Technology	Jonathan	Davidson
10/16/18	¤ 34,900.00	122	1023510	OnCourse Technologies	Grant	Phillips
10/16/18	¤ 29,500.00	123	1020910	Bank of the Southwest	Bryce	Kingston
10/16/18	¤ 30,000.00	124	1017710	OnCourse Technologies	Grant	Phillips
10/16/18	¤ 29,500.00	125	1017710	Georgetown Equipment	Lee	Woo
10/15/18	¤ 30,000.00	126	1020910	Global Resources Ltd	Benjamin	Leopold
10/16/18	¤ 31,500.00	127	2210122	OnCourse Technologies	Grant	Phillips
10/16/18	¤ 34,500.00	128	1023410	Texas Healthcare Partners	David	Huntington
10/15/18	¤ 34,900.00	129	1026310	Round Rock Business Solutions	Precious	Torres
10/15/18	¤ 29,500.00	130	1020710	Professional Marketing Inc	Alexis	Flores
10/16/18	¤ 33,000.00	131	2210122	Hinger, Todd, and Bracksford	Melinda	Diaz
10/16/18	¤ 35,000.00	132	1011510	American Insurance	Whitney	Washington
10/15/18	¤ 29,500.00	133	1023510	Communications Connections	Jason	Meyers
10/15/18	¤ 34,500.00	134	1017710	Hanson Insurance Agency	Quan	Nguyen
10/16/18	¤ 34,500.00	135	1017710	Computer Technology Services	Carlos	Martinez
10/15/18	¤ 34,900.00	136	1023410	Texas Lakes Technology	Jeffrey	Davidson
10/15/18	¤ 29,500.00	137	1011510	Austin BioTech Solutions	Alan	Mitchell
10/15/18	¤ 33,000.00	138	1023510	Jessup & Allen Consulting	Emily	Allen
10/16/18	¤ 31,500.00	139	1017710	City of Kyle Parks & Recreation	Vanessa	Perrigin
10/16/18	¤ 33,000.00	140	1017710	State of Texas	Kathleen	Fisher
10/15/18	¤ 33,000.00	141	1019010	Global Resources Ltd	Benjamin	Leopold
10/16/18	¤ 30,000.00	142	2210122	United Way of Liberty Hill	Charles	Lui
10/16/18	¤ 34,500.00	143	1020710	Riverside National Inc	Harrison	Waters
10/16/18	¤ 35,000.00	144	1019010	Cancer Care and Hope Organization	Sophia	Hernandez
10/16/18	¤ 35,000.00	145	1020710	Hanson Insurance Agency	Quan	Nguyen
10/15/18	¤ 34,900.00	146	2210122	Texas Healthcare Partners	David	Huntington
10/16/18	¤ 29,500.00	147	1015610	Cancer Care and Hope Organization	Sophia	Hernandez
10/16/18	¤ 30,000.00	148	1025510	AAA Telecom	Jennifer	Lee
10/16/18	¤ 35,000.00	149	1015710	Round Rock Business Solutions	Precious	Torres
10/15/18	¤ 31,500.00	150	1077610	Georgetown Equipment	Lee	Woo
10/16/18	¤ 35,000.00	151	2205522	Texas Healthcare Partners	David	Huntington
10/15/18	¤ 34,500.00	152	1099810	SOTEX National Securities	Maggie	Grayson
10/16/18	¤ 30,000.00	153	1143211	Bank of the Southwest	Bryce	Kingston
10/16/18	¤ 35,000.00	154	2145121	Health Mfg Inc	Misha	Mason
10/15/18	¤ 31,500.00	155	2016120	State of Texas	Kathleen	Fisher
10/15/18	¤ 34,900.00	156	2020720	Hinger, Todd, and Bracksford	Melinda	Diaz
10/15/18	¤ 33,000.00	157	2033620	Communications Connections	Jason	Meyers

Student ID	First Name	Last Name	College Major	Internship Completed	Phone Number
1011510	Tara	Shorecrest	Business	Social Services	(512) 555-0054
1015510	Charlie	Campbell	Nursing	Health Care	(512) 555-0071
1015610	Mark	Curtis	Communications	Health Care	(512) 555-0063
1015710	Carlos	Hernandez	Business		(512) 555-0012
1017710	Ben	Marsh	Graphic Arts	Social Services	(512) 555-0041
1019010	Darcy	McDougal	Business	Health Care	(512) 555-0051
1020710	Jenna	Fresch	Business	Finance	(512) 555-0065
1020910	Jessica	Lee	Communications	Government	(512) 555-0098
1023410	George	Thompson	Business	Finance	(512) 555-0064
1023510	Sophie	Goetz	Business		(512) 555-0063
1025510	Emily	Allen	Biology	Social Services	(512) 555-0013
1026310	Sara	Montague	Communications		(512) 555-0031
1077610	Carl	Chapman	History	Government	(512) 555-0073
1099810	Jordan	Bass	Communications	Health Care	(512) 555-0072
1143211	Jessica	Rhoades	Business	Finance	(512) 555-0062
2016120	Sara	Miller	History	Social Services	(512) 555-0060
2020720	George	Sanders	Business		(512) 555-0021
2033620	Lisa	Inaba	Communications		(512) 555-0089
2145121	Jean	Woodward	Business	Accounting	(512) 555-0061
2176421	Megan	Sweeney	Graphic Arts	Government	(512) 555-0076
2205522	Kristin	Schultz	Nursing		(512) 555-0067
2210122	Rosa	Suarez	Communications	Health Care	(512) 555-0088

a03_student_files/a03K_Financial_Aid.accdb

Award Amount	Award Date	Financial Aid ID	Award Name	Contact Last Name	Contact First Name	Contact Phone
¤ 2,000.00	7/30/18	FA-01	Pell Grant	Caprio	Nicholas	(512) 555-4573
¤ 500.00	8/15/18	FA-02	Work Study Grant	Hinez	Brenda	(512) 555-1284
¤ 1,500.00	6/15/18	FA-03	Academic Competiveness Grant	Slatter	Fred	(512) 555-7778
¤ 900.00	7/23/18	FA-04	NSF Engineering Award	Watts	Pamela	(512) 555-4682
¤ 1,000.00	7/15/18	FA-05	Mathematics Merit Award	Aggreko	Gayle	(512) 555-2004
¤ 2,500.00	7/22/18	FA-06	Supplemental Educational Opportunity Grant	Dickens	Elmer	(512) 555-3709
¤ 1,200.00	6/25/18	FA-07	Austin Citizenship Award	Gaddis	Shannon	(512) 555-7060
¤ 1,600.00	7/16/18	FA-08	Pflugerville Fellows Award	Patiniotis	Charles	(512) 555-6425
¤ 2,000.00	5/30/18	FA-09	Red Rock Sports Award	Swetnam	Chaolai	(512) 555-2946
¤ 2,500.00	7/6/18	FA-10	Austin Leadership Award	Tettah	Lucien	(512) 555-9991
¤ 1,250.00	8/4/18	FA-11	National Honor Society Award	McCammon	Kurt	(512) 555-9131
¤ 200.00	10/6/18	FA-12	Literary Festival Award	Nguyen	Myly	(512) 555-5996
¤ 2,500.00	8/4/18	FA-13	Texas Lakes CC Board Award	Nguyen	Thanh	(512) 555-3512
¤ 1,225.00	7/12/18	FA-14	Bank of Southwest Foundation	Ramos	Ricardo	(512) 555-3075
¤ 750.00	7/25/18	FA-15	Texas Lakes Foundation Award	Evancho	George	(512) 555-6098
¤ 2,250.00	8/2/18	FA-16	Crockett Academic Achievement Award	Culala	Aurora	(512) 555-4253
¤ 2,000.00	7/29/18	FA-17	Craig Fresch Memorial Award	Blair	Rose	(512) 555-1629
¤ 500.00	5/21/18	FA-18	Science Fair Award	Aurillo	Edward	(512) 555-7622
¤ 2,750.00	8/10/18	FA-19	President's Award	Leroux	Michael	(512) 555-1205
¤ 500.00	6/14/18	FA-20	Texas Lakes Sports Award	Quiban	Joselito	(512) 555-0871
¤ 1,500.00	8/12/18	FA-21	IT Scholarship Award	Winstead	Nellie	(512) 555-6428

Student ID	First Name	Last Name	Financial Aid ID	Home Phone	College Email
3957203	Howard	Fishman	FA-01	(512) 555-2062	[email protected]
4352863	Deborah	Fresch	FA-05	(512) 555-2013	[email protected]
4719238	Megan	Sweeney	FA-10	(512) 555-2319	[email protected]
4739502	Eliza	Alvarez	FA-15	(512) 555-2025	[email protected]
4769304	Jenna	Fresch	FA-20	(512) 555-2064	[email protected]
4852384	Jordan	Bass	FA-21	(512) 555-2323	[email protected]
5720358	Margot	Schneider	FA-02	(512) 555-2101	[email protected]
5730483	Clement	Forrester	FA-06	(512) 555-2018	[email protected]
5738495	Robert	Chun	FA-11	(512) 555-2331	[email protected]
5739437	Eugene	Sotova	FA-17	(512) 555-2030	[email protected]
5748392	Renato	Cildaro	FA-03	(512) 555-2318	[email protected]
5820384	Edward	Rose	FA-08	(512) 555-2019	[email protected]
5834924	Anastasia	Kakaulian	FA-13	(512) 555-2031	[email protected]
5835035	Laurence	Poon	FA-18	(512) 555-0304	[email protected]
5849320	Reza	Soltan	FA-04	(512) 555-9362	[email protected]
5860300	Jean	Woodward	FA-09	(512) 555-1016	[email protected]
5867384	Hashem	Avis	FA-14	(512) 555-9363	[email protected]
6738419	Kevin	Leopoldo	FA-19	(512) 555-1019	[email protected]
6739234	Janie	Martinez	FA-05	(512) 555-2027	[email protected]
6739256	Carolyn	Judkins	FA-10	(512) 555-2012	[email protected]
6739319	Zack	Rowe	FA-01	(512) 555-1020	[email protected]
6753841	Amanda	Snyder	FA-02	(512) 555-9361	[email protected]
7348502	Yianna	Mathis	FA-21	(512) 555-0303	[email protected]
7384952	Christopher	Danko	FA-18	(512) 555-1008	[email protected]
7481938	Jamal	Hardy	FA-01	(512) 555-2318	[email protected]
7583249	Betty	Poon	FA-01	(512) 555-1001	[email protected]
8247593	Patrice	Martinez	FA-01	(512) 555-2022	[email protected]
8273409	Naomi	Henigson	FA-02	(512) 555-2014	[email protected]
8273438	Edgardo	Pabelonia	FA-02	(512) 555-2322	[email protected]
8273485	Pei	Tram	FA-01	(512) 555-2027	[email protected]
8347568	Yolanda	Tram	FA-06	(512) 555-2025	[email protected]
8374853	Hendrick	Themis	FA-06	(512) 555-1010	[email protected]
8394284	Nora	Ramos	FA-21	(512) 555-2325	[email protected]
8473849	Yuri	Lau	FA-01	(512) 555-2021	[email protected]

SELECT [3K Financial Aid Students].[Student ID], [3K Financial Aid Students].[Last Name], [3K Financial Aid Students].[First Name], [3K Financial Aid Awards].[Award Amount], [3K Financial Aid Awards].[Award Name] FROM [3K Financial Aid Awards] INNER JOIN [3K Financial Aid Students] ON [3K Financial Aid Awards].[Financial Aid ID] = [3K Financial Aid Students].[Financial Aid ID] ORDER BY [3K Financial Aid Students].[Last Name], [3K Financial Aid Students].[First Name];

a03_student_files/a03L_Food_Services.accdb

Food Duty ID	Station	Staff ID	Time Slot	Booth Location	Day
FD-01	STATION-A	STAFF-1101	8-12	North Wing	Day 1
FD-02	STATION-A	STAFF-1102	12-4	North Wing	Day 1
FD-03	STATION-A	STAFF-1103	Lunch 12-1	North Wing	Day 1
FD-04	STATION-A	STAFF-1102	8-12	North Wing	Day 2
FD-05	STATION-A	STAFF-1101	12-4	North Wing	Day 2
FD-06	STATION-A	STAFF-1104	Lunch 12-1	North Wing	Day 2
FD-07	STATION-B	STAFF-1103	8-12	North Wing	Day 1
FD-08	STATION-B	STAFF-1104	12-4	North Wing	Day 1
FD-09	STATION-B	STAFF-1105	Lunch 12-1	North Wing	Day 1
FD-10	STATION-B	STAFF-1105	8-12	North Wing	Day 2
FD-11	STATION-B	STAFF-1106	12-4	North Wing	Day 2
FD-12	STATION-B	STAFF-1107	Lunch 12-1	North Wing	Day 2
FD-13	STATION-C	STAFF-1105	8-12	East Wing	Day 1
FD-14	STATION-C	STAFF-1106	12-4	East Wing	Day 1
FD-15	STATION-C	STAFF-1107	Lunch 12-1	East Wing	Day 1
FD-16	STATION-C	STAFF-1108	8-12	East Wing	Day 2
FD-17	STATION-C	STAFF-1109	12-4	East Wing	Day 2
FD-18	STATION-C	STAFF-1110	Lunch 12-1	East Wing	Day 2
FD-19	STATION-D	STAFF-1107	8-12	East Wing	Day 1
FD-20	STATION-D	STAFF-1108	12-4	East Wing	Day 1
FD-21	STATION-D	STAFF-1109	Lunch 12-1	East Wing	Day 1
FD-22	STATION-D	STAFF-1111	8-12	East Wing	Day 2
FD-23	STATION-D	STAFF-1112	12-4	East Wing	Day 2
FD-24	STATION-D	STAFF-1111	Lunch 12-1	East Wing	Day 2
FD-25	STATION-E	STAFF-1110	8-12	South Hall	Day 1
FD-26	STATION-E	STAFF-1111	12-4	South Hall	Day 1
FD-27	STATION-E	STAFF-1112	Lunch 12-1	South Hall	Day 1
FD-28	STATION-E	STAFF-1103	8-12	South Hall	Day 2
FD-29	STATION-E	STAFF-1113	12-4	South Hall	Day 2
FD-30	STATION-E	STAFF-1102	Lunch 12-1	South Hall	Day 2
FD-31	STATION-F	STAFF-1112	8-12	South Hall	Day 1
FD-32	STATION-F	STAFF-1113	12-4	South Hall	Day 1
FD-33	STATION-F	STAFF-1101	Lunch 12-1	South Hall	Day 1
FD-34	STATION-F	STAFF-1110	8-12	South Hall	Day 2
FD-35	STATION-F	STAFF-1114	12-4	South Hall	Day 2
FD-36	STATION-F	STAFF-1108	Lunch 12-1	South Hall	Day 2
FD-37	STATION-G	STAFF-1104	8-12	West Hall	Day 1
FD-38	STATION-G	STAFF-1115	12-4	West Hall	Day 1
FD-39	STATION-G	STAFF-1116	Lunch 12-1	West Hall	Day 1
FD-40	STATION-G	STAFF-1112	8-12	West Hall	Day 2
FD-41	STATION-G	STAFF-1117	12-4	West Hall	Day 2
FD-42	STATION-G	STAFF-1116	Lunch 12-1	West Hall	Day 2
FD-43	STATION-H	STAFF-1109	8-12	West Hall	Day 1
FD-44	STATION-H	STAFF-1114	12-4	West Hall	Day 1
FD-45	STATION-H	STAFF-1114	Lunch 12-1	West Hall	Day 1
FD-46	STATION-H	STAFF-1115	8-12	West Hall	Day 2
FD-47	STATION-H	STAFF-1118	12-4	West Hall	Day 2
FD-48	STATION-H	STAFF-1115	Lunch 12-1	West Hall	Day 2

Staff ID	Staff First Name	Staff Last Name	Phone Number	Title
STAFF-1101	Marissa	Poirier	(512) 555-0054	Server
STAFF-1102	Bill	Hutchinson	(512) 555-0071	Lead
STAFF-1103	Janet	Curtis	(512) 555-0063	Supervisor
STAFF-1104	Julio	Sanchez	(512) 555-0012	Server
STAFF-1105	Bob	Marguliues	(512) 555-0041	Supervisor
STAFF-1106	Lucy	Inaba	(512) 555-0051	Lead
STAFF-1107	Edna	Reese	(512) 555-0065	Server
STAFF-1108	Jesse	Lee	(512) 555-0098	Server
STAFF-1109	Gordon	Santana	(512) 555-0064	Lead
STAFF-1110	Leon	Peters	(512) 555-0063	Supervisor
STAFF-1111	Allen	Sullivan	(512) 555-0343	Lead
STAFF-1112	Stacey	Steinberg	(512) 555-0229	Supervisor
STAFF-1113	Josh	Parsons	(512) 555-0987	Server
STAFF-1114	Lucinda	Chen	(512) 555-0668	Lead
STAFF-1115	Barbara	Chapman	(512) 555-0443	Supervisor
STAFF-1116	Ron	Martinez	(512) 555-0221	Supervisor
STAFF-1117	Jean	Bartow	(512) 555-0657	Lead
STAFF-1118	Andy	Anderson	(512) 555-0233	Server

a03_student_files/a03M_Donor_Gifts.accdb

Donor ID	Donor	Phone Number	Contact Last Name	Contact First Name
DNR-1201	Fresch Foundation	(512) 555-0054	Lynne	Deborah
DNR-1202	AAA Marketing Inc	(512) 555-0071	Sinclair	Courtney
DNR-1203	Austin Chamber of Commerce	(512) 555-0063	Curtis	Marque
DNR-1204	Texas Partners	(512) 555-0012	Hernandez	Jesse
DNR-1205	Texas Hills Magazine	(512) 555-0041	Marshall	Connie
DNR-1206	KTLC Austin Radio	(512) 555-0051	McLennan	Douglas
DNR-1207	Austin City Foundation	(512) 555-0065	Stevenson	Reese
DNR-1208	Southwest Times Journal	(512) 555-0098	Jackson	Marshall
DNR-1209	Spicewood Business Alliance	(512) 555-0064	Soho	Julia
DNR-1210	Joseph Ingram Foundation	(512) 555-0063	Elkington	Kevin
DNR-1211	KATX Television	(512) 555-0765	Barnes	Elizabeth

Retail Value	Gift Item ID	Item Description	Donor ID	Category
¤ 25.00	GIFT-01	T-Shirts	DNR-1201	Clothing
¤ 20.00	GIFT-03	Tickets	DNR-1202	Movie Theater
¤ 30.00	GIFT-04	Tote Bag	DNR-1210	Misc
¤ 15.00	GIFT-05	Water Bottle	DNR-1203	Misc
¤ 35.00	GIFT-06	Restaurant Voucher	DNR-1204	Food
¤ 50.00	GIFT-07	Restaurant Voucher	DNR-1204	Food
¤ 200.00	GIFT-08	Computer Software	DNR-1205	Software
¤ 40.00	GIFT-09	Restaurant Voucher	DNR-1204	Food
¤ 75.00	GIFT-10	Computer Software	DNR-1210	Software
¤ 45.00	GIFT-11	Tickets	DNR-1202	Theater
¤ 80.00	GIFT-12	Computer Software	DNR-1204	Software
¤ 60.00	GIFT-13	Restaurant Voucher	DNR-1204	Food
¤ 12.00	GIFT-14	Water Bottle	DNR-1203	Misc
¤ 50.00	GIFT-15	Tickets	DNR-1210	Theater
¤ 40.00	GIFT-16	Tickets	DNR-1202	Theater
¤ 15.00	GIFT-17	Water Bottle	DNR-1203	Misc
¤ 50.00	GIFT-18	Gift Card	DNR-1210	Misc
¤ 100.00	GIFT-19	Gift Card	DNR-1204	Misc
¤ 10.00	GIFT-20	Water Bottle	DNR-1203	Misc
¤ 25.00	GIFT-21	Book Voucher	DNR-1209	Books
¤ 25.00	GIFT-22	CD	DNR-1208	Music
¤ 35.00	GIFT-23	Restaurant Voucher	DNR-1204	Food
¤ 14.00	GIFT-24	Water Bottle	DNR-1203	Misc
¤ 25.00	GIFT-25	CD	DNR-1208	Music
¤ 30.00	GIFT-26	CD	DNR-1208	Music
¤ 50.00	GIFT-27	T-Shirts	DNR-1201	Clothing
¤ 35.00	GIFT-28	CD	DNR-1208	Music
¤ 100.00	GIFT-29	Computer Software	DNR-1205	Software
¤ 75.00	GIFT-30	Restaurant Voucher	DNR-1204	Food
¤ 120.00	GIFT-31	Computer Software	DNR-1205	Software
¤ 50.00	GIFT-32	Computer Printer	DNR-1207	Hardware
¤ 150.00	GIFT-33	Theater Tickets	DNR-1211	Theater
¤ 600.00	GIFT-34	Laptop Computer	DNR-1206	Hardware

SELECT [3M Donors].Donor, [3M Gift Items].[Item Description], [3M Gift Items].Category, [3M Gift Items].[Retail Value] FROM [3M Donors] INNER JOIN [3M Gift Items] ON [3M Donors].[Donor ID] = [3M Gift Items].[Donor ID] ORDER BY [3M Donors].Donor, [3M Gift Items].[Item Description];