Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The director of sales and marketing at the travelagency would like to increase the efficiency of han-dling those who have frequent-flier accounts. Often,frequent fliers have

The director of sales and marketing at the travelagency would like to increase the efficiency of han-dling those who have frequent-flier accounts. Often,frequent fliers have regular travel routes and a pre-ferred seating area or meal category. In previous years,the data have been manually entered into a three-ringbinder. In order to handle the frequent fliers' requestsmore efficiently, your director has asked you to buildan Access database containing the traveler's name(first and last name), address, phone number, frequent-flier number, frequent-flier airline, meal category, andpreferred seating area.To do this, you will need to do the following:

?Create an empty database named "Frequent Flier."

?Import the data contained in the file FrequentFliers.txt. Use "Text File" under "Import" in the "ExternalData" tab. Hint: Use tab delimiters when importingthe data; note that the first row contains field names.

After importing the data, create a report displaying thenames and addresses of all frequent fliers by doing thefollowing:

?Select "Report Wizard" under "Report" in the"Create" tab.

?Include the fields "first name," "last name," and"address" in the report

.?Save the report as "Frequent Fliers.

image text in transcribed
Last Name Address City State ZIP Phone Number Frequent Flier_Number Airline Meal Category Seating Area First Name Vegan Aisle Easton Dennis 1401 Merman Moscow ID 83843 208-882-3476 725722 Continental ID 83843 208-882-3232 530376 American Airlines Vegan Aisle Lin Yu-Lin 1900 E 12th Moscow Pullman WA 99163 509-332-2354 144323 British Airways Vegan Aisle Beasley Steve 4125 Maryland Ct 99161 509-336-6578 603151 Vegan Window Becker Hubert 560 Hawthorne Dr louse WA American Airlines Vegan Window Fuhrmann Leslie 525 Dexter Albion WA 99102 509-336-9807 752937 Delta Gillespie Patricia 154 Diane Pullman WA 99163 509-332-4578 803686 Continental Vegan Emgerency Exit Aisle Li Chun 2250 Hwy 95 N Colfax WA 99111 509-357 211641 American Airlines Vegan Lee SooJin 1500 Ravenna Ct Pullman WA 99163 509-332-6589 740617 American Airlines Vegan Window Lawrence Earl 99161 509-123-4561 Vegan Window 2546 Palouse River Road Palouse WA 813258 American Airlines Pullman WA 99160 509-555-8947 219608 American Airlines Vegan Aisle Baker Beth 1230 Gibson Street Zhan Mar 811 Summit Rd Pullman WA 99163 509-332-4567 978445 Delta Vegan Aisle 105 NE Spring Colfax WA 99111 509-357-450 515086 Delta Vegan Window Yang Jung 800 True St Albion WA 99102 509-336-5465 867814 American Airlines Vegan Window Hutchinson Eric Caitlin 225 N Thomas Pullman WA 99163 509-332-8790 15782 British Airways Kosher Window Thompson Baldwin MaryAnn 450 Lamont St MOSCOW ID 83843 208-882-4455 206584 Continental Kosher Emgerency Exit Dumont Mark 547 Laurel Pullman WA 99163 509-332-4526 74826 Continental Kosher Emgerency Exit 79235 Delta Kosher Emgerency Exit Gibson Fernanda 201 Ponderosa Way Moscow ID 83843 208-882-6745 Sanderson Sonja 1212 W Pullman Rd Palouse WA 9161 509-336-5567 380392 Delta Kosher Aisle 1260 Crescent Ct 509-336-7777 13476 Kosher Window Clausen Gina Palouse WA 99161 American Airlines Emgerency Exit Hunter Anna 6 State St Moscow ID 83843 208-882-3424 189143 Continental Kosher Marshal Debbie 1427 E 5th Moscow ID 83843 208-882-1525 788839 Delta Kosher Aisle 448 C Street Pullman WA 99164 509-333-4576 398846 American Airlines Kosher Window Austin Joseph Clark Heather 313 S Blaine Pullman WA 99163 509-332-9087 276924 American Airlines Kosher Window 509-332-8679 Window Janet 883456 British Airways Kosher Thornton 815 SE Klemgard Pullman WA 99163 Norton Cynthia 333 Lauder Colfax WA 99111 509-357-5676 634054 Delta Islamic/halal Window Walker Ken 1300 Old State Route 26 Pullman WA 99163 509-332-6709 259804 British Airways Islamic/halal Window Nauman Michael 345 A Street Colfax WA 99160 509-357-5673 742971 British Airways Islamic/halal Aisle Boyd Gloria 445 Kamiaken Pullman WA 99163 509-332-1234 925803 British Airways Islamic/halal Aisle Lewiston ID 83501 208-875-3333 525630 Continental Islamic/halal Aisle Proctor Ginny 1031 Tolo Tr Jack 1200 Fairview St Pullman WA 99163 509-332-6708 424960 Delta Islamic/halal Aisle Hunt Islamic/halal Window West Helen 1255 Sunny Meade Way Colfax WA 99111 509-357-3487 747197 American Airlines Henderson Angela 50 Bishop Blvd 99163 509-332-4343 Window Pullman WA 434996 British Airways Islamic/halal Window Stewart Kathy 840 Mabelle Colfax WA 99111 509-357-8889 306513 British Airways Islamic/halal 1920 Terre View Dr 99163 509-332-7456 Islamic/halal Window Cox Linda Pullman WA 172458 American Airlines Choi Diane 103 S Main Moscow ID 83843 208-882-5478 224029 British Airways Non Veg Window Looney Carl 1234 Main Pullman WA 99163 509-222-5645 401419 Continental Non Veg Emgerency Exit Carla Pullman WA 99163 Non Veg Aisle Fujimoto 1501 Whitman 509-332-4532 542880 Continental Herman Frank 1611 Hwy 3 Pullman WA 99163 509-332-1267 837399 American Airlines Non Veg Window 1000 Colorado St ID 304136 Delta Non Veg Aisle Wallace Alex Moscow 83843 208-882-5576 Hall Marion 110 Van Buren Colfax WA 99111 509-357-3434 135797 American Airlines Non Veg Aisle 1037 Fink Rd Lewiston ID 83501 208-875-7844 874563 American Airlines Non Veg Aisle Weber cliff 1630 Valley Rd Pullman WA 99163 Non Veg Aisle Frazier Nancy 509-332-1243 294736 Continental Sanchez Ramon 1375 Mtn View Dr Moscow ID 83843 208-882-9898 818401 Continental Non Veg Aisle

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Essentials Of Strategic Management

Authors: J. Hunger, Thomas Wheelen

5th Edition

0136006698, 9788120348615

More Books

Students also viewed these General Management questions

Question

=+5. For the cost matrix of Exercise 3,

Answered: 1 week ago

Question

3. What is my goal?

Answered: 1 week ago

Question

2. I try to be as logical as possible

Answered: 1 week ago