CIS Access

profileMUMEI
Salvage-3.accdb
Home>Computer Science homework help>CIS Access
CenterName CenterStreet CenterCity CenterState CenterZip CenterPhone ContactFirst ContactLast CenterNumber Hazardous
A1 Salvage Center 987 Main Street Stillwell KS 61111 5551236666 Rhea Knox 1 true
Johnson Recycling 12345 Antioch Boulevard Bridgewater KS 63444 5552227897 Derek Pence 2 true
Adair county Recycling 12444 Cordoba Drive Adair KS 64222 5557809999 Andrea Russo 3 false
Taney County Salvage 78900 Carthage Street Greenfield KS 65444 5551111234 Gina Pitt 4 false
ClubNumber ClubName ClubStreet ClubCity ClubState ClubZip ClubPhone FName LName
1 Kansas City Frogman Club 111 Elm Street Overland Park KS 66213 5551238888 Jordan Smith
2 Boy Scout Troop 324 22 West 67th Drive Mission KS 60603 5551117777 Charles Schaffer
3 Great Plains 4-H 44 East 99th Road Lenexa KS 66111 5552222222 Renaldo Bartles
4 JavaScript KC 777 Oxford Street Fontanelle KS 66333 5553333111 Cory Harding
5 Junior League 3333 Princeton Lane Point Lookout MO 55886 7772134333 Amy Moon
6 Access Users Group 55 Oak Drive Ridgedale MO 55887 7771224444 Trey Hickman
7 Social Media Club 888 Switzer Street Kansas City MO 55888 7772223333 Trixie Cho
8 Alpha Alpha Alpha 1414 Sunset Drive Ames IA 50010 5557778888 Student First Student last
DepositID DepositDate Weight CenterNumber ClubNumber
1 1/30/14 60.0 4 1
2 1/30/14 100.0 4 1
3 2/4/14 75.0 2 4
4 2/4/14 80.0 1 4
5 2/8/14 150.0 2 5
6 2/13/14 200.0 2 6
7 2/14/14 50.0 2 1
8 2/16/14 50.0 1 7
9 2/17/14 40.0 3 1
10 2/18/14 100.0 4 7
11 2/20/14 200.0 4 2
12 2/22/14 75.0 4 6
13 2/23/14 80.0 1 4
14 2/26/14 100.0 4 6
15 3/1/14 150.0 2 5
16 3/2/14 70.0 4 4
17 3/3/14 100.0 3 7
18 3/4/14 150.0 3 5
19 3/5/14 200.0 4 1
20 3/6/14 50.0 2 6
21 1/30/15 60.0 1 1
22 1/30/15 100.0 2 6
23 2/4/15 80.0 1 4
24 2/4/15 75.0 4 4
25 2/8/15 150.0 2 5
26 2/13/15 185.0 2 6
27 2/14/15 50.0 4 1
28 2/16/15 35.0 1 7
29 2/17/15 40.0 3 1
30 2/18/15 185.0 4 6
31 2/20/15 200.0 3 2
32 2/22/15 75.0 4 5
33 2/23/15 80.0 1 4
34 2/26/15 65.0 2 4
35 3/2/15 150.0 1 5
36 3/3/15 50.0 3 4
37 3/4/15 45.0 3 7
38 3/5/15 75.0 4 5
39 3/6/15 200.0 1 1
40 3/7/15 145.0 4 6
41 4/19/15 115.0 4 6
42 4/20/15 65.0 4 1
43 4/22/15 105.0 2 1
44 4/23/15 90.0 4 2
45 4/25/15 65.0 1 1
46 4/30/15 205.0 3 2
47 5/1/15 105.0 4 6
48 5/7/15 190.0 3 2
49 6/4/15 90.0 4 4
50 6/7/15 65.0 3 4
51 6/19/15 65.0 1 4
52 6/20/15 85.0 4 5
53 6/22/15 95.0 3 1
54 7/7/15 75.0 3 5
55 7/8/15 200.0 2 1
56 8/31/15 50.0 4 6
57 9/24/15 200.0 2 5
58 10/1/15 90.0 3 5
59 10/2/15 90.0 4 4
60 10/4/15 80.0 2 5
61 1/4/16 60.0 1 2
62 1/6/16 90.0 2 7
63 2/14/16 50.0 3 7
64 2/18/16 30.0 2 2
65 2/21/16 50.0 4 6
66 2/22/16 100.0 3 6
67 2/28/16 125.0 2 4
68 3/15/16 60.0 1 2
69 4/3/16 115.0 1 4
70 4/18/16 105.0 1 2
71 5/18/16 90.0 2 2
72 5/19/16 80.0 3 1
73 5/20/16 50.0 4 1
74 5/31/16 60.0 4 6
75 6/1/16 65.0 3 4
76 6/7/16 75.0 3 5
77 6/8/16 95.0 2 2
78 6/9/16 90.0 2 1
79 7/10/16 85.0 1 2
80 7/11/16 95.0 1 4
81 7/16/16 65.0 4 6
82 7/17/16 85.0 3 4
83 7/19/16 45.0 2 5
84 8/19/16 205.0 1 7
85 8/20/16 105.0 2 1
86 9/18/16 30.0 3 2
87 10/19/16 60.0 4 4
88 10/20/16 40.0 3 4
89 10/30/16 90.0 2 4
90 10/31/16 80.0 1 1
91 11/1/16 25.0 2 4
92 11/2/16 100.0 4 2
93 11/16/16 85.0 4 5
94 11/17/16 75.0 3 5
95 11/18/16 85.0 3 6
96 11/29/16 90.0 3 5
97 12/1/16 80.0 2 6
98 12/3/16 70.0 2 7
99 12/6/16 80.0 1 7
100 12/8/16 50.0 4 6
101 1/2/17 45.0 2 5
102 1/3/17 205.0 1 7
103 1/7/17 105.0 2 1
104 1/7/17 30.0 3 2
105 1/7/17 60.0 4 3
106 1/8/17 140.0 3 5
107 1/9/17 90.0 4 7
108 1/9/17 80.0 3 1
109 1/13/17 125.0 4 2
110 1/13/17 100.0 1 4
111 1/14/17 85.0 4 5
112 1/15/17 175.0 1 7
113 1/16/17 85.0 4 6
114 1/20/17 190.0 1 5
115 1/20/17 80.0 2 4
116 1/21/17 170.0 3 3
117 1/21/17 80.0 2 1
118 1/21/17 150.0 4 2
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;