DATABASE EXPERT

The director of sales and marketing of the travel agency would like to increase the efficiency of handling those who have frequent-flier accounts.  Often, frequent fliers have regular travel routes, preferred seating area, or meal category.  In the previous years, the data has been manually entered in 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 following information:

• Name (first and last name)

• Address

• Phone number

• Frequent-flier number

• Frequent-flier airline

• Meal category

• Preferred seating area

To do this, you will need to do the following:

• Create an empty database named "Your_Lastname_Week 2_frequent flier."
• Import the data contained in the file FrequentFliers.txt.

• Use "Week 2 Application Text File" Found under Week 2 Required Assignments.
• 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:

1.      Select "ReportWizard" under "Report" in the "Create" tab.

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

3.      Save the report as "Your_lastname _frequent fliers."