Microsoft practice , word , excel access and power point .

access_data_files.zip

Home >Computer Science homework help >Microsoft practice , word , excel access and power point .

Access Unit D/Basketball-D.accdb

GameNo	Opponent	Mascot	HomeAway	HomeScore	OpponentScore	GameDate	WebSite
1	Iowa	Hawkeyes	A	45	43	2012-11-12
2	Creighton	Bluejays	H	50	45	2012-11-15	www.creighton.edu#..\A1\UnitJ-A1-2.doc# 1,46986,47004,4094,IC Practice Text,www.creighton.edu
3	Northern Illinois	Huskies	H	65	64	2012-11-22
4	Louisiana Tech	Red Raiders	A	69	68	2012-11-29
5	Drake	Bulldogs	H	80	78	2012-12-10	www.drake.edu#http://www.drake.edu#
6	Northern Iowa	Panthers	A	38	50	2012-12-18
7	Buffalo	Bulls	H	50	60	2012-12-28
8	Oklahoma	Sooners	A	53	50	2012-12-31
9	Texas	Longhorns	H	57	56	2013-01-03
10	Kansas	Jayhawks	H	74	70	2013-01-07
11	Colorado	Buffaloes	A	90	84	2013-01-11
12	Texas A&M	Aggies	H	77	60	2013-01-14
13	Clemson	Lady Tigers	A	72	81	2013-01-22
14	Nebraska	Cornhuskers	H	79	58	2013-01-26
15	Missouri	Tigers	A	80	54	2013-01-28
16	Oklahoma State	Cowgirls	A	76	42	2013-02-01
17	Kansas State	Wildcats	A	63	70	2013-02-08
18	Baylor	Lady Bears	A	68	70	2013-02-14
19	Oregon	Ducks	H	85	70	2013-02-18
20	Georgia	Bulldogs	H	91	89	2013-02-21
21	Connecticut	Huskies	H	64	58	2013-02-23
22	Southwest Texas	Bobcats	A	97	48	2013-02-25
23	Kansas State	Wildcats	H	100	52	2012-02-29	www.ksu.edu

PFirst	PLast	Height	PlayerNo	GradYear	Position	HomeTown	HomeState	Lettered
Sydney	Freesen	68	4	2014	G	Panora	IA	false
Kelsey	Douglas	69	5	2015	G	Linden	IA	true
Ellyse	Howard	70	12	2016	G	Osseo	MN	true
Amy	Hodel	72	21	2014	F	Oakbrook	IL	true
Theresa	Grant	73	22	2013	F	McKinney	TX	false
Sandy	Robins	65	23	2013	G	Anita	IA	false
Ashley	Sydnes	75	30	2013	F	Salina	KS	false
Abbey	Walker	76	32	2014	C	Fargo	ND	false
Kristen	Czyenski	73	35	2015	F	Omaha	NE	false
Denise	Franco	72	42	2016	F	Antigua	WI	true
Megan	Hile	74	45	2015	F	Cumberland	IA	true
Morgan	Tyler	71	51	2014	G	Roseau	MN	false
Jamie	Johnson	75	52	2016	F	Belleville	IL	false

PlayerNo	GameNo	FieldGoals	FieldGoalAttempts	3Pointers	3PointAttempts	FreeThrows	FreeThrowAttempts	ReboundOffense	ReboundDefense	Assists
5	1	3	4	2	2	1	1	1	2	2
5	2	4	6	1	3	3	3	2	2	4
5	3	5	6	2	3	2	4	2	1	2
5	4	5	7	3	3	3	3	3	1	1
5	5	6	8	3	3	5	6	1	1	1
5	6	4	8	1	1	1	3	1	3	2
5	7	4	7	2	2	2	2	2	2	2
5	8	3	4	2	2	1	1	2	1	3
5	9	4	5	2	6	3	4	1	4	3
5	10	4	6	2	4	3	3	2	5	3
12	1	2	3	1	1	1	1	1	2	1
12	2	3	2	0	0	3	4	3	3	1
12	3	5	6	0	0	2	4	4	3	1
12	4	5	7	0	0	3	3	2	3	1
12	5	6	8	0	0	4	6	2	3	0
12	6	4	8	0	0	2	3	2	5	2
12	7	4	7	0	0	3	3	4	6	2
12	8	3	4	0	0	1	1	5	7	3
12	9	4	5	0	1	4	6	5	4	4
12	10	4	6	1	2	3	3	5	5	1
21	1	1	3	1	1	1	1	5	3	1
21	2	1	2	0	0	1	4	1	4	1
21	3	1	1	0	0	4	4	1	4	1
21	4	1	1	0	0	5	5	3	2	1
21	5	1	2	0	0	6	6	5	2	0
21	6	0	1	0	0	2	3	4	2	1
21	7	0	0	0	0	2	3	2	2	0
21	8	0	1	0	0	1	1	2	1	0
21	9	2	2	0	1	5	6	2	5	0
21	10	2	3	1	1	5	3	1	3	1
42	1	2	5	1	2	4	4	2	3	1
42	2	2	4	1	2	5	5	5	3	2
42	3	5	3	2	4	4	5	5	3	1
42	4	2	2	2	5	5	6	2	2	1
42	5	1	1	2	3	6	8	2	3	3
42	6	0	6	1	2	2	4	2	4	1
42	7	2	2	0	2	5	5	5	2	0
42	8	4	5	1	3	3	4	5	1	3
42	9	1	2	2	2	1	3	1	4	0
42	10	5	5	1	1	1	3	5	2	1
45	1	1	4	0	2	1	1	1	2	1
45	2	2	3	0	3	1	1	1	5	1
45	3	1	3	0	0	1	1	2	2	1
45	4	2	3	0	0	1	1	1	4	1
45	5	2	2	0	0	1	3	1	2	1
45	6	3	3	0	0	1	3	1	2	1
45	7	1	2	0	0	1	1	3	4	1
45	8	1	4	2	2	1	1	2	4	1
45	9	1	3	0	0	1	2	1	3	2
45	10	3	3	0	0	1	1	1	5	2
51	1	1	5	0	0	2	4	4	6	1
51	2	2	4	0	0	3	5	3	6	1
51	3	1	3	0	0	4	5	3	4	1
51	4	1	4	0	0	5	6	3	3	1
51	5	3	4	0	0	5	5	2	4	1
51	6	0	2	0	0	2	4	1	2	3
51	7	2	3	0	0	5	5	1	2	2
51	8	3	3	0	0	3	4	1	3	1
51	9	1	5	0	0	5	5	3	3	2
51	10	3	3	0	1	4	5	4	4	1

Access Unit D/Conventions-D.accdb

AttendeeNo	AttendeeLast	AttendeeFirst	AttendeePhone	CompanyID	ConventionID
1	Abbar	Anas	555-666-7701	1	18
2	Apple	Megan	555-666-7702	1	18
3	Ackerman	Pilar	555-999-1006	3	5
4	Adell	Jeff	555-999-1002	3	5
5	Akers	Sonal	555-555-8809	2	25
6	McNeil	Timothy	555-555-8802	2	25
7	Abraham	Todd	555-555-8803	2	25
8	Alexander	Sean	555-666-7703	1	18
9	Anderson	Gordon	555-666-7704	1	18
10	Orth	Charlie	555-555-8804	2	25
11	Atkinson	Gabriel	555-555-8805	2	25
12	Nicolas	Cassie	555-555-8806	2	25
13	Brandon	Dorothy	555-555-8807	2	25
14	Barbariol	Angela	555-555-8808	2	25
15	Barnhill	Josh	555-999-1003	3	5
16	Barr	Eve	555-999-1004	3	5
17	Barrett	Holly	555-999-1005	3	5
18	Beck	Bradley	555-111-2005	4	2
19	Ben-Sachar	Ido	555-111-2002	4	2
20	Mathews	Lucas	555-111-2003	4	2
21	Smith	Karen	555-111-2004	4	2
22	Berglund	Andreas	555-111-3001	5	13
24	Allen	Arnold	555-666-7705	1	18
25	Abercrombie	Kim	555-555-8810	2	25
26	Appleton	Patsy	555-999-1007	3	25
27	Adams	Jeremiah	555-111-2005	4	2
28	Alversado	Grace	555-111-3002	5	13
29	Akhtar	Sarah	555-111-4001	6	7
30	Alboucq	Steve	555-444-9001	7	10
33	Anderson	Toby	555-444-5001	10	1
34	Stanton	Teresa	555-666-7706	1	18
35	Bacon	Callie	555-555-8811	2	25
36	Baldwin	Amie	555-999-1008	3	25
37	Hooper	Scott	555-111-2006	4	2
38	Meyer	Jedidiah	555-111-3003	5	13
39	Brantley	Tiffany	555-111-4002	6	7
40	Christoff	Holly	555-444-9002	7	10
43	Benson	Max	555-444-5002	10	1
44	Berge	Mary	555-666-7707	1	18
45	Scalzi	Sylvia	555-555-8812	2	25
46	Bergman	Ken	555-999-1009	3	25
47	Berry	Jordan	555-111-2007	4	2
48	Bockman	Anne	555-111-3004	5	13
49	Bonifaz	Luis	555-111-4003	6	7
50	Borm	Paul	555-444-9003	7	10
53	Bourne	Stephanie	555-444-5003	10	1
60	Brown	Jo	555-444-9004	7	10
64	Campbell	David	555-444-9005	7	10
65	Siren	Michael	555-444-9006	7	10
66	Carpenter	Lani Ota	555-444-9007	7	10
67	Carey	Richard	555-444-9008	7	10
68	Carlson	Ty	555-444-9009	7	10
69	Caron	Rob	555-444-9010	7	25
70	Castaneda	Marea Angela	555-444-9011	7	25
71	Chai	Sherilyn	555-111-4004	6	7
72	Chapman	Greg	555-111-4005	6	7
73	Charney	Neil	555-111-4006	6	7
74	Chen	John	555-111-4007	6	7
75	Chor	Naresh	555-111-4008	6	7
76	Clayton	Jane	555-111-4009	6	7
77	Coake	Angela	555-666-7708	1	18
78	Coleman	Pat	555-555-8813	2	25
79	Con	Aaron	555-999-1010	3	25
80	Connelly	Peter	555-111-2008	4	2
81	Conroy	Stephanie	555-111-3005	5	13
82	Cooper	Scott	555-111-4010	6	7
83	Corets	Eva	555-444-9012	7	10
86	Culbert	Becki	555-444-5004	10	1
87	Culp	Gayle	555-666-7709	1	18
88	Dalal	Ketan	555-555-8814	2	25
89	Dale	Martha	555-999-1011	3	25
90	Danseglio	Mike	555-111-2009	4	2
91	Daum	Kevin	555-111-3006	5	13
92	DeBroux	Steve	555-111-4011	6	7
93	Delaney	Aidan	555-444-9013	7	10
96	Dixon	Andrew	555-444-5005	10	1
97	Dolliver	Kaarin	555-666-7710	1	18
98	Dowler	Anthony	555-555-8815	2	25
99	Doyle	Patricia	555-999-1012	3	25
100	Dresen	Kate	555-111-2010	4	2
101	Dunn	Matthew	555-111-3007	5	11
102	Dunn	Micheal	555-111-4012	6	7
103	Durasoff	Dana	555-444-9014	7	10
106	Emanuel	Michael	555-444-5006	10	1
113	Flood	Kathie	555-444-9015	7	10
117	Fortune	Rhonda	555-444-9016	7	10
118	Fredericksen	Matthew	555-444-9017	7	10
119	Frey	Nancy	555-444-9018	7	10
120	Fuller	Joanna	555-444-9019	7	25
121	Funk	Don	555-444-9020	7	25
122	Galos	Nathan	555-444-9021	7	10
123	Gambardella	Matthew	555-444-9022	7	10
124	Ganio	Alexander	555-111-4013	6	7
125	Garmaise	Lisa	555-111-4014	6	7
126	Gavriluk	Erik	555-111-4015	6	7
127	Gerend	Jason	555-111-4016	6	7
128	Getzinger	Tom	555-111-4017	6	7
129	Gillmann	Kent	555-111-4018	6	7
130	Glynn	James	555-666-7711	1	18
131	Gode	Jack	555-555-8816	2	25
132	Good	Raymond	555-999-1013	3	25
133	Goldberg	Jossef	555-111-2011	4	2
134	Goodhand	Shiva	555-111-3008	5	11
135	Graff	Michael	555-111-4019	6	7
136	Graham	Derek	555-444-9023	7	10
139	Greenberg	Shannon	555-444-5007	10	1
140	Groncki	Douglas	555-666-7712	1	18
141	Guo	Bei-Jing	555-555-8817	2	25
142	Hall	Donald	555-999-1014	3	10
143	Hamilton	Darin	555-111-2012	4	2
144	Hampton	Doug	555-111-3009	5	13
145	Hance	Jim	555-111-4020	6	7
146	Hanson	Mark	555-444-9024	7	10
149	Hartwig	Doris	555-444-5008	10	21
150	Harui	Roger	555-666-7713	1	19
151	Hassall	Marcus	555-555-8818	2	25
152	Hector	Clair	555-999-1015	3	5
153	Henningsen	Jay	555-111-2013	4	2
154	Henshaw	Brandy	555-111-3010	5	13
155	Hensien	Kari	555-111-4021	6	7
156	Hepp	Achim	555-444-9025	7	10
159	Hinsch	Kathryn	555-444-5009	10	1
166	Holm	Tomoko	555-444-9026	7	25
170	Houston	Peter	555-444-9027	7	10
171	Howard	Joe	555-444-9028	7	10
172	Huff	Arlene	555-444-9029	7	10
173	Inman	Katherine	555-444-9030	7	10
174	Iwema	Mariehe	555-444-9031	7	10
175	Jackson	Sue	555-444-9032	7	10
176	Jacobson	Lisa	555-444-9033	7	10
177	Jaffe	Martha	555-111-4022	6	7
178	Jamison	Jay	555-111-4023	6	7
179	Jennings	Laura	555-111-4024	6	7
180	Jensen	Stephen	555-111-4025	6	7
181	Johnson	Silpa	555-111-4026	6	7
182	Johnston	Tom	555-111-4027	6	7
183	Jones	Amy	555-666-7714	1	19
184	Jones	Beverly	555-555-8819	2	5
185	Jordan	Katie	555-999-1016	3	10
186	Kaethler	Judy	555-111-2014	4	2
187	Kahn	Wilma	555-111-3011	5	13
188	Kaplan	Richard	555-111-4028	6	7
189	Kearney	Bonnie	555-444-9034	7	25
192	Kelly	Kenneth	555-444-5010	10	1
193	Kelly	Medna	555-666-7716	1	19
194	Kelly	Robert	555-555-8820	2	5
195	Kennedy	Charles	555-999-1017	3	5
196	Khanna	Karan	555-111-2015	4	2
197	Kilwine	Monica	555-111-3012	5	11
198	Kim	Samantha	555-111-4029	6	7
199	Noeth	Shane	555-444-9035	7	10
202	Kobara	Linda	555-444-5011	10	21
203	Kobylka	Mary Anne	555-666-7715	1	19
204	Koch	Reed	555-555-8821	2	5
205	Koduri	Sunil	555-999-1018	3	10
206	Krakowski	Alix	555-111-2016	4	22
207	Kress	Grace	555-111-3013	5	11
208	Kunze	Cornelia	555-111-4030	6	7
209	LaBrie	Ryan	555-444-9036	7	25
212	Lawler	Frank	555-444-5012	10	1
219	Lew	Carly	555-444-9037	7	10
223	Lum	Richard	555-444-9038	7	10
224	Lyon	Bella	555-444-9039	7	10
225	Lysaker	Rodney	555-444-9040	7	10
226	Maffei	Addison	555-444-9041	7	25
227	Mangione	Darlene	555-444-9042	7	10
228	Martin	Clay	555-444-9043	7	10
229	Martin	Mindy	555-444-9044	7	10
230	Martinez	Sandra	555-111-4031	6	7
231	Marton	Nina	555-111-4032	6	7
232	Masters	Steve	555-111-4033	6	7
233	Matey	Pierre	555-111-4034	6	7
234	Matthews	Joseph	555-111-4035	6	7
235	White	Katie	555-111-4036	6	7
236	McCann	Thom	555-666-7717	1	19
237	McCormick	Nikki	555-555-8822	2	5
238	McGinn	Fidelma	555-999-1019	3	5
239	Mendlen	Krista	555-111-2017	4	22
240	Meng	Jessup	555-111-3014	5	13
241	Meyer	Deanna	555-111-4037	6	7
242	Miksovsky	Jan	555-444-9045	7	10
245	Miller	Geof	555-444-5013	10	1
246	Mintz	Patti	555-666-7718	1	19
247	Mitchell	Heather	555-555-8823	2	5
248	Mitchell	Linda	555-999-1020	3	5
249	Mollerup	John	555-111-2018	4	22
250	Morgan	Louise	555-111-3015	5	13
251	Moris	Marylou	555-111-4038	6	7
252	Morris	Jon	555-444-9046	7	10
255	Munson	Stuart	555-444-5014	10	21
256	Muth	Edmund	555-666-7719	1	19
257	Nagata	Suanne	555-555-8824	2	10
258	Nash	Travis	555-999-1021	3	5
259	Nay	Lorraine	555-111-2019	4	22
260	Nelson	Stephen	555-111-3016	5	13
261	Niikkonen	Donna	555-111-4039	6	7
262	Nikore	Simi	555-444-9047	7	10
265	O’Brien	Tim	555-444-5015	10	1
272	Ota	Lani	555-444-9048	7	25
276	Parsons	Beth	555-444-9049	7	10
277	Patten	Sonya	555-444-9050	7	25
278	Penn	Daniel	555-444-9051	7	10
279	Perera	Jonathan	555-444-9052	7	10
280	Perry	Magaly	555-444-9053	7	10
281	Philips	Carol	555-444-9054	7	10
282	Phua	Meng	555-444-9055	7	10
283	Piira	Aaron	555-111-4040	6	7
284	Poland	Carole	555-111-4041	6	7
285	Porzuczek	Faith	555-111-4042	6	7
286	Preston	Chris	555-111-4043	6	7
287	Price	Criss	555-111-4044	6	7
288	Purcell	Sean	555-111-4045	6	7
289	Raddatz	Rick	555-666-7720	1	19
290	Ralls	Kim	555-555-8825	2	10
291	Ramirez	Francisco	555-999-1022	3	10
292	Randall	Cynthia	555-111-2020	4	22
293	Randall	Joshua	555-111-3017	5	13
294	Slattery	Tristan	555-111-4046	6	7
295	Reid	Marjorie	555-444-9056	7	10
298	Richardson	Miles	555-444-5016	10	1
299	Rodman	Cari	555-444-5017	10	1
300	Romanowsky	Claus	555-666-7721	1	19
301	Rothenberg	Eric	555-555-8826	2	10
302	Rounthwaite	Toni	555-555-8827	2	10
303	Rudd	Darlene	555-999-1023	3	25
304	Sacksteder	Lane	555-111-2021	4	2
305	Sam	Raymond	555-111-4047	6	7
306	Samarawickrama	Prasanna	555-666-7722	1	19
307	Sandberg	Mikael	555-555-8828	2	10
308	Sax	Jenny	555-999-1024	3	25
309	Scannell	Krista	555-111-2022	4	2
310	Hoehn	Christina	555-111-3018	5	11
311	Schare	Gary	555-111-4048	6	7
312	Schatz	Bethany	555-444-9057	7	10
315	Schuldt	Susanne	555-444-5018	10	1
316	Schulte	Scot	555-444-5019	10	21
317	Schumann	Ingo	555-666-7723	1	19
318	Seamans	Ashley	555-555-8829	2	10
319	Seeley	Carolyn	555-555-8830	2	5
320	Seidenspinner	Hope	555-999-1025	3	25
321	Seidl	Birgit	555-111-2023	4	22
322	Shapiro	Molly	555-111-4049	6	7
323	Shaughnnessy	Chuck	555-666-7724	1	19
324	Shelly	Daniel	555-555-8831	2	5
325	Sherman	Megan	555-999-1026	3	25
326	Silverberg	Beth	555-111-2024	4	2
327	Simon	Britta	555-111-3019	5	11
328	Simpson	David	555-111-4050	6	7
329	Slichter	Monte	555-444-9058	7	10
332	Smith	Mitzi	555-444-5020	10	1
333	Hameed	Pamela	555-444-5021	10	1
334	Curtis	Neil	555-666-7725	1	19
335	Hensley	Samantha	555-555-8832	2	5
336	Sornsin	William	555-555-8833	2	5
337	Spencer	Phil	555-999-1027	3	25
338	Stein	Adam	555-111-2025	4	2
339	Steiner	Alan	555-111-4051	6	7
340	Stenerson	Derik	555-666-7727	1	19
341	Stewart	Stefanie	555-555-8834	2	5
342	Sun	Nate	555-999-1028	3	25
343	Sutton	Brad	555-111-2026	4	2
344	Szymanski	Shelly	555-111-3020	5	11
345	Theodore	Stuart	555-111-4052	6	7
346	Thomas	Stephen	555-444-9059	7	10
349	Tiano	Mike	555-444-5022	10	1
350	Tibbott	Diane	555-444-5023	10	21
351	Tiedt	Danielle	555-666-7726	1	19
352	Tippett	Savi	555-555-8835	2	25
353	Tjarnberg	Susan	555-555-8836	2	25
354	Tobey	Kasey	555-999-1029	3	10
355	Tratt	Adam	555-111-2027	4	2
356	Turner	Catherine	555-111-4053	6	7
357	Valentine	Brian	555-666-7728	1	18
358	Van Dam	Tanya	555-555-8837	2	25
359	Vargas	Garrett	555-999-1030	3	5
360	Vasse	Wendy	555-111-2028	4	22
361	Verboort	Kevin	555-111-3021	5	13
362	Vernhes	Laurent	555-111-4054	6	7
363	Vong	William	555-444-9060	7	10
366	Waite	Connie	555-444-5024	10	1
367	Walton	Bryan	555-444-5025	10	1
368	Washburn	Dale	555-666-7729	1	19
369	Waxman	Joy	555-555-8838	2	5
370	Weems	Chan	555-555-8839	2	10
371	West	Paul	555-999-1031	3	5
372	Wheeler	Beth	555-111-2029	4	22
373	White	Bagheera	555-111-4055	6	7
374	Hetro	Elizabeth	555-666-7730	1	19
375	Puppala	Suki	555-555-8840	2	10
376	Williams	Thoma	555-999-1032	3	10
377	Wilson	Vincent	555-111-2030	4	2
378	Watters	Kathryn	555-111-3022	5	11
379	Wolfe-Hellene	Marta	555-111-4056	6	7
380	Wood	Dominique	555-444-9061	7	10
383	Young	Jonathan	555-444-5026	10	21
384	Zhang	Rob	555-444-5027	10	1
385	Yukish	Gary	555-666-7731	1	19
386	Zambroski	Ray	555-555-8841	2	10
387	Zimprich	Karin	555-555-8842	2	5
388	Zuvela	Leonard	555-999-1033	3	10

CompanyID	CompanyName
1	Gayle B Industries
2	Adventure Team
3	Rocky Ski House
4	Adair Museum of Science
5	High Seas Sailing
6	Kansas City Power & Light
7	Cohorts of America
10	Core Tech
12	Consolidated Industries
13	Farmers League
14	Drip Drip Coffee
15	Graphic Design Institute
16	Midwest Insurance
17	Vector Marketing
18	Two Pages Publishing
19	Quest Travel
20	Northwind Traders
21	Cutco Knives

ConventionNo	ConventionName	ConventionType	CountryName	MaxAttendees	DateofConvention
1	Grocers of America	Business	USA	1500	2015-01-04
2	Teens and the Internet	Educational	Canada	650	2015-01-02
3	Council of School Psychologists	Educational	Mexico	1800	2015-01-03
4	International Scuba Society	Personal	Australia	1020	2015-02-01
5	European Bikers Association	Personal	United Kingdom	1000	2015-02-02
6	The Future of Microchip Technology	Business	Japan	1000	2015-02-03
7	FCC Regulations Commission	Business	USA	1100	2015-03-01
8	Fly Fishermen International	Personal	USA	1120	2015-03-02
9	No Child Left Behind Institute	Educational	USA	1200	2015-03-03
10	Travel for Cheap Industries	Personal	USA	800	2015-04-01
11	Expanding Trade with Mexico Conference	Business	Mexico	800	2015-04-02
12	Expanding Tourism in the Caribbean Conference	Business	Puerto Rico	2000	2015-04-03
13	Safeguarding International Skies Conference	Business	Canada	1000	2015-05-01
14	Japanese Culture Institute	Personal	Japan	2500	2015-05-02
15	League for the Preservation of Wetlands	Educational	Australia	1000	2015-05-03
16	Distance Learning Institute	Educational	Australia	850	2015-06-01
17	Stamp Collectors International	Personal	USA	3000	2015-06-02
18	C++ Software Developers Institute	Business	USA	1000	2015-06-03
19	HTML Standards Institute	Business	USA	1100	2015-07-01
20	Ironworkers League	Business	USA	1210	2015-07-02
21	Healthcare of the Future Institute	Business	USA	20000	2015-08-01
22	Reluctant Learner Conference	Educational	United Kingdom	500	2015-08-02
23	University Model Schooling Conference	Educational	Mexico	750	2015-08-03
24	Stonecutters Institute	Business	Japan	1200	2015-09-01
25	Lewis and Clark Preservation Society	Personal	USA	800	2015-09-02
26	Twins International	Personal	USA	4000	2015-09-03

EnrollmentID	AttendeeNo	ConventionID	DateEnrolled
1	1	18	2015-04-04
2	2	18	2015-04-04
3	3	5	2014-12-04
4	4	5	2014-12-04
5	5	25	2015-07-04
6	6	25	2015-07-04
7	7	25	2015-07-04
8	8	18	2015-04-04
9	9	18	2015-04-04
10	10	25	2015-07-04
11	11	25	2015-07-04
12	12	25	2015-07-04
13	13	25	2015-07-04
14	14	25	2015-07-04
15	15	5	2014-12-04
16	16	5	2014-12-04
17	17	5	2014-12-04
18	18	2	2014-11-03
19	19	2	2014-11-03
20	20	2	2014-11-03
21	21	2	2014-11-03
22	22	13	2015-03-02
23	24	18	2015-04-04
24	25	25	2015-07-04
25	26	25	2015-07-04
26	27	2	2014-11-03
27	28	13	2015-03-02
28	29	7	2014-12-31
29	30	10	2015-01-31
30	33	1	2014-11-05
31	34	18	2015-04-04
32	35	25	2015-07-04
33	36	25	2015-07-04
34	37	2	2014-11-03
35	38	13	2015-03-02
36	39	7	2014-12-31
37	40	10	2015-01-31
38	43	1	2014-11-05
39	44	18	2015-04-04
40	45	25	2015-07-04
41	46	25	2015-07-04
42	47	2	2014-11-03
43	48	13	2015-03-02
44	49	7	2014-12-31
45	50	10	2015-01-31
46	53	1	2014-11-05
47	60	10	2015-01-31
48	64	10	2015-01-31
49	65	10	2015-01-31
50	66	10	2015-01-31
51	67	10	2015-01-31
52	68	10	2015-01-31
53	69	25	2015-07-04
54	70	25	2015-07-04
55	71	7	2014-12-31
56	72	7	2014-12-31
57	73	7	2014-12-31
58	74	7	2014-12-31
59	75	7	2014-12-31
60	76	7	2014-12-31
61	77	18	2015-04-04
62	78	25	2015-07-04
63	79	25	2015-07-04
64	80	2	2014-11-03
65	81	13	2015-03-02
66	82	7	2014-12-31
67	83	10	2015-01-31
68	86	1	2014-11-05
69	87	18	2015-04-04
70	88	25	2015-07-04
71	89	25	2015-07-04
72	90	2	2014-11-03
73	91	13	2015-03-02
74	92	7	2014-12-31
75	93	10	2015-01-31
76	96	1	2014-11-05
77	97	18	2015-04-04
78	98	25	2015-07-04
79	99	25	2015-07-04
80	100	2	2014-11-03
81	101	11	2015-02-01
82	102	7	2014-12-31
83	103	10	2015-01-31
84	106	1	2014-11-05
85	113	10	2015-01-31
86	117	10	2015-01-31
87	118	10	2015-01-31
88	119	10	2015-01-31
89	120	25	2015-07-04
90	121	25	2015-07-04
91	122	10	2015-01-31
92	123	10	2015-01-31
93	124	7	2014-12-31
94	125	7	2014-12-31
95	126	7	2014-12-31
96	127	7	2014-12-31
97	128	7	2014-12-31
98	129	7	2014-12-31
99	130	18	2015-04-04
100	131	25	2015-07-04
101	132	25	2015-07-04
102	133	2	2014-11-03
103	134	11	2015-02-01
104	135	7	2014-12-31
105	136	10	2015-01-31
106	139	1	2014-11-05
107	140	18	2015-04-04
108	141	25	2015-07-04
109	142	10	2015-01-31
110	143	2	2014-11-03
111	144	13	2015-03-02
112	145	7	2014-12-31
113	146	10	2015-01-31
114	149	21	2015-06-02
115	150	19	2015-05-02
116	151	25	2015-07-04
117	152	5	2014-12-04
118	153	2	2014-11-03
119	154	13	2015-03-02
120	155	7	2014-12-31
121	156	10	2015-01-31
122	159	1	2014-11-05
123	166	25	2015-07-04
124	170	10	2015-01-31
125	171	10	2015-01-31
126	172	10	2015-01-31
127	173	10	2015-01-31
128	174	10	2015-01-31
129	175	10	2015-01-31
130	176	10	2015-01-31
131	177	7	2014-12-31
132	178	7	2014-12-31
133	179	7	2014-12-31
134	180	7	2014-12-31
135	181	7	2014-12-31
136	182	7	2014-12-31
137	183	19	2015-05-02
138	184	5	2014-12-04
139	185	10	2015-01-31
140	186	2	2014-11-03
141	187	13	2015-03-02
142	188	7	2014-12-31
143	189	25	2015-07-04
144	192	1	2014-11-05
145	193	19	2015-05-02
146	194	5	2014-12-04
147	195	5	2014-12-04
148	196	2	2014-11-03
149	197	11	2015-02-01
150	198	7	2014-12-31
151	199	10	2015-01-31
152	202	21	2015-06-02
153	203	19	2015-05-02
154	204	5	2014-12-04
155	205	10	2015-01-31
156	206	22	2015-06-03
157	207	11	2015-02-01
158	208	7	2014-12-31
159	209	25	2015-07-04
160	212	1	2014-11-05
161	219	10	2015-01-31
162	223	10	2015-01-31
163	224	10	2015-01-31
164	225	10	2015-01-31
165	226	25	2015-07-04
166	227	10	2015-01-31
167	228	10	2015-01-31
168	229	10	2015-01-31
169	230	7	2014-12-31
170	231	7	2014-12-31
171	232	7	2014-12-31
172	233	7	2014-12-31
173	234	7	2014-12-31
174	235	7	2014-12-31
175	236	19	2015-05-02
176	237	5	2014-12-04
177	238	5	2014-12-04
178	239	22	2015-06-03
179	240	13	2015-03-02
180	241	7	2014-12-31
181	242	10	2015-01-31
182	245	1	2014-11-05
183	246	19	2015-05-02
184	247	5	2014-12-04
185	248	5	2014-12-04
186	249	22	2015-06-03
187	250	13	2015-03-02
188	251	7	2014-12-31
189	252	10	2015-01-31
190	255	21	2015-06-02
191	256	19	2015-05-02
192	257	10	2015-01-31
193	258	5	2014-12-04
194	259	22	2015-06-03
195	260	13	2015-03-02
196	261	7	2014-12-31
197	262	10	2015-01-31
198	265	1	2014-11-05
199	272	25	2015-07-04
200	276	10	2015-01-31
201	277	25	2015-07-04
202	278	10	2015-01-31
203	279	10	2015-01-31
204	280	10	2015-01-31
205	281	10	2015-01-31
206	282	10	2015-01-31
207	283	7	2014-12-31
208	284	7	2014-12-31
209	285	7	2014-12-31
210	286	7	2014-12-31
211	287	7	2014-12-31
212	288	7	2014-12-31
213	289	19	2015-05-02
214	290	10	2015-01-31
215	291	10	2015-01-31
216	292	22	2015-06-03
217	293	13	2015-03-02
218	294	7	2014-12-31
219	295	10	2015-01-31
220	298	1	2014-11-05
221	299	1	2014-11-05
222	300	19	2015-05-02
223	301	10	2015-01-31
224	302	10	2015-01-31
225	303	25	2015-07-04
226	304	2	2014-11-03
227	305	7	2014-12-31
228	306	19	2015-05-02
229	307	10	2015-01-31
230	308	25	2015-07-04
231	309	2	2014-11-03
232	310	11	2015-02-01
233	311	7	2014-12-31
234	312	10	2015-01-31
235	315	1	2014-11-05
236	316	21	2015-06-02
237	317	19	2015-05-02
238	318	10	2015-01-31
239	319	5	2014-12-04
240	320	25	2015-07-04
241	321	22	2015-06-03
242	322	7	2014-12-31
243	323	19	2015-05-02
244	324	5	2014-12-04
245	325	25	2015-07-04
246	326	2	2014-11-03
247	327	11	2015-02-01
248	328	7	2014-12-31
249	329	10	2015-01-31
250	332	1	2014-11-05
251	333	1	2014-11-05
252	334	19	2015-05-02
253	335	5	2014-12-04
254	336	5	2014-12-04
255	337	25	2015-07-04
256	338	2	2014-11-03
257	339	7	2014-12-31
258	340	19	2015-05-02
259	341	5	2014-12-04
260	342	25	2015-07-04
261	343	2	2014-11-03
262	344	11	2015-02-01
263	345	7	2014-12-31
264	346	10	2015-01-31
265	349	1	2014-11-05
266	350	21	2015-06-02
267	351	19	2015-05-02
268	352	25	2015-07-04
269	353	25	2015-07-04
270	354	10	2015-01-31
271	355	2	2014-11-03
272	356	7	2014-12-31
273	357	18	2015-04-04
274	358	25	2015-07-04
275	359	5	2014-12-04
276	360	22	2015-06-03
277	361	13	2015-03-02
278	362	7	2014-12-31
279	363	10	2015-01-31
280	366	1	2014-11-05
281	367	1	2014-11-05
282	368	19	2015-05-02
283	369	5	2014-12-04
284	370	10	2015-01-31
285	371	5	2014-12-04
286	372	22	2015-06-03
287	373	7	2014-12-31
288	374	19	2015-05-02
289	375	10	2015-01-31
290	376	10	2015-01-31
291	377	2	2014-11-03
292	378	11	2015-02-01
293	379	7	2014-12-31
294	380	10	2015-01-31
295	383	21	2015-06-02
296	384	1	2014-11-05
297	385	19	2015-05-02
298	386	10	2015-01-31
299	387	5	2014-12-04
300	388	10	2015-01-31

PARAMETERS __ConventionNo Value; SELECT DISTINCTROW * FROM [SELECT Attendees.AttendeeLast, Companies.CompanyName, Attendees.ConventionID FROM Companies INNER JOIN Attendees ON Companies.ID=Attendees.CompanyID; ]. AS [Convention Entry] WHERE ([__ConventionNo] = ConventionID);

Access Unit D/JobSearch-D.accdb

EmployerID	CompanyName	EmpStreet	EmpCity	EmpState	EmpZip	EmpPhone
1	IBM	400 Locust St	Des Moines	IA	51122	515-555-4444
2	Wang	500 Cricket St	Ames	IA	50010	515-555-3333
3	Hewlett Packard	600 Crocker St	Omaha	NE	66000	616-555-2222
4	DEC	700 Beetle St	Lincoln	NE	66110	616-555-1111
5	Honeywell	800 Ladybug St	Sioux City	NE	66220	616-555-3333

Title	CareerArea	AnnualSalary	Desirability	EmployerID	PositionID
Marketing Representative	Computers	¤ 35,000.00	5	1	1
Systems Engineer	Computers	¤ 37,000.00	5	1	2
Office Specialist	Computers	¤ 32,000.00	4	2	3
Customer Service Rep	Computers	¤ 31,000.00	4	2	4
Technician	Computers	¤ 30,500.00	3	2	5

Access Unit D/Membership-D.accdb

FName	LName	Company	Street	City	State	Zip	Phone	StatusNo	DuesPaid
Mitch	Smith	USConnect	52411-B Wornall Road	Kansas City	KS	64145	5550401	3	¤ 0.00
Jill	Smith	Hallmark Cards	2505 McGee	Kansas City	KS	64141	5556931	2	¤ 0.00
Bob	Bouchart	Sprint	5200 Main Street	Kansas City	KS	64105	5553081	2	¤ 200.00
Cynthia	Browning	Kansas Communications	8206 Marshall Drive	Lenexa	KS	66214	5559101	2	¤ 200.00
Mary	Smith	Sprint North Supply	600 Industrial Parkway	Industrial Airport	KS	66031	5557002	3	¤ 0.00
Christine	Collins	NAIC	520 W 52nd St	Kansas City	KS	64105	5553602	2	¤ 200.00
Denise	Camel	ONA	66020 King St	Overland Park	KS	66210	5558402	3	¤ 150.00
Gene	Custard	Instinet	66900 College Blvd	Overland Park	KS	66210	5555102	3	¤ 200.00
Jan	Cabriella	Tokyo Foods	52520 W. 505 Terr	Lenexa	KS	66215	5559871	3	¤ 100.00
Andrea	Eahlie	USConnect	52466-B Wornall Road	Kansas City	KS	64145	5550401	3	¤ 200.00
Barbara	Diverman	USConnect	52466-B Friedrichsen Road	Kansas City	KS	64145	5550401	3	¤ 300.00
Sylvia	Dotey	PHP	50966 Lowell	Overland Park	KS	66210	5554404	3	¤ 300.00
Juan	Holly	The Duff Company	66525 N. Ambassador Drive	Kansas City	KS	64153	5558844	4	¤ 400.00
Jay	Eckert	Trinity Systems	903 East 504th St	Kansas City	KS	64131	5557414	3	¤ 200.00
John	Garden	Williams Foods Inc	53305 W. 99th St	Lenexa	KS	66215	5554344	3	¤ 100.00
Lois	Goode	True North	900 Foxworthy	West Des Moines	KS	50265	5551324	3	¤ 150.00
Mike	Hammer	KGSM	66224 Holmes	Kansas City	KS	64131	5550365	4	¤ 300.00
Jeff	Hopper	Portege Resouces	4435 Main	Kansas City	KS	64111	5558774	2	¤ 150.00
Holly	Hubert	IBM	2345 Grand	Kansas City	KS	64108	5556004	3	¤ 200.00
Traci	Kalvert	Sprint Publishing	7066 College Blvd	Overland Park	KS	66211	5557154	1	¤ 50.00
Brad	Lang	Hills Bank	5253 Duck Creek Dr	Iowa City	KS	52240	5558777	1	¤ 50.00
Kristen	Larson	Denman & Company	3966 Woodland	West Des Moines	KS	50266	5558908	1	¤ 50.00
Jerry	Martin	JCCC	52345 College Blvd	Overland Park	KS	66210	5558505	1	¤ 50.00
Karen	Margolis	JCCC	52345 College Blvd	Overland Park	KS	66210	5558505	2	¤ 0.00
Helen	Mackintosh	International Diabetes	2584 E. Meyer Blvd	Kansas City	KS	64132	5559414	2	¤ 100.00
Robert	Maxim	Boatmen’s Bank of Kansas	95th & Mission Road	Overland Park	KS	66206	5554514	3	¤ 200.00
Jim	Mullins	ONA	66020 King Street	Overland Park	KS	66210	5556434	4	¤ 200.00
Jenny	Nelson	The Sunflower Group	50895 Lowell	Overland Park	KS	66210	5555084	3	¤ 300.00
Marcie	Olson	Sprint	8320 Ward Parkway	Kansas City	KS	64114	5551388	3	¤ 300.00
Sharol	Olingback	Sprint	2330 Shawnee Mission	Westwood	KS	66205	5552434	2	¤ 100.00
Kathy	Vogue	PHP	50966 Lowell	Overland Park	KS	66210	5554404	2	¤ 100.00
Jim	Wilson	JCCC	52345 College Blvd	Overland Park	KS	66210	5558504	2	¤ 200.00
Shirley	Walker	USConnect	52466-B Wornall Road	Kansas City	KS	64145	5550403	2	¤ 200.00
Kathy	Yode	JCCC	52345 College Blvd	Overland Park	KS	66210	5558503	1	¤ 100.00
Jeanette	Parton	Principal Mutual	4435 Main St	Kansas City	KS	64111	5558773	1	¤ 0.00
Jane	Eagan	Cummins Construction	1515 Maple St	Fontanelle	KS	50033	5551166	2	¤ 0.00
Connie	Sinclaire	LPA	1010 Green St	Bridgewater	KS	50022	5552277	4	¤ 150.00
Jim	Jenkins	JCCC	12345 College Blvd	Overland Park	KS	66213	5554444	1	¤ 75.00

Status	StatusNo	MinimumHours	MinimumMonths	DuesOwed
New	1	20	2	¤ 100.00
Bronze	2	50	6	¤ 200.00
Silver	3	100	18	¤ 300.00
Gold	4	200	24	¤ 400.00
Platinum	5	500	36	¤ 500.00

Access Unit D/QuestTravel-D.accdb

CustNo	FName	LName	Street	City	State	Zip	Phone	FirstContact
1	Gracita	Mayberry	52411 Oakmont Rd	Kansas City	MO	64144	5554441234	Friend
2	Jacob	Alman	2505 McGee St	Des Moines	IA	50288	5551116931	Friend
3	Julia	Bouchart	5200 Main St	Kansas City	MO	64105	5551113081	Mail
4	Jane	Taylor	8206 Marshall Dr	Lenexa	KS	66214	5552229101	Mail
5	Samantha	Braven	600 Elm St	Olathe	KS	66031	5552227002	Friend
6	Kristen	Collins	520 W 52nd St	Kansas City	KS	64105	5552223602	Radio
7	Tom	Camel	520 W 52nd St	Kansas City	KS	64105	5552223602	Radio
8	Dick	Tracy	66020 King St	Overland Park	KS	66210	5552228402	Internet
9	Daniel	Cabriella	52520 W. 505 Ter	Lenexa	KS	66215	5553339871	Internet
10	Brad	Eahlie	56 Jackson Rd	Kansas City	MO	64145	5553330401	Mail
11	Nancy	Diverman	466 Lincoln Rd	Kansas City	MO	64105	5553330401	Friend
12	Kathryn	Dotey	96 Lowell St	Overland Park	KS	66210	5554444404	Internet
13	Anne	Duman	525 Ambassador Dr	Kansas City	MO	64145	5554448844	Mail
14	Mary Jane	Eckert	903 East 504th St.	Kansas City	KS	64131	5554447414	Radio
15	Frank	Houston	305 W. 99th St	Lenexa	KS	66215	5555664344	Radio
16	David	Kalvert	7066 College Rd	Overland Park	KS	66211	5559997154	Internet
17	Jose	Hammer	624 Richmond Ter	Clive	IA	50266	5556660365	Mail
18	Ralph	Hopper	4435 Main St	Greenfield	IA	50849	5557778774	Internet
19	Naresh	Hubert	2345 Grand Blvd	Kansas City	KS	64108	5558886004	Friend
20	Elsie	Lang	5253 Duck Creek Dr	Iowa City	IA	52240	5559998777	Friend
21	Toby	Lang	5253 Duck Creek Dr	Iowa City	IA	52240	5559998777	Friend
22	Brandon	Larson	3966 Woodland St	West Des Moines	IA	50266	5552228908	Internet
23	Gabriel	Martin	345 College Rd	Overland Park	KS	66210	5553338505	Radio
24	Douglas	Margolis	525 College Rd	Overland Park	KS	66210	5554448505	Friend
25	Aaron	Mackintosh	2584 Meyer Rd	Kansas City	KS	64132	5557779414	Mail
26	Robert	Maxim	201 Birch St	Overland Park	KS	66206	5558884514	Internet
27	Jaele	Mullins	620 King St	Overland Park	KS	66210	5557776434	Mail
28	Jenny	Nelson	895 Lowell Dr	Overland Park	KS	66211	5556665084	Friend
29	Marcie	Olson	8320 Grant St	Kansas City	MO	64114	5552221388	Internet
30	Sharol	Olingback	2330 Shawnee Dr	Westwood	KS	66205	5553332434	Friend
31	Zohra	Vogue	506 Lowell St	Point Lookout	MO	65727	5556664404	Mail
32	Lisa	Wilson	345 College Rd	Ridgedale	MO	65777	5557778504	Mail
33	Shirley	Walker	46 Maple Rd	Hollister	MO	65727	5551110403	Radio
34	Kori	Yode	5234 Ash Rd	Ridgedale	MO	65777	5552228503	Radio
35	Jeanette	Parton	4435 Main St	Branson	MO	65726	5552228773	Radio
36	Brad	Langguth	123 Duck Creek Dr	Johnston	IA	50800	5553328888	Internet
37	Madison	Bonocore	57 West 159th St	Cushing	PA	87087	5552887722	Radio
38	Nancy	Langguth	123 Duck Creek Dr	Johnston	IA	50800	5553328888	Internet
39	Tim	Taylor	8206 Marshall Dr	Lenexa	KS	66214	5552229101	Mail
40	Hannah	Edwards	66900 College Rd	Overland Park	KS	66210	5552225102	Radio
41	Marcus	Edwards	66900 College Rd	Overland Park	KS	66210	5552225102	Radio
42	Kris	Goode	900 Barnes St	West Des Moines	IA	50265	5556661324	Mail
43	Lois	Goode	900 Barnes St	West Des Moines	IA	50265	5556661324	Mail
44	Samuel	Livingston	1551 Switzer St	Gardner	KS	66303	5556633366	Internet
45	Julie	Livingston	1551 Switzer St	Gardner	KS	66303	5556633366	Internet
46	Aaron	Alito	5989 Washington Ave	Hollister	MO	67827	5556766677	Internet
47	Kelsey	Hope	7800 West 16th St	Manhattan	KS	66502	5556655522	Internet
48	Orlando	Still	7722 Mastin St	Mission	KS	63552	5558887722	Internet
49	Maria	Still	7722 Mastin St	Mission	KS	63552	5558887722	Internet

SalesNo	SaleDate	CustNo	TourNo
2	2014-04-30	32	1
3	2014-04-30	6	3
4	2014-04-30	42	1
5	2014-04-30	43	1
6	2014-04-30	19	1
7	2014-05-01	3	12
8	2014-05-01	7	3
9	2014-05-05	33	10
10	2014-05-05	31	10
11	2014-05-05	12	10
12	2014-05-05	17	10
13	2014-05-11	4	2
14	2014-05-31	34	1
15	2014-06-01	30	36
16	2014-06-01	43	36
17	2014-06-01	39	36
18	2014-06-01	15	36
19	2014-06-01	7	47
20	2014-06-01	4	36
21	2014-06-01	6	47
22	2014-06-01	42	36
23	2014-06-01	18	36
24	2014-06-02	38	36
25	2014-06-02	36	36
26	2014-06-03	40	36
27	2014-06-03	41	36
28	2014-06-30	25	1
29	2014-07-01	6	36
30	2014-07-01	5	2
31	2014-07-01	29	2
32	2014-07-01	11	2
33	2014-07-01	3	2
34	2014-07-01	2	2
35	2014-07-01	1	2
36	2014-07-01	7	36
37	2014-07-02	15	2
38	2014-07-02	14	2
39	2014-07-07	43	51
40	2014-07-07	6	51
41	2014-07-07	7	51
42	2014-07-07	42	51
43	2014-07-08	8	51
44	2014-07-08	17	51
45	2014-07-09	9	36
46	2014-07-09	9	51
47	2014-07-09	41	51
48	2014-07-09	40	51
49	2014-07-09	19	51
50	2014-07-09	11	51
51	2014-07-09	12	36
52	2014-07-11	5	51
53	2014-07-11	26	3
54	2014-07-11	19	3
55	2014-07-12	20	3
56	2014-07-12	24	3
57	2014-07-12	21	3
58	2014-07-12	22	3
59	2014-07-13	30	3
60	2014-07-13	28	3
61	2014-07-13	29	3
62	2014-07-13	43	3
63	2014-07-13	42	3
64	2014-07-14	11	5
65	2014-07-14	15	5
66	2014-07-14	10	4
67	2014-07-14	13	4
68	2014-07-15	34	5
69	2014-07-15	14	5
70	2014-07-15	35	5
71	2014-07-15	17	5
72	2014-07-15	13	5
73	2014-07-15	12	5
74	2014-07-19	15	6
75	2014-07-19	31	6
76	2014-07-20	33	6
77	2014-07-20	42	6
78	2014-07-20	32	6
79	2014-07-20	43	6
80	2014-07-21	18	6
81	2014-07-21	25	6
82	2014-07-22	16	7
83	2014-07-22	22	7
84	2014-07-22	27	7
85	2014-07-22	28	7
86	2014-07-26	23	7
87	2014-07-26	20	7
88	2014-07-26	21	7
89	2015-06-01	24	8
90	2015-06-01	27	9
91	2015-06-01	26	8
92	2015-06-02	17	9
93	2015-06-03	15	9
94	2015-06-04	29	9
95	2015-06-08	25	8
96	2015-06-08	23	8
98	2014-08-01	36	44
99	2014-08-01	38	44
100	2014-06-14	42	46
101	2014-06-14	43	46
102	2014-08-02	20	45
103	2014-08-02	21	45

StateName	StateAbbreviation
Alaska	AK
Alabama	AL
Arkansas	AR
Arizona	AZ
California	CA
Colorado	CO
Connecticut	CT
District of Columbia	DC
Delaware	DE
Florida	FL
Georgia	GA
Hawaii	HI
Iowa	IA
Idaho	ID
Illinois	IL
Indiana	IN
Kansas	KS
Kentucky	KT
Louisiana	LA
Massachusetts	MA
Maryland	MD
Maine	ME
Michigan	MI
Minnesota	MN
Missouri	MO
Mississippi	MS
Montana	MT
North Carolina	NC
North Dakota	ND
Nebraska	NE
New Hampshire	NH
New Jersey	NJ
New Mexico	NM
Nevada	NV
New York	NY
Ohio	OH
Oklahoma	OK
Oregon	OR
Pennsylvania	PA
Rhode Island	RI
South Carolina	SC
South Dakota	SD
Tennessee	TN
Texas	TX
Utah	UT
Virginia	VA
Vermont	VT
Washington	WA
Wisconsin	WS
West Virginia	WV
Wyoming	WY

Category	Description
Adventure	Adventure tours include skiing, scuba, biking, hiking, and climbing tours.
Cultural	Cultural tours focus on historical festivals and cultural exchange.
Educational	Educational tours offer college credit.
Family	Family tours include weddings and reunions.
Service	Service tours send volunteer workers to areas hit by natural disasters.
Site Seeing	Site seeing tours focus on tourist attractions.
Sports	Sports tours offer a special inside look at major league sporting events.

TourNo	TourName	TourStartDate	Duration	City	StateAbbrev	Category	Price
1	Breeze Bay Shelling	2014-07-06	3	Captiva	FL	Adventure	¤ 750.00
2	Red Reef Scuba	2014-07-06	3	Islamadora	FL	Adventure	¤ 1,500.00
3	Ames Ski Club	2015-01-02	7	Breckenridge	CO	Adventure	¤ 850.00
4	Boy Scout Jamboree	2015-01-13	7	Vail	CO	Adventure	¤ 1,900.00
5	Bridgewater Country	2015-02-15	10	Aspen	CO	Adventure	¤ 1,200.00
6	Franklin Family Reunion	2015-03-11	3	Breckenridge	CO	Family	¤ 700.00
7	Spare Tire Ski Club	2015-03-13	7	Monmouth	WA	Adventure	¤ 600.00
8	Eagan Family Reunion	2015-06-12	7	Osage Beach	MO	Family	¤ 500.00
9	Gunnison Bikers	2015-06-20	4	Kimberling City	MO	Adventure	¤ 250.00
10	Golden Footsteps	2014-05-23	4	Kissimmee	FL	Site Seeing	¤ 550.00
11	Hummer Trail	2014-05-30	14	Key West	FL	Site Seeing	¤ 725.00
12	Piper-Heitman Wedding	2014-05-30	7	Captiva	FL	Family	¤ 550.00
13	High Adventurers	2014-06-05	7	Ft. Lauderdale	FL	Adventure	¤ 575.00
15	Patriot Debate Club	2014-06-12	7	Orlando	FL	Site Seeing	¤ 605.00
17	Tropical Sailboats	2014-06-19	14	Key West	FL	Adventure	¤ 655.00
18	Eagle Hiking Club	2014-06-19	7	Aspen	CO	Adventure	¤ 695.00
19	Paradise Water Club	2014-06-26	7	Hollister	MO	Adventure	¤ 595.00
20	Team Discovery	2014-06-29	5	Breckenridge	CO	Adventure	¤ 550.00
21	Gulfside Birdwatchers	2014-06-29	7	Tampa Bay	FL	Adventure	¤ 700.00
22	Perfect Waves	2014-06-27	5	Huntington Beach	CA	Adventure	¤ 500.00
23	Outrigger Cleanup	2014-06-29	7	Biloxi	MS	Service	¤ 395.00
24	Blue Canyon Youth	2014-07-01	7	New Orleans	LA	Service	¤ 425.00
25	Emmanuel Youth Club	2014-07-01	7	Diaberville	MS	Service	¤ 500.00
26	Dalgren-Smith Wedding	2014-07-02	3	West Des Moines	IA	Family	¤ 300.00
27	Lang Reunion	2014-07-02	3	Des Moines	IA	Family	¤ 350.00
28	Buehler Reunion	2014-07-02	4	Kimberling City	MO	Family	¤ 395.00
29	Silver Country	2014-07-13	14	Sacramento	CA	Educational	¤ 1,200.00
30	Monterey Mysteries	2014-07-14	7	Monterey	CA	Educational	¤ 800.00
31	Washington DC Band	2014-07-13	7	Washington	DC	Educational	¤ 890.00
33	Broadway Workshops	2014-08-24	7	New York City	NY	Educational	¤ 1,000.00
34	Colonial Tour	2014-08-19	14	Washington	DC	Educational	¤ 3,000.00
35	Freedom Tour	2014-08-24	7	Boston	MA	Educational	¤ 1,000.00
36	American Heritage Tour	2014-08-24	7	Philadelphia	PA	Educational	¤ 1,200.00
37	Cactus Language Exploration	2014-09-14	7	San Diego	CA	Educational	¤ 800.00
38	Water Education Foundation	2014-09-21	14	Fresno	CA	Educational	¤ 1,300.00
39	Oakland Museum of Science	2014-07-20	7	Oakland	CA	Educational	¤ 1,000.00
40	Redwood Forest Lab	2014-09-29	14	Mill Valley	CA	Educational	¤ 1,500.00
41	Langguth History	2014-10-19	10	Napa	CA	Site Seeing	¤ 900.00
43	Japanese California Connection	2014-08-19	4	Bolinas	CA	Site Seeing	¤ 424.00
44	Bear Valley Adventures	2014-08-19	3	Sacramento	CA	Adventure	¤ 725.00
45	Black Sheep Hiking Club	2014-08-26	14	El Dorado Hills	CA	Adventure	¤ 525.00
46	Bigfoot Rafting Club	2014-07-13	4	Placerville	CA	Adventure	¤ 455.00
47	Yosemite National Park Great Cleanup	2014-07-20	3	Sacramento	CA	Service	¤ 1,100.00
48	Kings Canyon Bridge Builders	2014-07-13	10	Three Rivers	CA	Service	¤ 950.00
49	Golden State Tours	2014-07-20	10	Sacramento	CA	Site Seeing	¤ 1,400.00
51	Bright Lights Expo	2014-12-01	7	Branson	MO	Site Seeing	¤ 200.00
52	Missouri Bald Eagle Watch Club	2014-08-13	7	Hollister	MO	Adventure	¤ 700.00
53	Salmon Run Fishing	2014-05-05	4	Seattle	WA	Adventure	¤ 800.00
54	Northwest Passage	2014-08-01	10	Vancouver	WA	Adventure	¤ 2,000.00
55	Space Needle Fireworks	2014-07-04	3	Seattle	WA	Site Seeing	¤ 500.00

Access Unit D/RealEstate-D.accdb

AgencyNo	AgencyName	Street	City	State	Zip	AgencyPhone
1	Four Lakes Realtors	123 First Street	Kimberling City	MO	77889	555-666-7700
2	Marvin and Pam Realtors	7878 Lake View Lane	Branson	MO	77770	555-555-8800
3	Sun and Ski Realtors	9900 West Sunset Drive	West Branson	MO	77990	555-999-9999
4	Ridgedale Real Estate	7744 Pokeberry Lane	Ridgedale	MO	77660	555-888-4444

ListingNo	Type	Area	SqFt	LakeFt	BR	Bath	Garage	Pool	Asking	RealtorNo	ListingDate
1	Ranch	Ozark Mountain	3400	150	4	4.0	2	false	475000	1	2012-01-05
2	New	Ridgedale	3000	65	2	3.0	0	false	305000	1	2012-01-06
3	New	Ridgedale	2900	180	3	2.5	2	false	345000	1	2012-02-01
4	Cabin	Horseshoe Bend	1200	102	4	3.0	2	false	185000	2	2012-03-01
5	Ranch	Ridgedale	2500	100	3	2.5	0	false	274000	2	2012-04-01
7	Two Story	Ozark Mountain	3000	110	4	4.0	2	false	275000	2	2012-05-01
8	Two Story	Shell City	1800	112	3	3.0	2	false	302000	2	2012-06-01
9	Ranch	Horseshoe Bend	2000	120	3	3.5	0	false	395000	1	2012-03-01
10	Ranch	Ridgedale	2000	80	3	3.0	2	false	290000	1	2012-04-01
11	Ranch	Ridgedale	1215	80	3	2.0	0	false	220000	1	2012-03-01
12	Ranch	Greenview	2200	200	3	3.0	2	false	395613	2	2012-05-01
13	Two Story	Blue Eye	3000	100	4	3.0	2	false	288000	3	2012-05-01
14	Two Story	Greenview	5500	250	4	2.5	3	true	550000	3	2012-06-01
15	Two Story	Branson West	2500	100	3	2.0	2	false	385000	3	2012-01-06
16	Ranch	Branson	2700	85	4	3.0	2	false	281000	4	2001-04-01
17	Log Cabin	Cape Fair	2000	300	3	2.0	0	false	375000	4	2012-05-01
18	Ranch	Kimberling City	2500	100	3	4.0	2	false	283000	4	2012-05-15
19	Two Story	Shell City	3200	110	3	4.5	0	false	399000	4	2002-06-01
20	Two Story	Kimberling City	2700	121	3	3.0	2	false	279000	4	2012-06-15
21	Patio Home	Kimberling City	2200	0	2	2.0	1	true	230000	4	2012-07-01
22	Cabin	Kimberling City	1350	50	2	2.0	2	false	289000	5	2012-01-05
23	Two Story	Galena	2000	75	4	1.0	0	false	224900	5	2012-02-01
24	Mobile Home	Galena	1200	120	3	2.0	0	false	129000	1	2012-05-01
25	Cabin	Kimberling City	1900	80	3	1.0	0	false	222000	1	2012-04-01
26	Ranch	Lampe	3000	250	3	2.5	3	false	375000	1	2012-05-15

RealtorNo	RFirst	RLast	RPhone	AgencyNo
1	Gordon	King	555-222-8877	1
2	Phil	Kirkpatrick	555-111-9900	1
3	Jessica	Polar	555-333-3344	3
4	Malika	Thompson	555-444-7788	3
5	Jane Ann	Rockaway	555-223-0044	2
6	Shari	Duncan	555-228-5577	2
7	Trixie	Angelina	555-220-4466	2
8	Mary Jane	Dell	555-888-7777	1
9	Deb	Trumpet	555-333-0123	1
10	Cy	Clone	555-888-9999	4

SELECT Agencies.AgencyName, Listings.Area, Listings.Type, Listings.SqFt, Listings.Asking FROM (Agencies INNER JOIN Realtors ON Agencies.AgencyNo = Realtors.AgencyNo) INNER JOIN Listings ON Realtors.RealtorNo = Listings.RealtorNo ORDER BY Agencies.AgencyName, Listings.Area;

SELECT Realtors.RFirst, Realtors.RLast, Listings.Type, Listings.SqFt, Listings.Asking FROM Realtors INNER JOIN Listings ON Realtors.RealtorNo = Listings.RealtorNo;

Access Unit D/Recycle-D.accdb

CenterName	Street	City	State	Zip	Phone	ContactFirst	ContactLast	CenterNumber	Hazardous
Trash Can	987 Main	Lenexa	KS	61111	5551236666	Trixie	Fredrick	1	true
Bachman Trash	12345 College	Overland Park	KS	63444	5552227897	Harlan	Parker	2	true
Wilson County Landfill	12444 Murlen	Shawnee	KS	64222	5557809999	Cindy	Hileman	3	false
Johnson County Landfill	78900 180th St.	Olathe	KS	65444	5551111234	Emir	Cipra	4	false

ClubNumber	ClubName	Street	City	State	Zip	Phone	FName	LName
1	Access Users Group	111 Elm	Overland Park	KS	66213	5551238888	Samuel	Scott
2	Boy Scouts #11	22 West 67th	Lenexa	KS	66000	5551117777	Jordan	Ruff
3	Great Plains 4-H	44 East 99th	Lenexa	KS	66111	5552222222	Marco	Wiles
4	Lions	777 Oxford St.	Overland Park	KS	66333	5553333111	Cory	Mills
5	Junior League	3333 Princeton Ln.	Overland Park	KS	66222	5552134333	Lloyd	Oliver
6	Girl Scouts #11	55 Oak	Shawnee	KS	68777	5551224444	Tara	Block
7	Oak Hill Patriots	888 Switzer	Overland Park	KS	66444	5551239999	Trevor	Cho

DepositNumber	DepositDate	Weight	CenterNumber	ClubNumber
1	2012-01-05	60.0	1	2
2	2012-01-07	90.0	2	7
3	2012-02-15	50.0	3	7
4	2012-02-19	30.0	2	2
5	2012-02-22	50.0	4	6
6	2012-02-23	100.0	3	6
7	2012-02-29	125.0	2	4
8	2012-03-16	60.0	1	2
9	2012-04-04	115.0	1	4
10	2012-04-19	105.0	1	2
11	2012-05-19	90.0	2	2
12	2012-05-20	80.0	3	1
13	2012-05-21	50.0	4	1
14	2012-06-01	60.0	4	6
15	2012-06-02	65.0	3	4
16	2012-06-08	75.0	3	5
17	2012-06-09	95.0	2	2
18	2012-06-10	90.0	2	1
19	2012-07-11	85.0	1	2
20	2012-07-12	95.0	1	4
21	2012-07-17	65.0	4	6
22	2012-07-18	85.0	3	4
23	2012-07-20	45.0	2	5
24	2012-08-20	205.0	1	7
25	2012-08-21	105.0	2	1
26	2012-09-19	30.0	3	2
27	2012-10-20	60.0	4	4
28	2012-10-21	40.0	3	4
29	2012-10-31	90.0	2	4
30	2012-11-01	80.0	1	1
31	2012-11-02	25.0	2	4
32	2012-11-03	100.0	4	2
33	2012-11-17	85.0	4	5
34	2012-11-18	75.0	3	5
35	2012-11-19	85.0	3	6
36	2012-11-30	90.0	3	5
37	2012-12-02	80.0	2	6
38	2012-12-04	70.0	2	7
39	2012-12-07	80.0	1	7
40	2012-12-09	50.0	4	6
41	2013-01-30	60.0	1	1
42	2013-01-30	100.0	2	6
43	2013-02-04	80.0	1	4
44	2013-02-04	75.0	4	4
45	2013-02-08	150.0	2	5
46	2013-02-13	185.0	2	6
47	2013-02-14	50.0	4	1
48	2013-02-16	35.0	1	7
49	2013-02-17	40.0	3	1
50	2013-02-18	185.0	4	6
51	2013-02-20	200.0	3	2
52	2013-02-22	75.0	4	5
53	2013-02-23	80.0	1	4
54	2013-02-26	65.0	2	4
55	2013-03-02	150.0	1	5
56	2013-03-03	50.0	3	4
57	2013-03-04	45.0	3	7
58	2013-03-05	75.0	4	5
59	2013-03-06	200.0	1	1
60	2013-03-07	145.0	4	6
61	2013-04-19	115.0	4	6
62	2013-04-20	65.0	4	1
63	2013-04-22	105.0	2	1
64	2013-04-23	90.0	4	2
65	2013-04-25	65.0	1	1
66	2013-04-30	205.0	3	2
67	2013-05-01	105.0	4	6
68	2013-05-07	190.0	3	2
69	2013-06-04	90.0	4	4
70	2013-06-07	65.0	3	4
71	2013-06-19	65.0	1	4
72	2013-06-20	85.0	4	5
73	2013-06-22	95.0	3	1
74	2013-07-07	75.0	3	5
75	2013-07-08	200.0	2	1
76	2013-08-31	50.0	4	6
77	2013-09-24	200.0	2	5
78	2013-10-01	90.0	3	5
79	2013-10-02	90.0	4	4
80	2013-10-04	80.0	2	5
81	2012-01-31	60.0	4	1
82	2012-01-31	100.0	4	1
83	2012-02-05	80.0	1	4
84	2012-02-05	75.0	2	4
85	2012-02-09	150.0	2	5
86	2012-02-14	200.0	2	6
87	2012-02-15	50.0	2	1
88	2012-02-17	50.0	1	7
89	2012-02-18	40.0	3	1
90	2012-02-19	100.0	4	7
91	2012-02-21	200.0	4	2
92	2012-02-23	75.0	4	6
93	2012-02-24	80.0	1	4
94	2012-02-27	100.0	4	6
95	2012-03-02	150.0	2	5
96	2012-03-03	70.0	4	4
97	2012-03-04	100.0	3	7
98	2012-03-05	150.0	3	5
99	2012-03-06	200.0	4	1
100	2012-03-07	50.0	2	6

Access Unit A/Basketball-A.accdb

GameNo	Opponent	Mascot	HomeAway	CycloneScore	OpponentScore	GameDate	WebSite
1	Iowa	Hawkeyes	A	81	65	2014-11-12	www.uiowa.edu#http://www.uiowa.edu#
2	Creighton	Bluejays	H	79	60	2014-11-15	www.creighton.edu#..\A1\UnitJ-A1-2.doc# 1,46986,47004,4094,IC Practice Text,www.creighton.edu
3	Northern Illinois	Huskies	H	79	60	2014-11-22	www.niu.edu#http://www.niu.edu#
4	Louisiana Tech	Red Raiders	A	60	89	2014-11-29	www.latech.edu#http://www.latech.edu#
5	Drake	Bulldogs	H	78	60	2014-12-10	www.drake.edu#http://www.drake.edu#
6	Northern Iowa	Panthers	A	80	73	2014-12-18	www.uni.edu#http://www.uni.edu#
7	Buffalo	Bulls	H	77	55	2014-12-28	www.buffalo.edu#http://www.buffalo.edu#
8	Oklahoma	Sooners	A	81	60	2014-12-31	www.ou.edu#http://www.ou.edu#
9	Texas	Longhorns	H	81	60	2015-01-03	www.utexas.edu#http://www.utexas.edu#
10	Kansas	Jayhawks	H	70	58	2015-01-07	www.ku.edu#http://www.ku.edu#
11	Colorado	Buffaloes	A	90	84	2015-01-11	www.cubuffs.com#http://www.cubuffs.com#
12	Texas A&M	Aggies	H	77	60	2015-01-14	www.tamu.edu#http://www.tamu.edu#
13	Clemson	Lady Tigers	A	72	81	2015-01-22	www.clemson.edu#http://www.clemson.edu#
14	Nebraska	Cornhuskers	H	79	58	2015-01-26	www.unl.edu#http://www.unl.edu#
15	Missouri	Tigers	A	80	54	2015-01-28	www.missouri.edu#http://www.missouri.edu#
16	Oklahoma State	Cowgirls	A	76	42	2015-02-01	www.okstate.edu#http://www.okstate.edu#
17	Kansas State	Wildcats	A	63	70	2015-02-08	www.ksu.edu##
18	Baylor	Lady Bears	A	68	70	2015-02-14	www.baylor.edu#http://www.baylor.edu#
19	Oregon	Ducks	H	85	70	2015-02-18	www.uoregon.edu#http://www.uoregon.edu#
20	Georgia	Bulldogs	H	91	89	2015-02-21	www.uga.edu#http://www.uga.edu#
21	Connecticut	Huskies	H	64	58	2015-02-23	www.uconn.edu#http://www.uconn.edu#
22	Texas State	Bobcats	A	97	48	2015-02-25	www.txstate.edu#http://www.txstate.edu#
23	Kansas State	Wildcats	H	100	52	2015-02-28	www.ksu.edu
24	Iowa	Hawkeyes	A			2015-11-12	www.uiowa.edu#http://www.uiowa.edu/#
25	Creighton	Bluejays	H			2015-11-15	www.creighton.edu#..\A1\UnitJ-A1-2.doc# 1,46986,47004,4094,IC Practice Text,www.creighton.edu
26	Northern Illinois	Huskies	H			2015-11-22	www.niu.edu#http://www.niu.edu/#
27	Louisiana Tech	Red Raiders	A			2015-11-29	www.latech.edu#http://www.latech.edu/#
28	Drake	Bulldogs	H			2015-12-10	www.drake.edu#http://www.drake.edu#
29	Northern Iowa	Panthers	A			2015-12-18	www.uni.edu#http://www.uni.edu/#
30	Buffalo	Bulls	H			2015-12-28	www.buffalo.edu#http://www.buffalo.edu/#
31	Oklahoma	Sooners	A			2015-12-31	www.ou.edu#http://www.ou.edu/#
32	Texas	Longhorns	H			2016-01-03	www.utexas.edu#http://www.utexas.edu/#
33	Kansas	Jayhawks	H			2016-01-07	www.ku.edu#http://www.ku.edu/#
34	Colorado	Buffaloes	A			2016-01-11	www.cubuffs.com#http://www.cubuffs.com/#
35	Texas A&M	Aggies	H			2016-01-14	www.utexas.edu#http://www.utexas.edu/#
36	Clemson	Lady Tigers	A			2016-01-22	www.clemson.edu#http://www.clemson.edu/#
37	Nebraska	Cornhuskers	H			2016-01-26	www.unl.edu#http://www.unl.edu/#
38	Missouri	Tigers	A			2016-01-28	www.missouri.edu#http://www.missouri.edu/#
39	Oklahoma State	Cowgirls	A			2016-02-01	www.okstate.edu#http://www.okstate.edu/#
40	Kansas State	Wildcats	A			2016-02-08	www.ksu.edu##
41	Baylor	Lady Bears	A			2016-02-14	www.baylor.edu#http://www.baylor.edu/#
42	Oregon	Ducks	H			2016-02-18	www.uoregon.edu#http://www.uoregon.edu/#
43	Georgia	Bulldogs	H			2016-02-21	www.uga.edu#http://www.uga.edu/#
44	Connecticut	Huskies	H			2016-02-23	www.uconn.edu#http://www.uconn.edu/#
45	Texas State	Bobcats	A			2016-02-25	www.txstate.edu#http://www.txstate.edu/#
46	Kansas State	Wildcats	H			2016-02-28	www.ksu.edu

PFirst	PLast	Height	PlayerNo	GradYear	Position	HomeTown	HomeState
Sydney	Freesen	68	4	2014	G	Panora	IA
Kelsey	Douglas	69	5	2015	G	Linden	IA
Ellyse	Howard	70	12	2016	G	Osseo	MN
Amy	Hodel	72	21	2014	F	Oakbrook	IL
Theresa	Grant	73	22	2013	F	McKinney	TX
Sandy	Robins	65	23	2013	G	Anita	IA
Ashley	Sydnes	75	30	2013	F	Salina	KS
Abbey	Walker	76	32	2014	C	Fargo	ND
Kristen	Czyenski	73	35	2015	F	Omaha	NE
Denise	Franco	72	42	2016	F	Antigua	WI
Megan	Hile	74	45	2015	F	Cumberland	IA
Morgan	Tyler	71	51	2014	G	Roseau	MN
Jamie	Johnson	75	52	2016	F	Belleville	IL

PlayerNo	GameNo	FieldGoals	FieldGoalAttempts	3Pointers	3PointAttempts	FreeThrows	FreeThrowAttempts	ReboundOffense	ReboundDefense	Assists
5	1	3	4	2	2	1	1	1	2	2
5	2	4	6	1	3	3	3	2	2	4
5	3	5	6	2	3	2	4	2	1	2
5	4	5	7	3	3	3	3	3	1	1
5	5	6	8	3	3	5	6	1	1	1
5	6	4	8	1	1	1	3	1	3	2
5	7	4	7	2	2	2	2	2	2	2
5	8	3	4	2	2	1	1	2	1	3
5	9	4	5	2	6	3	4	1	4	3
5	10	4	6	2	4	3	3	2	5	3
12	1	2	3	1	1	1	1	1	2	1
12	2	3	2	0	0	3	4	3	3	1
12	3	5	6	0	0	2	4	4	3	1
12	4	5	7	0	0	3	3	2	3	1
12	5	6	8	0	0	4	6	2	3	0
12	6	4	8	0	0	2	3	2	5	2
12	7	4	7	0	0	3	3	4	6	2
12	8	3	4	0	0	1	1	5	7	3
12	9	4	5	0	1	4	6	5	4	4
12	10	4	6	1	2	3	3	5	5	1
21	1	1	3	1	1	1	1	5	3	1
21	2	1	2	0	0	1	4	1	4	1
21	3	1	1	0	0	4	4	1	4	1
21	4	1	1	0	0	5	5	3	2	1
21	5	1	2	0	0	6	6	5	2	0
21	6	0	1	0	0	2	3	4	2	1
21	7	0	0	0	0	2	3	2	2	0
21	8	0	1	0	0	1	1	2	1	0
21	9	2	2	0	1	5	6	2	5	0
21	10	2	3	1	1	5	3	1	3	1
42	1	2	5	1	2	4	4	2	3	1
42	2	2	4	1	2	5	5	5	3	2
42	3	5	3	2	4	4	5	5	3	1
42	4	2	2	2	5	5	6	2	2	1
42	5	1	1	2	3	6	8	2	3	3
42	6	0	6	1	2	2	4	2	4	1
42	7	2	2	0	2	5	5	5	2	0
42	8	4	5	1	3	3	4	5	1	3
42	9	1	2	2	2	1	3	1	4	0
42	10	5	5	1	1	1	3	5	2	1
45	1	1	4	0	2	1	1	1	2	1
45	2	2	3	0	3	1	1	1	5	1
45	3	1	3	0	0	1	1	2	2	1
45	4	2	3	0	0	1	1	1	4	1
45	5	2	2	0	0	1	3	1	2	1
45	6	3	3	0	0	1	3	1	2	1
45	7	1	2	0	0	1	1	3	4	1
45	8	1	4	2	2	1	1	2	4	1
45	9	1	3	0	0	1	2	1	3	2
45	10	3	3	0	0	1	1	1	5	2
51	1	1	5	0	0	2	4	4	6	1
51	2	2	4	0	0	3	5	3	6	1
51	3	1	3	0	0	4	5	3	4	1
51	4	1	4	0	0	5	6	3	3	1
51	5	3	4	0	0	5	5	2	4	1
51	6	0	2	0	0	2	4	1	2	3
51	7	2	3	0	0	5	5	1	2	2
51	8	3	3	0	0	3	4	1	3	1
51	9	1	5	0	0	5	5	3	3	2
51	10	3	3	0	1	4	5	4	4	1

SELECT Players.PFirst, Players.PLast, Stats.FieldGoals, Stats.[3Pointers], Stats.FreeThrows, Games.Opponent FROM Games INNER JOIN (Players INNER JOIN Stats ON Players.PlayerNo = Stats.PlayerNo) ON Games.GameNo = Stats.GameNo;

Access Unit A/BusinessContacts-A.accdb

ID	Company	FirstName	LastName	Street	City	State	Zip	Phone	Fax	Birthdate	Email	YTDSales
1	Sprint Systems	Aaron	Clark	111 Ash St	Kansas City	MO	668881111	5555552227	(555) 555-2221	1960-05-05	[email protected]	¤ 501.87
2	KGSM	Jacob	Douglas	222 Elm St	Kansas City	MO	668882222	(555) 555-1111	(555) 555-1115	1965-07-16	[email protected]	¤ 750.87
3	JCCC	Douglas	Scott	333 Oak Dr	Kansas City	KS	667774444	(555) 555-8888	(555) 555-8889	1959-08-27	[email protected]#http://[email protected]#	¤ 1,987.52
4	Oliver's Salon	Ann	Thomas	444 Apple St	Kansas City	KS	667773333	(555) 555-7777	5555557771	1960-08-20	[email protected]	¤ 986.43
5	Eye Surgery Center	Todd	Vandenburg	555 Birch St	Lenexa	KS	666610033	(555) 555-6666	(555) 555-6665	1962-08-21	[email protected]	¤ 207.25
6	Mohs Surgery Center	Glenn	Choi	666 Pine St	Kansas City	MO	668863333	(555) 555-3333	(555) 555-2228	1947-08-15	[email protected]	¤ 2,345.98
7	American Diabetes Center	Sandie	Wilberforce	777 Mulberry Way	Overland Park	KS	665552222	(555) 555-2222	(555) 555-2223	1961-09-06	[email protected]	¤ 2,040.95
8	Hallmark Company	Kristen	Chung	888 Fountain Dr	Mission Hills	KS	662223333	(555) 555-1191	(555) 555-1118	1970-01-06	[email protected]	¤ 789.78
9	Aaron Rents	Tom	Cinotto	999 Riverside Dr	Shawnee	KS	661118888	(555) 555-5888	(555) 555-8887	1968-04-15	[email protected]	¤ 6,588.50
10	IBM	Daniel	Arno	123 Wrigley Field	Overland Park	KS	663332222	(555) 555-3111	(555) 555-1119	1970-08-19	[email protected]	¤ 5,690.23
11	Motorola Corporation	Mark	Espindola	234 Wedd St	Overland Park	KS	663339988	(555) 555-1234	(555) 555-1233	1964-07-03	[email protected]	¤ 788.89
12	PFS Investments	David	Duarte	987 Front St	Lenexa	MO	666610025	(555) 555-9999	(555) 555-9998	1971-08-19	[email protected]	¤ 5,432.88
13	Hill Pet Foods	Molly	Wu	6788 Pine St	Independence	MO	602223333	(555) 555-6777	(555) 555-7776	1969-09-09	[email protected]	¤ 1,235.99
14	LabOne	Claire	Dodge	6789 Canyon Pl	Raytown	MO	601242222	(555) 555-5555	(555) 555-5554	1970-05-04	[email protected]	¤ 1,190.76
15	ABC Electricity	Brett	Morgan	987 Lincolnway	Lenexa	KS	664444444	(555) 555-4444	(555) 555-4445	1968-04-15	[email protected]	¤ 987.34
16	Health Midwest Clinic	Jane	Eagan	201 Jackson St	Overland Park	KS	663329999	(555) 555-1999	(555) 555-9998	1949-09-30	[email protected]	¤ 5,679.99
17	Cerner Industries	Fritz	Bradley	887 Winger Rd	Shawnee	KS	661118887	(555) 555-1777	(555) 555-7779	1948-09-26	[email protected]	¤ 8,976.33
18	EBC	Carl	Salter	444 Metcalf	Overland Park	KS	661117777	(555) 555-1222	(555) 555-2228	1945-09-08	[email protected]	¤ 6,789.50
19	Royals	Peg	Fox	554 Stadium Ln	Raytown	MO	601241111	(555) 555-4777	(555) 555-7779	1960-01-20	[email protected]	¤ 9,873.33
20	St. Luke's Hospital	Amanda	Summer	667 Birdie Ln	Kansas City	MO	668885555	(555) 555-3338	(555) 555-3332	1965-08-21	[email protected]	¤ 6,782.55
21	Rocket Laboratory	Brittney	Willoughby	887 Foxtrot Ln	Kansas City	KS	667772222	(555) 555-4222	(555) 555-2221	1966-06-10	[email protected]	¤ 4,323.22
22	Oak Hill Elementary School	Callie	Jones	244 75th St	Overland Park	MO	668877777	(555) 555-2211	(555) 555-1112	1967-05-04	[email protected]	¤ 3,259.77
23	Farmland Industries	Marjorie	Donald	556 Cory Ave	Mission Hills	KS	662222222	(555) 555-2233	(555) 555-3334	1962-04-16	[email protected]	¤ 2,341.49
24	Cardiac Rehabilitation	Mildred	Wambold	600 Adair St	Greenfield	MO	600222222	(555) 555-2266	(555) 555-6665	1940-02-17	[email protected]	¤ 2,345.23
25	First National Bank	Irma	Mitchell	800 First St	Fontanelle	MO	600330011	(555) 555-2244	(555) 555-4443	1945-10-04	[email protected]	¤ 987.32
26	IKON	Ralph	Gregory	500 Maple St	Adair	MO	600440022	(555) 555-2288	(555) 555-8887	1947-11-08	[email protected]	¤ 298.74
27	St. Thomas Church	Frances	Gustaphson	400 Russel Ln	Casey	MO	600550055	(555) 555-5556	(555) 555-5557	1946-02-25	[email protected]	¤ 6,790.33

Access Unit A/QuestTravel-A.accdb

CustNo	FName	LName	Street	City	State	Zip	Phone	FirstContact
1	Gracita	Mayberry	52411 Oakmont Rd	Kansas City	MO	64144	5554441234	Friend
2	Jacob	Alman	2505 McGee St	Des Moines	IA	50288	5551116931	Friend
3	Julia	Bouchart	5200 Main St	Kansas City	MO	64105	5551113081	Mail
4	Jane	Taylor	8206 Marshall Dr	Lenexa	KS	66214	5552229101	Mail
5	Samantha	Braven	600 Elm St	Olathe	KS	66031	5552227002	Friend
6	Kristen	Collins	520 W 52nd St	Kansas City	KS	64105	5552223602	Radio
7	Tom	Camel	520 W 52nd St	Kansas City	KS	64105	5552223602	Radio
8	Dick	Tracy	66020 King St	Overland Park	KS	66210	5552228402	Internet
9	Daniel	Cabriella	52520 W. 505 Ter	Lenexa	KS	66215	5553339871	Internet
10	Brad	Eahlie	56 Jackson Rd	Kansas City	MO	64145	5553330401	Mail
11	Nancy	Diverman	466 Lincoln Rd	Kansas City	MO	64105	5553330401	Friend
12	Kathryn	Dotey	96 Lowell St	Overland Park	KS	66210	5554444404	Internet
13	Anne	Duman	525 Ambassador Dr	Kansas City	MO	64145	5554448844	Mail
14	Mary Jane	Eckert	903 East 504th St.	Kansas City	KS	64131	5554447414	Radio
15	Frank	Houston	305 W. 99th St	Lenexa	KS	66215	5555664344	Radio
16	David	Kalvert	7066 College Rd	Overland Park	KS	66211	5559997154	Internet
17	Jose	Hammer	624 Richmond Ter	Clive	IA	50266	5556660365	Mail
18	Ralph	Hopper	4435 Main St	Greenfield	IA	50849	5557778774	Internet
19	Naresh	Hubert	2345 Grand Blvd	Kansas City	KS	64108	5558886004	Friend
20	Elsie	Lang	5253 Duck Creek Dr	Iowa City	IA	52240	5559998777	Friend
21	Toby	Lang	5253 Duck Creek Dr	Iowa City	IA	52240	5559998777	Friend
22	Brandon	Larson	3966 Woodland St	West Des Moines	IA	50266	5552228908	Internet
23	Gabriel	Martin	345 College Rd	Overland Park	KS	66210	5553338505	Radio
24	Douglas	Margolis	525 College Rd	Overland Park	KS	66210	5554448505	Friend
25	Aaron	Mackintosh	2584 Meyer Rd	Kansas City	KS	64132	5557779414	Mail
26	Robert	Maxim	201 Birch St	Overland Park	KS	66206	5558884514	Internet
27	Jaele	Mullins	620 King St	Overland Park	KS	66210	5557776434	Mail
28	Jenny	Nelson	895 Lowell Dr	Overland Park	KS	66211	5556665084	Friend
29	Marcie	Olson	8320 Grant St	Kansas City	MO	64114	5552221388	Internet
30	Sharol	Olingback	2330 Shawnee Dr	Westwood	KS	66205	5553332434	Friend
31	Zohra	Vogue	506 Lowell St	Point Lookout	MO	65727	5556664404	Mail
32	Lisa	Wilson	345 College Rd	Ridgedale	MO	65777	5557778504	Mail
33	Shirley	Walker	46 Maple Rd	Hollister	MO	65727	5551110403	Radio
34	Kori	Yode	5234 Ash Rd	Ridgedale	MO	65777	5552228503	Radio
35	Jeanette	Parton	4435 Main St	Branson	MO	65726	5552228773	Radio
36	Brad	Langguth	123 Duck Creek Dr	Johnston	IA	50800	5553328888	Internet
37	Madison	Bonocore	57 West 159th St	Cushing	PA	87087	5552887722	Radio
38	Nancy	Langguth	123 Duck Creek Dr	Johnston	IA	50800	5553328888	Internet
39	Tim	Taylor	8206 Marshall Dr	Lenexa	KS	66214	5552229101	Mail
40	Hannah	Edwards	66900 College Rd	Overland Park	KS	66210	5552225102	Radio
41	Marcus	Edwards	66900 College Rd	Overland Park	KS	66210	5552225102	Radio
42	Kris	Goode	900 Barnes St	West Des Moines	IA	50265	5556661324	Mail
43	Lois	Goode	900 Barnes St	West Des Moines	IA	50265	5556661324	Mail
44	Samuel	Livingston	1551 Switzer St	Gardner	KS	66303	5556633366	Internet
45	Julie	Livingston	1551 Switzer St	Gardner	KS	66303	5556633366	Internet
46	Aaron	Alito	5989 Washington Ave	Hollister	MO	67827	5556766677	Internet
47	Kelsey	Hope	7800 West 16th St	Manhattan	KS	66502	5556655522	Internet
48	Orlando	Still	7722 Mastin St	Mission	KS	63552	5558887722	Internet
49	Maria	Still	7722 Mastin St	Mission	KS	63552	5558887722	Internet

SalesNo	SaleDate	CustNo	TourNo
1	2014-04-30	18	1
2	2014-04-30	32	1
3	2014-04-30	6	3
4	2014-04-30	42	1
5	2014-04-30	43	1
6	2014-04-30	19	1
7	2014-05-01	3	12
8	2014-05-01	7	3
9	2014-05-05	33	10
10	2014-05-05	31	10
11	2014-05-05	12	10
12	2014-05-05	17	10
13	2014-05-11	4	2
14	2014-05-31	34	1
15	2014-06-01	30	36
16	2014-06-01	43	36
17	2014-06-01	39	36
18	2014-06-01	15	36
19	2014-06-01	7	47
20	2014-06-01	4	36
21	2014-06-01	6	47
22	2014-06-01	42	36
23	2014-06-01	18	36
24	2014-06-02	38	36
25	2014-06-02	36	36
26	2014-06-03	40	36
27	2014-06-03	41	36
28	2014-06-30	25	1
29	2014-07-01	6	36
30	2014-07-01	5	2
31	2014-07-01	29	2
32	2014-07-01	11	2
33	2014-07-01	3	2
34	2014-07-01	2	2
35	2014-07-01	1	2
36	2014-07-01	7	36
37	2014-07-02	15	2
38	2014-07-02	14	2
39	2014-07-07	43	51
40	2014-07-07	6	51
41	2014-07-07	7	51
42	2014-07-07	42	51
43	2014-07-08	8	51
44	2014-07-08	17	51
45	2014-07-09	9	36
46	2014-07-09	9	51
47	2014-07-09	41	51
48	2014-07-09	40	51
49	2014-07-09	19	51
50	2014-07-09	11	51
51	2014-07-09	12	36
52	2014-07-11	5	51
53	2014-07-11	26	3
54	2014-07-11	19	3
55	2014-07-12	20	3
56	2014-07-12	24	3
57	2014-07-12	21	3
58	2014-07-12	22	3
59	2014-07-13	30	3
60	2014-07-13	28	3
61	2014-07-13	29	3
62	2014-07-13	43	3
63	2014-07-13	42	3
64	2014-07-14	11	5
65	2014-07-14	15	5
66	2014-07-14	10	4
67	2014-07-14	13	4
68	2014-07-15	34	5
69	2014-07-15	14	5
70	2014-07-15	35	5
71	2014-07-15	17	5
72	2014-07-15	13	5
73	2014-07-15	12	5
74	2014-07-19	15	6
75	2014-07-19	31	6
76	2014-07-20	33	6
77	2014-07-20	42	6
78	2014-07-20	32	6
79	2014-07-20	43	6
80	2014-07-21	18	6
81	2014-07-21	25	6
82	2014-07-22	16	7
83	2014-07-22	22	7
84	2014-07-22	27	7
85	2014-07-22	28	7
86	2014-07-26	23	7
87	2014-07-26	20	7
88	2014-07-26	21	7
89	2015-06-01	24	8
90	2015-06-01	27	9
91	2015-06-01	26	8
92	2015-06-02	17	9
93	2015-06-03	15	9
94	2015-06-04	29	9
95	2015-06-08	25	8
96	2015-06-08	23	8
98	2014-08-01	36	44
99	2014-08-01	38	44
100	2014-06-14	42	46
101	2014-06-14	43	46
102	2014-08-02	20	45
103	2014-08-02	21	45

StateName	StateAbbreviation
Alaska	AK
Alabama	AL
Arkansas	AR
Arizona	AZ
California	CA
Colorado	CO
Connecticut	CT
District of Columbia	DC
Delaware	DE
Florida	FL
Georgia	GA
Hawaii	HI
Iowa	IA
Idaho	ID
Illinois	IL
Indiana	IN
Kansas	KS
Kentucky	KT
Louisiana	LA
Massachusetts	MA
Maryland	MD
Maine	ME
Michigan	MI
Minnesota	MN
Missouri	MO
Mississippi	MS
Montana	MT
North Carolina	NC
North Dakota	ND
Nebraska	NE
New Hampshire	NH
New Jersey	NJ
New Mexico	NM
Nevada	NV
New York	NY
Ohio	OH
Oklahoma	OK
Oregon	OR
Pennsylvania	PA
Rhode Island	RI
South Carolina	SC
South Dakota	SD
Tennessee	TN
Texas	TX
Utah	UT
Virginia	VA
Vermont	VT
Washington	WA
Wisconsin	WS
West Virginia	WV
Wyoming	WY

Category	Description
Adventure	Adventure tours include skiing, scuba, biking, hiking, and climbing tours.
Cultural	Cultural tours focus on historical festivals and cultural exchange.
Educational	Educational tours offer college credit.
Family	Family tours include weddings and reunions.
Service	Service tours send volunteer workers to areas hit by natural disasters.
Site Seeing	Site seeing tours focus on tourist attractions.
Sports	Sports tours offer a special inside look at major league sporting events.

TourNo	TourName	TourStartDate	Duration	City	StateAbbrev	Category	Price
1	Stanley Bay Shelling	2014-07-06	3	Captiva	FL	Adventure	¤ 750.00
2	Red Reef Scuba	2014-07-06	3	Islamadora	FL	Adventure	¤ 1,500.00
3	Ames Ski Club	2015-01-02	7	Breckenridge	CO	Adventure	¤ 850.00
4	Boy Scout Jamboree	2015-01-13	7	Vail	CO	Adventure	¤ 1,900.00
5	Bridgewater Country	2015-02-15	10	Aspen	CO	Adventure	¤ 1,200.00
6	Franklin Family Reunion	2015-03-11	3	Breckenridge	CO	Family	¤ 700.00
7	Spare Tire Ski Club	2015-03-13	7	Monmouth	WA	Adventure	¤ 600.00
8	Eagan Family Reunion	2015-06-12	7	Osage Beach	MO	Family	¤ 500.00
9	Gunnison Bikers	2015-06-20	4	Kimberling City	MO	Adventure	¤ 250.00
10	Golden Footsteps	2014-05-23	4	Orlando	FL	Site Seeing	¤ 550.00
11	Hummer Trail	2014-05-30	7	Key West	FL	Site Seeing	¤ 725.00
12	Piper-Heitman Wedding	2014-05-30	7	Captiva	FL	Family	¤ 825.00
13	High Adventurers	2014-06-05	7	Ft. Lauderdale	FL	Adventure	¤ 575.00
15	Patriot Debate Club	2014-06-12	7	Orlando	FL	Site Seeing	¤ 605.00
17	Tropical Sailboats	2014-06-19	7	Key West	FL	Adventure	¤ 655.00
18	Eagle Hiking Club	2014-06-19	7	Aspen	CO	Adventure	¤ 695.00
19	Paradise Water Club	2014-06-26	7	Hollister	MO	Adventure	¤ 595.00
20	Team Discovery	2014-06-29	5	Breckenridge	CO	Adventure	¤ 550.00
21	Gulfside Birdwatchers	2014-06-29	7	Tampa Bay	FL	Adventure	¤ 700.00
22	Perfect Waves	2014-06-27	5	Huntington Beach	CA	Adventure	¤ 500.00
23	Outrigger Cleanup	2014-06-29	7	Biloxi	MS	Service	¤ 395.00
24	Blue Canyon Youth	2014-07-01	7	New Orleans	LA	Service	¤ 425.00
25	Emmanuel Youth Club	2014-07-01	7	Diaberville	MS	Service	¤ 500.00
26	Dalgren-Smith Wedding	2014-07-02	3	West Des Moines	IA	Family	¤ 300.00
27	Lang Reunion	2014-07-02	3	Des Moines	IA	Family	¤ 350.00
28	Buehler Reunion	2014-07-02	4	Kimberling City	MO	Family	¤ 395.00
29	Silver Country	2014-07-13	14	Sacramento	CA	Educational	¤ 1,200.00
30	Monterey Mysteries	2014-07-14	7	Monterey	CA	Educational	¤ 800.00
31	Washington DC Band	2014-07-13	7	Washington	DC	Educational	¤ 890.00
33	Broadway Workshops	2014-08-24	7	New York City	NY	Educational	¤ 1,000.00
34	Colonial Tour	2014-08-19	14	Washington	DC	Educational	¤ 3,000.00
35	Freedom Tour	2014-08-24	7	Boston	MA	Educational	¤ 1,000.00
36	American Heritage Tour	2014-08-24	7	Philadelphia	PA	Educational	¤ 1,200.00
37	Cactus Language Exploration	2014-09-14	7	San Diego	CA	Educational	¤ 800.00
38	Water Education Foundation	2014-09-21	14	Fresno	CA	Educational	¤ 1,300.00
39	Oakland Museum of Science	2014-07-20	7	Oakland	CA	Educational	¤ 1,000.00
40	Redwood Forest Lab	2014-09-29	14	Mill Valley	CA	Educational	¤ 1,500.00
41	Langguth History	2014-10-19	10	Napa	CA	Site Seeing	¤ 900.00
43	Japanese California Connection	2014-08-19	4	Bolinas	CA	Cultural	¤ 424.00
44	Bear Valley Adventures	2014-08-19	3	Sacramento	CA	Adventure	¤ 725.00
45	Black Sheep Hiking Club	2014-08-26	14	El Dorado Hills	CA	Adventure	¤ 525.00
46	Bigfoot Rafting Club	2014-07-13	4	Placerville	CA	Adventure	¤ 455.00
47	Yosemite National Park Great Cleanup	2014-07-20	3	Sacramento	CA	Service	¤ 1,100.00
48	Kings Canyon Bridge Builders	2014-07-13	10	Three Rivers	CA	Service	¤ 950.00
49	Golden State Tours	2014-07-20	10	Sacramento	CA	Cultural	¤ 1,400.00
51	Bright Lights Expo	2014-12-01	7	Branson	MO	Site Seeing	¤ 200.00
52	Missouri Bald Eagle Watch Club	2014-08-13	7	Hollister	MO	Adventure	¤ 700.00

SELECT TourCategories.Category FROM TourCategories;

PARAMETERS __TourNo Value; SELECT DISTINCTROW * FROM CustomerSales AS CustomerRoster WHERE ([__TourNo] = TourNo);

SELECT States.StateAbbreviation, States.StateName FROM States;

SELECT DISTINCTROW * FROM States;

SELECT DISTINCTROW * FROM Tours;

SELECT Customers.CustNo, [LName] & ", " & [FName] AS CustomerName FROM Customers ORDER BY [LName] & ", " & [FName];

SELECT [States].[StateName], [States].[StateAbbreviation] FROM States ORDER BY [StateAbbreviation];

SELECT Sales.SalesNo, Customers.LName, Customers.FName, Tours.TourName FROM Tours INNER JOIN (Customers INNER JOIN Sales ON Customers.CustNo = Sales.CustNo) ON Tours.TourNo = Sales.TourNo ORDER BY Customers.LName, Customers.FName, Tours.TourName;

SELECT States.StateAbbreviation, States.StateAbbreviation, States.StateName FROM States ORDER BY States.StateName;

PARAMETERS __Category Value; SELECT DISTINCTROW * FROM Tours AS ToursByCategory WHERE ([__Category] = Category);

SELECT TourCategories.Category FROM TourCategories;

SELECT DISTINCTROW * FROM Tours;

SELECT DISTINCTROW * FROM Customers;

SELECT DISTINCTROW * FROM TourCategories;

SELECT DISTINCTROW * FROM Tours;

SELECT Customers.CustNo AS Customers_CustNo, Customers.FName, Customers.LName, Customers.Street, Customers.City, Customers.State, Customers.Zip, Customers.Phone, Sales.SalesNo, Sales.SaleDate, Sales.CustNo, Sales.TourNo, Tours.TourNo, Tours.TourName, Tours.TourStartDate, Tours.Duration, Tours.City, Tours.StateAbbrev, Tours.Category, Tours.Price FROM Tours INNER JOIN (Customers INNER JOIN Sales ON Customers.CustNo = Sales.CustNo) ON Tours.TourNo = Sales.TourNo WHERE (((Sales.SalesNo)=[Forms]![Switchboard]![cboFindCustomer]));

SELECT Customers.CustNo, Customers.FName, Customers.LName, [LName] & ", " & [FName] AS CustomerName, Customers.Street, Customers.City, Customers.State, Customers.Zip, Customers.Phone, Customers.FirstContact, Sales.TourNo, Sales.CustNo, Sales.SaleDate FROM Customers INNER JOIN Sales ON Customers.CustNo = Sales.CustNo;

SELECT Tours.TourName, Customers.LName, Customers.FName, Sales.SaleDate FROM Tours INNER JOIN (Customers INNER JOIN Sales ON Customers.CustNo = Sales.CustNo) ON Tours.TourNo = Sales.TourNo ORDER BY Tours.TourName, Customers.LName;

SELECT Tours.TourName, Tours.TourStartDate, Tours.Duration, Tours.City, Tours.StateAbbrev, Tours.Category, Tours.Price, Sales.SaleDate, Customers.FName, Customers.LName, Customers.Street, Customers.City, Customers.State, Customers.Zip, Customers.Phone, Customers.FirstContact FROM Tours INNER JOIN (Customers INNER JOIN Sales ON Customers.CustNo = Sales.CustNo) ON Tours.TourNo = Sales.TourNo ORDER BY Tours.TourName;

SELECT TourCategories.Category, Tours.TourName, Tours.TourStartDate, Tours.Price FROM TourCategories INNER JOIN Tours ON TourCategories.Category = Tours.Category ORDER BY TourCategories.Category, Tours.TourName;

SELECT States.StateName, Tours.TourName, Tours.TourStartDate, Tours.Price, States.StateAbbreviation FROM States INNER JOIN Tours ON States.StateAbbreviation = Tours.StateAbbrev WHERE (((States.StateAbbreviation)=[Forms]![Switchboard]![cboFindState])) ORDER BY States.StateName, Tours.TourName;

Access Unit A/RealEstate-A.accdb

AgencyNo	AgencyName	Street	City	State	Zip	AgencyPhone
1	Four Lakes Realtors	123 First Street	Kimberling City	MO	77889	555-666-7700
2	Marvin and Pam Realtors	7878 Lake View Lane	Branson	MO	77770	555-555-8800
3	Emerald Point Realtors	9900 West Sunset Drive	West Branson	MO	77990	555-999-9999
4	Hollister Real Estate	7744 Pokeberry Lane	Hollister	MO	77660	555-888-4444

Type
Cabin
Condo
Log Cabin
Patio Home
Ranch
Two Story

ListingNo	Type	SchoolDistrict	SqFt	LotAcres	BR	Bath	Garage	Pool	Asking	RealtorNo	ListingDate
1	Ranch	Ozark Mountain	3400	0.5	4	4.0	2	false	¤ 90,000.00	1	2014-01-04
2	Ranch	Ridgedale	3000	0.5	2	3.0	0	false	¤ 129,000.00	1	2014-01-05
3	Cabin	Ridgedale	2900	0.5	3	2.5	2	false	¤ 135,000.00	1	2014-01-31
4	Cabin	Horseshoe Bend	1200	0.4	4	3.0	2	false	¤ 150,000.00	2	2014-03-01
5	Ranch	Ridgedale	2500	1.0	3	2.5	0	false	¤ 199,000.00	2	2014-04-01
7	Two Story	Ozark Mountain	3000	1.0	4	4.0	2	false	¤ 276,000.00	2	2014-05-01
8	Two Story	Shell City	1800	0.4	3	3.0	2	false	¤ 138,000.00	2	2014-06-01
9	Ranch	Horseshoe Bend	2000	1.5	3	3.5	0	false	¤ 105,000.00	7	2014-03-01
10	Ranch	Ridgedale	2000	0.5	3	3.0	2	false	¤ 250,000.00	8	2014-04-01
11	Ranch	Ridgedale	1215	0.5	3	2.0	0	false	¤ 85,000.00	1	2014-03-01
12	Ranch	Greenview	2200	0.7	3	3.0	2	false	¤ 395,613.00	2	2014-05-01
13	Two Story	Blue Eye	3000	0.5	4	3.0	2	false	¤ 199,950.00	3	2014-05-01
14	Two Story	Greenview	5500	0.4	4	2.5	3	true	¤ 194,500.00	3	2014-06-01
15	Two Story	Branson West	2500	0.6	3	2.0	2	false	¤ 189,900.00	3	2014-01-05
16	Ranch	Branson	2700	0.6	4	3.0	2	false	¤ 189,900.00	4	2003-04-01
17	Log Cabin	Cape Fair	2000	1.0	3	2.0	0	false	¤ 189,900.00	4	2014-05-01
18	Ranch	Kimberling City	2500	1.2	3	4.0	2	false	¤ 189,900.00	4	2014-05-15
19	Two Story	Shell City	3200	0.9	3	4.5	0	false	¤ 187,500.00	4	2004-05-31
20	Two Story	Kimberling City	2700	1.0	3	3.0	2	false	¤ 147,900.00	4	2014-06-15
21	Patio Home	Kimberling City	2200	0.4	2	2.0	1	true	¤ 139,900.00	4	2014-07-01
22	Cabin	Kimberling City	1350	0.7	2	2.0	2	false	¤ 127,900.00	5	2014-01-04
23	Two Story	Galena	2000	0.5	4	1.0	0	false	¤ 124,900.00	5	2014-01-31
24	Patio Home	Galena	1200	0.4	3	2.0	0	false	¤ 120,000.00	6	2014-05-01
25	Cabin	Kimberling City	1900	0.5	3	1.0	0	false	¤ 111,900.00	8	2014-04-01
26	Ranch	Lampe	3000	2.0	3	2.5	3	false	¤ 399,999.00	8	2014-05-15
27	Cabin	Oakmont	2000	1.2	4	3.0	0	false	¤ 280,000.00	1	2014-03-02

RealtorNo	RFirst	RLast	RPhone	AgencyNo
1	Gordon	Bono	555-222-8877	1
2	Phil	Kirkpatrick	555-111-9900	1
3	Jessica	Podor	555-333-3344	3
4	Malika	Thompson	555-444-7788	3
5	Jane Ann	Welch	555-223-0044	2
6	Shari	Duncan	555-228-5577	2
7	Trixie	Angelina	555-220-4466	2
8	Mary	Baldwin	555-888-7777	1
9	Deb	Trumpet	555-333-0123	1
10	Cy	Clone	555-888-9999	4
11	Rob	Zacharias	555-888-1111	4

PARAMETERS __RealtorNo Value; SELECT DISTINCTROW * FROM Listings AS RealtorsMainForm WHERE ([__RealtorNo] = RealtorNo);

SELECT DISTINCTROW * FROM Listings;

SELECT DISTINCTROW * FROM Realtors;

SELECT Agencies.AgencyName, Listings.SchoolDistrict, Listings.Type, Listings.SqFt, Listings.Asking FROM (Agencies INNER JOIN Realtors ON Agencies.AgencyNo = Realtors.AgencyNo) INNER JOIN Listings ON Realtors.RealtorNo = Listings.RealtorNo ORDER BY Agencies.AgencyName;

SELECT Realtors.RFirst, Realtors.RLast, Listings.Type, Listings.SqFt, Listings.Asking FROM Realtors INNER JOIN Listings ON Realtors.RealtorNo = Listings.RealtorNo;

Access Unit A/Recycle-A.accdb

CenterName	CenterStreet	CenterCity	CenterState	CenterZip	CenterPhone	ContactFirst	ContactLast	CenterNumber	Hazardous
Hugo Trash Can	987 Main Street	Lenexa	KS	61111	5551236666	Benjamin	Knox	1	true
Barker Trash	12345 College Boulevard	Overland Park	KS	63444	5552227897	Phyllis	Stein	2	true
Taney County Landfill	12444 Murlen Drive	Shawnee	KS	64222	5557809999	John	Sharona	3	false
Stone County Landfill	78900 180th Street	Olathe	KS	65444	5551111234	Emir	Cipra	4	false

ClubNumber	ClubName	ClubStreet	ClubCity	ClubState	ClubZip	ClubPhone	FName	LName
1	Jaycees	111 Elm Street	Overland Park	KS	66213	5551238888	Francis	Bender
2	Boy Scout Troop 7	22 West 67th Drive	Mission	KS	60603	5551117777	Mason	Schaffer
3	Great Plains 4-H	44 East 99th Road	Lenexa	KS	66111	5552222222	Renaldo	Holt
4	Lions of Fontanelle	777 Oxford Street	Fontanelle	KS	66333	5553333111	Cory	Mills
5	Junior League	3333 Princeton Lane	Point Lookout	MO	55886	7772134333	Lottie	Moon
6	Ice Kings	55 Oak Drive	Ridgedale	MO	55887	7771224444	Tara	Jackson
7	KC Patriots	888 Switzer Street	Kansas City	MO	55888	7772223333	Trixie	Cho

DepositDate	Weight	CenterNumber	ClubNumber	DepositID
2012-01-31	60.0	4	1	1
2012-01-31	100.0	4	1	2
2012-02-05	75.0	2	4	3
2012-02-05	80.0	1	4	4
2012-02-09	150.0	2	5	5
2012-02-14	200.0	2	6	6
2012-02-15	50.0	2	1	7
2012-02-17	50.0	1	7	8
2012-02-18	40.0	3	1	9
2012-02-19	100.0	4	7	10
2012-02-21	200.0	4	2	11
2012-02-23	75.0	4	6	12
2012-02-24	80.0	1	4	13
2012-02-27	100.0	4	6	14
2012-03-01	150.0	2	5	15
2012-03-02	70.0	4	4	16
2012-03-03	100.0	3	7	17
2012-03-04	150.0	3	5	18
2012-03-05	200.0	4	1	19
2012-03-06	50.0	2	6	20
2013-01-30	60.0	1	1	21
2013-01-30	100.0	2	6	22
2013-02-04	80.0	1	4	23
2013-02-04	75.0	4	4	24
2013-02-08	150.0	2	5	25
2013-02-13	185.0	2	6	26
2013-02-14	50.0	4	1	27
2013-02-16	35.0	1	7	28
2013-02-17	40.0	3	1	29
2013-02-18	185.0	4	6	30
2013-02-20	200.0	3	2	31
2013-02-22	75.0	4	5	32
2013-02-23	80.0	1	4	33
2013-02-26	65.0	2	4	34
2013-03-02	150.0	1	5	35
2013-03-03	50.0	3	4	36
2013-03-04	45.0	3	7	37
2013-03-05	75.0	4	5	38
2013-03-06	200.0	1	1	39
2013-03-07	145.0	4	6	40
2013-04-19	115.0	4	6	41
2013-04-20	65.0	4	1	42
2013-04-22	105.0	2	1	43
2013-04-23	90.0	4	2	44
2013-04-25	65.0	1	1	45
2013-04-30	205.0	3	2	46
2013-05-01	105.0	4	6	47
2013-05-07	190.0	3	2	48
2013-06-04	90.0	4	4	49
2013-06-07	65.0	3	4	50
2013-06-19	65.0	1	4	51
2013-06-20	85.0	4	5	52
2013-06-22	95.0	3	1	53
2013-07-07	75.0	3	5	54
2013-07-08	200.0	2	1	55
2013-08-31	50.0	4	6	56
2013-09-24	200.0	2	5	57
2013-10-01	90.0	3	5	58
2013-10-02	90.0	4	4	59
2013-10-04	80.0	2	5	60
2014-01-04	60.0	1	2	61
2014-01-06	90.0	2	7	62
2014-02-14	50.0	3	7	63
2014-02-18	30.0	2	2	64
2014-02-21	50.0	4	6	65
2014-02-22	100.0	3	6	66
2014-02-28	125.0	2	4	67
2014-03-16	60.0	1	2	68
2014-04-04	115.0	1	4	69
2014-04-19	105.0	1	2	70
2014-05-19	90.0	2	2	71
2014-05-20	80.0	3	1	72
2014-05-21	50.0	4	1	73
2014-06-01	60.0	4	6	74
2014-06-02	65.0	3	4	75
2014-06-08	75.0	3	5	76
2014-06-09	95.0	2	2	77
2014-06-10	90.0	2	1	78
2014-07-11	85.0	1	2	79
2014-07-12	95.0	1	4	80
2014-07-17	65.0	4	6	81
2014-07-18	85.0	3	4	82
2014-07-20	45.0	2	5	83
2014-08-20	205.0	1	7	84
2014-08-21	105.0	2	1	85
2014-09-19	30.0	3	2	86
2014-10-20	60.0	4	4	87
2014-10-21	40.0	3	4	88
2014-10-31	90.0	2	4	89
2014-11-01	80.0	1	1	90
2014-11-02	25.0	2	4	91
2014-11-03	100.0	4	2	92
2014-11-17	85.0	4	5	93
2014-11-18	75.0	3	5	94
2014-11-19	85.0	3	6	95
2014-11-30	90.0	3	5	96
2014-12-02	80.0	2	6	97
2014-12-04	70.0	2	7	98
2014-12-07	80.0	1	7	99
2014-12-09	50.0	4	6	100

Access Unit B/Baseball-B.accdb

PlayerNumber	PlayerFirst	PlayerLast	PlayerNickname	PlayerPhone	PlayerPosition	Insurance	Uniform	TeamNumber
10000	Louis	Gehrig	Lou	9137623444	5	true	true	7
10001	Sanford	Koufax	Sandy	9133231212	2	true	true	7
10002	Barb	Rickey	Barbie	9132129878	7	true	true	7
10003	George	Ruth	Babe	9133131234	7	true	true	3
10004	Teddie	Williams	Ted	9143230900	9	true	true	7
10005	Cycylie	Young	Sid	9132423212	2	true	true	1
10006	Abner	Doubleday	Abby	9131213212	3	true	true	5
10007	Roggie	Hornsby	Tex	9132422345	4	true	true	7
10008	Mickey	Mantle	Mick	9132425678	9	true	true	1
10009	Jackie	Robinson	Jackie	9132423123	7	true	true	1
10010	Roy	Campanella	Roy	9132521321	1	true	true	1
10011	Tyrus	Cobb	Ty	8169192343	8	true	true	3
10012	Carl	Mathewson	Cookie	9132928384	2	true	true	5
10013	Henrietta	Aaron	Henry	8169274638	7	true	true	5
10014	Joey	DiMaggio	Joe	9138283848	5	true	true	3
10015	Charles	Ford	Whitey	9132435667	1	true	true	3
10016	Francis	Frampton	Chris	9132546789	8	true	true	5
10017	Bill	Mayes	Willie	9134565678	6	true	true	1
10018	Stanley	Musial	Stan	9132459876	3	true	true	3
10019	Leroy	Paige	Satchel	9137876523	3	true	true	1
10020	James	Thorpe	JT	9134563789	4	true	false	3
10021	John	Wagner	Jimmy	8166546789	8	true	true	7
10022	John	Bench	Johnny	9132857451	6	true	true	3
10023	Louise	Brock	Lou	9134456543	4	false	true	5
10024	Abner	Chandler	Abby	8164562098	6	true	true	7
10025	Roger	Maris	Roger	9137652845	8	true	false	1
10026	Alfred	Martin	Al	9132456483	6	true	true	5
10027	Greg	Perry	Greg	9137654876	2	true	true	3
10028	George	Plimpton	Bruiser	8162458742	3	true	true	7
10029	Frank	Robinson	Fred	9130897654	9	false	false	3
10030	Nolan	Ryan	Slick	9136765432	5	false	false	5
10031	Warren	Spahn	Warren	8165478923	4	true	true	1
10032	Andrew	Spalding	Addie	9134937592	1	true	false	7
10033	Roberta	Clemente	Bob	9138642725	9	false	false	5
10034	Jeffrey	Dean	Speedy	8166602748	5	true	false	1
10035	Luis	Durocher	Pop	9137652845	1	false	false	5

FieldName	GameDate	GameTime	HomeTeamNumber	VisitorTeamNumber
Wriggley	2015-06-04	1899-12-30	1	2
Ebbetts	2015-06-04	1899-12-30	3	4
Center	2015-06-04	1899-12-30	5	6
The Junkyard	2015-06-04	1899-12-30	7	8
Wriggley	2015-06-11	1899-12-30	2	3
Ebbetts	2015-06-11	1899-12-30	4	5
Center	2015-06-11	1899-12-30	6	7
The Junkyard	2015-06-11	1899-12-30	8	1
Wriggley	2015-06-18	1899-12-30	1	4
Ebbetts	2015-06-18	1899-12-30	3	6
Center	2015-06-18	1899-12-30	5	8
The Junkyard	2015-06-18	1899-12-30	7	2
Wriggley	2015-06-25	1899-12-30	2	5
Ebbetts	2015-06-25	1899-12-30	4	7
Center	2015-06-25	1899-12-30	6	1
The Junkyard	2015-06-25	1899-12-30	8	3
Wriggley	2015-07-02	1899-12-30	1	8
Ebbetts	2015-07-02	1899-12-30	3	2
Center	2015-07-02	1899-12-30	5	4
The Junkyard	2015-07-02	1899-12-30	7	6
Wriggley	2015-07-09	1899-12-30	1	2
Ebbetts	2015-07-09	1899-12-30	3	4
Center	2015-07-09	1899-12-30	5	6
The Junkyard	2015-07-09	1899-12-30	7	8

TeamNumber	TeamName	TeamSponsor	TeamCity	TeamState
1	Brooklyn Beetles	Brooklyn Bagles & More	Brooklyn	NY
2	Blue Herons	Hilda's House of Hair	Boston	MA
3	Snapping Turtles	Snappy's Lawn Mowers	Philadelphia	PA
4	Louie's Sluggers	Louie's Sport Shop	New York City	NY
5	Mayfair Monarchs	Uptown Formal Wear	Washington	DC
6	The Seahorses	Sheila's Shell Shop	Trenton	NJ
7	Rocky's Rockets	Rocky's Rocket Drive-In	Concord	MA
8	Yellow Jackets	Mellow Yellow Book Shop	Cambridge	MA

Access Unit B/Congress-B.accdb

ID	LName	FName	StateAbbrev
1	Ackerman	Juan	NY
2	Jackson	Allen	AL
3	Blunt	Bobby	MO
4	Boustany	David	LA
5	Baker	Deborah	ME
6	Bass	Fortney	NJ
7	Goodlatte	Richard	CA
8	Green	Zoe	AL
9	Boucher	George	DC
10	Alexander	Greg	LA
11	Capito	Juan	WS
12	Brady	Jeff	SC
13	Brown	John	GA
14	Allen	Mike	MD
15	Blackburn	Randy	TX
16	Berkley	Sam	NH
17	Barrow	Bennie	IL
18	Capps	Brad	CO
19	Scott	Rick	CA
20	Akin	Stephanie	NV
21	Larsen	Alcee	CA
22	Davis	Bart	AR
23	Bean	Benjamin	IL
24	Smith	Betty	CA
25	Boyd	Bobby	FL
26	Bonilla	Chris	UT
27	Bishop	Charles	GA
29	Brown	Christopher	TN
30	Boren	Dave	OR
31	Capuano	Devin	MO
32	Andrews	Ed	NY
33	Butterfield	Ed	OH
34	Burgess	Emanuel	TX
35	Sessions	Frank	AL
36	Rodgers	Fred	CA
37	Forbes	Gresham	AR
39	Brown	Jerry	OK
40	Buyer	Joe	IA
41	Cannon	Jim	VA
42	Boswell	Lucas	LA
43	Bilirakis	Aioko	FL
44	Bradley	John	NH
45	Brady	Judy	TX
46	Blumenauer	Jon	PA
47	Beauprez	Kay	FL
48	Barrett	Mark	SC
49	Boehner	Luis	OH
50	Brown	Leonard	FL
51	Barton	Stephen	TX
52	Burton	Mark	IN
53	Boehlert	Michael	NC
54	Biggert	Michael	IN
55	Solis	Nancy	CA
56	Visclosky	Paul	MI
57	Inslee	Peter	CA
58	Bishop	Rick	UT
59	Cantor	Rob	VA
60	Baird	Robert	WV
61	Reichert	Rodney	CA
62	Bartlett	Rodney	MA
63	Lipinski	Ron	MD
64	Ross	Scott	CA
65	Wynn	Steve	MO
66	Mack	Steve	IN
67	Istook	Ted	TX
68	Hefley	Thelma	HI
69	Herger	Thomas	DE
70	Engel	Totoro	OH
71	Lewis	Tom	KT
72	Crenshaw	Trent	IN
74	Gilchrest	Bart	MO
75	Cardin	Don	MO
76	Kaptur	Jack	SC
77	LoBiondo	Melissa	NC
78	Meeks	Robin	OK
79	Pitts	Susan	TX
80	Leach	Todd	MI
81	Pryce	Donald	TN
82	Shadegg	Joe	CA
83	Johnson	Koito	IL
84	Granger	Sanford	AL
85	Lofgren	Sherrod	FL
86	Taylor	Corrine	NY
87	Marchant	Bill	WY
88	DeFazio	Butch	TX
89	Walden	Carolyn	TX
90	Gutierrez	Charles	MD
91	Smith	David	AL
92	Harris	Duncan	IL
93	Kingston	Frank	KT
94	Miller	Doris	FL
95	Wamp	Jane	VA
96	Chabot	Gary	TN
97	Young	Dumar	CA
98	Inglis	Jeb	VA
99	Salazar	Tamar	GA
100	Nadler	Kendrick	OR
102	Schakowsky	Mario	MA
103	Issa	Mark	CT
104	Dent	Peter	TX
105	Price	Rick	PA
106	Tauscher	Sander	FL
107	Woolsey	Steve	FL
108	Jenkins	Tom	DC
109	King	Virgil	MI
110	Cole	Vito	TX
111	Petri	Zach	CA
112	Pomeroy	Anthony	PA
113	Tanner	Bill	VA
114	Hastings	Diane	CA
115	LaTourette	Henry	TN
116	Wu	JoJo	TX
117	Nussle	José	MI
118	Ros	Joseph	IL
119	Van Hollen	Lane	MO
121	Miller	Malachi	PA
122	Moore	Pete	CA
123	Pallone	Rubén	NC
124	Keller	Virginia	IL
125	Johnson	Brad	AL
127	Campbell	Connie	CA
128	Weiner	Mike	PA
129	Pelosi	Sherwood	FL
130	Knollenberg	Barney	NJ
131	Berman	Bernie	CA
132	Kelly	David	PA
133	Christian	Dennis	AZ
134	Dreier	Elijah	FL
135	Ford	Ernest	VA
136	Strickland	James	TN
137	Olver	Jean	NE
138	Fortuno	Jim	FL
139	Hulshof	James	NY
140	Pascrell	Joel	NC
141	Evans	John	MA
142	McCaul	John	AZ
143	Kildee	Joseph	NJ
144	Goode	Kenny	CA
145	McCotter	Robert	NJ
146	Etheridge	Ron	PA
147	Neal	Shelley	NV
148	Manzullo	Virginia	MD
149	Udall	Chuck	OH
150	Thomas	Chase	GA
151	Fitzpatrick	Cliff	TX
152	Sullivan	Dale	TX
153	Duncan	Joseph	VA
154	Cooper	Nathan	VA
155	Ney	Stephen	TN
157	McGovern	Raymond	MO
158	Sherwood	Brian	TX
159	Peterson	Justice	TX
160	Poe	John	WS
161	Gonzalez	John	AZ
162	Diaz	Mitchell	IL
163	Jefferson	Martin	MN
164	Weldon	Mary	TX
165	Aderholt	Robert	CA
166	Napolitano	Tim	FL
167	Myrick	Cynthia	PA
168	Hastings	Dennis	IL
169	Rohrabacher	Joseph	FL
170	Cuellar	Micah	DC
171	Frelinghuysen	Richard	NC
172	Wolf	Wally	AZ
173	Royce	Al	CO
174	Kanjorski	Ander	TX
175	Bilbray	Buck	CA
176	Schmidt	Titus	SD
177	Terry	JoAnn	NY
178	Gibbons	Lois	NY
179	Gerlach	Marcy	TX
180	Pearce	Alan	OH
181	Chocola	Marion	MI
182	Coble	Artur	PA
183	Camp	Chris	NJ
184	Sensenbrenner	Debbie	CA
185	Owens	Heather	OR
186	Miller	Mary	IN
187	Lahood	Robert	MD
188	Cummings	Tasha	MO
189	Green	Xavier	CA
190	Weldon	Chris	IL
191	Tiberi	Don	SC
192	DeLay	Grace	DC
193	Thompson	Ken	NY
194	Bachus	Lamar	CA
195	Fossella	Louie	OK
196	Meek	Mac	IL
197	Doyle	Ezekiel	TX
198	Otter	Michael	LA
199	Jones	Timothy	TN
200	Simpson	Charlie	LA
201	Schwartz	Edolphus	TX
202	Radanovich	Darrell	CT
203	Holden	Jim	TX
204	Simmons	Earl	IL
205	McHugh	Mookie	OH
206	Garrett	John	NC
207	Gillmor	John	PA
208	Reynolds	John	OH
209	Watson	Lloyd	FL
210	McCollum	Roman	NY
211	Northup	Richard	MN
212	Ryan	Roy	RI
213	Tiahrt	Steven	MI
214	Souder	Trent	MI
215	Neugebauer	James	WS
216	Oberstar	John	NY
217	Putnam	Isaiah	IA
218	Lee	Linda	GA
219	Wexler	Michael	IL
220	McCrery	Nick	MN
221	Pence	Phil	MI
222	Drake	Robert	AZ
223	Slaughter	Nydia	OH
224	Rehberg	Terry	NY
225	Castle	Thomas	IL
226	Turner	Walter	RI
227	Becerra	Adam	CA
228	Carter	Bob	DC
229	Pombo	Clay	CT
230	Davis	Dan	IA
231	Higgins	Dana	OH
232	Gingrey	Eliot	IA
233	Franks	Ike	CA
234	Latham	Jim	MI
235	Baca	Silvestre	CA
236	Udall	Ralph	GA
237	Marshall	Geoff	KT
238	Davis	Mike	GA
239	Shays	Thaddeus	IL
240	Conyers	Ben	NJ
241	Grijalva	Harold	CA
242	Schwarz	Paul	NY
243	Sweeney	Bozno	OK
244	Renzi	Candice	CA
245	Davis	Albert	MA
246	Lantos	Frank	FL
247	Cleaver	Gregory	NY
248	DeLauro	Gwen	IL
249	Murphy	Carlos	TX
250	Hyde	Juanita	MA
251	Calvert	Marilyn	GA
252	Wilson	Forrest	UT
253	Flake	Holly	CA
254	Osborne	Mike	NY
255	Fattah	Rob	TX
256	Davis	Ron	MN
257	Hostettler	Steny	MI
258	Jackson	Nancy	LA
259	Conaway	Todd	DC
260	Hastert	Wayne	MA
261	Holt	Arnold	NC
262	Carnahan	Bill	NY
263	Rothman	Robin	NC
264	Farr	David	CA
265	Cardoza	Ellen	GA
266	Clay	Jorge	NY
267	Sodrel	Jerry	MA
268	Sanchez	Jerry	FL
269	Wicker	Luke	NY
270	Case	John	LA
271	Levin	Justin	NJ
272	Gallegly	Lennie	FL
273	Johnson	Julia	ME
274	Harman	Kenny	CA
275	Menendez	Michael	NC
276	Carson	Major	MI
277	Sherman	Lincoln	CA
278	Snyder	Lucille	CA
279	Miller	Lynn	FL
280	Johnson	Mike	WV
281	Linder	Rahm	KS
282	Hensarling	Ray	WS
283	McKinney	Sam	KS
284	Davis	Solomon	VA
285	Watt	Sue	PA
286	McIntyre	Timothy	PA
287	Stark	LeRoy	CO
288	Payne	Tom	NC
289	Graves	Vernon	NY
290	Dicks	Chin	CA
291	Shimkus	Daniel	MA
292	Murtha	Eric	TX
293	McCarthy	Gil	OH
294	Deal	Jeff	KT
296	Thompson	John	GA
297	Rahall	Louise	CA
298	Wasserman	Luis	IA
299	Whitfield	Mark	MN
300	Reyes	Melissa	WS
301	Weller	Pete	MA
302	Shuster	Ted	TX
303	Frank	Tom	NE
304	DeGette	Paul	ID
305	Pickering	Bob	NY
306	Hinchey	Chaka	OH
307	Kilpatrick	Curt	NJ
308	Ehlers	Henry	NJ
309	Gohmert	Jim	AZ
310	Hart	John	TX
311	Rogers	Ziphira	NJ
312	Miller	Corkie	NM
313	Obey	John	CA
314	Stearns	Obed	IN
315	Rogers	Quentin	MN
316	Taylor	Pete	PA
317	Paul	Ralph	WS
318	Melancon	Lee	MS
319	McHenry	Rosa	PA
320	Kuhl	Steven	PA
321	Langevin	Tim	TX
322	McDermott	Todd	CA
323	Wilson	Brian	ND
324	Delahunt	Danny	NV
325	Smith	Katherine	NC
326	Tancredo	Jim	GA
327	Crowley	Sue	OH
328	Schiff	Emir	FL
329	Bonner	Doc	CA
330	Green	Jim	WV
331	Lewis	LeJuan	MN
332	Porter	William	NY
333	Towns	Carter	OH
334	Meehan	Donna	MT
335	Doggett	Ed	DC
336	Sanders	Elton	AZ
337	English	Fredrick	TX
338	Sabo	Gary	NY
339	Thornberry	Harold	DC
340	Price	Jim	KT
341	Hall	Jay	AL
342	Ryun	Moses	MI
343	Everett	Maxine	CA
344	Lungren	Mel	FL
345	Moran	Nita	AR
346	Dingell	Pat	NJ
347	Bono	Patrick	CA
349	Kirk	Sheila	MD
350	Larson	Shelley	IL
351	Ortiz	John	WS
352	Serrano	Vic	OH
353	Westmoreland	John	KS
354	Jindal	Anne	MN
355	Eshoo	Cathy	CO
356	Mollohan	Daniel	CA
357	Kind	Matthew	CA
358	Clyburn	Steve	VT
359	Hoekstra	William	NJ
360	Mica	Jerry	IL
361	Berry	Sasha	CA
362	Israel	Dave	OH
363	Foxx	Denny	PA
364	Moran	Ed	MI
365	McKeon	Gene	GA
366	Herseth	Howard	VA
367	Hinojosa	JoAnn	WS
368	Platts	Tom	TX
369	Ramstad	Tammy	NY
370	Matheson	Barbara	AZ
371	Sanchez	Bob	FL
372	Honda	Carolyn	CT
373	Ryan	Charles	CA
374	Lowey	Collin	PA
376	Jones	David	PA
377	Hunter	David	CT
378	Musgrave	Donald	ID
379	Tierney	Earl	MO
380	Emerson	Eddie	NY
381	Culberson	Howard	DC
382	Lynch	Jose	NJ
383	Hooley	Julian	TX
384	Davis	Ileana	AR
385	Feeney	Pedro	IN
386	Boozman	James	CA
387	Shaw	Jerrold	IN
388	Kucinich	Jesse	SC
389	Cubin	Timothy	CA
390	Roybal-Allard	Joe	FL
391	Velázquez	Joe	OH
392	Chandler	Kevin	MI
393	Rangel	Lincoln	OK
394	Kline	Amos	NY
395	Filner	Michael	CO
396	Regula	Mike	TN
397	Cramer	Patrick	CA
398	Saxton	Sam	NC
399	Hoyer	Raul	MS
400	Markey	Stephanie	NE
402	Michaud	Bill	MS
403	Davis	Dan	CA
404	Lucas	Charlie	TX
405	Scott	Lee	KS
406	Maloney	Roger	OH
407	Costello	Brian	MA
408	Gutknecht	Chet	NY
409	McNulty	Dennis	OH
410	Doolittle	Diana	CO
411	Upton	Enoch	NM
412	Moore	Jorge	MI
413	Rush	Henry	MD
414	Peterson	Hilda	NY
415	Young	Maurice	IN
416	King	Rush	OR
417	Fortenberry	William	NY
418	Oxley	Allyson	TN
419	Costa	Dutch	FL
420	Pastor	Jeb	CA
421	Kolbe	Mark	CA
422	Ferguson	Shayna	NC
423	Hayworth	Loretta	CA
424	Skelton	Randy	NY
425	Hayes	Spencer	PA
426	Waxman	Ric	FL
427	Foley	Chris	IL
428	Matsui	Marsha	GA
429	Waters	Phil	FL
430	Norwood	Anna	KT
431	Ruppersberger	Jack	MS
432	Stupak	John	NM
433	Hobson	Marty	SC
434	Gordon	Michael	VA
435	Nunes	Norman	CA
436	Walsh	Harper	OR
437	Emanuel	Russ	MD
438	Millender	George	FL
439	Edwards	David	AK

StateName	StateAbbrev	Capital
Alaska	AK	Juneau
Alabama	AL	Montgomery
Arkansas	AR	Little Rock
Arizona	AZ	Phoenix
California	CA	Sacramento
Colorado	CO	Denver
Connecticut	CT	Hartford
Washington	DC
Delaware	DE	Dover
Florida	FL	Tallahassee
Georgia	GA	Atlanta
Hawaii	HI	Honolulu
Iowa	IA	Des Moines
Idaho	ID	Boise
Illinois	IL	Springfield
Indiana	IN	Indianapolis
Kansas	KS	Topeka
Kentucky	KT	Frankfort
Louisiana	LA	Baton Rouge
Massachusetts	MA	Boston
Maryland	MD	Annapolis
Maine	ME	Augusta
Michigan	MI	Lansing
Minnesota	MN	St. Paul
Missouri	MO	Jefferson City
Mississippi	MS	Jackson
Montana	MT	Helena
North Carolina	NC	Raleigh
North Dakota	ND	Bismarck
Nebraska	NE	Lincoln
New Hampshire	NH	Concord
New Jersey	NJ	Trenton
New Mexico	NM	Santa Fe
Nevada	NV	Carson City
New York	NY	Albany
Ohio	OH	Columbus
Oklahoma	OK	Oklahoma City
Oregon	OR	Salem
Pennsylvania	PA	Harrisburg
Rhode Island	RI	Providence
South Carolina	SC	Columbia
South Dakota	SD	Pierre
Tennessee	TN	Nashville
Texas	TX	Austin
Utah	UT	Salt Lake City
Virginia	VA	Richmond
Vermont	VT	Montpelier
Washington	WA	Olympia
Wisconsin	WS	Madison
West Virginia	WV	Charleston
Wyoming	WY	Cheyenne

Access Unit B/Membership-B.accdb

ID	MemberNo	ActivityDate	HoursWorked
1	6	2013-12-31	8
2	7	2013-12-31	8
3	9	2013-12-31	8
4	13	2014-01-27	4
5	18	2014-01-27	4
6	12	2014-01-27	4
7	8	2014-01-27	6
8	11	2014-01-27	2
9	16	2014-01-29	5
10	14	2014-01-29	5
11	19	2014-01-29	5
12	20	2014-01-29	4
13	17	2014-01-29	5
14	28	2014-01-30	10
15	27	2014-01-30	8
16	25	2014-01-30	4
17	26	2014-01-30	4
18	13	2014-03-27	4
19	18	2014-03-27	4
20	10	2014-03-29	4
21	15	2014-03-29	4
22	20	2014-03-29	4
23	3	2014-03-29	4
24	33	2014-03-29	4
25	1	2014-03-29	4
26	17	2014-03-29	5
27	16	2014-03-29	5
28	14	2014-03-29	5
29	19	2014-03-29	5
30	15	2014-03-30	8
31	26	2014-03-30	4
32	27	2014-03-30	8
33	28	2014-03-30	10
34	25	2014-03-30	4
35	31	2014-03-30	8
36	32	2014-03-30	8
37	29	2014-03-31	8
38	6	2014-03-31	8
39	27	2014-03-31	8
40	8	2014-04-27	6
41	11	2014-04-27	2
42	1	2014-12-30	4
43	15	2014-12-30	4
44	10	2014-12-30	4
45	3	2014-12-30	4
46	2	2014-12-30	4
47	15	2014-12-31	8
48	5	2014-12-31	8
49	4	2014-12-31	8
50	13	2014-01-27	4
51	5	2015-01-22	4
52	12	2015-01-22	4
53	8	2015-01-22	6
54	11	2015-01-22	2
55	16	2015-01-24	5
56	14	2015-01-24	5
57	21	2015-01-24	5
58	20	2015-01-24	4
59	19	2015-01-24	5
60	28	2015-01-25	10
61	7	2015-01-25	8
62	25	2015-01-25	4
63	1	2015-01-25	4
64	27	2015-03-22	4
65	18	2015-03-22	4
66	10	2015-03-24	4
67	24	2015-03-24	4
68	20	2015-03-24	4
69	15	2015-03-24	4
70	2	2015-03-24	4
71	1	2015-03-24	4
72	17	2015-03-24	5
73	4	2015-03-24	5
74	22	2015-03-24	5
75	9	2015-03-24	5
76	23	2015-03-25	8
77	26	2015-03-25	4
78	3	2015-03-25	8
79	14	2015-03-25	10
80	25	2015-03-25	4
81	31	2015-03-25	8
82	32	2015-03-25	8
83	29	2015-03-26	8
84	6	2015-03-26	8
85	15	2015-03-26	8
86	8	2015-04-22	6
87	13	2015-04-22	2

FirstName	LastName	Street	ZipCode	Birthday	Dues	MemberNo	Retired
Micah	Mayberry	52411 Wornall Road	64145	1985-08-20	¤ 75.00	1	false
Allie	Eahlie	5246 Crabapple Road	64145	1970-12-25	¤ 75.00	10	false
Brenda	Daniels	661 Reagan Road	64145	1969-12-24	¤ 75.00	11	false
Sindy	Dotey	50966 Lowell Rd	66210	1961-11-01	¤ 75.00	12	false
Martha	Duman	651 N. Ambassador Drive	64153	1959-09-05	¤ 75.00	13	false
Jana	Eckert	903 East 504th St	64131	1962-04-18	¤ 75.00	14	false
Quentin	Garden	53305 W. 99th Street	66215	1955-08-14	¤ 75.00	15	true
Loraine	Goode	900 Barnes Road	50265	1961-10-06	¤ 75.00	16	false
Gabriel	Hammer	664 Carthage Rd	64131	1969-04-19	¤ 75.00	17	false
Jeremiah	Hopper	100 Main St	64111	1960-02-10	¤ 75.00	18	false
Helen	Hubert	2345 Grand Blvd	64108	1982-03-02	¤ 75.00	19	false
Josiah	Alman	2505 McGee St	64141	1979-06-04	¤ 75.00	2	false
Heidi	Kalvert	7066 College Blvd	66211	1961-09-05	¤ 100.00	20	false
Benjamin	Martin	5253 Duck Creek Dr	52240	1963-07-16	¤ 100.00	21	false
Karla	Larson	3966 Woodland Ave	50266	1962-01-06	¤ 100.00	22	false
Jose	Martin	52345 College Blvd	66210	1951-11-30	¤ 100.00	23	true
Katrina	Margolis	52345 College Blvd	66210	1970-08-01	¤ 100.00	24	false
Harvey	Mackintosh	2584 E. Meyer Blvd	64132	1970-05-23	¤ 100.00	25	false
Jon	Maxim	105 Mission Road	66206	1960-08-18	¤ 100.00	26	false
Patch	Mullins	66020 King Street	66210	1971-07-04	¤ 100.00	27	false
Young	Nelson	895 Lowell St	66210	1961-09-06	¤ 75.00	28	false
Mallory	Olson	300 Adams St	64114	1945-01-29	¤ 75.00	29	true
Bart	Bouchart	5200 Main Street	64105	1960-05-05	¤ 75.00	3	false
Sally	Olingback	2330 Shawnee Mission Pkwy	66205	1950-11-05	¤ 75.00	30	true
Su	Vogue	509 Johson Dr	66210	1961-07-19	¤ 75.00	31	false
Taney	Wilson	52345 College Blvd	66210	1950-03-22	¤ 75.00	32	true
Sherry	Walker	466 Lincoln Way	64145	1960-09-06	¤ 75.00	33	false
Maggie	Yode	52345 College Blvd	66210	1972-07-03	¤ 75.00	34	false
Joshua	Parton	200 Washington St	64111	1961-02-15	¤ 75.00	35	false
Jaye	May	1515 Maple St	50033	1960-09-30	¤ 75.00	36	false
Martin	Chen	1010 Green St	50022	1980-08-19	¤ 75.00	37	false
Forrest	Browning	8206 Marshall Drive	66214	1961-09-04	¤ 100.00	4	false
Mary	Bovier	110 College Blvd	66031	1989-10-01	¤ 100.00	5	false
Golga	Collins	520 West Elm	64105	1947-03-01	¤ 100.00	6	true
Mark	Camel	66020 King Street	66210	1960-06-19	¤ 75.00	7	true
Mildred	Custard	66900 College Blvd	66210	1958-06-12	¤ 75.00	8	false
Holly	Cabriella	52520 W. 505 Terr	66215	1954-01-01	¤ 75.00	9	true

ZipCode	City	State2
50022	Bridgewater	IA
50033	Fontanelle	IA
50265	Greenfield	IA
50266	Running Deer	MO
52240	Des Moines	IA
64105	Lee's Summit	MO
64108	Leawood	MO
64111	Kansas City	MO
64114	Kansas City	KS
64131	Overland Park	KS
64132	Lenexa	KS
64141	Flat Hills	KS
64145	Shawnee	KS
64153	Blue Springs	MO
66031	Manhattan	KS
66205	Hollister	KS
66206	Langguth	KS
66210	Red Bridge	KS
66211	Manawatta	KS
66214	Dripping Springs	KS
66215	Clear Water	KS

SELECT DISTINCTROW * FROM CONTACTS PIVOT null;

Access Unit B/QuestTravel-B.accdb

CustNo	FName	LName	Street	City	State	Zip	Phone	FirstContact
1	Gracita	Mayberry	52411 Oakmont Rd	Kansas City	MO	64144	5554441234	Friend
2	Jacob	Alman	2505 McGee St	Des Moines	IA	50288	5551116931	Friend
3	Julia	Bouchart	5200 Main St	Kansas City	MO	64105	5551113081	Mail
4	Jane	Taylor	8206 Marshall Dr	Lenexa	KS	66214	5552229101	Mail
5	Samantha	Braven	600 Elm St	Olathe	KS	66031	5552227002	Friend
6	Kristen	Collins	520 W 52nd St	Kansas City	KS	64105	5552223602	Radio
7	Tom	Camel	520 W 52nd St	Kansas City	KS	64105	5552223602	Radio
8	Dick	Tracy	66020 King St	Overland Park	KS	66210	5552228402	Internet
9	Daniel	Cabriella	52520 W. 505 Ter	Lenexa	KS	66215	5553339871	Internet
10	Brad	Eahlie	56 Jackson Rd	Kansas City	MO	64145	5553330401	Mail
11	Nancy	Diverman	466 Lincoln Rd	Kansas City	MO	64105	5553330401	Friend
12	Kathryn	Dotey	96 Lowell St	Overland Park	KS	66210	5554444404	Internet
13	Anne	Duman	525 Ambassador Dr	Kansas City	MO	64145	5554448844	Mail
14	Mary Jane	Eckert	903 East 504th St.	Kansas City	KS	64131	5554447414	Radio
15	Frank	Houston	305 W. 99th St	Lenexa	KS	66215	5555664344	Radio
16	David	Kalvert	7066 College Rd	Overland Park	KS	66211	5559997154	Internet
17	Jose	Hammer	624 Richmond Ter	Clive	IA	50266	5556660365	Mail
18	Ralph	Hopper	4435 Main St	Greenfield	IA	50849	5557778774	Internet
19	Naresh	Hubert	2345 Grand Blvd	Kansas City	KS	64108	5558886004	Friend
20	Elsie	Lang	5253 Duck Creek Dr	Iowa City	IA	52240	5559998777	Friend
21	Toby	Lang	5253 Duck Creek Dr	Iowa City	IA	52240	5559998777	Friend
22	Brandon	Larson	3966 Woodland St	West Des Moines	IA	50266	5552228908	Internet
23	Gabriel	Martin	345 College Rd	Overland Park	KS	66210	5553338505	Radio
24	Douglas	Margolis	525 College Rd	Overland Park	KS	66210	5554448505	Friend
25	Aaron	Mackintosh	2584 Meyer Rd	Kansas City	KS	64132	5557779414	Mail
26	Robert	Maxim	201 Birch St	Overland Park	KS	66206	5558884514	Internet
27	Jaele	Mullins	620 King St	Overland Park	KS	66210	5557776434	Mail
28	Jenny	Nelson	895 Lowell Dr	Overland Park	KS	66211	5556665084	Friend
29	Marcie	Olson	8320 Grant St	Kansas City	MO	64114	5552221388	Internet
30	Sharol	Olingback	2330 Shawnee Dr	Westwood	KS	66205	5553332434	Friend
31	Zohra	Vogue	506 Lowell St	Point Lookout	MO	65727	5556664404	Mail
32	Lisa	Wilson	345 College Rd	Ridgedale	MO	65777	5557778504	Mail
33	Shirley	Walker	46 Maple Rd	Hollister	MO	65727	5551110403	Radio
34	Kori	Yode	5234 Ash Rd	Ridgedale	MO	65777	5552228503	Radio
35	Jeanette	Parton	4435 Main St	Branson	MO	65726	5552228773	Radio
36	Brad	Langguth	123 Duck Creek Dr	Johnston	IA	50800	5553328888	Internet
37	Madison	Bonocore	57 West 159th St	Cushing	PA	87087	5552887722	Radio
38	Nancy	Langguth	123 Duck Creek Dr	Johnston	IA	50800	5553328888	Internet
39	Tim	Taylor	8206 Marshall Dr	Lenexa	KS	66214	5552229101	Mail
40	Hannah	Edwards	66900 College Rd	Overland Park	KS	66210	5552225102	Radio
41	Marcus	Edwards	66900 College Rd	Overland Park	KS	66210	5552225102	Radio
42	Kris	Goode	900 Barnes St	West Des Moines	IA	50265	5556661324	Mail
43	Lois	Goode	900 Barnes St	West Des Moines	IA	50265	5556661324	Mail
44	Samuel	Livingston	1551 Switzer St	Gardner	KS	66303	5556633366	Internet
45	Julie	Livingston	1551 Switzer St	Gardner	KS	66303	5556633366	Internet
46	Aaron	Alito	5989 Washington Ave	Hollister	MO	67827	5556766677	Internet
47	Kelsey	Hope	7800 West 16th St	Manhattan	KS	66502	5556655522	Internet
48	Orlando	Still	7722 Mastin St	Mission	KS	63552	5558887722	Internet
49	Maria	Still	7722 Mastin St	Mission	KS	63552	5558887722	Internet

SalesNo	SaleDate	CustNo	TourNo
1	2014-04-30	18	1
2	2014-04-30	32	1
3	2014-04-30	6	3
4	2014-04-30	42	1
5	2014-04-30	43	1
6	2014-04-30	19	1
7	2014-05-01	3	12
8	2014-05-01	7	3
9	2014-05-05	33	10
10	2014-05-05	31	10
11	2014-05-05	12	10
12	2014-05-05	17	10
13	2014-05-11	4	2
14	2014-05-31	34	1
15	2014-06-01	30	36
16	2014-06-01	43	36
17	2014-06-01	39	36
18	2014-06-01	15	36
19	2014-06-01	7	47
20	2014-06-01	4	36
21	2014-06-01	6	47
22	2014-06-01	42	36
23	2014-06-01	18	36
24	2014-06-02	38	36
25	2014-06-02	36	36
26	2014-06-03	40	36
27	2014-06-03	41	36
28	2014-06-30	25	1
29	2014-07-01	6	36
30	2014-07-01	5	2
31	2014-07-01	29	2
32	2014-07-01	11	2
33	2014-07-01	3	2
34	2014-07-01	2	2
35	2014-07-01	1	2
36	2014-07-01	7	36
37	2014-07-02	15	2
38	2014-07-02	14	2
39	2014-07-07	43	51
40	2014-07-07	6	51
41	2014-07-07	7	51
42	2014-07-07	42	51
43	2014-07-08	8	51
44	2014-07-08	17	51
45	2014-07-09	9	36
46	2014-07-09	9	51
47	2014-07-09	41	51
48	2014-07-09	40	51
49	2014-07-09	19	51
50	2014-07-09	11	51
51	2014-07-09	12	36
52	2014-07-11	5	51
53	2014-07-11	26	3
54	2014-07-11	19	3
55	2014-07-12	20	3
56	2014-07-12	24	3
57	2014-07-12	21	3
58	2014-07-12	22	3
59	2014-07-13	30	3
60	2014-07-13	28	3
61	2014-07-13	29	3
62	2014-07-13	43	3
63	2014-07-13	42	3
64	2014-07-14	11	5
65	2014-07-14	15	5
66	2014-07-14	10	4
67	2014-07-14	13	4
68	2014-07-15	34	5
69	2014-07-15	14	5
70	2014-07-15	35	5
71	2014-07-15	17	5
72	2014-07-15	13	5
73	2014-07-15	12	5
74	2014-07-19	15	6
75	2014-07-19	31	6
76	2014-07-20	33	6
77	2014-07-20	42	6
78	2014-07-20	32	6
79	2014-07-20	43	6
80	2014-07-21	18	6
81	2014-07-21	25	6
82	2014-07-22	16	7
83	2014-07-22	22	7
84	2014-07-22	27	7
85	2014-07-22	28	7
86	2014-07-26	23	7
87	2014-07-26	20	7
88	2014-07-26	21	7
89	2015-06-01	24	8
90	2015-06-01	27	9
91	2015-06-01	26	8
92	2015-06-02	17	9
93	2015-06-03	15	9
94	2015-06-04	29	9
95	2015-06-08	25	8
96	2015-06-08	23	8
98	2014-08-01	36	44
99	2014-08-01	38	44
100	2014-06-14	42	46
101	2014-06-14	43	46
102	2014-08-02	20	45
103	2014-08-02	21	45

StateName	StateAbbreviation
Alaska	AK
Alabama	AL
Arkansas	AR
Arizona	AZ
California	CA
Colorado	CO
Connecticut	CT
District of Columbia	DC
Delaware	DE
Florida	FL
Georgia	GA
Hawaii	HI
Iowa	IA
Idaho	ID
Illinois	IL
Indiana	IN
Kansas	KS
Kentucky	KT
Louisiana	LA
Massachusetts	MA
Maryland	MD
Maine	ME
Michigan	MI
Minnesota	MN
Missouri	MO
Mississippi	MS
Montana	MT
North Carolina	NC
North Dakota	ND
Nebraska	NE
New Hampshire	NH
New Jersey	NJ
New Mexico	NM
Nevada	NV
New York	NY
Ohio	OH
Oklahoma	OK
Oregon	OR
Pennsylvania	PA
Rhode Island	RI
South Carolina	SC
South Dakota	SD
Tennessee	TN
Texas	TX
Utah	UT
Virginia	VA
Vermont	VT
Washington	WA
Wisconsin	WS
West Virginia	WV
Wyoming	WY

Category	Description
Adventure	Adventure tours include skiing, scuba, biking, hiking, and climbing tours.
Cultural	Cultural tours focus on historical festivals and cultural exchange.
Educational	Educational tours offer college credit.
Family	Family tours include weddings and reunions.
Service	Service tours send volunteer workers to areas hit by natural disasters.
Site Seeing	Site seeing tours focus on tourist attractions.
Sports	Sports tours offer a special inside look at major league sporting events.

TourNo	TourName	TourStartDate	Duration	City	StateAbbrev	Category	Price
1	Stanley Bay Shelling	2014-07-06	3	Captiva	FL	Adventure	¤ 750.00
2	Red Reef Scuba	2014-07-06	3	Islamadora	FL	Adventure	¤ 1,500.00
3	Ames Ski Club	2015-01-02	7	Breckenridge	CO	Adventure	¤ 850.00
4	Boy Scout Jamboree	2015-01-13	7	Vail	CO	Adventure	¤ 1,900.00
5	Bridgewater Country	2015-02-15	10	Aspen	CO	Adventure	¤ 1,200.00
6	Franklin Family Reunion	2015-03-11	3	Breckenridge	CO	Family	¤ 700.00
7	Spare Tire Ski Club	2015-03-13	7	Monmouth	WA	Adventure	¤ 600.00
8	Eagan Family Reunion	2015-06-12	7	Osage Beach	MO	Family	¤ 500.00
9	Gunnison Bikers	2015-06-20	4	Kimberling City	MO	Adventure	¤ 250.00
10	Golden Footsteps	2014-05-23	4	Orlando	FL	Site Seeing	¤ 550.00
11	Hummer Trail	2014-05-30	14	Key West	FL	Site Seeing	¤ 725.00
12	Piper-Heitman Wedding	2014-05-30	7	Captiva	FL	Family	¤ 550.00
13	High Adventurers	2014-06-05	7	Ft. Lauderdale	FL	Adventure	¤ 575.00
15	Patriot Debate Club	2014-06-12	7	Orlando	FL	Site Seeing	¤ 605.00
17	Tropical Sailboats	2014-06-19	14	Key West	FL	Adventure	¤ 655.00
18	Eagle Hiking Club	2014-06-19	7	Aspen	CO	Adventure	¤ 695.00
19	Paradise Water Club	2014-06-26	7	Hollister	MO	Adventure	¤ 595.00
20	Team Discovery	2014-06-29	5	Breckenridge	CO	Adventure	¤ 550.00
21	Gulfside Birdwatchers	2014-06-29	7	Tampa Bay	FL	Adventure	¤ 700.00
22	Perfect Waves	2014-06-27	5	Huntington Beach	CA	Adventure	¤ 500.00
23	Outrigger Cleanup	2014-06-29	7	Biloxi	MS	Service	¤ 395.00
24	Blue Canyon Youth	2014-07-01	7	New Orleans	LA	Service	¤ 425.00
25	Emmanuel Youth Club	2014-07-01	7	Diaberville	MS	Service	¤ 500.00
26	Dalgren-Smith Wedding	2014-07-02	3	West Des Moines	IA	Family	¤ 300.00
27	Lang Reunion	2014-07-02	3	Des Moines	IA	Family	¤ 350.00
28	Buehler Reunion	2014-07-02	4	Kimberling City	MO	Family	¤ 395.00
29	Silver Country	2014-07-13	14	Sacramento	CA	Educational	¤ 1,200.00
30	Monterey Mysteries	2014-07-14	7	Monterey	CA	Educational	¤ 800.00
31	Washington DC Band	2014-07-13	7	Washington	DC	Educational	¤ 890.00
33	Broadway Workshops	2014-08-24	7	New York City	NY	Educational	¤ 1,000.00
34	Colonial Tour	2014-08-19	14	Washington	DC	Educational	¤ 3,000.00
35	Freedom Tour	2014-08-24	7	Boston	MA	Educational	¤ 1,000.00
36	American Heritage Tour	2014-08-24	7	Philadelphia	PA	Educational	¤ 1,200.00
37	Cactus Language Exploration	2014-09-14	7	San Diego	CA	Educational	¤ 800.00
38	Water Education Foundation	2014-09-21	14	Fresno	CA	Educational	¤ 1,300.00
39	Oakland Museum of Science	2014-07-20	7	Oakland	CA	Educational	¤ 1,000.00
40	Redwood Forest Lab	2014-09-29	14	Mill Valley	CA	Educational	¤ 1,500.00
41	Langguth History	2014-10-19	10	Napa	CA	Site Seeing	¤ 900.00
43	Japanese California Connection	2014-08-19	4	Bolinas	CA	Cultural	¤ 424.00
44	Bear Valley Adventures	2014-08-19	3	Sacramento	CA	Adventure	¤ 725.00
45	Black Sheep Hiking Club	2014-08-26	14	El Dorado Hills	CA	Adventure	¤ 525.00
46	Bigfoot Rafting Club	2014-07-13	4	Placerville	CA	Adventure	¤ 455.00
47	Yosemite National Park Great Cleanup	2014-07-20	3	Sacramento	CA	Service	¤ 1,100.00
48	Kings Canyon Bridge Builders	2014-07-13	10	Three Rivers	CA	Service	¤ 950.00
49	Golden State Tours	2014-07-20	10	Sacramento	CA	Cultural	¤ 1,400.00
51	Bright Lights Expo	2014-12-01	7	Branson	MO	Site Seeing	¤ 200.00
52	Missouri Bald Eagle Watch Club	2014-08-13	7	Hollister	MO	Adventure	¤ 700.00

SELECT TourCategories.Category FROM TourCategories;

PARAMETERS __TourNo Value; SELECT DISTINCTROW * FROM CustomerSales AS CustomerRoster WHERE ([__TourNo] = TourNo);

SELECT States.StateAbbreviation, States.StateName FROM States;

SELECT DISTINCTROW * FROM States;

SELECT DISTINCTROW * FROM Tours;

SELECT Customers.CustNo, [LName] & ", " & [FName] AS CustomerName FROM Customers ORDER BY [LName] & ", " & [FName];

SELECT [States].[StateName], [States].[StateAbbreviation] FROM States ORDER BY [StateAbbreviation];

SELECT States.StateAbbreviation, States.StateAbbreviation, States.StateName FROM States ORDER BY States.StateName;

PARAMETERS __Category Value; SELECT DISTINCTROW * FROM Tours AS ToursByCategory WHERE ([__Category] = Category);

SELECT TourCategories.Category FROM TourCategories;

SELECT DISTINCTROW * FROM Tours;

SELECT DISTINCTROW * FROM Customers;

SELECT DISTINCTROW * FROM TourCategories;

SELECT DISTINCTROW * FROM Tours;

SELECT Tours.TourName, Tours.TourStartDate, Tours.Duration, Tours.City, Tours.StateAbbrev, Tours.Category, Tours.price, Sales.SaleDate, Customers.FName, Customers.LName, Customers.Street, Customers.City, Customers.State, Customers.Zip, Customers.Phone, Customers.FirstContact FROM Tours INNER JOIN (Customers INNER JOIN Sales ON Customers.CustNo = Sales.CustNo) ON Tours.TourNo = Sales.TourNo ORDER BY Tours.TourName;

SELECT Tours.Category, Tours.TourName, Tours.TourStartDate, Tours.Price FROM Tours ORDER BY Tours.Category, Tours.TourName;

Access Unit B/Recycle-B.accdb

CenterName	CenterStreet	CenterCity	CenterState	CenterZip	CenterPhone	ContactFirst	ContactLast	CenterNumber	Hazardous
Hugo Trash Can	987 Main Street	Lenexa	KS	61111	5551236666	Benjamin	Knox	1	true
Barker Trash	12345 College Boulevard	Overland Park	KS	63444	5552227897	Phyllis	Stein	2	true
Taney County Landfill	12444 Murlen Drive	Shawnee	KS	64222	5557809999	John	Sharona	3	false
Stone County Landfill	78900 180th Street	Olathe	KS	65444	5551111234	Emir	Cipra	4	false

ClubNumber	ClubName	ClubStreet	ClubCity	ClubState	ClubZip	ClubPhone	FName	LName
1	Jaycees	111 Elm Street	Overland Park	KS	66213	5551238888	Francis	Bender
2	Boy Scout Troop 7	22 West 67th Drive	Mission	KS	60603	5551117777	Mason	Schaffer
3	Great Plains 4-H	44 East 99th Road	Lenexa	KS	66111	5552222222	Renaldo	Holt
4	Lions of Fontanelle	777 Oxford Street	Fontanelle	KS	66333	5553333111	Cory	Mills
5	Junior League	3333 Princeton Lane	Point Lookout	MO	55886	7772134333	Lottie	Moon
6	Ice Kings	55 Oak Drive	Ridgedale	MO	55887	7771224444	Tara	Jackson
7	KC Patriots	888 Switzer Street	Kansas City	MO	55888	7772223333	Trixie	Cho

DepositDate	Weight	CenterNumber	ClubNumber	DepositID
2014-01-30	60.0	4	1	1
2014-01-30	100.0	4	1	2
2014-02-04	75.0	2	4	3
2014-02-04	80.0	1	4	4
2014-02-08	150.0	2	5	5
2014-02-13	200.0	2	6	6
2014-02-14	50.0	2	1	7
2014-02-16	50.0	1	7	8
2014-02-17	40.0	3	1	9
2014-02-18	100.0	4	7	10
2014-02-20	200.0	4	2	11
2014-02-22	75.0	4	6	12
2014-02-23	80.0	1	4	13
2014-02-26	100.0	4	6	14
2014-03-01	150.0	2	5	15
2014-03-02	70.0	4	4	16
2014-03-03	100.0	3	7	17
2014-03-04	150.0	3	5	18
2014-03-05	200.0	4	1	19
2014-03-06	50.0	2	6	20
2015-01-30	60.0	1	1	21
2015-01-30	100.0	2	6	22
2015-02-04	80.0	1	4	23
2015-02-04	75.0	4	4	24
2015-02-08	150.0	2	5	25
2015-02-13	185.0	2	6	26
2015-02-14	50.0	4	1	27
2015-02-16	35.0	1	7	28
2015-02-17	40.0	3	1	29
2015-02-18	185.0	4	6	30
2015-02-20	200.0	3	2	31
2015-02-22	75.0	4	5	32
2015-02-23	80.0	1	4	33
2015-02-26	65.0	2	4	34
2015-03-02	150.0	1	5	35
2015-03-03	50.0	3	4	36
2015-03-04	45.0	3	7	37
2015-03-05	75.0	4	5	38
2015-03-06	200.0	1	1	39
2015-03-07	145.0	4	6	40
2015-04-19	115.0	4	6	41
2015-04-20	65.0	4	1	42
2015-04-22	105.0	2	1	43
2015-04-23	90.0	4	2	44
2015-04-25	65.0	1	1	45
2015-04-30	205.0	3	2	46
2015-05-01	105.0	4	6	47
2015-05-07	190.0	3	2	48
2015-06-04	90.0	4	4	49
2015-06-07	65.0	3	4	50
2015-06-19	65.0	1	4	51
2015-06-20	85.0	4	5	52
2015-06-22	95.0	3	1	53
2015-07-07	75.0	3	5	54
2015-07-08	200.0	2	1	55
2015-08-31	50.0	4	6	56
2015-09-24	200.0	2	5	57
2015-10-01	90.0	3	5	58
2015-10-02	90.0	4	4	59
2015-10-04	80.0	2	5	60
2016-01-04	60.0	1	2	61
2016-01-06	90.0	2	7	62
2016-02-14	50.0	3	7	63
2016-02-18	30.0	2	2	64
2016-02-21	50.0	4	6	65
2016-02-22	100.0	3	6	66
2016-02-28	125.0	2	4	67
2016-03-15	60.0	1	2	68
2016-04-03	115.0	1	4	69
2016-04-18	105.0	1	2	70
2016-05-18	90.0	2	2	71
2016-05-19	80.0	3	1	72
2016-05-20	50.0	4	1	73
2016-05-31	60.0	4	6	74
2016-06-01	65.0	3	4	75
2016-06-07	75.0	3	5	76
2016-06-08	95.0	2	2	77
2016-06-09	90.0	2	1	78
2016-07-10	85.0	1	2	79
2016-07-11	95.0	1	4	80
2016-07-16	65.0	4	6	81
2016-07-17	85.0	3	4	82
2016-07-19	45.0	2	5	83
2016-08-19	205.0	1	7	84
2016-08-20	105.0	2	1	85
2016-09-18	30.0	3	2	86
2016-10-19	60.0	4	4	87
2016-10-20	40.0	3	4	88
2016-10-30	90.0	2	4	89
2016-10-31	80.0	1	1	90
2016-11-01	25.0	2	4	91
2016-11-02	100.0	4	2	92
2016-11-16	85.0	4	5	93
2016-11-17	75.0	3	5	94
2016-11-18	85.0	3	6	95
2016-11-29	90.0	3	5	96
2016-12-01	80.0	2	6	97
2016-12-03	70.0	2	7	98
2016-12-06	80.0	1	7	99
2016-12-08	50.0	4	6	100

Access Unit B/Vet-B.accdb

ClinicName	Address	City	State	Zip	Phone	ClinicNo
Veterinary Specialists	17053 South 71 Highway	Belton	MO	64012	(555) 555-4000	1
Animal Haven	204 East North Avenue	Belton	MO	64012	(555) 555-7900	2
Animal Hospital	12121 Blue Ridge Blvd	Grandview	MO	64030	(555) 555-0884	3
General Veterinary Clinic	6420 Prospect	Kansas City	MO	64132	(555) 555-4100	4
Small Animal Specialists	600 NW Murray Road	Lee's Summit	MO	64081	(555) 555-2626	5
Pet Clinic	720 Oak Street	Kansas City	MO	64106	(555) 555-2892	6
Leawood Animal Clinic	5401 College Blvd.	Leawood	KS	66211	(555) 555-1311	7
Fontanelle Furry Friends	2900 Baltimore Avenue	Kansas City	MO	64108	(555) 555-3700	8

VetNo	VetFirst	VetLast	ClinicNo
1	Mark	Garver	1
2	Richard	Hambley	3
3	Doug	Braden	5
4	Kirk	Ridwell	7
5	Gary	Gomez	8
6	William	Baker	8
7	Samuel	Harley	6
8	Kirk	Barnhart	4
9	Vicki	Kowalewski	2
10	Jeffrey	Simmons	3
11	John	Collins	5
12	Herbert	Doctorman	6
13	Stephen	Salamander	7
14	Mark	Major	1
15	Darryl	Newhart	2
16	Colleen	Stewart	5
17	William	Beaman	6
18	Selbert	Chernoble	2
19	Jonathan	Genderheit	3
20	Carl	Douglas	4
21	J. Simon	Szevets	8
22	Howard	Rosenheim	7
23	Mary Ann	Cooper	5
24	Mark	Galan	6
25	Richard	Hileman	4
26	Edwin	Kramer	5
27	Johnett	LaDue	3
28	Thomas	Manheim	1
29	Kenneth	Sellers	2
30	Frank	Stewart	1
31	Anne	Sanderson	2

Access Unit C/Baseball-C.accdb

PlayerNumber	PlayerFirst	PlayerLast	PlayerNickname	PlayerPhone	PlayerPosition	Insurance	Uniform	TeamNumber
10000	Louis	Gehrig	Lou	9137623444	5	true	true	7
10001	Sanford	Koufax	Sandy	9133231212	2	true	true	7
10002	Barb	Rickey	Barbie	9132129878	7	true	true	7
10003	George	Ruth	Babe	9133131234	7	true	true	3
10004	Teddie	Williams	Ted	9143230900	9	true	true	7
10005	Cycylie	Young	Sid	9132423212	2	true	true	1
10006	Abner	Doubleday	Abby	9131213212	3	true	true	5
10007	Roggie	Hornsby	Tex	9132422345	4	true	true	7
10008	Mickey	Mantle	Mick	9132425678	9	true	true	1
10009	Jackie	Robinson	Jackie	9132423123	7	true	true	1
10010	Roy	Campanella	Roy	9132521321	1	true	true	1
10011	Tyrus	Cobb	Ty	8169192343	8	true	true	3
10012	Carl	Mathewson	Cookie	9132928384	2	true	true	5
10013	Henry	Aaron	Henry	8169274638	7	true	true	5
10014	Joey	DiMaggio	Joe	9138283848	5	true	true	3
10015	Charles	Ford	Whitey	9132435667	1	true	true	3
10016	Francis	Frampton	Chris	9132546789	8	true	true	5
10017	Bill	Mayes	Willie	9134565678	6	true	true	1
10018	Stanley	Musial	Stan	9132459876	3	true	true	3
10019	Leroy	Paige	Satchel	9137876523	3	true	true	1
10020	James	Thorpe	JT	9134563789	4	true	false	3
10021	John	Wagner	Jimmy	8166546789	8	true	true	7
10022	John	Bench	Johnny	9132857451	6	true	true	3
10023	Louie	Brock	Lou	9134456543	4	false	true	5
10024	Abner	Chandler	Abby	8164562098	6	true	true	7
10025	Roger	Maris	Roger	9137652845	8	true	false	1
10026	Alfred	Martin	Al	9132456483	6	true	true	5
10027	Greg	Perry	Greg	9137654876	2	true	true	3
10028	George	Plimpton	Bruiser	8162458742	3	true	true	7
10029	Frank	Robinson	Fred	9130897654	9	false	false	3
10030	Nolan	Ryan	Slick	9136765432	5	false	false	5
10031	Warren	Spahn	Warren	8165478923	4	true	true	1
10032	Andrew	Spalding	Addie	9134937592	1	true	false	7
10033	Robert	Clemente	Bob	9138642725	9	false	false	5
10034	Jeffrey	Dean	Speedy	8166602748	5	true	false	1
10035	Luis	Durocher	Pop	9137652845	1	false	false	5

FieldName	GameDate	GameTime	HomeTeamNumber	VisitorTeamNumber
Wriggley	2015-06-04	1899-12-30	1	2
Ebbetts	2015-06-04	1899-12-30	3	4
Center	2015-06-04	1899-12-30	5	6
The Junkyard	2015-06-04	1899-12-30	7	8
Wriggley	2015-06-11	1899-12-30	2	3
Ebbetts	2015-06-11	1899-12-30	4	5
Center	2015-06-11	1899-12-30	6	7
The Junkyard	2015-06-11	1899-12-30	8	1
Wriggley	2015-06-18	1899-12-30	1	4
Ebbetts	2015-06-18	1899-12-30	3	6
Center	2015-06-18	1899-12-30	5	8
The Junkyard	2015-06-18	1899-12-30	7	2
Wriggley	2015-06-25	1899-12-30	2	5
Ebbetts	2015-06-25	1899-12-30	4	7
Center	2015-06-25	1899-12-30	6	1
The Junkyard	2015-06-25	1899-12-30	8	3
Wriggley	2015-07-02	1899-12-30	1	8
Ebbetts	2015-07-02	1899-12-30	3	2
Center	2015-07-02	1899-12-30	5	4
The Junkyard	2015-07-02	1899-12-30	7	6
Wriggley	2015-07-09	1899-12-30	1	2
Ebbetts	2015-07-09	1899-12-30	3	4
Center	2015-07-09	1899-12-30	5	6
The Junkyard	2015-07-09	1899-12-30	7	8

TeamNumber	TeamName	TeamSponsor	TeamCity	TeamState
1	Brooklyn Beetles	Brooklyn Bagles & More	Brooklyn	NY
2	Blue Herons	Hilda's House of Hair	Boston	MA
3	Snapping Turtles	Snappy's Lawn Mowers	Philadelphia	PA
4	Louie's Sluggers	Louie's Sport Shop	New York City	NY
5	Mayfair Monarchs	Uptown Formal Wear	Washington	DC
6	The Seahorses	Sheila's Shell Shop	Trenton	NJ
7	Rocky's Rockets	Rocky's Rocket Drive-In	Concord	MA
8	Yellow Jackets	Mellow Yellow Book Shop	Cambridge	MA

SELECT Teams.TeamName, Players.PlayerLast, Players.PlayerFirst, Players.PlayerPosition FROM Teams INNER JOIN Players ON Teams.TeamNumber = Players.TeamNumber WHERE (((Players.PlayerPosition)=1)) OR (((Players.PlayerPosition)=2)) ORDER BY Teams.TeamName, Players.PlayerPosition;

Access Unit C/Dives-C.accdb

Abbrev	StateTerritory
AK	Alaska
AL	Alabama
AR	Arkansas
AS	American Samoa
AZ	Arizona
CA	California
CO	Colorado
CT	Connecticut
DC	District Of Columbia
DE	Delaware
FL	Florida
FM	Federated States Of Micronesia
GA	Georgia
GU	Guam
HI	Hawaii
IA	Iowa
ID	Idaho
IL	Illinois
IN	Indiana
KS	Kansas
KY	Kentucky
LA	Louisiana
MA	Massachusetts
MD	Maryland
ME	Maine
MH	Marshall Islands
MI	Michigan
MN	Minnesota
MO	Missouri
MP	Northern Mariana Islands
MS	Mississippi
MT	Montana
NC	North Carolina
ND	North Dakota
NE	Nebraska
NH	New Hampshire
NJ	New Jersey
NM	New Mexico
NV	Nevada
NY	New York
OH	Ohio
OK	Oklahoma
OR	Oregon
PA	Pennsylvania
PR	Puerto Rico
PW	Palau
RI	Rhode Island
SC	South Carolina
SD	South Dakota
TN	Tennessee
TX	Texas
UT	Utah
VA	Virginia
VI	Virgin Islands
VT	Vermont
WA	Washington
WI	Wisconsin
WV	West Virginia
WY	Wyoming
QLD	Queensland

CountryName
Australia
Bahamas
Belize
Bonaire
Brazil
Cayman Islands
Cuba
Curacao
Cyprus
Egypt
Fiji
Honduras
Israel
Jamaica
Mexico
United Kingdom
US Virgin Islands
USA

DiveMasterID	LName	Address	City	StateProvince	ZipPostalCode	PhoneNumber
1	Chow	111 Maple Street	Filmont	NM	77881	5555550101
2	Hend	222 Oak Street	Erie	PA	34567	5555552344
3	Barnes	333 Elm Avenue	New York City	NY	15875	5555557890
4	Fillmore	444 Lincoln Way	Ft. Dodge	IA	50111	5555557777
5	Franklin	555 Perry Street	Key Largo	FL	29922	5555554545
6	Crone	12345 100th Street	Long Beach	CA	90222	5555551234
7	Tomi	12344 99th Street	Branson	MO	55880	5555557788
8	Zenk	128 Main Street	Green River	FL	24242	5555557799
9	Stedo	789 Jackson Street	Dallas	TX	68686	6662234343
10	Randal	600 Lenexa Road	Hartford	CT	12345	2227060500

ID	DiveMasterID	Location	City	State/Province	Country	TripStartDate	Lodging	Rating	CertificationDiving	Participants	TripReport
1	1	Great Barrier Reef	Cairns		Australia	2015-05-14	Royal Palm	4.0	false	5
2	2	Grand Bahama Island	Bimini		Bahamas	2015-02-07	Travel 6 Inn	4.0	false	6
3	2	Grand Bahama Island	Nassau		Bahamas	2015-10-07	Marriott Sands	3.0	true	12
4	3	Grand Bahama Island	Nassau		Bahamas	2014-12-30	Fairwind	4.0	false	10
5	4	Black Beards Cruises	Nassau		Bahamas	2013-04-30	Fairwind	4.0	false	11
6	5	Grand Bahama Island	Nassau		Bahamas	2014-12-16	Fairwind	3.0	true	15
7	6	Ambergris Caye	Belize City		Belize	2015-04-26	Sun Breeze	4.0	false	7
8	6	Ambergris Caye	Belize City		Belize	2015-04-25	Sun Breeze	4.0	false	6
9	8	South Shore	Kralendijk		Bonaire	2014-10-02	Pink Flamingo	4.0	false	4
10	9	South Shore	Kralendijk		Bonaire	2015-06-20	Sea Star	4.0	false	5
11	8	South Shore	Kralendijk		Bonaire	2014-10-03	Pink Flamingo	5.0	false	10	Overall, the trip was fantastic! The diving was absolutely spectacular!. Some of our favorite sites are: Alice in Wonderland, Andrea II and Pink Beach Weather: We went October 9-16. This is their rainy season, but it only rained one day and didn`t stop us from diving. Otherwise, it was partly cloudy to mostly sunny (bring sunscreen!) and the temperature was 85-90 degrees every day. There`s always a nice breeze and the evenings cooled off really nice. Very comfortable.
12	9	South Shore	Kralendijk		Bonaire	2015-06-21	Sea Star	5.0	false	12	Three great dives today. Bari Reef, Salt Pier and back to Bari for a REALLY late night dive. The Salt Pier was exciting for us as we missed this dive the last time we were here. Dinner tonight was at Richards. Beautiful place!
13	10	South Shore	Kralendijk		Bonaire	2015-03-30	Sea Star	5.0	false	13	Oooh, Bonaire is a great place to be if you like relaxed vacations. You don`t have to worry about boats leaving without you, or times of departure. You just hire a pick-up and off you go. Almost every dive-site at the coast-line, you can do a shore-dive. This really is great and relaxing.
14	10	South Shore	Kralendijk		Bonaire	2014-05-19	Pink Flamingo	4.0	false	5
15	8	South Shore	Kralendijk		Bonaire	2013-10-20	Sea Star	3.0	false	6
16	7	Fernando de Noronha	Pernambuco		Brazil	2015-04-13	Port Arrowhead	3.0	false	3
17	7	Fernando de Noronha	Pernambuco		Brazil	2015-08-04	Port Arrowhead	3.0	false	7
18	7	Angra dos Reis	Rio de Janerio		Brazil	2014-03-20	Sunset City	3.0	false	8
19	7	Arraial do Cabo	Rio de Janerio		Brazil	2015-04-03	Sunset City	4.0	false	10
20	6	Arraial do Cabo	Rio de Janerio		Brazil	2015-02-25	Sunset City	4.0	false	11
21	1	Grand Cayman	George Town		Cayman Islands	2014-05-12	Diving Lodge	4.0	false	13
22	2	Grand Cayman	George Town		Cayman Islands	2013-04-27	Diving Lodge	5.0	false	12	This has been the best vacation we have taken. The most relaxing and great diving.
23	3	Grand Cayman	George Town		Cayman Islands	2014-09-01	Diving Lodge	5.0	false	11	As always this trip to Cayman was great. The weather was good. The guests were great.
24	1	Grand Cayman	George Town		Cayman Islands	2014-09-01	Diving Lodge	5.0	false	10	This was our third trip to Grand Cayman - our second time with Cayman Diving Lodge.The day we went to Stingray City, we did two dives on the way there, had lunch on the boat, then dove Stingray City. The fish were abundant - many Parrotfish, Blennys (those guys are so cute!), Butterflyfish, Jacks, Tarpon, Snappers, Triggerfish, Spotted Drums Jawfish and several Barracuda, Filefish, Flyingfish, Groupers, Hogfish, Morays, Scorpionfish and Turtles. The highlights of this trip were the Turtles, Nurse Sharks and Octopi. The night dives we did were filled with cool creatures. We saw Green Moray Eels, Sharptail Eels, Spotted Moray Eels (one so small that it`s head was about the size of a dime), Porcupinefish, Slipper Lobster, and Octopi.
25	1	Grand Cayman	George Town		Cayman Islands	2015-05-11	Sunset Hotel	4.0	false	16
26	2	Grand Cayman	George Town		Cayman Islands	2015-09-24	Sunset Hotel	4.0	false	8
27	5	West Shore	Havana		Cuba	2013-01-22	Copa Cabana	3.0	true	7
28	3	East Shore	Willemstad		Curacao	2014-07-03	Prince Resort	5.0	false	6
29	3	East Shore	Willemstad		Curacao	2013-01-22	Prince Resort	4.0	false	6
30	4	Big Island	Willemstad		Cyprus	2015-05-07	Prince Resort	4.0	false	10
31	5	Summer Lake	Hurghada		Egypt	2014-09-10	Ramada Inn	3.0	true	10
32	5	Winter Lake	Sharm El Naga		Egypt	2014-10-01	Sala Dive Center	3.0	true	9
33	5	Winter Lake	Sharm El Sheik		Egypt	2013-09-29	Rosada Dive Center	3.0	false	8
34	5	Winter Lake	Sharm El Sheik		Egypt	2015-07-11	Rosada Dive Center	3.0	false	6
35	6	Two Islands	Nadi		Fiji	2013-03-17	Coco Bay Resort	4.0	false	8
36	6	Two Islands	Nadi		Fiji	2013-03-18	Coco Bay Resort	4.0	false	10
37	4	Sunset Reef	Roatan		Honduras	2015-03-10	Tony's Resort	3.0	true	12
38	4	Sunset Reef	Roatan		Honduras	2015-03-11	Tony's Resort	3.0	false	13
39	3	Sunset Reef	Roatan		Honduras	2015-03-10	Lover's Bay Resort	4.0	false	11
40	3	Sunset Reef	Roatan		Honduras	2015-10-15	Lover's Bay Resort	4.0	false	10
41	4	Sunset Reef	Roatan		Honduras	2015-05-07	Lover's Bay Resort	3.0	false	8
42	2	Tree of Life Lake	Eilat		Israel	2015-03-14	Kibbutz Dive	4.0	false	7
43	1	North Shore	Montego Bay		Jamaica	2014-03-05	Village Sand	3.0	false	8
44	2	Flaming Reef	Cabo San Lucas		Mexico	2014-04-29	Village by the Sea	4.0	false	8
45	2	Flaming Reef	Cabo San Lucas		Mexico	2014-05-08	Village by the Sea	3.0	false	9
46	2	Flaming Reef	Cabo San Lucas		Mexico	2014-04-30	Village by the Sea	3.0	false	10
47	3	Gold Shore	Cancun		Mexico	2015-10-09	Hyatt Sands	4.0	false	12
48	4	Gold Shore	Cancun		Mexico	2015-08-29	Hyatt Sands	4.0	false	12
49	5	Columbia Shallows	Cozumel		Mexico	2013-03-04	Westin Del Mar	3.0	false	14
50	5	Columbia Shallows	Cozumel		Mexico	2014-02-08	Westin Del Mar	3.0	false	10
51	5	Columbia Shallows	Cozumel		Mexico	2014-02-06	Westin Del Mar	3.0	false	9
52	6	Columbia Shallows	Cozumel		Mexico	2015-02-06	Atempo Resort	3.0	false	8
53	6	Columbia Shallows	Cozumel		Mexico	2015-04-28	Atempo Resort	3.0	false	7
54	7	Columbia Shallows	Cozumel		Mexico	2013-08-23	Atempo Resort	3.0	false	10
55	7	Columbia Shallows	Cozumel		Mexico	2013-08-22	Atempo Resort	3.0	false	9
56	8	Columbia Shallows	Cozumel		Mexico	2014-03-05	Royal Seas	3.0	false	8
57	9	Columbia Shallows	Cozumel		Mexico	2014-03-06	Royal Seas	3.0	false	7
58	10	Columbia Shallows	Cozumel		Mexico	2015-02-03	Royal Seas	3.0	false	5
59	10	Columbia Shallows	Cozumel		Mexico	2015-02-04	Royal Seas	4.0	false	10
60	5	Columbia Shallows	Cozumel		Mexico	2014-02-07	Scuba South Resort	4.0	false	4
61	6	Columbia Shallows	Cozumel		Mexico	2015-04-27	Scuba South Resort	4.0	false	7
62	7	Columbia Shallows	Cozumel		Mexico	2014-08-24	Scuba South Resort	4.0	false	9
63	8	Columbia Shallows	Cozumel		Mexico	2014-03-06	Scuba South Resort	5.0	false	9
64	3	The Reef Club	Cozumel		Mexico	2015-01-06	Scuba South Resort	3.0	false	10
65	2	The Reef Club	Cozumel		Mexico	2013-06-25	Scuba South Resort	4.0	false	11
66	1	Blue Water Reef	Ixtapa		Mexico	2013-04-02	Hyatt Ixtapa	3.0	false	12
67	10	Red Reef	La Buffadora		Mexico	2015-02-12	4 Seasons Inn	3.0	false	13
68	5	Orange Reef	La Paz		Mexico	2015-08-23	Hotel La Paz	4.0	false	7
69	4	Cat Eye Reef	Mar de Cortez		Mexico	2014-09-26	Sweet Seas Resort	3.0	false	8
70	3	Tiger Reef	San Carlos		Mexico	2015-03-29	Pedro Hotel	4.0	false	9
71	6	Manicles Porthkerris	Cornwall		United Kingdom	2014-04-12	King James Castle	4.0	false	10
72	8	Porthkerris	Cornwall		United Kingdom	2013-04-05	King James Castle	4.0	false	10
73	10	East Shore	St John		US Virgin Islands	2013-05-10	Pirates Cove Inn	3.0	false	9
74	8	Twin Grand Rivers	Ketchikan	AK	USA	2015-05-14	Timberwolf Lodge	4.0	false	8
75	6	Frog Reef	Catalina Island	CA	USA	2015-08-22	Marriott Catalina	3.0	true	7
76	6	Frog Reef	Catalina Island	CA	USA	2013-08-23	Marriott Catalina	3.0	true	10
77	4	Frog Reef	Catalina Island	CA	USA	2014-03-10	Marriott Catalina	4.0	false	10
78	4	Frog Reef	Catalina Island	CA	USA	2015-01-09	Hotel California	3.0	false	10
79	2	Daves Reef	San Clemente	CA	USA	2013-05-11	Galleon Resort	3.0	false	11
80	2	Daves Reef	San Clemente	CA	USA	2013-05-10	Galleon Resort	2.0	true	11
81	1	Little Reef	Clearwater	FL	USA	2014-07-23	Tropicana Inn	3.0	false	7
82	3	Little Reef	Clearwater	FL	USA	2013-06-08	Tropicana Inn	1.0	true	8
83	5	Manatee Island	Crystal River	FL	USA	2015-10-19	Westin Manatee	4.0	false	9
84	9	Indian Reef	Key Largo	FL	USA	2013-03-05	Key Largo Inn	3.0	false	9
85	7	Indian Reef	Key Largo	FL	USA	2015-05-01	Key Largo Inn	2.0	false	10
86	8	Indian Reef	Key Largo	FL	USA	2015-07-17	Best Western Key Largo	3.0	false	12
87	9	Blue State Park	Key West	FL	USA	2014-11-19	Westin Key West	3.0	false	13
88	10	Blue State Park	Key West	FL	USA	2015-12-16	Hyatt Sunset Harbor	2.0	false	11
89	5	Dragon Park	Lake City	FL	USA	2014-01-12	Sheriton 4 Seasons	3.0	false	10
90	4	Dragon Park	Lake City	FL	USA	2014-02-23	Spruce Inn	3.0	false	8
91	3	Tree Island	Panama City	FL	USA	2015-08-20	Iota Key Resort	3.0	false	7
92	3	Tree Island	Panama City	FL	USA	2015-12-25	Panama City Resort	3.0	false	8
93	2	Salt Island	Ramrod Key	FL	USA	2015-07-04	Lighthouse Inn	2.0	false	8
94	1	Lobster Island	Tavernier	FL	USA	2014-10-08	Pirates Ahoy Hotel	1.0	false	9
95	3	Fish House	West Palm Beach	FL	USA	2013-04-21	Motel 8 West Palm	2.0	false	10
96	5	Fish House	West Palm Beach	FL	USA	2013-03-10	Holiday Inn West	3.0	false	12
97	7	Fish House	West Palm Beach	FL	USA	2013-03-24	Holiday Inn West	3.0	false	12
98	9	Fish House	West Palm Beach	FL	USA	2013-07-29	Westin Beach House	3.0	false	14
99	2	Molokini Crater	Molokiai	HI	USA	2015-03-16	Grand Beach Resort	3.0	false	10
100	2	Molokini Crater	Molokiai	HI	USA	2015-03-17	Grand Beach Resort	4.0	false	9
101	3	Molokini Crater	Molokiai	HI	USA	2013-11-13	Grand Beach Resort	4.0	false	8
102	4	Molokini Crater	Molokiai	HI	USA	2015-08-10	Sand and Surf Resort	4.0	false	7
103	4	Molokini Crater	Molokiai	HI	USA	2015-08-11	Sand and Surf Resort	5.0	false	10
104	5	South Maui Island	Maui	HI	USA	2015-08-10	Hyatt Maui	4.0	false	9
105	6	Molokini Crater	Molokiai	HI	USA	2015-08-08	Sand and Surf Resort	4.0	false	8
106	4	Spurgeon Lake	Grand Springs	IL	USA	2013-05-13	Holiday Inn Mermet	2.0	true	7
107	4	Spurgeon Lake	Grand Springs	IL	USA	2013-05-14	Holiday Inn Mermet	3.0	true	5
108	4	Spurgeon Lake	Grand Springs	IL	USA	2013-05-15	Red Roof Inn	3.0	true	10
109	2	Bass Lake	Logansport	IN	USA	2013-10-29	Logan's Point Hotel	3.0	true	12
110	2	Bass Lake	Logansport	IN	USA	2013-10-30	Logan's Point Hotel	4.0	true	13
111	10	Sawfish Lake	Rockport	MA	USA	2013-10-24	Rock Lodge	3.0	true	14
112	7	Mark Twain Lake	Bonne Terre	MO	USA	2013-07-25	Lucky 13 Lodge	4.0	true	8
113	7	Mark Twain Lake	Bonne Terre	MO	USA	2013-07-26	Lucky 13 Lodge	4.0	true	9
114	7	Table Rock Lake	Branson	MO	USA	2014-07-14	Big Cedar Lodge	3.0	true	8
115	10	Delaware Water Gap	Manasquan	NJ	USA	2014-08-12	La Quinta Inn	1.0	true	10
116	10	Delaware Water Gap	Manasquan	NJ	USA	2014-08-13	La Quinta Inn	2.0	true	12
117	1	Pontiac Reserve	Santa Rosa	NM	USA	2014-09-29	Ramada Inn	2.0	false	13
118	2	Gilboa Quarry	Ottawa	OH	USA	2014-06-20	Marriott Ottawa	3.0	false	11
119	2	Shawnee River	Portage	OH	USA	2015-06-24	Marriott Portage	3.0	false	10
120	2	Racoon Quarry	Bethlehem	PA	USA	2015-07-30	Red Roof Inn	3.0	false	8
121	2	Racoon Quarry	Bethlehem	PA	USA	2015-07-29	Red Roof Inn	3.0	false	7
122	2	Red River	Dinman's Ferry	PA	USA	2015-09-03	Hotel 6	3.0	true	8
123	2	Green River	Dutch Springs	PA	USA	2015-07-12	Super 8	3.0	true	8
124	2	Large Island	Lake Erie	PA	USA	2013-09-02	Holiday Inn Lake Erie	3.0	false	9
125	8	Outpost Island	Charleston	SC	USA	2013-11-04	Fairfield Inn Charleston	4.0	false	10
126	9	Turtle Island	Myrtle Beach	SC	USA	2015-09-17	Super 8	4.0	false	12
127	8	Turtle Island	Myrtle Beach	SC	USA	2014-09-21	Super 8	3.0	false	12
128	9	Snake Island	Tyler	TX	USA	2015-06-03	Hotel 6	1.0	false	14
129	4	Devil`s Lake	Baraboo	WI	USA	2013-05-08	Holiday Inn Baraboo	2.0	true	10
130	4	Wazee Lake	Black River Falls	WI	USA	2013-06-18	Antler Lodge	3.0	true	9
131	4	Pearl Lake	Red Granite	WI	USA	2013-07-06	Granite Hotel	3.0	true	8
132	7	Pearl Lake	Red Granite	WI	USA	2015-06-19	Granite Hotel	3.0	true	7
133	7	Pearl Lake	Red Granite	WI	USA	2013-05-31	Deer Crossing Inn	3.0	true	10
134	4	Springwater	Washara	WI	USA	2015-06-23	Moose Resort	3.0	true	9

PARAMETERS __DiveMasterID Value; SELECT DISTINCTROW * FROM DiveTrips AS Members WHERE ([__DiveMasterID] = DiveMasterID);

SELECT DISTINCTROW * FROM DiveTrips;

SELECT DISTINCTROW * FROM DiveMasters;

SELECT Members.LName, Dives.Location, Dives.City, Dives.[State/Province], Dives.Country, Dives.Date, Dives.Rating FROM Members INNER JOIN Dives ON Members.MemberID = Dives.MemberID;

SELECT [DiveTrips].ID, [DiveTrips].MemberID, [DiveTrips].Location, [DiveTrips].City, [DiveTrips].[State/Province], [DiveTrips].Country, [DiveTrips].Date, [DiveTrips].Dives, [DiveTrips].Lodging, [DiveTrips].Rating, [DiveTrips].CertificationDive, [DiveTrips].TripReport FROM DiveTrips WHERE ((([DiveTrips].Country)="USA"));

SELECT Dives.Country, Dives.Location, Dives.Date, Dives.Rating FROM Dives;

Access Unit C/ForSale.bmp

Access Unit C/Jobs-C.accdb

EmployerID	CompanyName	EmpStreet	EmpCity	EmpState	EmpZip	EmpPhone
1	IBM	400 Locust St	Des Moines	IA	51122	515-555-4444
2	EDS	500 Cricket St	Ames	IA	50010	515-555-3333
3	Google	600 Crocker St	Omaha	NE	66000	616-555-2222
4	Apple	700 Beetle St	Lincoln	NE	66110	616-555-1111
5	Bass Pro Shops	800 Ladybug St	Sioux City	NE	66220	616-555-3333

Title	CareerArea	AnnualSalary	Desirability	EmployerID	PositionID
Marketing Representative	Computers	¤ 35,000.00	5	1	1
Systems Engineer	Computers	¤ 37,000.00	5	1	2
Office Specialist	Computers	¤ 32,000.00	4	2	3
Customer Service Rep	Computers	¤ 31,000.00	4	2	4
Technician	Computers	¤ 30,500.00	3	2	5

Access Unit C/Membership-C.accdb

FName	LName	Company	Street	City	State	Zip	Phone	StatusNo	DuesPaid
Mitch	Mayberry	USConnect	52411-B Wornall Road	Kansas City	KS	64145	4445550401	3	¤ 0.00
Jill	Alman	Hallmark Cards	2505 McGee	Kansas City	KS	64141	4445556931	2	¤ 0.00
Bob	Bouchart	Sprint	5200 Main Street	Kansas City	KS	64105	4445553081	2	¤ 200.00
Cynthia	Browning	Kansas Communications	8206 Marshall Drive	Lenexa	KS	66214	4445559101	2	¤ 200.00
Mary	Braven	Sprint North Supply	600 Industrial Parkway	Industrial Airport	KS	66031	4445557002	3	¤ 0.00
Christine	Collins	NAIC	520 W 52nd St	Kansas City	KS	64105	4445553602	2	¤ 200.00
Denise	Camel	ONA	66020 King St	Overland Park	KS	66210	4445558402	3	¤ 150.00
Gene	Custard	Instinet	66900 College Blvd	Overland Park	KS	66210	4445555102	3	¤ 200.00
Jan	Cabriella	Tokyo Foods	52520 W. 505 Terr	Lenexa	KS	66215	4445559871	3	¤ 100.00
Andrea	Eahlie	USConnect	52466-B Wornall Road	Kansas City	KS	64145	4445550401	3	¤ 200.00
Barbara	Diverman	USConnect	52466-B Friedrichsen Road	Kansas City	KS	64145	4445550401	3	¤ 300.00
Sylvia	Dotey	PHP	50966 Lowell	Overland Park	KS	66210	4445554404	3	¤ 300.00
Juan	Holly	The Duff Company	66525 N. Ambassador Drive	Kansas City	KS	64153	4445558844	4	¤ 400.00
Jay	Eckert	Trinity Systems	903 East 504th St	Kansas City	KS	64131	4445557414	3	¤ 200.00
John	Garden	Williams Foods Inc	53305 W. 99th St	Lenexa	KS	66215	4445554344	3	¤ 100.00
Lois	Goode	True North	900 Foxworthy	West Des Moines	KS	50265	4445551324	3	¤ 150.00
Mike	Hammer	KGSM	66224 Holmes	Kansas City	KS	64131	4445550365	4	¤ 300.00
Jeff	Hopper	Portege Resouces	4435 Main	Kansas City	KS	64111	4445558774	2	¤ 150.00
Holly	Hubert	IBM	2345 Grand	Kansas City	KS	64108	4445556004	3	¤ 200.00
Traci	Kalvert	Sprint Publishing	7066 College Blvd	Overland Park	KS	66211	4445557154	1	¤ 50.00
Brad	Lang	Hills Bank	5253 Duck Creek Dr	Iowa City	KS	52240	4445558777	1	¤ 50.00
Kristen	Larson	Denman & Company	3966 Woodland	West Des Moines	KS	50266	4445558908	1	¤ 50.00
Jerry	Martin	JCCC	52345 College Blvd	Overland Park	KS	66210	4445558505	1	¤ 50.00
Karen	Margolis	JCCC	52345 College Blvd	Overland Park	KS	66210	4445558505	2	¤ 0.00
Helen	Mackintosh	International Diabetes	2584 E. Meyer Blvd	Kansas City	KS	64132	4445559414	2	¤ 100.00
Robert	Maxim	Boatmen’s Bank of Kansas	95th & Mission Road	Overland Park	KS	66206	4445554514	3	¤ 200.00
Jim	Mullins	ONA	66020 King Street	Overland Park	KS	66210	4445556434	4	¤ 200.00
Jenny	Nelson	The Sunflower Group	50895 Lowell	Overland Park	KS	66210	4445555084	3	¤ 300.00
Marcie	Olson	Sprint	8320 Ward Parkway	Kansas City	KS	64114	4445551388	3	¤ 300.00
Sharol	Olingback	Sprint	2330 Shawnee Mission	Westwood	KS	66205	4445552434	2	¤ 100.00
Kathy	Vogue	PHP	50966 Lowell	Overland Park	KS	66210	4445554404	2	¤ 100.00
Jim	Wilson	JCCC	52345 College Blvd	Overland Park	KS	66210	4445558504	2	¤ 200.00
Shirley	Walker	USConnect	52466-B Wornall Road	Kansas City	KS	64145	4445550403	2	¤ 200.00
Kathy	Yode	JCCC	52345 College Blvd	Overland Park	KS	66210	4445558503	1	¤ 100.00
Jeanette	Parton	Principal Mutual	4435 Main St	Kansas City	KS	64111	4445558773	1	¤ 0.00
Jane	Eagan	Cummins Construction	1515 Maple St	Fontanelle	KS	50033	4445551166	2	¤ 0.00
Connie	Sinclaire	LPA	1010 Green St	Bridgewater	KS	50022	4445552277	4	¤ 150.00

Status	StatusNo	MinimumHours	MinimumMonths	DuesOwed
New	1	20	2	¤ 100.00
Bronze	2	50	6	¤ 200.00
Silver	3	100	18	¤ 300.00
Gold	4	200	24	¤ 400.00
Platinum	5	500	36	¤ 500.00

Access Unit C/People.JPG

Access Unit C/QuestLogo.bmp

Access Unit C/QuestTravel-C.accdb

CustNo	FName	LName	Street	City	State	Zip	Phone	FirstContact
1	Gracita	Mayberry	52411 Oakmont Rd	Kansas City	MO	64144	5554441234	Friend
2	Jacob	Alman	2505 McGee St	Des Moines	IA	50288	5551116931	Friend
3	Julia	Bouchart	5200 Main St	Kansas City	MO	64105	5551113081	Mail
4	Jane	Taylor	8206 Marshall Dr	Lenexa	KS	66214	5552229101	Mail
5	Samantha	Braven	600 Elm St	Olathe	KS	66031	5552227002	Friend
6	Kristen	Collins	520 W 52nd St	Kansas City	KS	64105	5552223602	Radio
7	Tom	Camel	520 W 52nd St	Kansas City	KS	64105	5552223602	Radio
8	Dick	Tracy	66020 King St	Overland Park	KS	66210	5552228402	Internet
9	Daniel	Cabriella	52520 W. 505 Ter	Lenexa	KS	66215	5553339871	Internet
10	Brad	Eahlie	56 Jackson Rd	Kansas City	MO	64145	5553330401	Mail
11	Nancy	Diverman	466 Lincoln Rd	Kansas City	MO	64105	5553330401	Friend
12	Kathryn	Dotey	96 Lowell St	Overland Park	KS	66210	5554444404	Internet
13	Anne	Duman	525 Ambassador Dr	Kansas City	MO	64145	5554448844	Mail
14	Mary Jane	Eckert	903 East 504th St.	Kansas City	KS	64131	5554447414	Radio
15	Frank	Houston	305 W. 99th St	Lenexa	KS	66215	5555664344	Radio
16	David	Kalvert	7066 College Rd	Overland Park	KS	66211	5559997154	Internet
17	Jose	Hammer	624 Richmond Ter	Clive	IA	50266	5556660365	Mail
18	Ralph	Hopper	4435 Main St	Greenfield	IA	50849	5557778774	Internet
19	Naresh	Hubert	2345 Grand Blvd	Kansas City	KS	64108	5558886004	Friend
20	Elsie	Lang	5253 Duck Creek Dr	Iowa City	IA	52240	5559998777	Friend
21	Toby	Lang	5253 Duck Creek Dr	Iowa City	IA	52240	5559998777	Friend
22	Brandon	Larson	3966 Woodland St	West Des Moines	IA	50266	5552228908	Internet
23	Gabriel	Martin	345 College Rd	Overland Park	KS	66210	5553338505	Radio
24	Douglas	Margolis	525 College Rd	Overland Park	KS	66210	5554448505	Friend
25	Aaron	Mackintosh	2584 Meyer Rd	Kansas City	KS	64132	5557779414	Mail
26	Robert	Maxim	201 Birch St	Overland Park	KS	66206	5558884514	Internet
27	Jaele	Mullins	620 King St	Overland Park	KS	66210	5557776434	Mail
28	Jenny	Nelson	895 Lowell Dr	Overland Park	KS	66211	5556665084	Friend
29	Marcie	Olson	8320 Grant St	Kansas City	MO	64114	5552221388	Internet
30	Sharol	Olingback	2330 Shawnee Dr	Westwood	KS	66205	5553332434	Friend
31	Zohra	Vogue	506 Lowell St	Point Lookout	MO	65727	5556664404	Mail
32	Lisa	Wilson	345 College Rd	Ridgedale	MO	65777	5557778504	Mail
33	Shirley	Walker	46 Maple Rd	Hollister	MO	65727	5551110403	Radio
34	Kori	Yode	5234 Ash Rd	Ridgedale	MO	65777	5552228503	Radio
35	Jeanette	Parton	4435 Main St	Branson	MO	65726	5552228773	Radio
36	Brad	Langguth	123 Duck Creek Dr	Johnston	IA	50800	5553328888	Internet
37	Madison	Bonocore	57 West 159th St	Cushing	PA	87087	5552887722	Radio
38	Nancy	Langguth	123 Duck Creek Dr	Johnston	IA	50800	5553328888	Internet
39	Tim	Taylor	8206 Marshall Dr	Lenexa	KS	66214	5552229101	Mail
40	Hannah	Edwards	66900 College Rd	Overland Park	KS	66210	5552225102	Radio
41	Marcus	Edwards	66900 College Rd	Overland Park	KS	66210	5552225102	Radio
42	Kris	Goode	900 Barnes St	West Des Moines	IA	50265	5556661324	Mail
43	Lois	Goode	900 Barnes St	West Des Moines	IA	50265	5556661324	Mail
44	Samuel	Livingston	1551 Switzer St	Gardner	KS	66303	5556633366	Internet
45	Julie	Livingston	1551 Switzer St	Gardner	KS	66303	5556633366	Internet
46	Aaron	Alito	5989 Washington Ave	Hollister	MO	67827	5556766677	Internet
47	Kelsey	Hope	7800 West 16th St	Manhattan	KS	66502	5556655522	Internet
48	Orlando	Still	7722 Mastin St	Mission	KS	63552	5558887722	Internet
49	Maria	Still	7722 Mastin St	Mission	KS	63552	5558887722	Internet

SalesNo	SaleDate	CustNo	TourNo
2	2014-04-30	32	1
3	2014-04-30	6	3
4	2014-04-30	42	1
5	2014-04-30	43	1
6	2014-04-30	19	1
7	2014-05-01	3	12
8	2014-05-01	7	3
9	2014-05-05	33	10
10	2014-05-05	31	10
11	2014-05-05	12	10
12	2014-05-05	17	10
13	2014-05-11	4	2
14	2014-05-31	34	1
15	2014-06-01	30	36
16	2014-06-01	43	36
17	2014-06-01	39	36
18	2014-06-01	15	36
19	2014-06-01	7	47
20	2014-06-01	4	36
21	2014-06-01	6	47
22	2014-06-01	42	36
23	2014-06-01	18	36
24	2014-06-02	38	36
25	2014-06-02	36	36
26	2014-06-03	40	36
27	2014-06-03	41	36
28	2014-06-30	25	1
29	2014-07-01	6	36
30	2014-07-01	5	2
31	2014-07-01	29	2
32	2014-07-01	11	2
33	2014-07-01	3	2
34	2014-07-01	2	2
35	2014-07-01	1	2
36	2014-07-01	7	36
37	2014-07-02	15	2
38	2014-07-02	14	2
39	2014-07-07	43	51
40	2014-07-07	6	51
41	2014-07-07	7	51
42	2014-07-07	42	51
43	2014-07-08	8	51
44	2014-07-08	17	51
45	2014-07-09	9	36
46	2014-07-09	9	51
47	2014-07-09	41	51
48	2014-07-09	40	51
49	2014-07-09	19	51
50	2014-07-09	11	51
51	2014-07-09	12	36
52	2014-07-11	5	51
53	2014-07-11	26	3
54	2014-07-11	19	3
55	2014-07-12	20	3
56	2014-07-12	24	3
57	2014-07-12	21	3
58	2014-07-12	22	3
59	2014-07-13	30	3
60	2014-07-13	28	3
61	2014-07-13	29	3
62	2014-07-13	43	3
63	2014-07-13	42	3
64	2014-07-14	11	5
65	2014-07-14	15	5
66	2014-07-14	10	4
67	2014-07-14	13	4
68	2014-07-15	34	5
69	2014-07-15	14	5
70	2014-07-15	35	5
71	2014-07-15	17	5
72	2014-07-15	13	5
73	2014-07-15	12	5
74	2014-07-19	15	6
75	2014-07-19	31	6
76	2014-07-20	33	6
77	2014-07-20	42	6
78	2014-07-20	32	6
79	2014-07-20	43	6
80	2014-07-21	18	6
81	2014-07-21	25	6
82	2014-07-22	16	7
83	2014-07-22	22	7
84	2014-07-22	27	7
85	2014-07-22	28	7
86	2014-07-26	23	7
87	2014-07-26	20	7
88	2014-07-26	21	7
89	2015-06-01	24	8
90	2015-06-01	27	9
91	2015-06-01	26	8
92	2015-06-02	17	9
93	2015-06-03	15	9
94	2015-06-04	29	9
95	2015-06-08	25	8
96	2015-06-08	23	8
98	2014-08-01	36	44
99	2014-08-01	38	44
100	2014-06-14	42	46
101	2014-06-14	43	46
102	2014-08-02	20	45
103	2014-08-02	21	45

StateName	StateAbbreviation
Alaska	AK
Alabama	AL
Arkansas	AR
Arizona	AZ
California	CA
Colorado	CO
Connecticut	CT
District of Columbia	DC
Delaware	DE
Florida	FL
Georgia	GA
Hawaii	HI
Iowa	IA
Idaho	ID
Illinois	IL
Indiana	IN
Kansas	KS
Kentucky	KT
Louisiana	LA
Massachusetts	MA
Maryland	MD
Maine	ME
Michigan	MI
Minnesota	MN
Missouri	MO
Mississippi	MS
Montana	MT
North Carolina	NC
North Dakota	ND
Nebraska	NE
New Hampshire	NH
New Jersey	NJ
New Mexico	NM
Nevada	NV
New York	NY
Ohio	OH
Oklahoma	OK
Oregon	OR
Pennsylvania	PA
Rhode Island	RI
South Carolina	SC
South Dakota	SD
Tennessee	TN
Texas	TX
Utah	UT
Virginia	VA
Vermont	VT
Washington	WA
Wisconsin	WS
West Virginia	WV
Wyoming	WY

Category	Description
Adventure	Adventure tours include skiing, scuba, biking, hiking, and climbing tours.
Cultural	Cultural tours focus on historical festivals and cultural exchange.
Educational	Educational tours offer college credit.
Family	Family tours include weddings and reunions.
Service	Service tours send volunteer workers to areas hit by natural disasters.
Site Seeing	Site seeing tours focus on tourist attractions.
Sports	Sports tours offer a special inside look at major league sporting events.

TourNo	TourName	TourStartDate	Duration	City	StateAbbrev	Category	Price
1	Breeze Bay Shelling	2014-07-06	3	Captiva	FL	Adventure	¤ 750.00
2	Red Reef Scuba	2014-07-06	3	Islamadora	FL	Adventure	¤ 1,500.00
3	Ames Ski Club	2015-01-02	7	Breckenridge	CO	Adventure	¤ 850.00
4	Boy Scout Jamboree	2015-01-13	7	Vail	CO	Adventure	¤ 1,900.00
5	Bridgewater Country	2015-02-15	10	Aspen	CO	Adventure	¤ 1,200.00
6	Franklin Family Reunion	2015-03-11	3	Breckenridge	CO	Family	¤ 700.00
7	Spare Tire Ski Club	2015-03-13	7	Monmouth	WA	Adventure	¤ 600.00
8	Eagan Family Reunion	2015-06-12	7	Osage Beach	MO	Family	¤ 500.00
9	Gunnison Bikers	2015-06-20	4	Kimberling City	MO	Adventure	¤ 250.00
10	Golden Footsteps	2014-05-23	4	Kissimmee	FL	Site Seeing	¤ 550.00
11	Hummer Trail	2014-05-30	14	Key West	FL	Site Seeing	¤ 725.00
12	Piper-Heitman Wedding	2014-05-30	7	Captiva	FL	Family	¤ 550.00
13	High Adventurers	2014-06-05	7	Ft. Lauderdale	FL	Adventure	¤ 575.00
15	Patriot Debate Club	2014-06-12	7	Orlando	FL	Site Seeing	¤ 605.00
17	Tropical Sailboats	2014-06-19	14	Key West	FL	Adventure	¤ 655.00
18	Eagle Hiking Club	2014-06-19	7	Aspen	CO	Adventure	¤ 695.00
19	Paradise Water Club	2014-06-26	7	Hollister	MO	Adventure	¤ 595.00
20	Team Discovery	2014-06-29	5	Breckenridge	CO	Adventure	¤ 550.00
21	Gulfside Birdwatchers	2014-06-29	7	Tampa Bay	FL	Adventure	¤ 700.00
22	Perfect Waves	2014-06-27	5	Huntington Beach	CA	Adventure	¤ 500.00
23	Outrigger Cleanup	2014-06-29	7	Biloxi	MS	Service	¤ 395.00
24	Blue Canyon Youth	2014-07-01	7	New Orleans	LA	Service	¤ 425.00
25	Emmanuel Youth Club	2014-07-01	7	Diaberville	MS	Service	¤ 500.00
26	Dalgren-Smith Wedding	2014-07-02	3	West Des Moines	IA	Family	¤ 300.00
27	Lang Reunion	2014-07-02	3	Des Moines	IA	Family	¤ 350.00
28	Buehler Reunion	2014-07-02	4	Kimberling City	MO	Family	¤ 395.00
29	Silver Country	2014-07-13	14	Sacramento	CA	Educational	¤ 1,200.00
30	Monterey Mysteries	2014-07-14	7	Monterey	CA	Educational	¤ 800.00
31	Washington DC Band	2014-07-13	7	Washington	DC	Educational	¤ 890.00
33	Broadway Workshops	2014-08-24	7	New York City	NY	Educational	¤ 1,000.00
34	Colonial Tour	2014-08-19	14	Washington	DC	Educational	¤ 3,000.00
35	Freedom Tour	2014-08-24	7	Boston	MA	Educational	¤ 1,000.00
36	American Heritage Tour	2014-08-24	7	Philadelphia	PA	Educational	¤ 1,200.00
37	Cactus Language Exploration	2014-09-14	7	San Diego	CA	Educational	¤ 800.00
38	Water Education Foundation	2014-09-21	14	Fresno	CA	Educational	¤ 1,300.00
39	Oakland Museum of Science	2014-07-20	7	Oakland	CA	Educational	¤ 1,000.00
40	Redwood Forest Lab	2014-09-29	14	Mill Valley	CA	Educational	¤ 1,500.00
41	Langguth History	2014-10-19	10	Napa	CA	Site Seeing	¤ 900.00
43	Japanese California Connection	2014-08-19	4	Bolinas	CA	Site Seeing	¤ 424.00
44	Bear Valley Adventures	2014-08-19	3	Sacramento	CA	Adventure	¤ 725.00
45	Black Sheep Hiking Club	2014-08-26	14	El Dorado Hills	CA	Adventure	¤ 525.00
46	Bigfoot Rafting Club	2014-07-13	4	Placerville	CA	Adventure	¤ 455.00
47	Yosemite National Park Great Cleanup	2014-07-20	3	Sacramento	CA	Service	¤ 1,100.00
48	Kings Canyon Bridge Builders	2014-07-13	10	Three Rivers	CA	Service	¤ 950.00
49	Golden State Tours	2014-07-20	10	Sacramento	CA	Site Seeing	¤ 1,400.00
51	Bright Lights Expo	2014-12-01	7	Branson	MO	Site Seeing	¤ 200.00
52	Missouri Bald Eagle Watch Club	2014-08-13	7	Hollister	MO	Adventure	¤ 700.00

SELECT DISTINCTROW * FROM States;

SELECT TourCategories.Category FROM TourCategories;

PARAMETERS __TourNo Value; SELECT DISTINCTROW * FROM CustomerSales AS CustomerRoster WHERE ([__TourNo] = TourNo);

SELECT States.StateAbbreviation, States.StateName FROM States;

SELECT DISTINCTROW * FROM Tours;

SELECT Customers.CustNo, [LName] & ", " & [FName] AS CustomerName FROM Customers ORDER BY [LName] & ", " & [FName];

SELECT [States].[StateName], [States].[StateAbbreviation] FROM States ORDER BY [StateAbbreviation];

SELECT States.StateAbbreviation, States.StateAbbreviation, States.StateName FROM States ORDER BY States.StateName;

PARAMETERS __Category Value; SELECT DISTINCTROW * FROM Tours AS ToursByCategory WHERE ([__Category] = Category);

SELECT TourCategories.Category FROM TourCategories;

SELECT DISTINCTROW * FROM Customers;

SELECT DISTINCTROW * FROM Tours;

SELECT DISTINCTROW * FROM TourCategories;

SELECT DISTINCTROW * FROM Tours;

SELECT Tours.TourName, Tours.City, Tours.Category, Tours.Price, Customers.FName, Customers.LName FROM Tours INNER JOIN (Customers INNER JOIN Sales ON Customers.[CustNo] = Sales.[CustNo]) ON Tours.[TourNo] = Sales.[TourNo];

SELECT Tours.Category, Tours.TourName, Tours.TourStartDate, Tours.Price, Tours.Duration FROM Tours ORDER BY Tours.TourStartDate, Tours.Price;

SELECT States.StateName, Tours.TourName, Tours.TourStartDate, Tours.Price, Tours.StateAbbrev FROM States INNER JOIN Tours ON States.StateAbbreviation = Tours.StateAbbrev WHERE (((Tours.StateAbbrev)=[Forms]![Switchboard]![cboFindState])) ORDER BY States.StateName, Tours.TourName;

Access Unit C/RealEstate-C.accdb

AgencyNo	AgencyName	Street	City	State	Zip	AgencyPhone
1	Four Lakes Realtors	123 First Street	Kimberling City	MO	77889	555-666-7700
2	Marvin and Pam Realtors	7878 Lake View Lane	Branson	MO	77770	555-555-8800
3	Emerald Point Realtors	9900 West Sunset Drive	West Branson	MO	77990	555-999-9999
4	Hollister Real Estate	7744 Pokeberry Lane	Hollister	MO	77660	555-888-4444

Type
Cabin
Condo
Log Cabin
Patio Home
Ranch
Two Story

ListingNo	Type	SchoolDistrict	SqFt	LotAcres	BR	Bath	Garage	Pool	Asking	RealtorNo	ListingDate
1	Ranch	Ozark Mountain	3400	0.5	4	4.0	2	false	¤ 90,000.00	1	2014-01-04
2	Ranch	Ridgedale	3000	0.5	2	3.0	0	false	¤ 129,000.00	1	2014-01-05
3	Cabin	Ridgedale	2900	0.5	3	2.5	2	false	¤ 135,000.00	1	2014-01-31
4	Cabin	Horseshoe Bend	1200	0.4	4	3.0	2	false	¤ 150,000.00	2	2014-03-01
5	Ranch	Ridgedale	2500	1.0	3	2.5	0	false	¤ 199,000.00	2	2014-04-01
7	Two Story	Ozark Mountain	3000	1.0	4	4.0	2	false	¤ 276,000.00	2	2014-05-01
8	Two Story	Shell City	1800	0.4	3	3.0	2	false	¤ 138,000.00	2	2014-06-01
9	Ranch	Horseshoe Bend	2000	1.5	3	3.5	0	false	¤ 105,000.00	7	2014-03-01
10	Ranch	Ridgedale	2000	0.5	3	3.0	2	false	¤ 250,000.00	8	2014-04-01
11	Ranch	Ridgedale	1215	0.5	3	2.0	0	false	¤ 85,000.00	1	2014-03-01
12	Ranch	Greenview	2200	0.7	3	3.0	2	false	¤ 395,613.00	2	2014-05-01
13	Two Story	Blue Eye	3000	0.5	4	3.0	2	false	¤ 199,950.00	3	2014-05-01
14	Two Story	Greenview	5500	0.4	4	2.5	3	true	¤ 194,500.00	3	2014-06-01
15	Two Story	Branson West	2500	0.6	3	2.0	2	false	¤ 189,900.00	3	2014-01-05
16	Ranch	Branson	2700	0.6	4	3.0	2	false	¤ 189,900.00	4	2003-04-01
17	Log Cabin	Cape Fair	2000	1.0	3	2.0	0	false	¤ 189,900.00	4	2014-05-01
18	Ranch	Kimberling City	2500	1.2	3	4.0	2	false	¤ 189,900.00	4	2014-05-15
19	Two Story	Shell City	3200	0.9	3	4.5	0	false	¤ 187,500.00	4	2004-05-31
20	Two Story	Kimberling City	2700	1.0	3	3.0	2	false	¤ 147,900.00	4	2014-06-15
21	Patio Home	Kimberling City	2200	0.4	2	2.0	1	true	¤ 139,900.00	4	2014-07-01
22	Cabin	Kimberling City	1350	0.7	2	2.0	2	false	¤ 127,900.00	5	2014-01-04
23	Two Story	Galena	2000	0.5	4	1.0	0	false	¤ 124,900.00	5	2014-01-31
24	Patio Home	Galena	1200	0.4	3	2.0	0	false	¤ 120,000.00	6	2014-05-01
25	Cabin	Kimberling City	1900	0.5	3	1.0	0	false	¤ 111,900.00	8	2014-04-01
26	Ranch	Lampe	3000	2.0	3	2.5	3	false	¤ 399,999.00	8	2014-05-15
27	Cabin	Oakmont	2000	1.2	4	3.0	0	false	¤ 280,000.00	1	2014-03-02

RealtorNo	RFirst	RLast	RPhone	AgencyNo
1	Aaron	West	555-222-8877	1
2	Phil	Kirkpatrick	555-111-9900	1
3	Jessica	Podor	555-333-3344	3
4	Malika	Thompson	555-444-7788	3
5	Jane Ann	Welch	555-223-0044	2
6	Shari	Duncan	555-228-5577	2
7	Trixie	Angelina	555-220-4466	2
8	Mary	Baldwin	555-888-7777	1
9	Deb	Trumpet	555-333-0123	1
10	Cy	Clone	555-888-9999	4
11	Rob	Zacharias	555-888-1111	4

PARAMETERS __RealtorNo Value; SELECT DISTINCTROW * FROM Listings AS RealtorsMainForm WHERE ([__RealtorNo] = RealtorNo);

SELECT DISTINCTROW * FROM Listings;

SELECT DISTINCTROW * FROM Realtors;

SELECT Realtors.RFirst, Realtors.RLast, Listings.Type, Listings.SqFt, Listings.Asking FROM Realtors INNER JOIN Listings ON Realtors.RealtorNo = Listings.RealtorNo;

Access Unit C/Recycle-C.accdb

CenterName	CenterStreet	CenterCity	CenterState	CenterZip	CenterPhone	ContactFirst	ContactLast	CenterNumber	Hazardous
Hugo Trash Can	987 Main Street	Lenexa	KS	61111	5551236666	Benjamin	Knox	1	true
Bachman Underdrive Trash	12345 College Boulevard	Overland Park	KS	63444	5552227897	Phyllis	Stein	2	true
Taney County Landfill	12444 Murlen Drive	Shawnee	KS	64222	5557809999	John	Sharona	3	false
Stone County Landfill	78900 180th Street	Olathe	KS	65444	5551111234	Emir	Cipra	4	false

ClubNumber	ClubName	ClubStreet	ClubCity	ClubState	ClubZip	ClubPhone	FName	LName
1	Dallas Jaycees	111 Elm Street	Overland Park	KS	66213	5551238888	Francis	Bender
2	Boy Scout Troop 7	22 West 67th Drive	Mission	KS	60603	5551117777	Mason	Schaffer
3	Great Plains 4-H	44 East 99th Road	Lenexa	KS	66111	5552222222	Renaldo	Holt
4	Lions of Bridgewater	777 Oxford Street	Fontanelle	KS	66333	5553333111	Cory	Mills
5	Junior League	3333 Princeton Lane	Point Lookout	MO	55886	7772134333	Lottie	Moon
6	Ice Kings	55 Oak Drive	Ridgedale	MO	55887	7771224444	Marcus	Jackson
7	KC Patriots	888 Switzer Street	Kansas City	MO	55888	7772223333	Trixie	Cho

DepositID	DepositDate	Weight	CenterNumber	ClubNumber
1	2014-01-30	60.0	4	1
2	2014-01-30	100.0	4	1
3	2014-02-04	75.0	2	4
4	2014-02-04	80.0	1	4
5	2014-02-08	150.0	2	5
6	2014-02-13	200.0	2	6
7	2014-02-14	50.0	2	1
8	2014-02-16	50.0	1	7
9	2014-02-17	40.0	3	1
10	2014-02-18	100.0	4	7
11	2014-02-20	200.0	4	2
12	2014-02-22	75.0	4	6
13	2014-02-23	80.0	1	4
14	2014-02-26	100.0	4	6
15	2014-03-01	150.0	2	5
16	2014-03-02	70.0	4	4
17	2014-03-03	100.0	3	7
18	2014-03-04	150.0	3	5
19	2014-03-05	200.0	4	1
20	2014-03-06	50.0	2	6
22	2015-01-30	100.0	2	6
23	2015-02-04	80.0	1	4
24	2015-02-04	75.0	4	4
25	2015-02-08	150.0	2	5
26	2015-02-13	185.0	2	6
27	2015-02-14	50.0	4	1
28	2015-02-16	35.0	1	7
29	2015-02-17	40.0	3	1
30	2015-02-18	185.0	4	6
31	2015-02-20	200.0	3	2
32	2015-02-22	75.0	4	5
33	2015-02-23	80.0	1	4
34	2015-02-26	65.0	2	4
35	2015-03-02	150.0	1	5
36	2015-03-03	50.0	3	4
37	2015-03-04	45.0	3	7
38	2015-03-05	75.0	4	5
39	2015-03-06	200.0	1	1
40	2015-03-07	145.0	4	6
41	2015-04-19	115.0	4	6
42	2015-04-20	65.0	4	1
43	2015-04-22	105.0	2	1
44	2015-04-23	90.0	4	2
45	2015-04-25	65.0	1	1
46	2015-04-30	205.0	3	2
47	2015-05-01	105.0	4	6
48	2015-05-07	190.0	3	2
49	2015-06-04	90.0	4	4
50	2015-06-07	65.0	3	4
51	2015-06-19	65.0	1	4
52	2015-06-20	85.0	4	5
53	2015-06-22	95.0	3	1
54	2015-07-07	75.0	3	5
55	2015-07-08	200.0	2	1
56	2015-08-31	50.0	4	6
57	2015-09-24	200.0	2	5
58	2015-10-01	90.0	3	5
59	2015-10-02	90.0	4	4
60	2015-10-04	80.0	2	5
61	2016-01-04	60.0	1	2
62	2016-01-06	90.0	2	7
63	2016-02-14	50.0	3	7
64	2016-02-18	30.0	2	2
65	2016-02-21	50.0	4	6
66	2016-02-22	100.0	3	6
67	2016-02-28	125.0	2	4
68	2016-03-15	60.0	1	2
69	2016-04-03	115.0	1	4
70	2016-04-18	105.0	1	2
71	2016-05-18	90.0	2	2
72	2016-05-19	80.0	3	1
73	2016-05-20	50.0	4	1
74	2016-05-31	60.0	4	6
75	2016-06-01	65.0	3	4
76	2016-06-07	75.0	3	5
77	2016-06-08	95.0	2	2
78	2016-06-09	90.0	2	1
79	2016-07-10	85.0	1	2
80	2016-07-11	95.0	1	4
81	2016-07-16	65.0	4	6
82	2016-07-17	85.0	3	4
83	2016-07-19	45.0	2	5
84	2016-08-19	205.0	1	7
85	2016-08-20	105.0	2	1
86	2016-09-18	30.0	3	2
87	2016-10-19	60.0	4	4
88	2016-10-20	40.0	3	4
89	2016-10-30	90.0	2	4
90	2016-10-31	80.0	1	1
91	2016-11-01	25.0	2	4
92	2016-11-02	100.0	4	2
93	2016-11-16	85.0	4	5
94	2016-11-17	75.0	3	5
95	2016-11-18	85.0	3	6
96	2016-11-29	90.0	3	5
97	2016-12-01	80.0	2	6
98	2016-12-03	70.0	2	7
99	2016-12-06	80.0	1	7
100	2016-12-16	50.0	4	6

SELECT Centers.CenterName, Deposits.DepositDate, Deposits.Weight, Clubs.ClubName FROM Clubs INNER JOIN (Centers INNER JOIN Deposits ON Centers.[CenterNumber] = Deposits.[CenterNumber]) ON Clubs.[ClubNumber] = Deposits.[ClubNumber];

PlayerNo	GameNo	FieldGoals	FieldGoalAttempts	3Pointers	3PointAttempts	FreeThrows	FreeThrowAttempts	ReboundOffense	ReboundDefense	Assists
5	1	3	4	2	2	1	1	1	2	2
5	2	4	6	1	3	3	3	2	2	4
5	3	5	6	2	3	2	4	2	1	2
5	4	5	7	3	3	3	3	3	1	1
5	5	6	8	3	3	5	6	1	1	1
5	6	4	8	1	1	1	3	1	3	2
5	7	4	7	2	2	2	2	2	2	2
5	8	3	4	2	2	1	1	2	1	3
5	9	4	5	2	6	3	4	1	4	3
5	10	4	6	2	4	3	3	2	5	3
12	1	2	3	1	1	1	1	1	2	1
12	2	3	2	0	0	3	4	3	3	1
12	3	5	6	0	0	2	4	4	3	1
12	4	5	7	0	0	3	3	2	3	1
12	5	6	8	0	0	4	6	2	3	0
12	6	4	8	0	0	2	3	2	5	2
12	7	4	7	0	0	3	3	4	6	2
12	8	3	4	0	0	1	1	5	7	3
12	9	4	5	0	1	4	6	5	4	4
12	10	4	6	1	2	3	3	5	5	1
21	1	1	3	1	1	1	1	5	3	1
21	2	1	2	0	0	1	4	1	4	1
21	3	1	1	0	0	4	4	1	4	1
21	4	1	1	0	0	5	5	3	2	1
21	5	1	2	0	0	6	6	5	2	0
21	6	0	1	0	0	2	3	4	2	1
21	7	0	0	0	0	2	3	2	2	0
21	8	0	1	0	0	1	1	2	1	0
21	9	2	2	0	1	5	6	2	5	0
21	10	2	3	1	1	5	3	1	3	1
42	1	2	5	1	2	4	4	2	3	1
42	2	2	4	1	2	5	5	5	3	2
42	3	5	3	2	4	4	5	5	3	1
42	4	2	2	2	5	5	6	2	2	1
42	5	1	1	2	3	6	8	2	3	3
42	6	0	6	1	2	2	4	2	4	1
42	7	2	2	0	2	5	5	5	2	0
42	8	4	5	1	3	3	4	5	1	3
42	9	1	2	2	2	1	3	1	4	0
42	10	5	5	1	1	1	3	5	2	1
45	1	1	4	0	2	1	1	1	2	1
45	2	2	3	0	3	1	1	1	5	1
45	3	1	3	0	0	1	1	2	2	1
45	4	2	3	0	0	1	1	1	4	1
45	5	2	2	0	0	1	3	1	2	1
45	6	3	3	0	0	1	3	1	2	1
45	7	1	2	0	0	1	1	3	4	1
45	8	1	4	2	2	1	1	2	4	1
45	9	1	3	0	0	1	2	1	3	2
45	10	3	3	0	0	1	1	1	5	2
51	1	1	5	0	0	2	4	4	6	1
51	2	2	4	0	0	3	5	3	6	1
51	3	1	3	0	0	4	5	3	4	1
51	4	1	4	0	0	5	6	3	3	1
51	5	3	4	0	0	5	5	2	4	1
51	6	0	2	0	0	2	4	1	2	3
51	7	2	3	0	0	5	5	1	2	2
51	8	3	3	0	0	3	4	1	3	1
51	9	1	5	0	0	5	5	3	3	2
51	10	3	3	0	1	4	5	4	4	1

PlayerNo	GameNo	FieldGoals	FieldGoalAttempts	3Pointers	3PointAttempts	FreeThrows	FreeThrowAttempts	ReboundOffense	ReboundDefense	Assists
5	1	3	4	2	2	1	1	1	2	2
5	2	4	6	1	3	3	3	2	2	4
5	3	5	6	2	3	2	4	2	1	2
5	4	5	7	3	3	3	3	3	1	1
5	5	6	8	3	3	5	6	1	1	1
5	6	4	8	1	1	1	3	1	3	2
5	7	4	7	2	2	2	2	2	2	2
5	8	3	4	2	2	1	1	2	1	3
5	9	4	5	2	6	3	4	1	4	3
5	10	4	6	2	4	3	3	2	5	3
12	1	2	3	1	1	1	1	1	2	1
12	2	3	2	0	0	3	4	3	3	1
12	3	5	6	0	0	2	4	4	3	1
12	4	5	7	0	0	3	3	2	3	1
12	5	6	8	0	0	4	6	2	3	0
12	6	4	8	0	0	2	3	2	5	2
12	7	4	7	0	0	3	3	4	6	2
12	8	3	4	0	0	1	1	5	7	3
12	9	4	5	0	1	4	6	5	4	4
12	10	4	6	1	2	3	3	5	5	1
21	1	1	3	1	1	1	1	5	3	1
21	2	1	2	0	0	1	4	1	4	1
21	3	1	1	0	0	4	4	1	4	1
21	4	1	1	0	0	5	5	3	2	1
21	5	1	2	0	0	6	6	5	2	0
21	6	0	1	0	0	2	3	4	2	1
21	7	0	0	0	0	2	3	2	2	0
21	8	0	1	0	0	1	1	2	1	0
21	9	2	2	0	1	5	6	2	5	0
21	10	2	3	1	1	5	3	1	3	1
42	1	2	5	1	2	4	4	2	3	1
42	2	2	4	1	2	5	5	5	3	2
42	3	5	3	2	4	4	5	5	3	1
42	4	2	2	2	5	5	6	2	2	1
42	5	1	1	2	3	6	8	2	3	3
42	6	0	6	1	2	2	4	2	4	1
42	7	2	2	0	2	5	5	5	2	0
42	8	4	5	1	3	3	4	5	1	3
42	9	1	2	2	2	1	3	1	4	0
42	10	5	5	1	1	1	3	5	2	1
45	1	1	4	0	2	1	1	1	2	1
45	2	2	3	0	3	1	1	1	5	1
45	3	1	3	0	0	1	1	2	2	1
45	4	2	3	0	0	1	1	1	4	1
45	5	2	2	0	0	1	3	1	2	1
45	6	3	3	0	0	1	3	1	2	1
45	7	1	2	0	0	1	1	3	4	1
45	8	1	4	2	2	1	1	2	4	1
45	9	1	3	0	0	1	2	1	3	2
45	10	3	3	0	0	1	1	1	5	2
51	1	1	5	0	0	2	4	4	6	1
51	2	2	4	0	0	3	5	3	6	1
51	3	1	3	0	0	4	5	3	4	1
51	4	1	4	0	0	5	6	3	3	1
51	5	3	4	0	0	5	5	2	4	1
51	6	0	2	0	0	2	4	1	2	3
51	7	2	3	0	0	5	5	1	2	2
51	8	3	3	0	0	3	4	1	3	1
51	9	1	5	0	0	5	5	3	3	2
51	10	3	3	0	1	4	5	4	4	1

PlayerNo	GameNo	FieldGoals	FieldGoalAttempts	3Pointers	3PointAttempts	FreeThrows	FreeThrowAttempts	ReboundOffense	ReboundDefense	Assists
5	1	3	4	2	2	1	1	1	2	2
5	2	4	6	1	3	3	3	2	2	4
5	3	5	6	2	3	2	4	2	1	2
5	4	5	7	3	3	3	3	3	1	1
5	5	6	8	3	3	5	6	1	1	1
5	6	4	8	1	1	1	3	1	3	2
5	7	4	7	2	2	2	2	2	2	2
5	8	3	4	2	2	1	1	2	1	3
5	9	4	5	2	6	3	4	1	4	3
5	10	4	6	2	4	3	3	2	5	3
12	1	2	3	1	1	1	1	1	2	1
12	2	3	2	0	0	3	4	3	3	1
12	3	5	6	0	0	2	4	4	3	1
12	4	5	7	0	0	3	3	2	3	1
12	5	6	8	0	0	4	6	2	3	0
12	6	4	8	0	0	2	3	2	5	2
12	7	4	7	0	0	3	3	4	6	2
12	8	3	4	0	0	1	1	5	7	3
12	9	4	5	0	1	4	6	5	4	4
12	10	4	6	1	2	3	3	5	5	1
21	1	1	3	1	1	1	1	5	3	1
21	2	1	2	0	0	1	4	1	4	1
21	3	1	1	0	0	4	4	1	4	1
21	4	1	1	0	0	5	5	3	2	1
21	5	1	2	0	0	6	6	5	2	0
21	6	0	1	0	0	2	3	4	2	1
21	7	0	0	0	0	2	3	2	2	0
21	8	0	1	0	0	1	1	2	1	0
21	9	2	2	0	1	5	6	2	5	0
21	10	2	3	1	1	5	3	1	3	1
42	1	2	5	1	2	4	4	2	3	1
42	2	2	4	1	2	5	5	5	3	2
42	3	5	3	2	4	4	5	5	3	1
42	4	2	2	2	5	5	6	2	2	1
42	5	1	1	2	3	6	8	2	3	3
42	6	0	6	1	2	2	4	2	4	1
42	7	2	2	0	2	5	5	5	2	0
42	8	4	5	1	3	3	4	5	1	3
42	9	1	2	2	2	1	3	1	4	0
42	10	5	5	1	1	1	3	5	2	1
45	1	1	4	0	2	1	1	1	2	1
45	2	2	3	0	3	1	1	1	5	1
45	3	1	3	0	0	1	1	2	2	1
45	4	2	3	0	0	1	1	1	4	1
45	5	2	2	0	0	1	3	1	2	1
45	6	3	3	0	0	1	3	1	2	1
45	7	1	2	0	0	1	1	3	4	1
45	8	1	4	2	2	1	1	2	4	1
45	9	1	3	0	0	1	2	1	3	2
45	10	3	3	0	0	1	1	1	5	2
51	1	1	5	0	0	2	4	4	6	1
51	2	2	4	0	0	3	5	3	6	1
51	3	1	3	0	0	4	5	3	4	1
51	4	1	4	0	0	5	6	3	3	1
51	5	3	4	0	0	5	5	2	4	1
51	6	0	2	0	0	2	4	1	2	3
51	7	2	3	0	0	5	5	1	2	2
51	8	3	3	0	0	3	4	1	3	1
51	9	1	5	0	0	5	5	3	3	2
51	10	3	3	0	1	4	5	4	4	1

PlayerNo	GameNo	FieldGoals	FieldGoalAttempts	3Pointers	3PointAttempts	FreeThrows	FreeThrowAttempts	ReboundOffense	ReboundDefense	Assists
5	1	3	4	2	2	1	1	1	2	2
5	2	4	6	1	3	3	3	2	2	4
5	3	5	6	2	3	2	4	2	1	2
5	4	5	7	3	3	3	3	3	1	1
5	5	6	8	3	3	5	6	1	1	1
5	6	4	8	1	1	1	3	1	3	2
5	7	4	7	2	2	2	2	2	2	2
5	8	3	4	2	2	1	1	2	1	3
5	9	4	5	2	6	3	4	1	4	3
5	10	4	6	2	4	3	3	2	5	3
12	1	2	3	1	1	1	1	1	2	1
12	2	3	2	0	0	3	4	3	3	1
12	3	5	6	0	0	2	4	4	3	1
12	4	5	7	0	0	3	3	2	3	1
12	5	6	8	0	0	4	6	2	3	0
12	6	4	8	0	0	2	3	2	5	2
12	7	4	7	0	0	3	3	4	6	2
12	8	3	4	0	0	1	1	5	7	3
12	9	4	5	0	1	4	6	5	4	4
12	10	4	6	1	2	3	3	5	5	1
21	1	1	3	1	1	1	1	5	3	1
21	2	1	2	0	0	1	4	1	4	1
21	3	1	1	0	0	4	4	1	4	1
21	4	1	1	0	0	5	5	3	2	1
21	5	1	2	0	0	6	6	5	2	0
21	6	0	1	0	0	2	3	4	2	1
21	7	0	0	0	0	2	3	2	2	0
21	8	0	1	0	0	1	1	2	1	0
21	9	2	2	0	1	5	6	2	5	0
21	10	2	3	1	1	5	3	1	3	1
42	1	2	5	1	2	4	4	2	3	1
42	2	2	4	1	2	5	5	5	3	2
42	3	5	3	2	4	4	5	5	3	1
42	4	2	2	2	5	5	6	2	2	1
42	5	1	1	2	3	6	8	2	3	3
42	6	0	6	1	2	2	4	2	4	1
42	7	2	2	0	2	5	5	5	2	0
42	8	4	5	1	3	3	4	5	1	3
42	9	1	2	2	2	1	3	1	4	0
42	10	5	5	1	1	1	3	5	2	1
45	1	1	4	0	2	1	1	1	2	1
45	2	2	3	0	3	1	1	1	5	1
45	3	1	3	0	0	1	1	2	2	1
45	4	2	3	0	0	1	1	1	4	1
45	5	2	2	0	0	1	3	1	2	1
45	6	3	3	0	0	1	3	1	2	1
45	7	1	2	0	0	1	1	3	4	1
45	8	1	4	2	2	1	1	2	4	1
45	9	1	3	0	0	1	2	1	3	2
45	10	3	3	0	0	1	1	1	5	2
51	1	1	5	0	0	2	4	4	6	1
51	2	2	4	0	0	3	5	3	6	1
51	3	1	3	0	0	4	5	3	4	1
51	4	1	4	0	0	5	6	3	3	1
51	5	3	4	0	0	5	5	2	4	1
51	6	0	2	0	0	2	4	1	2	3
51	7	2	3	0	0	5	5	1	2	2
51	8	3	3	0	0	3	4	1	3	1
51	9	1	5	0	0	5	5	3	3	2
51	10	3	3	0	1	4	5	4	4	1

PlayerNo	GameNo	FieldGoals	FieldGoalAttempts	3Pointers	3PointAttempts	FreeThrows	FreeThrowAttempts	ReboundOffense	ReboundDefense	Assists
5	1	3	4	2	2	1	1	1	2	2
5	2	4	6	1	3	3	3	2	2	4
5	3	5	6	2	3	2	4	2	1	2
5	4	5	7	3	3	3	3	3	1	1
5	5	6	8	3	3	5	6	1	1	1
5	6	4	8	1	1	1	3	1	3	2
5	7	4	7	2	2	2	2	2	2	2
5	8	3	4	2	2	1	1	2	1	3
5	9	4	5	2	6	3	4	1	4	3
5	10	4	6	2	4	3	3	2	5	3
12	1	2	3	1	1	1	1	1	2	1
12	2	3	2	0	0	3	4	3	3	1
12	3	5	6	0	0	2	4	4	3	1
12	4	5	7	0	0	3	3	2	3	1
12	5	6	8	0	0	4	6	2	3	0
12	6	4	8	0	0	2	3	2	5	2
12	7	4	7	0	0	3	3	4	6	2
12	8	3	4	0	0	1	1	5	7	3
12	9	4	5	0	1	4	6	5	4	4
12	10	4	6	1	2	3	3	5	5	1
21	1	1	3	1	1	1	1	5	3	1
21	2	1	2	0	0	1	4	1	4	1
21	3	1	1	0	0	4	4	1	4	1
21	4	1	1	0	0	5	5	3	2	1
21	5	1	2	0	0	6	6	5	2	0
21	6	0	1	0	0	2	3	4	2	1
21	7	0	0	0	0	2	3	2	2	0
21	8	0	1	0	0	1	1	2	1	0
21	9	2	2	0	1	5	6	2	5	0
21	10	2	3	1	1	5	3	1	3	1
42	1	2	5	1	2	4	4	2	3	1
42	2	2	4	1	2	5	5	5	3	2
42	3	5	3	2	4	4	5	5	3	1
42	4	2	2	2	5	5	6	2	2	1
42	5	1	1	2	3	6	8	2	3	3
42	6	0	6	1	2	2	4	2	4	1
42	7	2	2	0	2	5	5	5	2	0
42	8	4	5	1	3	3	4	5	1	3
42	9	1	2	2	2	1	3	1	4	0
42	10	5	5	1	1	1	3	5	2	1
45	1	1	4	0	2	1	1	1	2	1
45	2	2	3	0	3	1	1	1	5	1
45	3	1	3	0	0	1	1	2	2	1
45	4	2	3	0	0	1	1	1	4	1
45	5	2	2	0	0	1	3	1	2	1
45	6	3	3	0	0	1	3	1	2	1
45	7	1	2	0	0	1	1	3	4	1
45	8	1	4	2	2	1	1	2	4	1
45	9	1	3	0	0	1	2	1	3	2
45	10	3	3	0	0	1	1	1	5	2
51	1	1	5	0	0	2	4	4	6	1
51	2	2	4	0	0	3	5	3	6	1
51	3	1	3	0	0	4	5	3	4	1
51	4	1	4	0	0	5	6	3	3	1
51	5	3	4	0	0	5	5	2	4	1
51	6	0	2	0	0	2	4	1	2	3
51	7	2	3	0	0	5	5	1	2	2
51	8	3	3	0	0	3	4	1	3	1
51	9	1	5	0	0	5	5	3	3	2
51	10	3	3	0	1	4	5	4	4	1

PlayerNo	GameNo	FieldGoals	FieldGoalAttempts	3Pointers	3PointAttempts	FreeThrows	FreeThrowAttempts	ReboundOffense	ReboundDefense	Assists
5	1	3	4	2	2	1	1	1	2	2
5	2	4	6	1	3	3	3	2	2	4
5	3	5	6	2	3	2	4	2	1	2
5	4	5	7	3	3	3	3	3	1	1
5	5	6	8	3	3	5	6	1	1	1
5	6	4	8	1	1	1	3	1	3	2
5	7	4	7	2	2	2	2	2	2	2
5	8	3	4	2	2	1	1	2	1	3
5	9	4	5	2	6	3	4	1	4	3
5	10	4	6	2	4	3	3	2	5	3
12	1	2	3	1	1	1	1	1	2	1
12	2	3	2	0	0	3	4	3	3	1
12	3	5	6	0	0	2	4	4	3	1
12	4	5	7	0	0	3	3	2	3	1
12	5	6	8	0	0	4	6	2	3	0
12	6	4	8	0	0	2	3	2	5	2
12	7	4	7	0	0	3	3	4	6	2
12	8	3	4	0	0	1	1	5	7	3
12	9	4	5	0	1	4	6	5	4	4
12	10	4	6	1	2	3	3	5	5	1
21	1	1	3	1	1	1	1	5	3	1
21	2	1	2	0	0	1	4	1	4	1
21	3	1	1	0	0	4	4	1	4	1
21	4	1	1	0	0	5	5	3	2	1
21	5	1	2	0	0	6	6	5	2	0
21	6	0	1	0	0	2	3	4	2	1
21	7	0	0	0	0	2	3	2	2	0
21	8	0	1	0	0	1	1	2	1	0
21	9	2	2	0	1	5	6	2	5	0
21	10	2	3	1	1	5	3	1	3	1
42	1	2	5	1	2	4	4	2	3	1
42	2	2	4	1	2	5	5	5	3	2
42	3	5	3	2	4	4	5	5	3	1
42	4	2	2	2	5	5	6	2	2	1
42	5	1	1	2	3	6	8	2	3	3
42	6	0	6	1	2	2	4	2	4	1
42	7	2	2	0	2	5	5	5	2	0
42	8	4	5	1	3	3	4	5	1	3
42	9	1	2	2	2	1	3	1	4	0
42	10	5	5	1	1	1	3	5	2	1
45	1	1	4	0	2	1	1	1	2	1
45	2	2	3	0	3	1	1	1	5	1
45	3	1	3	0	0	1	1	2	2	1
45	4	2	3	0	0	1	1	1	4	1
45	5	2	2	0	0	1	3	1	2	1
45	6	3	3	0	0	1	3	1	2	1
45	7	1	2	0	0	1	1	3	4	1
45	8	1	4	2	2	1	1	2	4	1
45	9	1	3	0	0	1	2	1	3	2
45	10	3	3	0	0	1	1	1	5	2
51	1	1	5	0	0	2	4	4	6	1
51	2	2	4	0	0	3	5	3	6	1
51	3	1	3	0	0	4	5	3	4	1
51	4	1	4	0	0	5	6	3	3	1
51	5	3	4	0	0	5	5	2	4	1
51	6	0	2	0	0	2	4	1	2	3
51	7	2	3	0	0	5	5	1	2	2
51	8	3	3	0	0	3	4	1	3	1
51	9	1	5	0	0	5	5	3	3	2
51	10	3	3	0	1	4	5	4	4	1