Microsoft Access 2013

Need assistance in creating 2 access files. Both are relatively short. Data files and instructions included in zip.

Access Assignment/Assignment/Tutorial 10 Case 1.JPG

Access Assignment/Assignment/Tutorial 11 Case 1.JPG

Access Assignment/Data files for assignment/Case1/Job.accdb

MemberID
CardNum
ExpDate

1202
9876-5432-1234-5678
2017-03-04

1207
8642-0975-3196-3083
2018-10-03

1215
3055-2529-8786-6812
2017-09-04

1223
6334-4300-1000-7219
2019-07-03

MemberID
PlanID
FirstName
LastName
Street
City
State
Zip
Phone
DateJoined
Expiration
MemberComments
MemberStatus

1200
311
Student First
Student Last
45 Lakeview Dr
Boulder
CO
80301
303-559-1238
2015-11-01
2016-02-01
buy groceries

active

1201
304
Denis
Davidson
286 Cheyenne Ave
Louisville
CO
80027
303-550-6119
2016-11-15
2017-11-15

active

1202
312
Bess
Hanson
103 Hubbard St
Boulder
CO
80305
303-236-6717
2015-12-01
2016-03-01

active

1205
312
Ava
Poirier
462 Rambler Rd
Boulder
CO
80302
303-559-5060
2015-12-03
2016-03-03

active

1207
304
Rick
Reynolds
320 Great Rd
Westminster
CO
80030
720-559-4642
2015-12-20
2016-12-20

active

1208
304
Kara
Murray
302 Pond Ln
Boulder
CO
80301
303-559-1651
2016-01-09
2017-01-09

on hold

1209
312
Lucy
Xiong
56 Tuckerman St
Boulder
CO
80302
303-323-0291
2016-01-17
2016-04-17

on hold

1210
312
Todd
Grant
6 Rosebriar Rd
Erie
CO
80516
303-674-2140
2016-01-20
2016-04-20

inactive

1211
308
Marg
Hadley
128 Follins Rd
Lafayette
CO
80026
303-550-6103
2016-02-01
2016-08-01

inactive

1214
302
Elizabeth
Griswold
350 Elm St
Jamestown
CO
80455
303-751-8772
2016-02-01
2017-02-01

on hold

1215
301
Keely
Ward
1294 Monument Ave
Boulder
CO
80305
303-674-8462
2016-02-22
2017-02-22

active

1216
305
Abella
Montaz
2200 Douglas St
Arvada
CO
80003
720-236-1794
2016-02-25
2016-08-25

active

1218
307
Maria
Turner
78 Flint St
Boulder
CO
80301
303-674-6807
2016-03-01
2016-09-01

active

1220
301
Federico
Medina
100 Hill Tower Dr
Boulder
CO
80302
303-559-5885
2016-03-01
2017-03-01

active

1221
312
Joseph
Albert
52 Fairway Dr
Boulder
CO
80305
303-550-3051
2016-03-12
2016-06-12

active

1223
310
Kurt
Fletcher
2 Wilber Ln
Boulder
CO
80302
303-236-8961
2016-03-20
2016-06-20

active

1224
310
Louisa
Sanchez
551 Harrington Ave
Boulder
CO
80304
303-674-5991
2016-04-01
2016-07-01

active

1225
308
Jamela
Picard
8 Calico Ct
Boulder
CO
80304
720-559-0909
2016-04-01
2016-10-01

active

1226
303
Maria
Duarte
74 Winter St
Boulder
CO
80304
303-550-0107
2016-04-13
2017-04-13

active

1228
308
Eric
Larsen
852 Winslow Rd
Boulder
CO
80302
303-553-1275
2016-04-22
2016-10-22

active

1230
305
Lisbeth
Sorrento
921 Prospect St
Erie
CO
80516
720-751-1270
2016-04-25
2016-10-25

active

1231
306
Marco
Krukonis
514 Collins Dr
Arvada
CO
80002
720-674-4333
2016-05-05
2016-11-05

active

1232
305
Marlene
Parker
64 Alderman Rd
Boulder
CO
80305
303-323-0346
2016-05-20
2016-11-20

active

1235
306
Jamal
Asmal
81 Barton St
Louisville
CO
80027
303-236-2194
2016-05-28
2016-11-28

active

1236
303
Rita
Smith
94 Newtown Ct
Boulder
CO
80301
720-751-0466
2016-06-01
2017-06-01

active

1237
310
Mary
Cunningham
742 Southbridge St
Boulder
CO
80305
303-550-7732
2016-06-01
2016-09-01

active

1239
303
Michael
DeCosta
163 Jeremiah Ave
Arvada
CO
80002
303-236-4121
2016-06-03
2017-06-03

active

1240
304
Mike
Nguyen
972 Turnpike Rd
Boulder
CO
80303
303-236-0325
2016-06-14
2017-06-14

active

1242
302
Olivia
Pedicini
58 Santos Rd
Boulder
CO
80302
303-236-0642
2016-06-27
2017-06-27

on hold

1245
309
Marla
Gonzalez
33 Pleasant St
Lafayette
CO
80026
303-236-6337
2016-07-01
2016-10-01

active

1246
306
Peter
Horovitz
7 Fort Union St
Louisville
CO
80027
303-553-1642
2016-07-09
2017-01-09

active

1247
307
Ramone
Reyes
456 Harris Ave
Boulder
CO
80301
303-559-1750
2016-07-19
2017-01-19

active

1249
307
Vincent
Tumbiolo
55 Johnson Blvd
Arvada
CO
80002
303-674-1434
2016-08-01
2017-02-01

active

1250
312
Min
Kim
66 Carver Rd
Boulder
CO
80302
303-550-1164
2016-08-01
2016-11-01

active

1251
302
Steven
Curran
13 Lincoln Rd
Louisville
CO
80027
303-674-0227
2016-08-15
2017-08-15

active

1254
312
Tomas
Vargas
111 Rocky Mountain Ave
Boulder
CO
80301
720-751-1119
2016-08-18
2016-11-18

inactive

1255
310
Amartya
Krishna
88 Green Blvd
Boulder
CO
80304
303-751-1847
2016-09-05
2016-12-05

on hold

1256

Tina
Louis
25 Putnam Rd
Jamestown
CO
80455
303-751-9111
2016-09-12
2016-12-12

inactive

1258
303
Kristi
Culberson
98 Lark Ln
Boulder
CO
80303
303-553-7986
2016-09-20
2017-09-20

on hold

1260
307
Arietta
Cimino
71 Beechwood St
Erie
CO
80516
303-550-9870
2016-09-25
2017-03-25

active

PlanID
PlanDescription
PlanCost
FeeWaived

301
20 tasks per month for 12 months
¤ 6,000.00
true

302
18 tasks per month for 12 months
¤ 5,400.00
true

303
15 tasks per month for 12 months
¤ 4,500.00
true

304
10 tasks per month for 12 months
¤ 3,000.00
true

305
18 tasks per month for 6 months
¤ 2,700.00
true

306
15 tasks per month for 6 months
¤ 2,250.00
true

307
10 tasks per month for 6 months
¤ 1,800.00
false

308
8 tasks per month for 6 months
¤ 1,500.00
false

309
15 tasks per month for 3 months
¤ 1,125.00
false

310
12 tasks per month for 3 months
¤ 900.00
false

311
10 tasks per month for 3 months
¤ 750.00
false

312
8 tasks per month for 3 months
¤ 600.00
false

TaskID
ClassDay
StartTime
TaskLength

300
MW
1899-12-30
1899-12-30

301
MW
1899-12-30
1899-12-30

302
MW
1899-12-30
1899-12-30

303
MW
1899-12-30
1899-12-30

304
MW
1899-12-30
1899-12-30

305
TH
1899-12-30
1899-12-30

306
TH
1899-12-30
1899-12-30

307
TH
1899-12-30
1899-12-30

308
TH
1899-12-30
1899-12-30

309
TH
1899-12-30
1899-12-30

310
TH
1899-12-30
1899-12-30

311
TH
1899-12-30
1899-12-30

312
TH
1899-12-30
1899-12-30

313
TH
1899-12-30
1899-12-30

314
TH
1899-12-30
1899-12-30

315
TH
1899-12-30
1899-12-30

316
TH
1899-12-30
1899-12-30

317
TH
1899-12-30
1899-12-30

TaskID
MemberID

300
1200

300
1202

300
1221

300
1232

300
1239

301
1220

301
1230

302
1205

302
1207

302
1216

306
1225

306
1231

306
1246

306
1251

307
1205

307
1224

307
1237

307
1245

307
1250

311
1225

311
1251

313
1200

313
1223

313
1240

314
1247

315
1201

315
1215

315
1218

315
1226

315
1228

315
1235

315
1249

315
1260

316
1215

316
1226

316
1236

SELECT tblPlan.PlanID, tblPlan.PlanDescription, tblPlan.PlanCost
FROM tblPlan;

SELECT DISTINCTROW *
FROM tblPlan;

TRANSFORM Sum(tblPlan.[PlanCost]) AS SumOfPlanCost
SELECT tblPlan.[PlanDescription], Sum(tblPlan.[PlanCost]) AS [Total Of PlanCost]
FROM tblPlan
GROUP BY tblPlan.[PlanDescription]
PIVOT tblPlan.[FeeWaived];

SELECT [tblPlan].[PlanID], [tblPlan].[PlanDescription], [tblPlan].[PlanCost], [tblPlan].[FeeWaived]
FROM tblPlan LEFT JOIN tblMember ON [tblPlan].[PlanID] = [tblMember].[PlanID]
WHERE ([tblMember].[PlanID] Is Null);

SELECT tblPlan.PlanID, tblPlan.FeeWaived, tblPlan.PlanDescription, tblPlan.PlanCost, tblMember.FirstName, tblMember.LastName
FROM tblPlan INNER JOIN tblMember ON tblPlan.PlanID = tblMember.PlanID
ORDER BY tblPlan.PlanID, tblPlan.FeeWaived, tblMember.LastName;

SELECT DISTINCTROW *
FROM tblMember;

PARAMETERS __PlanID Value;
SELECT DISTINCTROW *
FROM tblMember AS frmPlansWithMembers
WHERE ([__PlanID] = PlanID);

SELECT DISTINCTROW *
FROM tblPlan;

SELECT DISTINCTROW *
FROM tblMember;

SELECT DISTINCTROW *
FROM tblPlan;

Access Assignment/Data files for assignment/Case1/NewTasks.accdb

TaskID
TaskDesc

101
Grocery Shopping

102
Painting

103
Rake Leaves

104
Shovel Snow

105
Shopping

106
Cooking

107
House Cleaning

108
Errands

109
Clean Windows

110
Dusting

111
Wash Floors

112
Walking

113
Driving

114
Swimming

115
Hiking

116
Clean Shed

117
Gardening

118
Prune Trees

119
Medical Appointment

120
Computer Assistance

121
Friendly Visit

Access Assignment/Data files for assignment/Case2/.DS_Store

Access Assignment/Data files for assignment/Case2/Amy_Hawkins_Associate_Degree x
Joseph Brant Community College

THIS CERTIFIES THAT

amy hawkins

has successfully completed the required course of study approved by the Board of Education for the State of Michigan, and is therefore awarded this

Associate Degree

Dated this 29th day of May, 2011

Pamela Lee

Roger Samuels

President

Vice Principal Academic

image1

Access Assignment/Data files for assignment/Case2/Amy_Hawkins_Bachelor_Degree

ORANGE GROVE UNIVERSITY

THIS CERTIFIES THAT

AMY HAWKINS

has successfully completed the required course of study approved by the Board of Education for

the State of Michigan, and is therefore awarded this

BACHELOR DEGREE

Dated this 5th day of May, 2008

Richard Meaden

Theo Yan
President Vice Principal Academic

Access Assignment/Data files for assignment/Case2/Lesson.accdb

ContractID
StudentID
TutorID
ContractDate
SessionType
Length
NumSessions
Cost
Assessment

5100
CAR8059
31-1200
2015-08-01
Group
4
6
¤ 960.00
true

5101
DEN8042
33-0122
2015-09-18
Group
3
6
¤ 720.00
true

5102
NUN8084
69-2254
2015-09-30
Semi-private
2
8
¤ 800.00
true

5103
AND8009
27-0505
2015-12-01
Private
2
8
¤ 960.00
true

5105
GOS8029
51-7070
2015-12-15
Group
3
8
¤ 960.00
false

5107
WOO8071
88-0022
2015-12-15
Semi-private
3
12
¤ 1,800.00
true

5108
HEC8018
69-2254
2015-12-17
Semi-private
3
6
¤ 900.00
true

5110
YEN8035
43-4006
2016-01-07
Group
4
8
¤ 1,280.00
true

5113
ZWI8066
31-1200
2016-01-10
Group
3
8
¤ 960.00
false

5115
PAP8024
33-0122
2016-01-15
Group
4
6
¤ 960.00
false

5117
MUE8041
51-7070
2016-01-15
Private
3
8
¤ 1,440.00
false

5118
COL8031
55-1234
2016-01-20
Group
3
12
¤ 1,440.00
true

5121
ROC8025
50-3390
2016-01-25
Group
4
6
¤ 960.00
true

5123
OAT8010
88-0022
2016-01-26
Private
3
8
¤ 1,440.00
true

5125
GUS8002
69-2254
2016-01-28
Group
3
6
¤ 720.00
true

5126
NAS8012
79-0678
2016-02-01
Group
3
8
¤ 960.00
false

5128
SPE8022
66-5010
2016-02-01
Private
2
8
¤ 960.00
true

5130
BAT8045
68-8234
2016-02-10
Group
3
8
¤ 960.00
true

5131
HIN8040
55-1234
2016-03-01
Group
3
8
¤ 960.00
true

5133
TUR8005
68-8234
2016-03-01
Group
4
8
¤ 1,280.00
false

5135
BIE8000
19-3726
2016-03-14
Semi-private
3
12
¤ 1,800.00
true

5136
STI8038
51-7070
2016-03-15
Private
2
6
¤ 720.00
true

5138
VAR8027
71-1698
2016-04-03
Private
3
6
¤ 1,080.00
true

5140
BAL8033
19-3726
2016-04-16
Group
4
8
¤ 1,280.00
true

5141
SHE8090
55-1234
2016-05-03
Group
4
12
¤ 1,920.00
false

5143
MAS8056
31-1200
2016-05-08
Group
4
6
¤ 960.00
true

5146
YEN8035
50-3390
2016-06-22
Private
2
12
¤ 1,440.00
false

5148
ZWI8066
79-0678
2016-07-07
Private
2
8
¤ 960.00
true

5149
PAP8024
66-5010
2016-07-10
Private
3
6
¤ 1,080.00
false

5151
ROC8025
33-0122
2016-07-11
Group
3
8
¤ 960.00
true

5154
MOS8053
68-8234
2016-07-12
Group
4
8
¤ 1,280.00
false

5158
CAR8059
36-1664
2016-07-15
Semi-private
2
12
¤ 1,200.00
true

5159
MAH8053
27-0505
2016-07-16
Private
2
6
¤ 720.00
true

5161
DEN8042
66-5010
2016-08-01
Semi-private
2
8
¤ 800.00
true

5163
MCS8051
36-1664
2016-08-01
Semi-private
2
8
¤ 800.00
false

5166
RIV8011
19-3726
2016-08-10
Private
3
6
¤ 1,080.00
false

5167
ENR8055
43-4006
2016-08-23
Group
3
8
¤ 960.00
true

5168
LUF8037
68-8234
2016-08-30
Group
3
12
¤ 1,440.00
true

5169
TAR8049
88-0022
2016-08-30
Group
3
6
¤ 720.00
true

5170
TAR8050
88-0022
2016-08-30
Group
3
6
¤ 720.00
true

5171
PLU8015
36-1664
2016-09-09
Private
3
8
¤ 1,440.00
false

5172
GOS8029
71-1698
2016-09-07
Private
2
6
¤ 720.00
true

5174
GUS8002
69-2254
2016-09-10
Semi-private
3
6
¤ 900.00
true

5175
NAS8012
79-0678
2016-09-12
Semi-private
2
8
¤ 800.00
true

5176
TUR8005
50-3390
2016-09-15
Private
3
8
¤ 1,440.00
true

5177
DRO8048
27-0505
2016-09-15
Private
2
6
¤ 720.00
true

5178
VAR8027
71-1698
2016-09-20
Private
2
8
¤ 960.00
true

StudentID
FirstName
LastName
Address
City
State
Zip
CreditRelationship
CreditCardNum

AYO8022
Rebecca
Ayotte
880 Northern Ave
South Bend
IN
46613
Mother
1357-2468-9753-8642

BIE8000
Allison
Biega
122 Chestnut St
Mishawaka
IN
46544
Mother
8908-9999-9999-9999

DEN8042
Adam
DeNardo
283 Tulane Dr
South Bend
IN
46617
Father
7890-8888-8888-8888

GUS8002
Samantha
Gustafson
329 Murphy Ave
Oscela
IN
46561
Mother
4989-7777-7777-7777

KAV8030
Alexa
Kavik
504 Windemere Ave
Mishawaka
IN
46544
Student
1908-6666-6666-6666

MAS8056
Weldon
Mase
550 Allanville St
Oscela
IN
46561
Father
2196-5555-5555-5555

PAP8024
Ben
Pappas
781 Merchants Rd
South Bend
IN
46619
Father
6736-4444-4444-4444

SPE8022
Leslie
Vargas
1220 Holcomb Dr
South Bend
IN
46637
Mother
2217-3333-3333-3333

EquipmentNum
Equipment
MonthlyRentalCost

19
Calculator
¤ 5.00

20
Calculator
¤ 5.00

21
Tablet computer
¤ 25.00

22
Tablet computer
¤ 30.00

23
Tablet computer
¤ 25.00

24
Microscope
¤ 30.00

25
Microscope
¤ 30.00

26
Microscope
¤ 30.00

27
Laptop computer
¤ 45.00

28
Laptop computer
¤ 30.00

29
Laptop computer
¤ 50.00

30
Desktop computer
¤ 75.00

31
Desktop computer
¤ 90.00

32
Desktop computer
¤ 75.00

33
Tablet computer
¤ 35.00

34
Tablet computer
¤ 35.00

35
Tablet computer
¤ 35.00

36
Laptop computer
¤ 35.00

37
Laptop computer
¤ 35.00

39
Laptop computer
¤ 35.00

40
Laptop computer
¤ 35.00

41
Laptop computer
¤ 35.00

EquipmentNum
ContractID

19
5117

19
5154

20
5110

21
5140

24
5117

25
5101

25
5138

26
5108

28
5115

29
5133

30
5101

32
5148

32
5149

33
5130

34
5141

36
5121

36
5161

37
5128

39
5151

40
5175

StudentID
FirstName
LastName
Address
City
State
Zip
HomePhone
CellPhone
BirthDate
Gender

AND8009
Student First
Student Last
5678 Wayside Ct
New Carlisle
IN
46552
574-654-2245
574-654-0091
2002-10-10
F

AYO8022
Andrea
Ayotte
880 Northern Ave
South Bend
IN
46613
574-204-2227
574-472-2308
2002-11-28
F

BAL8033
Sean
Balise
462 Main St
South Bend
IN
46614
574-210-5326
574-485-1045
2001-06-12
M

BAT8045
Gerta
Batchelder
87 Calvin Ct
Mishawaka
IN
46544
574-252-4409
574-252-4932
2000-08-20
F

BIE8000
Joshua
Biega
122 Chestnut St
Mishawaka
IN
46544
574-252-1135
574-527-0219
2001-01-12
M

CAR8059
Carol
Carlson
1213 Winter St
South Bend
IN
46613
574-220-8410
574-220-9625
2001-09-24
F

CHA8034
Henry
Chang
1401 Lauren Dr
Oscela
IN
46561
574-607-3045
574-674-2410
1999-10-05
M

COL8031
Morris
Coldwell
205 Cinder St
Mishawaka
IN
46544
574-254-0838
574-527-7712
2002-07-26
M

DEN8042
David
DeNardo
283 Tulane Dr
South Bend
IN
46617
574-245-9610
574-514-8337
2001-03-27
M

DRO8048
Emma
Drouin
1910 Davidson St
Oscela
IN
46561
574-607-2368
574-674-1275
2001-10-24
F

ELL8065
Jack
Ellis
16 Court St
South Bend
IN
46637
574-228-3663
574-228-6540
2001-10-20
M

ENR8055
Bess
Enright
1715 Honeycomb Dr
New Carlisle
IN
46552
574-654-8879
574-654-5951
2002-02-04
F

GOS8029
Haley
Gosnold
1763 Ryan Ct
Mishawaka
IN
46544
574-255-3027
574-520-1033
2001-11-29
F

GUS8002
Michael
Gustafson
329 Murphy Ave
Oscela
IN
46561
574-674-4038
574-256-9117
2001-09-13
M

HEC8018
Eric
Hecht
30 Calico St
South Bend
IN
46617
574-234-7433
574-564-1956
2000-04-04
M

HIN8040
Erica
Hinkle
55 Shepley Rd
Oscela
IN
46561
574-675-2553
574-547-5573
2000-06-14
F

KAV8030
Alexa
Kavik
504 Windemere Ave
Mishawaka
IN
46544
574-675-8864
574-675-6876
2000-04-23
F

LUF8037
Greg
Luff
145 Powell Blvd
New Carlisle
IN
46552
574-654-1430
574-654-8002
2002-01-31
M

MAH8053
Albert
Mahlau
1012 Barlow Rd
South Bend
IN
46637
574-217-6218
574-564-1018
2000-03-15
M

MAS8056
Kimberly
Mase
550 Allanville St
Oscela
IN
46561
574-679-6639
574-563-9511
1999-07-27
F

MCS8051
Lauren
McShea
195 Utah St
Oscela
IN
46561
574-607-1269
574-530-7722
2002-12-13
F

MOS8053
Anesha
Mosychuk
185 Sammy Ln
South Bend
IN
46637
574-217-0559
574-485-6303
2002-11-13
F

MUE8041
Bart
Mueller
1347 Lance Rd
Oscela
IN
46561
574-651-1155
574-646-8902
2001-04-18
M

NAS8012
Andre
Nastasia
668 Nora Dr
Oscela
IN
46561
574-651-3379
574-617-9245
2000-02-16
M

NUN8084
Rodrigo
Nunez
140 Lower County Rd
South Bend
IN
46637
574-232-3156
574-514-8882
2000-10-13
M

OAT8010
Kyle
Oates
45 Sebastian Rd
South Bend
IN
46619
574-232-4828
574-232-5228
2001-07-06
M

PAP8024
Zach
Pappas
781 Merchants Rd
South Bend
IN
46619
574-259-6004
574-232-2790
2001-06-16
M

PLU8015
Dana
Plummer
405 Palmer Ave
New Carlisle
IN
46552
574-645-8155
574-654-3581
2001-11-20
F

RIV8011
Marco
Rivera
4321 Farmcrest St
Oscela
IN
46561
574-607-1517
574-640-0443
2001-05-22
M

ROC8025
Daniel
Roche
2385 Vista Dr
South Bend
IN
46613
574-220-3717
574-617-7984
2002-03-23
M

SHE8090
Marci
Sheppard
135 Bradford Pl
South Bend
IN
46614
574-232-4221
574-232-5322
2000-08-23
F

SPE8022
Ross
Spence
1220 Holcomb Dr
South Bend
IN
46637
574-233-7998
574-514-7299
2001-08-22
M

STI8038
Lily
Stiefel
164 Maris St
Oscela
IN
46561
574-675-4232
574-258-0202
2002-10-19
F

TAR8049
Isabella
Tartaglia
5 Ryebrook Ave
Mishawaka
IN
46544
574-256-7302
574-536-7819
2001-10-14
F

TAR8050
Donato
Tartaglia
5 Ryebrook Ave
Mishawaka
IN
46544
574-256-7302
574-536-7899
2001-10-14
M

TUR8005
Lynne
Turner
6 Crowell Ct
South Bend
IN
46614
574-245-2125
574-245-8842
2002-07-24
F

VAR8027
Vera
Vargas
37 Great Western Rd
South Bend
IN
46617
574-220-5928
574-245-1972
2002-09-18
F

WOO8071
Jon
Woodburn
445 Avalon Dr
South Bend
IN
46613
574-228-9284
574-204-9284
2001-06-20
M

YEN8035
Lila
Yen
1220 Burkhill St
Oscela
IN
46561
574-607-9451
574-607-8841
1999-09-30
F

ZWI8066
Robert
Zwicker
68 King St
Mishawaka
IN
46545
574-256-2148
574-527-2479
2001-05-01
M

SubjectID
Subject
MonthlyCost

19
Math1
¤ 50.00

20
Math1
¤ 50.00

21
Bio1
¤ 25.00

22
Bio1
¤ 30.00

23
Bio1
¤ 25.00

24
History1
¤ 30.00

25
History1
¤ 30.00

26
History1
¤ 30.00

27
History1
¤ 45.00

28
History1
¤ 30.00

29
History1
¤ 50.00

30
Math2
¤ 75.00

31
Math2
¤ 90.00

32
Math2
¤ 75.00

33
Chem1
¤ 35.00

34
Chem1
¤ 35.00

35
Chem1
¤ 35.00

36
Math3
¤ 35.00

37
Math3
¤ 35.00

39
Math3
¤ 35.00

40
Math3
¤ 35.00

41
Math3
¤ 35.00

50
Math4
¤ 50.00

51
Math4
¤ 50.00

52
Bio2
¤ 25.00

53
Bio2
¤ 30.00

54
Bio2
¤ 25.00

55
History2
¤ 30.00

56
History2
¤ 30.00

TutorID
FirstName
LastName
Degree
School
HireDate
Groups
Coordinator

19-3726
Melissa
Michau
BA
Robert Frost State College
2015-01-06
false
27-0505

27-0505
Michaela
Jellinek
MS
Kilderry College
2016-06-20
false

31-1200
Student First
Student Last
BA
Pierre University
2015-08-02
true
27-0505

33-0122
Amy
Hawkins
BS
Rosebriar College
2015-08-04
true
27-0505

36-1664
Youngho
Lim
EdD
Weisser Technical Institute
2016-04-01
false
55-1234

43-4006
Lori
Burns
BA
University of Reedsville
2016-03-03
true
69-2254

50-3390
Deborah
Nowak
BA
Guilford-Grant College
2015-06-03
false
27-0505

51-7070
Alameda
Sarracino
MA
Edgar Lee University
2016-03-22
false
69-2254

55-1234
Samuel
Glick
BA
Manoog College
2016-07-23
true

66-5010
Jacques
LaFarge
MA
College of the North West
2016-01-25
false
27-0505

68-8234
Caitlin
Shea
MS
Towns University
2016-01-05
true
55-1234

69-2254
Sachi
Hatanaka
MA
Wyman College
2015-03-23
false

71-1698
Richard
Keating
PhD
Hobert University
2015-05-03
false
27-0505

79-0678
Riley
Andoval
BS
University of Piperstown
2015-09-05
false
69-2254

88-0022
Len
Onida
BS
Tomason College
2015-02-17
false
69-2254

SELECT [tblStudent].[StudentID], [tblStudent].[LastName], [tblStudent].[FirstName]
FROM tblStudent
ORDER BY [LastName], [FirstName];

SELECT [tblContract].[ContractID]
FROM tblContract;

SELECT [tblTutor].[TutorID], [tblTutor].[FirstName], [tblTutor].[LastName]
FROM tblTutor
ORDER BY [LastName];

SELECT DISTINCTROW *
FROM tblContract;

SELECT tblTutor.TutorID, [tblTutor]![FirstName] & ” ” & [tblTutor]![LastName] AS TutorName, tblTutor.Degree, tblTutor.School, tblTutor.HireDate, tblTutor.Groups
FROM tblTutor
ORDER BY tblTutor.LastName, tblTutor.FirstName;

SELECT tblTutor.LastName, tblTutor.FirstName, tblContract.SessionType, tblStudent.FirstName, tblStudent.LastName, tblContract.NumSessions, tblContract.Cost
FROM tblStudent INNER JOIN (tblTutor INNER JOIN tblContract ON tblTutor.TutorID = tblContract.TutorID) ON tblStudent.StudentID = tblContract.StudentID
ORDER BY tblTutor.LastName, tblTutor.FirstName, tblContract.SessionType;

SELECT tblContract.StudentID, tblContract.ContractDate, tblContract.SessionType, tblContract.Length, tblContract.Cost
FROM tblTutor INNER JOIN tblContract ON tblTutor.TutorID = tblContract.TutorID;

SELECT DISTINCTROW *
FROM tblTutor;

Access Assignment/Data files for assignment/Case2/Room.accdb

RoomNum
RentalCost
RoomType

6
¤ 15.00
Semi-Private

7
¤ 15.00
Semi-Private

8
¤ 40.00
Group

9
¤ 20.00
Semi-Private

10
¤ 55.00
Group

Access Assignment/Data files for assignment/Case3/Pet.accdb

AnimalID
AnimalName
AnimalAge
AnimalGender
AnimalType
AnimalDesc
ArrivalDate
AdoptionDate
Adopted
PatronID

A23
Missy
7
Female
Cat
Brown with white spots
2016-05-09
2016-06-08
true
30490

A29
Rolf
3
Male
Dog
Beagle mix
2016-08-23

false

A34
Daisy
4
Female
Dog
Beagle mix
2016-02-03

false

A43
Neo
7
Female
Cat
white with a stubby tail
2016-05-04
2016-07-08
true
33104

A49
Tabby
4
Female
Cat
Long hair, white
2016-03-05

false

A55
Penny
8
Female
Dog
Lab mix
2016-05-02
2016-05-14
true
33287

A58
Whiskers
9
Male
Cat
Long hair, white and black
2016-04-23

false

A73
Sammy
5
Female
Cat
Calico mix, short hair
2016-04-14

false

B24
Casey
2
Female
Cat
Calico mix, short hair
2016-03-04
2016-05-22
true
30490

B33
Jack
4
Male
Dog
Terrier mix
2016-03-04
2016-04-22
true
33227

B35
Cutie
2
Female
Cat
Black with white spots
2016-05-23
2016-07-22
true
33902

B45
Gizmo
12
Male
Dog
Hound mix
2016-03-06

false

B55
Oliver
2
Male
Dog
Terrier mix
2016-03-16
2016-04-22
true
36032

C27
Bonnie
9
Male
Cat
Bengal mix
2016-08-04

false

C28
Sophie
4
Female
Cat
Long hair, white, blue eyes
2016-03-14
2016-04-22
true
49484

C29
Tiger
4
Female
Cat
White and orange
2016-07-15

false

C33
Midnight
3
Male
Cat
Black, short hair
2016-03-04

false

C44
Sparky
2
Female
Dog
Long hair, white
2016-03-01

false

C58
Maggy
3
Female
Cat
Calico mix, short hair
2016-04-03
2016-05-04
true
30490

C74
Ginger
4
Female
Cat
Orange with white patches
2016-04-05

false

C92
Wiskers
8
Male
Cat
White, long hair
2016-03-04
2016-06-05
true
48483

D21
Toby
7
Male
Dog
Shepherd mix
2016-05-03
2016-06-01
true
45797

D22
Sparky
3
Male
Dog
medium size, mixed breed
2016-06-18

false

D23
Babar
6
Male
Dog
Shepherd mix, stubby tail
2016-04-09

false

D34
Tommy
5
Female
Dog
Shepherd mix
2016-04-17
2016-04-22
true
48483

D42
Wynn
12
Male
Dog
Short hair, black with white spots, small
2016-02-22
2016-03-04
true
33104

D44
Randy
5
Male
Dog
Hound mix
2016-04-11
2016-04-22
true
47183

D48
Max
6
Male
Dog
Newfoundland mix
2016-04-20

false

D83
Hunter
4
Male
Dog
Lab mix, black, long hair
2016-05-14

false

F14
Sam
5
Male
Dog
Hound mix
2016-03-04

false

F29
Bonzo
2
Male
Dog
Beagle mix
2016-02-09
2016-04-22
true
36051

G23
Tina
2
Female
Dog
Beagle mix
2016-06-03

false

G28
Ginger
2
Female
Cat
Persian mix
2016-04-13

false

G29
Mango
3
Female
Cat
Orange with white spots
2016-05-14
2016-05-27
true
36574

G36
Sarah
3
Female
Cat
White with black and brown spots, short hair
2016-05-03
2016-08-20
true
38985

G45
Molly
5
Female
Dog
Lab mix
2016-04-14
2016-05-22
true
36703

G48
Fluffy
9
Female
Cat
Black with white patches
2016-05-03

false

G56
Haley
2
Female
Dog
Beagle mix
2016-05-18
2016-06-04
true
36062

H04
Pandora
1
Male
Cat
Savannah mix
2016-06-19
2016-07-07
true
36058

H21
Sammy
2
Male
Dog
Retriever mix, golden
2016-06-15
2016-06-22
true
36077

H34
Smokey
4
Male
Cat
Grey, long hair
2016-06-20

false

J28
Marmaduke
8
Male
Dog
Lab mix
2016-03-05
2016-03-22
true
42511

J29
Benny
2
Male
Dog
Retriever mix, large
2016-04-12
2016-05-28
true
41038

J37
Penny
2
Female
Dog
Shepherd mix
2016-02-17

false

K23
Tabby
4
Female
Cat
Calico mix, short hair
2016-04-04

false

K24
Precious
2
Female
Dog
Long hair, brown and white, small
2016-05-03
2016-06-20
true
43097

K25
Scooter
8
Male
Dog
Long hair, brown, medium size
2016-03-08
2016-05-12
true
41630

K33
Spot
2
Female
Dog
Black with white spots
2016-02-05
2016-02-22
true
48127

K34
Sonny
6
Male
Cat
Calico mix
2016-03-19

false

K38
Rusty
4
Female
Cat
Long hair, orange with white patches
2016-04-07

false

K39
Lawrence
2
Male
Dog
Beagle mix
2016-08-14

false

K43
Kitty
3
Female
Cat
Calico mix, long hair
2016-04-03
2016-04-22
true
47767

K48
Pepper
3
Female
Dog
Black and brown
2016-03-18
2016-03-25
true
34525

K94
Carmen
3
Male
Dog
Beagle mix
2016-05-03

false

L45
Jiggles
4
Male
Dog
Brown with white spots, large
2016-07-14

false

M23
Princess
2
Female
Dog
Long hair, black and white, small
2016-04-14

false

M48
Bandit
5
Female
Dog
Border Collie mix
2016-03-12

false

M49
Buster
4
Male
Cat
Brown and white, long hair
2016-02-03

false

M77
Spike
5
Male
Dog
Pug mix
2016-04-06

false

N34
Shadow
3
Male
Cat
Black
2016-04-19

false

N35
Patches
5
Male
Cat
White with black spots
2016-02-03

false

N37
Misty
8
Male
Cat
Grey, long hair
2016-04-12
2016-06-21
true
35511

N43
Jake
12
Male
Dog
Hound mix
2016-03-12
2016-03-24
false

N82
Rudy
7
Male
Dog
Lab mix, golden
2016-06-08

false

N84
Singer
9
Male
Dog
Beagle mix
2016-03-04
2016-04-09
true
36001

N94
Duke
3
Male
Dog
Shepherd mix
2016-06-06

false

P34
Skylar
4
Female
Dog
Lab mix
2016-04-11

false

P38
Patch
6
Male
Dog
Black with brown around the left eye
2016-05-15
2016-06-21
true
36012

P39
Zoey
4
Female
Dog
Pug mix
2016-05-11
2016-05-18
true
33902

P48
Butch
7
Male
Cat
Short hair, black
2016-06-18
2016-08-24
true
36016

R22
Rio
4
Male
Cat
Calico mix, long hair
2016-09-14

false

R27
Spike
4
Male
Dog
Shepherd mix
2016-06-04
2016-06-22
true
36037

R29
Gabby
6
Female
Dog
Brown with black spots above the eyes
2016-03-14
2016-05-02
true
36070

R33
Randy
4
Male
Dog
Beagle mix
2016-04-17
2016-06-25
true
36703

R34
Snooker
6
Male
Dog
Lab mix, golden
2016-04-19

false

R38
Shadow
8
Female
Cat
Black and grey mix
2016-05-03
2016-06-17
true
37223

R39
Simba
3
Female
Cat
Siamese
2016-04-12
2016-05-14
true
38398

R43
Lucky
3
Male
Dog
Collie mix
2016-05-03

false

R45
Molly
7
Female
Cat
Calico mix, long hair
2016-03-04
2016-04-25
true
36070

R55
Spike
5
Male
Dog
Black with brown and white patches, medium
2016-03-04

false

R59
Barky
5
Male
Dog
Sheepdog mix
2016-03-12
2016-05-22
true
38014

R98
Gus
2
Male
Dog
Beagle mix
2016-04-18

false

S31
Charger
4
Female
Cat
Calico mix, long hair
2016-03-15

false

S35
Roggie
8
Male
Cat
Siamese
2016-05-10

false

T23
Fanny
4
Female
Cat
Calico short hair
2016-07-03

false

T32
Buddy
8
Male
Dog
Border Collie mix
2016-05-19

false

T75
Stormy
10
Female
Dog
Grey/brown, medium
2016-03-28

false

V84
Max
8
Male
Dog
Lab mix, black
2016-05-17

false

V98
Chow
3
Male
Dog
Husky mix
2016-06-12

false

W15
Rocky
4
Male
Dog
Husky mix
2016-02-06
2016-06-14
true
38985

W22
Whiskers
3
Female
Cat
Persian mix
2016-03-05

false

W23
Buddy
1
Male
Dog
Beagle mix
2016-06-01
2016-06-08
true
40900

W29
Jenny
2
Female
Cat
Long hair, brown
2016-04-14

false

W52
Sammy
2
Female
Cat
Calico mix
2016-04-19

false

W73
Joselin
3
Female
Cat
White, long hair
2016-03-12

false

Y24
Gini
4
Female
Dog
Hound mix
2016-04-03

false

Y29
Jenny
2
Male
Dog
Beagle mix
2016-04-04
2016-04-12
true
45350

Y33
Sam
2
Male
Cat
Black, long hair
2016-07-07

false

Y35
Spot
9
Female
Dog
Hound mix, small
2016-05-12

false

Y98
Rocky
6
Male
Dog
Black, large
2016-04-29

false

AnimalID
StorageID

A23
1

A29
5

A34
6

A43
2

A49
3

A55
4

A58
1

A73
2

B24
3

B33
5

B35
1

B45
6

B55
5

C27
2

C28
3

C29
1

C33
2

C44
4

C58
2

C74
3

C92
1

D21
5

D22
6

D23
4

D34
5

D42
6

D44
5

D48
4

D83
5

F14
6

F29
5

G23
4

G28
1

G29
2

G36
3

G45
5

G48
1

G56
4

H04
1

H21
4

H34
2

J28
5

J29
6

J37
5

K23
3

K24
6

K25
5

K33
4

K34
2

K38
2

K39
5

K43
1

K48
6

K94
5

L45
4

M23
5

M48
6

M49
2

M77
6

N34
3

N35
3

N37
2

N43
5

N82
4

N84
5

N94
5

P34
6

P38
4

P39
5

P48
1

R22
1

R27
6

R29
4

R33
5

R34
5

R38
2

R39
3

R43
5

R45
1

R55
4

R59
5

R98
6

S31
2

S35
3

T23
1

T32
6

T75
5

V84
4

V98
6

W15
5

W22
1

W23
4

W29
2

W52
3

W73
3

Y24
5

Y29
6

Y33
2

Y35
5

Y98
4

DonationID
PatronID
DonationDate
DonationDesc
DonationTypeID
DonationValue

2100
30490
2016-02-02
Cash donation
C
117

2101
30607
2016-02-06
Cash donation
C
119

2102
30753
2016-02-08
Cash donation
C
245

2103
30891
2016-02-10
Cash donation
C
152

2104
31087
2016-02-12
Dog Food
F
247

2105
32107
2016-02-14
Cash donation
C
289

2108
32810
2016-02-20
Cages
E
120

2109
33046
2016-02-22
Cash donation
C
65

2111
33190
2016-02-26
Cages
E
203

2112
34642
2016-02-28
Dog Food
F
50

2113
33765
2016-03-01
Cat Food
F
135

2114
33765
2016-03-03
Cash donation
C
189

2116
34642
2016-03-07
Pet toys
E
254

2118
34642
2016-03-11
Food Bowls
E
121

2119
34894
2016-03-13
Cat Food
F
186

2120
35105
2016-03-15
Cash donation
C
89

2121
35665
2016-03-17
Cash donation
C
251

2122
35665
2016-03-19
Cash donation
C
72

2123
35828
2016-03-21
Cash donation
C
194

2124
35895
2016-03-23
Dog Food
F
64

2125
36002
2016-03-25
Cash donation
C
223

2126
36002
2016-03-27
Cash donation
C
276

2127
36019
2016-03-29
Cash donation
C
253

2130
36020
2016-04-04
Leashes
E
88

2131
36023
2016-04-06
Cash donation
C
59

2132
36025
2016-04-08
Cash donation
C
270

2133
36028
2016-04-10
Dog Food
F
91

2134
36056
2016-04-12
Cash donation
C
283

2135
36033
2016-04-14
Cash donation
C
87

2136
36041
2016-04-16
Cash donation
C
262

2137
36041
2016-04-18
Cash donation
C
203

2139
36049
2016-04-22
Cages
E
59

2140
36056
2016-04-24
Cash donation
C
122

2141
36055
2016-04-26
Cash donation
C
273

2142
36056
2016-04-28
Cash donation
C
91

2143
36058
2016-04-30
Cat Food
F
271

2145
36073
2016-05-04
Cash donation
C
80

2146
36064
2016-05-06
Cash donation
C
226

2147
36073
2016-05-08
Cash donation
C
269

2148
36073
2016-05-10
Dog Food
F
154

2149
36074
2016-05-12
Dog Food
F
178

2150
36077
2016-05-14
Cash donation
C
54

2151
36183
2016-05-16
Cash donation
C
174

2152
36574
2016-05-18
Cash donation
C
116

2154
37223
2016-05-22
Pet toys
E
299

2155
37454
2016-05-24
Cash donation
C
167

2156
37774
2016-05-26
Cash donation
C
205

2157
40905
2016-05-28
Cash donation
C
68

2158
38154
2016-05-30
Dog Food
F
262

2159
40905
2016-06-01
Dog Food
F
152

2160
38635
2016-06-03
Cash donation
C
57

2161
38848
2016-06-05
Cash donation
C
264

2162
38955
2016-06-07
Cash donation
C
79

2163
40905
2016-06-09
Cash donation
C
104

2164
39007
2016-06-11
Cat Food
F
142

2165
39387
2016-06-13
Cash donation
C
279

2166
39610
2016-06-15
Cash donation
C
163

2167
39619
2016-06-17
Cash donation
C
160

2169
40372
2016-04-14
Pet toys
E
63

2170
40900
2016-04-16
Cash donation
C
78

2171
40905
2016-04-18
Dog Food
F
86

2172
39387
2016-04-20
Cash donation
C
117

2173
39610
2016-04-22
Cash donation
C
256

2175
39644
2016-04-26
Cages
E
258

2176
43685
2016-04-28
Cash donation
C
56

2177
45061
2016-04-30
Cash donation
C
267

2178
45350
2016-05-02
Cash donation
C
229

2179
45797
2016-05-04
Dog Food
F
165

2182
46410
2016-05-10
Cages
E
98

2183
46751
2016-05-12
Cash donation
C
80

2184
46968
2016-05-14
Cash donation
C
248

2185
46997
2016-05-16
Dog Food
F
222

2186
47183
2016-05-18
Cash donation
C
213

2188
47767
2016-03-03
Pet toys
E
81

2189
47984
2016-03-05
Cash donation
C
229

2190
49206
2016-03-07
Cash donation
C
81

2191
48151
2016-03-09
Cat Food
F
62

2192
48372
2016-03-11
Cash donation
C
185

2193
49206
2016-03-13
Dog Food
F
89

2194
49039
2016-03-15
Cash donation
C
253

2195
49115
2016-03-17
Cash donation
C
117

2196
49177
2016-04-12
Dog Food
F
170

2197
49206
2016-04-14
Cash donation
C
196

2198
49206
2016-04-16
Cash donation
C
149

2199
49905
2016-04-18
Cash donation
C
101

FacilityID
FacilityName

A01
Cramer Storage

A02
Oakview Building

PatronID
Title
FirstName
LastName
Phone

30490

Student First
Student Last
770-427-9300

30607
Mr.
Randolph
Kramer
770-528-7835

30753
Ms.
Cynthia
Crosby
678-444-2676

30891
Mrs.
Kelsey
Mayo
678-528-9994

31087
Dr.
Al
Higgins
678-528-2363

32107
Dr.
Tim
Iordan
770-528-7108

32154
Mr.
Paul
Lee
770-528-5466

32189
Mrs.
Gini
Smith
770-499-2775

32810
Mrs.
Sharon
Welch
770-419-2229

33046
Ms.
Marie
Ortega
770-444-6643

33104
Ms.
Cynthia
French
770-528-3396

33190
Mrs.
Diane
Byrd
770-419-4993

33227
Mrs.
Sam
Mueller
678-528-4385

33287
Dr.
Ali
Haddad
770-528-8973

33765
Mrs.
Mandy
Sohar
678-528-5407

33803
Mrs.
Penelope
Stephenson
678-419-6412

33902
Mr.
Ron
Lam
770-528-3387

34525
Mr.
Jim
Murphy
770-499-1074

34642
Mr.
Joe
Giacomelli
678-499-8847

34894
Mrs.
Susan
Lowe
678-444-3454

35105
Mrs.
Beth
Kumar
678-444-1085

35511
Ms.
Amandeep
Patel
770-528-7378

35665
Mrs.
Jenny
Bates
770-444-8885

35828
Mr.
Bob
Jeffreys
770-528-8258

35895
Ms.
Corinne
Graham
678-819-8625

36001
Dr.
Angela
Harris
678-452-8736

36002
Dr.
Brian
Crane
678-277-8767

36012
Mr.
Joe
Martinson
678-823-9275

36016
Mr.
Doug
Fuller
770-793-8477

36019
Ms.
Connie
Delacruz
678-452-1178

36020
Mrs.
JoAnn
McGee
678-309-6540

36023
Ms.
Carole
Walsh
770-771-9152

36025
Mrs.
Mary
Moses
678-598-0569

36028
Mr.
Michael
Carlucci
678-283-6334

36032
Mrs.
Barbara
Schmidt
678-827-9713

36033
Mr.
Brian
Ewing
770-663-1418

36037
Ms.
Sherill
Kussow
678-823-2284

36041
Mrs.
Celia
Brubaker
678-669-3970

36042
Mrs.
Helen
Mullins
678-238-9451

36049
Mrs.
Katharine
Gardiner
678-826-2135

36051
Mr.
Leland
Jaeger
678-309-1655

36055
Ms.
Tina
Sun
678-827-2688

36056
Mr.
Robert
Parkinson
678-263-5896

36058
Mrs.
Rebecca
Lawry
678-825-5583

36060
Mrs.
Dianne
Corrigan
678-826-0063

36062
Mr.
Wesley
Tarkenton
770-282-2556

36064
Ms.
Erika
Lange
678-263-1054

36070
Mrs.
Ashley
Willis
678-827-1862

36073
Mr.
Gerald
Persinger
678-241-2526

36074
Mrs.
Maria
Gonzalez
678-238-0337

36077
Mrs.
Meredith
Dellkamp
678-820-1521

36183
Dr.
Sandy
Velez
770-528-4966

36574
Mrs.
Nellie
Wong
770-819-3399

36703
Ms.
Christine
Weaver
678-419-3174

37223
Mr.
Neil
Cummings
770-419-9968

37454
Ms.
Ramona
Freeman
678-528-1133

37774
Mr.
Bob
Rasmussen
678-528-4981

38014
Mrs.
Fong
Yang
770-427-5977

38154
Mrs.
Simranjeet
Patel
678-819-8112

38398
Mrs.
Cheryl
Jensen
678-528-1743

38635
Mr.
Ken
Phelps
678-528-9991

38848
Mrs.
Mary
Ratliff
770-444-2334

38955
Mrs.
Nadine
Rosales
770-819-2156

38985
Mr.
Jose
Salinas
770-444-5730

39007
Mr.
Roger
Vargas
678-528-2733

39387
Mrs.
Jennifer
Jensen
770-528-3163

39610
Mrs.
Sally
Bruch
770-427-6391

39619
Mr.
Jasjeet
Singh
678-528-4730

39644
Mr.
Amanbir
Singh
770-427-6950

40372
Ms.
Jenny
Webster
770-528-2715

40900
Mr.
Jaspreet
Singh
770-528-3542

40905
Mr.
Albert
Turner
770-528-7227

41038
Ms.
Janet
Wong
770-528-5760

41630
Mr.
Tim
Wallace
770-528-9884

42511
Mrs.
Fong
Chin
770-499-8549

43097
Ms.
Sue
Diaz
770-419-4660

43685
Mr.
Tony
Silva
678-528-4293

45061
Mrs.
Amanda
Bolstad
770-528-8492

45350
Ms.
Linda
Reilly
770-499-6019

45797
Dr.
Susan
Greene
770-499-8386

46260
Mr.
Roger
Hanson
770-528-6771

46342
Dr.
Samantha
Kriby
770-419-8194

46410
Mr.
Steven
Holder
770-819-6729

46751
Ms.
Cheryl
Johns
678-427-7938

46968
Mr.
Albert
Ross
770-819-5092

46997
Ms.
Kathy
Garrett
770-528-7177

47183
Mrs.
Maureen
Lew
770-528-2539

47631
Ms.
Lynn
Lowe
770-528-4155

47767
Mr.
Leslie
Mays
770-528-3626

47984
Mrs.
Marie
Alvarez
770-528-5643

48127
Mrs.
Denise
Farrell
770-819-8838

48151
Mrs.
Janice
Dalton
770-528-5565

48372
Mrs.
Fanny
Stanford
770-528-9637

48483
Mrs.
Diane
Lee
678-499-9356

49039
Dr.
Neil
Santiago
770-528-6084

49115
Ms.
Marie
Holloway
770-528-7048

49177
Ms.
Amanda
Ghomeshi
770-528-1689

49206
Mrs.
Lily
Yee
678-528-4091

49484
Mr.
Arnold
Morton
770-427-2033

49905
Mr.
Jim
Sloan
770-427-1855

StorageID
Location
FacilityID

1
Room 140
A01

2
Room 141
A01

3
Room 142
A01

4
Suite 225
A02

5
Suite 240
A02

6
Suite 250
A02

SELECT DISTINCTROW *
FROM tblPatron;

SELECT tblAnimal.AnimalName, tblAnimal.AnimalGender, tblAnimal.AnimalType, tblAnimal.AdoptionDate, tblAnimal.Adopted
FROM tblAnimal
WHERE (((tblAnimal.AnimalType)=”dog”) AND ((tblAnimal.Adopted)=Yes))
ORDER BY tblAnimal.AnimalName;

SELECT tblDonation.DonationDesc, tblDonation.DonationDate, tblDonation.DonationValue, tblPatron.FirstName, tblPatron.LastName
FROM (tblPatron INNER JOIN tblAnimal ON tblPatron.PatronID = tblAnimal.PatronID) INNER JOIN tblDonation ON tblPatron.PatronID = tblDonation.PatronID
ORDER BY tblDonation.DonationDate, tblPatron.LastName;

SELECT [tblPatron].[PatronID]
FROM tblPatron;

PARAMETERS __PatronID Text;
SELECT DISTINCTROW *
FROM [SELECT [tblDonation].[DonationID], [tblDonation].[PatronID], [tblDonation].[DonationDate], [tblDonation].[DonationDesc], [tblDonation].[DonationTypeID], [tblDonation].[DonationValue] FROM tblDonation]. AS frmPatronDonations
WHERE ([__PatronID] = PatronID);

SELECT DISTINCTROW *
FROM tblPatron;

Access Assignment/Data files for assignment/Case3/Receipt2100.xlsx

Sheet1

Receipt for purchase: 2100

Dog food
$ 412.85

Tax
$ 49.54

Total
$ 462.39

Access Assignment/Data files for assignment/Case3/Receipt2101.xlsx

Sheet1

Receipt for purchase: 2101

Cat food
$ 96.24

Tax
$ 11.55

Total
$ 107.79

Access Assignment/Data files for assignment/Case3/Rescuers.accdb

DriverID
FirstName
LastName

1
Sam
Hoang

2
Pat
Linden

3
Terry
Benson

4
Maria
Nunez

Access Assignment/Data files for assignment/Case4/.DS_Store

Access Assignment/Data files for assignment/Case4/Leary_1.txt
Medical document certifying Edward Leary had his flu vaccine has been verified.

Access Assignment/Data files for assignment/Case4/Leary_2.txt
Medical document certifying Edward Leary had his meningitis vaccine has been verified.

Access Assignment/Data files for assignment/Case4/Vacation.accdb

GuestID
GuestFirst
GuestLast
Address
City
StateProv
PostalCode
Country
Phone

401
Student First
Student Last
10 Winter Ave
Boise
ID
83702
USA
208-344-0975

402
Ingrid
Schmidt
340 Riverside Dr East
Calgary
AB
T1Y 3N4
Canada
403-226-8577

403
Brian
Anderson
5003 Grant Blvd
Great Falls
MT
59401
USA
406-761-4515

405
Leo
Nelson
34 King St
Hamilton
ON
L9C 2T9
Canada
905-388-1212

406
Li
Zhu
3406 Lakeshore Dr
Great Falls
MT
59406
USA
406-761-8109

407
Anna
Martinez
17 Western Ave
Pocatello
ID
83201
USA
208-705-3847

409
Suzanne
Marceaux
734 Great Rd
Cheyenne
WY
82001
USA
314-556-1290

410
Luiz
Neto
8552 Main St
Cheyenne
WY
82002
USA
314-556-7053

411
Sarah
Vanesse
312 Park Rd
Butte
MT
59701
USA
406-782-1882

412
Olivia
Froberg
433 Madison St
Boise
ID
83702
USA
208-344-3055

415
Jose
Gonzales
14 Spencer Blvd
Pocatello
ID
83201
USA
208-705-3044

416
Sushil
Gupta
150 Maple St
Boise
ID
83702
USA
208-344-3339

417
Isabelle
Rouy
227 Front Ln
Calgary
AB
T1Y 2N7
Canada
403-226-0065

419
Patrick
Higgins
2120 W Gable Rd
Pocatello
ID
83711
USA
208-232-1672

420
Alberto
Lopez
991 Crestview Dr
Butte
MT
59701
USA
406-782-1183

421
Amy
DuBrava
118 Forest Rd
Cheyenne
WY
82001
USA
314-556-1275

422
Ansis
Kalnajs
3 March St
Butte
MT
59701
USA
406-782-0312

425
Kelly
Skolnik
15 Tobin Dr
Red Deer
AB
T4N 3D5
Canada
403-755-1597

428
Jacques
Portier
4478 Queen Ave
Windsor
ON
N8X 3Y8
Canada
519-966-9094

429
Paul
Barry
7533 Conant Dr
Butte
MT
59701
USA
406-782-2209

430
Susan
Davis
463 Evergreen Rd
Pocatello
ID
83201
USA
208-705-5943

PersonID
FirstName
LastName
JobTitle
Manager

CH2468
Catherine
Higgins
Tour Manager

CM2222
Christopher
Murphy
Tour Manager

EJ7531
Elizabeth
Jackson
Tour Manager

EJ8888
Edward
Leary
Tour Guide
CH2468

RC1111
Robert
Crane
Tour Guide
EJ7531

SL3333
Susan
Lawrence
Tour Guide
CM2222

TD5555
Thomas
Digby
Tour Guide
EJ7531

TP8642
Theodore
Paine
Tour Guide
CM2222

VW9751
Victoria
Watson
Tour Guide
CH2468

ReservationID
GuestID
StartDate
People
TourID
TourGuide

503
409
2016-06-12
2
3488
EJ8888

504
403
2016-07-11
3
3010
VW9751

507
425
2016-05-12
2
3002
RC1111

510
420
2016-05-01
4
3107
EJ8888

511
401
2016-08-20
2
3142
SL3333

512
411
2016-04-04
3
3222
TP8642

513
416
2016-07-20
8
3007
VW9751

515
402
2016-09-08
1
3050
EJ8888

520
415
2016-08-10
3
3002
TD5555

521
406
2016-06-03
4
3395
RC1111

522
430
2016-06-22
5
3190
SL3333

525
412
2016-07-11
6
3010
EJ8888

530
429
2016-08-05
2
3204
TP8642

531
405
2016-07-11
2
3010
TD5555

535
421
2016-09-10
2
3003
SL3333

536
422
2016-07-20
2
3007
EJ8888

537
410
2016-05-01
3
3107
VW9751

540
411
2016-04-10
2
3222
TD5555

541
428
2016-09-10
4
3003
TP8642

545
403
2016-08-20
1
3142
EJ8888

548
412
2016-10-02
1
3395
SL3333

550
429
2016-10-02
6
3395
RC1111

TourID
TourName
Location
Country
TourPricePerPerson
SingleSupplement
TourType
Nights
Description

3002
Galapagos Wildlife
Galapagos Islands
Ecuador
¤ 5,500.00
¤ 1,200.00
Boat
11
Island beauty; diverse wildlife; boating

3003
Madagascar Photo Expedition
Madagascar
Madagascar
¤ 6,500.00
¤ 1,100.00
Hiking
13
Exotic animals; stunning landscape; hiking

3007
South American Expedition
Pantanal
Brazil
¤ 6,000.00
¤ 1,250.00
Jeep
8
Jaguars; Macaw; Savannah

3010
Amazon River Tour
Manaus
Brazil
¤ 4,500.00
¤ 800.00
Boat
6
River wildlife; native villages; cruise

3050
Inca Trail
Cusco
Peru
¤ 3,800.00
¤ 600.00
Hiking
4
Ancient structures; hiking

3107
Machu Picchu Hike
Cusco
Peru
¤ 4,300.00
¤ 650.00
Hiking
5
Ancient structures; hiking

3142
Petra Desert Tour
Jerusalem
Israel
¤ 4,800.00
¤ 700.00
Jeep
4
Ancient structures; desert; 4×4 jeep

3179
Everglades Kayaking Tour
Miami
U.S.
¤ 800.00
¤ 0.00
Kayak
1
Day trip; kayak; wildlife

3190
Chambok Community Volunteer
Chambok
Cambodia
¤ 6,500.00
¤ 1,200.00
Hiking
12
National Park; Volunteer in the community; Ox cart transportation

3204
Cambodian Agricultural Development
Battambang
Cambodia
¤ 4,500.00
¤ 900.00
Jeep
10
Work on a farm; wildlife; hiking; 4×4 jeep

3222
Malaysian Rainforest Tour
Gunung Mulu National Park
Malaysia
¤ 2,800.00
¤ 500.00
Hiking
6
Walk along the canopy; wildlife; hiking

3395
Himalayan Hike
Trisul
India
¤ 5,600.00
¤ 1,500.00
Hiking
6
Trek around Roopkund Lake; glacier; hiking

3423
India Wildlife Safari
Delhi
India
¤ 6,200.00
¤ 1,800.00
Hiking
10
Tigers; exotic plants; hiking

3488
Birding Adventure
Almaty
Kazakhstan
¤ 2,800.00
¤ 600.00
Hiking
8
Bird watching; hiking

ReservationID
PersonID

503
EJ8888

504
VW9751

507
RC1111

510
EJ8888

511
SL3333

512
TP8642

513
VW9751

515
EJ8888

520
TD5555

521
RC1111

522
SL3333

525
EJ8888

530
TP8642

531
TD5555

535
SL3333

536
EJ8888

537
VW9751

540
TD5555

541
TP8642

545
EJ8888

548
SL3333

550
RC1111

TourName
Location
Country
TourPricePerPerson
SingleSupplement
TourType
Nights
Description

Galapagos Relaxation
Galapagos Islands
Equador
4200
1000
Boat
7
Island beauty; spa; diverse wildlife

Madagascar Wildlife
Madagascar
Madagascar
5500
800
Hiking
8
Exotic animals; stunning landscape; hiking

South American Adventure
Pantanal
Brazil
4500
800
Hiking
8
Exotic wildlife; hiking; Savannah

Amazon River Adventure Tour
Manaus
Brazil
6800
1200
Boat
12
River wildlife; native villages; cruise; hiking

Inca Trail and Machu Picchu
Cusco
Peru
7800
1800
Hiking
10
Ancient structures; hiking

Petra Desert Adventure
Jerusalem
Israel
6800
1200
Jeep
7
Ancient structures; desert; 4×4 jeep

Everglades Adventure
Miami
U.S.
1200
300
Kayak
4
kayak; wildlife; hiking

Chambok Community Volunteer Extended
Chambok
Cambodia
14500
1800
Hiking
21
National Park; Volunteer in the community; Ox cart transportation

Malaysian Rainforest Adventure
Gunung Mulu National Park
Malaysia
3800
800
Jeep
10
Walk along the canopy; wildlife; 4×4 jeep