The director of sales and marketing at the travel agency would like to increase the efficiency of handling customers who have frequent-flier accounts. Often, frequent fliers have regular travel routes and a preferred seating area or meal category. In previous years, the data have been manually entered into a three-ring binder. In order to handle the frequent fliersâ€™ requests more efficiently, your director has asked you to build an Access database containing the travelerâ€™s name (first and last name), address, phone number, frequent-flier number, frequent-flier airline, meal category, and preferred 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 â€œExternal Dataâ€ tab. Hint: Use tab delimiters when importing the data; note that the first row contains field names.
After importing the data, create a report displaying the names and addresses of all frequent fliers by doing the following:
â– 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.â€