microsoft access asignment

profilezxy0120
Programming-CaseBStartup1.accdb
Home>Information Systems homework help>microsoft access asignment
ContractID StudentID TutorID ContractDate SessionType Length NumSessions Cost Assessment
6215 PER4055 1018 7/6/17 Group 2 5 ¤ 400.00 true
6220 GAL4050 1025 7/10/17 Private 1 5 ¤ 300.00 false
6225 VAS4040 1051 7/18/17 Group 2 6 ¤ 480.00 true
6230 JOH4075 1005 7/21/17 Private 1 5 ¤ 300.00 true
6235 PAS4020 1001 7/25/17 Semi-private 3 2 ¤ 360.00 false
6240 MAL4115 1031 8/2/17 Private 2 3 ¤ 300.00 true
6245 NIV4110 1039 8/4/17 Group 2 5 ¤ 400.00 false
6250 TOL4035 1008 8/11/17 Private 1 5 ¤ 300.00 true
6255 DOR4030 1013 8/15/17 Semi-private 2 6 ¤ 720.00 true
6260 LON4105 1033 8/17/17 Private 2 5 ¤ 600.00 true
6265 AND4010 1028 8/23/17 Private 2 4 ¤ 480.00 true
6270 RAM4025 1023 8/25/17 Group 2 5 ¤ 400.00 false
6275 BAR4018 1003 8/30/17 Group 2 5 ¤ 400.00 false
6280 COW4100 1015 9/5/17 Private 3 4 ¤ 720.00 true
6285 EIG4042 1036 9/6/17 Group 2 5 ¤ 400.00 false
6290 FRA4045 1020 9/12/17 Semi-private 1 5 ¤ 300.00 true
6295 HIC4055 1042 9/18/17 Private 2 6 ¤ 720.00 true
6300 KIL4085 1045 9/26/17 Private 1 10 ¤ 600.00 true
6305 WIL4050 1048 9/28/17 Private 2 10 ¤ 1,200.00 true
6315 NIV4110 1060 10/2/17 Semi-private 2 8 ¤ 960.00 true
6325 FRA4045 1018 10/3/17 Group 1 10 ¤ 400.00 false
6330 VAS4040 1025 10/6/17 Private 2 5 ¤ 600.00 true
6335 JOH4075 1042 10/9/17 Private 2 10 ¤ 1,200.00 true
6340 LON4105 1015 10/11/17 Private 2 4 ¤ 480.00 true
6350 LOP4015 1010 10/12/17 Private 3 4 ¤ 720.00 true
StudentID FirstName LastName Address City State Zip HomePhone CellPhone BirthDate Gender
AND4010 Joshua Anderson 55 Boone Ct Raleigh NC 27601 919-263-4938 919-665-0119 4/27/98 M
BAR4018 Andrew Bartles 47 King St Cary NC 27511 919-663-9110 919-678-1612 11/2/97 M
COW4100 Darcy Cowler 88 Earth Way Raleigh NC 27601 919-264-5981 919-664-4454 12/2/98 F
DOR4030 Barbara Dorman 65 Kirby Ct Raleigh NC 27602 919-265-6549 919-664-0971 9/16/97 F
EIG4042 Fredrik Eigenmeyer 16 Emporium Ct Raleigh NC 27603 919-264-2598 919-665-5540 3/2/95 M
FRA4045 Salvador Francisco 11 Bobcat Dr Cary NC 27512 919-664-9810 919-678-4719 5/25/98 M
GAL4050 Elizabeth Gallagher 44 Winner Cir Raleigh NC 27602 919-265-1410 919-664-9988 4/12/97 F
HIC4055 Hildago Hickman 22 Pinwheel Ln Cary NC 27511 919-664-0129 919-678-4960 11/12/98 M
JOH4075 Amber Johnson 2 14th Ave Raleigh NC 27602 919-263-4432 919-664-1992 4/1/97 F
KIL4085 David Killian 123 Berry Dr Apex NC 27503 919-234-1413 919-698-9381 11/14/97 M
LON4105 Wilbur Long 55 Pond Rd Holly Springs NC 27540 919-355-8450 919-712-2139 1/5/97 M
LOP4015 Henry Lopez 19 8th St Raleigh NC 27601 919-264-9981 919-665-8110 2/19/98 M
MAL4115 Dystra Malik 14 Gaston St Raleigh NC 27602 919-264-6450 919-664-9125 6/22/98 M
NIV4110 Christy Niver 617 Echo Ln Apex NC 27503 919-234-6693 919-699-0158 4/12/96 F
PAS4020 Victor Pasquez 42 Nightingale Ct Cary NC 27511 919-662-1002 919-678-8240 8/2/98 M
PER4055 Rosalyn Perez 421 Pine Ln Cary NC 27511 984-662-4761 919-678-0012 4/12/96 F
RAM4025 Ellen Ramsey 45 7th St Holly Springs NC 27540 919-355-5340 919-713-1654 12/29/97 F
TOL4035 Jack Tolliver 12 19th St Apex NC 27503 919-235-1109 919-698-1585 6/2/97 M
VAS4040 Anton Vasquez 32 Wolf Dr Raleigh NC 27602 919-263-9531 919-665-5329 10/22/98 M
WIL4050 Sue Williams 99 Skyblue Rd Apex NC 27503 919-235-5343 919-699-5339 2/6/96 F
TutorID FirstName LastName Major YearInSchool School HireDate Groups
1001 Tom Johnson Computer Science Senior Hogan University 2/5/17 false
1003 Carey Billings Information Systems Junior Eikenville College 3/1/17 true
1005 Bob Smith Computer Science Graduate Hogan University 4/18/17 false
1008 Sally Gilbert Information Systems Senior Ellings College 1/15/17 false
1010 Cathy Cowler Computer Engineering Graduate Eikenville College 2/1/17 false
1013 Aaron Black Computer Science Junior Smith Technical College 5/14/17 false
1015 Douglas Arrendale Computer Engineering Senior Ellings College 3/27/17 false
1018 Fredrik Karlsson Mechatronics Junior Smith Technical College 2/6/17 true
1020 Ian Rodriguez Computer Science Senior Potswan College 2/27/17 false
1023 Jake Ballard Mechatronics Senior Smith Technical College 4/2/17 false
1025 Larry Smith Computer Science Graduate Hogan University 5/21/17 false
1028 Mike Johnson Mechatronics Senior Smith Technical College 1/8/17 false
1031 Nichole Schneider Computer Science Junior Switzer University 2/28/17 false
1033 Barbara Alzo Information Systems Senior Hogan University 3/12/17 false
1036 Ellen Desoto Computer Science Graduate Hogan University 4/16/17 true
1039 Gail Fordham Information Systems Junior Switzer University 2/22/17 false
1042 Henry Justice Computer Science Graduate Smith Technical College 4/20/17 false
1045 Kelly Rudd Computer Science Graduate Potswan College 2/27/17 false
1048 Angie Hinson Computer Engineering Senior Franklin University 5/10/17 false
1051 Donald Gallager Computer Science Graduate Hogan University 1/18/17 true
1060 Student First Student Last Computer Science Senior Ellings College 2/14/17 false
SELECT DISTINCTROW * FROM Tutor;
SELECT DISTINCTROW * FROM Tutor;
SELECT Tutor.FirstName, Tutor.LastName, Tutor.HireDate FROM Tutor;