AppTrail1.accdb
| HikerID | HikerFirst | HikerLast | Address | City | State | Zip | Phone |
| 501 | Student First | Student Last | 123 Jackson St | Boone | NC | 28607 | 828-497-9128 |
| 503 | Ellen | Gilliams | 19 Westernville Rd | Spartanburg | SC | 29301 | 864-921-9876 |
| 506 | Robert | Taylor | 41 Taylor Ln | Jackson | GA | 30233 | 770-999-2391 |
| 509 | Sarah | Peeler | 32 Mountain Ln | Ridgeview | WV | 25169 | 703-599-2043 |
| 512 | Rebecca | Peeler | 32 Mountain Ln | Ridgeview | WV | 25169 | 703-456-9381 |
| 515 | Robert | Peeler | 32 Mountain Ln | Ridgeview | WV | 25169 | 703-456-9381 |
| 518 | Wilbur | Sanders | 512 Loop Rd | Asheville | NC | 28801 | 828-910-2058 |
| 521 | Zack | Hoskins | 2 Hope Rd | Atlanta | GA | 30301 | 404-998-2381 |
| 524 | Sissy | Jackson | 92 Bobcat Cir | Bethesda | MD | 20817 | 240-925-0129 |
| 527 | Mark | Billings | 43 Oak Ln | Cashiers | NC | 28717 | 828-829-9842 |
| 530 | Todd | Pillow | 2 Pillow St | Hendersonville | NC | 28739 | 828-987-2948 |
| 533 | Thomas | Jones | 11 Boston Rd | Greenville | SC | 29601 | 864-234-9501 |
| 535 | Elmer | Jackson | 99 River Rd | Blacksburg | SC | 29702 | 864-921-2384 |
| 538 | Catherine | Johnson | 21 Pine St | Cedartown | GA | 30125 | 678-982-1029 |
| 541 | Douglas | Furrington | 44 King St | Hershey | PA | 17033 | 717-098-9382 |
| 544 | Matthew | Smith | 412 Sentry Ln | Gastonia | NC | 28052 | 704-998-0987 |
| 547 | Heather | Smith | 412 Sentry Ln | Gastonia | NC | 28052 | 704-998-0987 |
| 550 | Jack | Smith | 412 Sentry Ln | Gastonia | NC | 28052 | 704-998-0987 |
| 553 | Seth | Barkley | 12 Main St | Stanley | NC | 28164 | 704-988-2019 |
| 556 | Henry | Billings | 5 Loop Rd | Alexis | NC | 28006 | 704-921-8832 |
| 560 | William | Shockley | 42 Windmill Rd | Gastonia | NC | 28052 | 704-998-4297 |
| ReservationID | HikerID | TourID | TourDate | People |
| 3000 | 512 | 100 | 9/9/17 | 3 |
| 3005 | 538 | 115 | 9/16/17 | 1 |
| 3010 | 544 | 115 | 9/16/17 | 1 |
| 3015 | 547 | 115 | 9/16/17 | 1 |
| 3020 | 550 | 115 | 9/16/17 | 1 |
| 3025 | 501 | 130 | 9/23/17 | 2 |
| 3030 | 521 | 130 | 9/23/17 | 2 |
| 3035 | 535 | 125 | 9/30/17 | 3 |
| 3040 | 556 | 125 | 9/30/17 | 2 |
| 3045 | 527 | 105 | 10/7/17 | 1 |
| 3050 | 527 | 125 | 9/30/17 | 1 |
| 3055 | 503 | 110 | 9/2/17 | 1 |
| 3060 | 553 | 110 | 9/2/17 | 1 |
| 3065 | 541 | 120 | 10/7/17 | 5 |
| 3070 | 524 | 100 | 9/9/17 | 2 |
| 3075 | 506 | 130 | 9/23/17 | 2 |
| 3080 | 509 | 125 | 9/30/17 | 2 |
| 3085 | 533 | 125 | 9/30/17 | 1 |
| 3090 | 530 | 135 | 10/14/17 | 3 |
| 3095 | 515 | 140 | 12/16/17 | 3 |
| 3100 | 518 | 145 | 8/26/17 | 2 |
| 3105 | 527 | 150 | 8/19/17 | 3 |
| 3110 | 544 | 150 | 8/19/17 | 2 |
| 3115 | 547 | 120 | 10/7/17 | 2 |
| 3120 | 503 | 140 | 12/16/17 | 2 |
| TourID | TourName | TourType | Hours | Description | PricePerPerson |
| 100 | Linville Gorge | Hiking | 4 | Exploration of Linville Gorge and falls | ¤ 100.00 |
| 105 | Rough Ridge | Hiking | 3 | Scenic views at Rough Ridge and surrounding peaks | ¤ 75.00 |
| 110 | Grandfather Mountain | Hiking | 6 | Exploration of Grandfather Mountain (lunch included) | ¤ 175.00 |
| 115 | Boone Greenway | Hiking | 4 | Traverse the Boone Greenway and explore the beauty | ¤ 100.00 |
| 120 | Explore the High Country | Van | 8 | Spend a day exploring the High Country (lunch and dinner included) | ¤ 250.00 |
| 125 | Elk Knob | Hiking | 4 | Explore Elk Knob and surrounding area | ¤ 100.00 |
| 130 | Mount Mitchell | Hiking | 6 | Explore beautiful Mount Mitchell (lunch included) | ¤ 175.00 |
| 135 | Roan Mountain | Hiking | 6 | Explore Roan Mountain (lunch included) | ¤ 175.00 |
| 140 | Cross Country Skiing | Skiing | 3 | Explore the High Country on skis (equipment included) | ¤ 150.00 |
| 145 | Rock Climbing | Climbing | 3 | Introduction to rock climbing in the High Country (equipment included) | ¤ 125.00 |
| 150 | Fishing | Van/Fishing | 6 | Spend the day fishing on various lakes in the High Country (equipment and lunch included) | ¤ 200.00 |
SELECT DISTINCTROW *
FROM tblHiker;
SELECT DISTINCTROW *
FROM tblHiker;
gijack25
