Data Entry and Project Implentiation

profilesdotholla
harris_week_2_frequent_flier.accdb
Home>Computer Science homework help>Data Entry and Project Implentiation
ID Last_Name First_Name Address Phone_Number Frequent-flier number Frequent-flier airline Meal category Preferred seating area
1 Easton Dennis 1401 Merman 208-882-3476 725722 Continental Vegan Aisle
2 Lin Yu-Lin 1900 E 12th 208-882-3232 530376 American Airlines Vegan Aisle
3 Beasley Steve 4125 Maryland Ct 509-332-2354 144323 British Airways Vegan Aisle
4 Becker Hubert 560 Hawthorne Dr 509-336-6578 603151 American Airlines Vegan Window
5 Fuhrmann Leslie 525 Dexter 509-336-9807 752937 Delta Vegan Window
6 Gillespie Patricia 454 Diane 509-332-4578 803686 Continental Vegan Emgerency Exit
7 Li Chun 2250 Hwy 95 N 509-357-4433 211641 American Airlines Vegan Aisle
8 Lee SooJin 1500 Ravenna Ct 509-332-6589 740617 American Airlines Vegan Window
9 Lawrence Earl 2546 Palouse River Road 509-123-4561 813258 American Airlines Vegan Window
10 Baker Beth 1230 Gibson Street 509-555-8947 219608 American Airlines Vegan Aisle
11 Zhan Man 811 Summit Rd 509-332-4567 978445 Delta Vegan Aisle
12 Yang Jung 105 NE Spring 509-357-4509 515086 Delta Vegan Window
13 Hutchinson Eric 800 True St 509-336-5465 867814 American Airlines Vegan Window
14 Thompson Caitlin 225 N Thomas 509-332-8790 15782 British Airways Kosher Window
15 Baldwin MaryAnn 450 Lamont St 208-882-4455 206584 Continental Kosher Emgerency Exit
16 Dumont Mark 547 Laurel 509-332-4526 74826 Continental Kosher Emgerency Exit
17 Gibson Fernanda 201 Ponderosa Way 208-882-6745 79235 Delta Kosher Emgerency Exit
18 Sanderson Sonja 1212 W Pullman Rd 509-336-5567 380392 Delta Kosher Aisle
19 Clausen Gina 1260 Crescent Ct 509-336-7777 43476 American Airlines Kosher Window
20 Hunter Anna 6 State St 208-882-3424 189143 Continental Kosher Emgerency Exit
21 Marshal Debbie 1427 E 5th 208-882-1525 788839 Delta Kosher Aisle
22 Austin Joseph 448 C Street 509-333-4576 398846 American Airlines Kosher Window
23 Clark Heather 313 S Blaine 509-332-9087 276924 American Airlines Kosher Window
24 Thornton Janet 815 SE Klemgard 509-332-8679 883456 British Airways Kosher Window
25 Norton Cynthia 333 Lauder 509-357-5676 634054 Delta Islamic/halal Window
26 Walker Ken 1300 Old State Route 26 509-332-6709 259804 British Airways Islamic/halal Window
27 Nauman Michael 345 A Street 509-357-5673 742971 British Airways Islamic/halal Aisle
28 Boyd Gloria 445 Kamiaken 509-332-1234 925803 British Airways Islamic/halal Aisle
29 Proctor Ginny 1031 Tolo Tr 208-875-3333 525630 Continental Islamic/halal Aisle
30 Hunt Jack 1200 Fairview St 509-332-6708 424960 Delta Islamic/halal Aisle
31 West Helen 1255 Sunny Meade Way 509-357-3487 747197 American Airlines Islamic/halal Window
32 Henderson Angela 50 Bishop Blvd 509-332-4343 434996 British Airways Islamic/halal Window
33 Stewart Kathy 840 Mabelle 509-357-8889 306513 British Airways Islamic/halal Window
34 Cox Linda 1920 Terre View Dr 509-332-7456 472458 American Airlines Islamic/halal Window
35 Choi Diane 103 S Main 208-882-5478 224029 British Airways Non Veg Window
36 Looney Carl 1234 Main 509-222-5645 401419 Continental Non Veg Emgerency Exit
37 Fujimoto Carla 1501 Whitman 509-332-4532 542880 Continental Non Veg Aisle
38 Herman Frank 1611 Hwy 3 509-332-1267 837399 American Airlines Non Veg Window
39 Wallace Alex 1000 Colorado St 208-882-5576 304136 Delta Non Veg Aisle
40 Hall Marion 110 Van Buren 509-357-3434 135797 American Airlines Non Veg Aisle
41 Weber Cliff 1037 Fink Rd 208-875-7844 874563 American Airlines Non Veg Aisle
42 Frazier Nancy 1630 Valley Rd 509-332-1243 294736 Continental Non Veg Aisle
43 Sanchez Ramon 1375 Mtn View Dr 208-882-9898 818401 Continental Non Veg Aisle
44
ID Last_Name First_Name Address Phone_Number Frequent-flier number Frequent-flier airline Meal category Preferred seating area
1 Easton Dennis 1401 Merman 208-882-3476 725722 Continental Vegan Aisle
2 Lin Yu-Lin 1900 E 12th 208-882-3232 530376 American Airlines Vegan Aisle
3 Beasley Steve 4125 Maryland Ct 509-332-2354 144323 British Airways Vegan Aisle
4 Becker Hubert 560 Hawthorne Dr 509-336-6578 603151 American Airlines Vegan Window
5 Fuhrmann Leslie 525 Dexter 509-336-9807 752937 Delta Vegan Window
6 Gillespie Patricia 454 Diane 509-332-4578 803686 Continental Vegan Emgerency Exit
7 Li Chun 2250 Hwy 95 N 509-357-4433 211641 American Airlines Vegan Aisle
8 Lee SooJin 1500 Ravenna Ct 509-332-6589 740617 American Airlines Vegan Window
9 Lawrence Earl 2546 Palouse River Road 509-123-4561 813258 American Airlines Vegan Window
10 Baker Beth 1230 Gibson Street 509-555-8947 219608 American Airlines Vegan Aisle
11 Zhan Man 811 Summit Rd 509-332-4567 978445 Delta Vegan Aisle
12 Yang Jung 105 NE Spring 509-357-4509 515086 Delta Vegan Window
13 Hutchinson Eric 800 True St 509-336-5465 867814 American Airlines Vegan Window
14 Thompson Caitlin 225 N Thomas 509-332-8790 15782 British Airways Kosher Window
15 Baldwin MaryAnn 450 Lamont St 208-882-4455 206584 Continental Kosher Emgerency Exit
16 Dumont Mark 547 Laurel 509-332-4526 74826 Continental Kosher Emgerency Exit
17 Gibson Fernanda 201 Ponderosa Way 208-882-6745 79235 Delta Kosher Emgerency Exit
18 Sanderson Sonja 1212 W Pullman Rd 509-336-5567 380392 Delta Kosher Aisle
19 Clausen Gina 1260 Crescent Ct 509-336-7777 43476 American Airlines Kosher Window
20 Hunter Anna 6 State St 208-882-3424 189143 Continental Kosher Emgerency Exit
21 Marshal Debbie 1427 E 5th 208-882-1525 788839 Delta Kosher Aisle
22 Austin Joseph 448 C Street 509-333-4576 398846 American Airlines Kosher Window
23 Clark Heather 313 S Blaine 509-332-9087 276924 American Airlines Kosher Window
24 Thornton Janet 815 SE Klemgard 509-332-8679 883456 British Airways Kosher Window
25 Norton Cynthia 333 Lauder 509-357-5676 634054 Delta Islamic/halal Window
26 Walker Ken 1300 Old State Route 26 509-332-6709 259804 British Airways Islamic/halal Window
27 Nauman Michael 345 A Street 509-357-5673 742971 British Airways Islamic/halal Aisle
28 Boyd Gloria 445 Kamiaken 509-332-1234 925803 British Airways Islamic/halal Aisle
29 Proctor Ginny 1031 Tolo Tr 208-875-3333 525630 Continental Islamic/halal Aisle
30 Hunt Jack 1200 Fairview St 509-332-6708 424960 Delta Islamic/halal Aisle
31 West Helen 1255 Sunny Meade Way 509-357-3487 747197 American Airlines Islamic/halal Window
32 Henderson Angela 50 Bishop Blvd 509-332-4343 434996 British Airways Islamic/halal Window
33 Stewart Kathy 840 Mabelle 509-357-8889 306513 British Airways Islamic/halal Window
34 Cox Linda 1920 Terre View Dr 509-332-7456 472458 American Airlines Islamic/halal Window
35 Choi Diane 103 S Main 208-882-5478 224029 British Airways Non Veg Window
36 Looney Carl 1234 Main 509-222-5645 401419 Continental Non Veg Emgerency Exit
37 Fujimoto Carla 1501 Whitman 509-332-4532 542880 Continental Non Veg Aisle
38 Herman Frank 1611 Hwy 3 509-332-1267 837399 American Airlines Non Veg Window
39 Wallace Alex 1000 Colorado St 208-882-5576 304136 Delta Non Veg Aisle
40 Hall Marion 110 Van Buren 509-357-3434 135797 American Airlines Non Veg Aisle
41 Weber Cliff 1037 Fink Rd 208-875-7844 874563 American Airlines Non Veg Aisle
42 Frazier Nancy 1630 Valley Rd 509-332-1243 294736 Continental Non Veg Aisle
43 Sanchez Ramon 1375 Mtn View Dr 208-882-9898 818401 Continental Non Veg Aisle
44
SELECT DISTINCTROW * FROM table;