computer science - discussion board

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