COMPUTER APPLICATIONS INTEGRATION (MICROSOFT WORD AND DATABASE)

COMPUTER APPLICATIONS

INTEGRATION (MICROSOFT WORD AND DATABASE)

1. You are employed at Southwest Airlines. Enter the following customers’ records in a database. Save the main database as SOUTHWEST and the customers’ records as AIRLINES.

2. Create the following queries:

· Name and address of customers living in Colorado. Save as Colorado Customers.

· Name and address of customers living in Los Angeles. Save as Los Angeles Customers.

· Name and address of customers who owe less than $100. Save as Less than $100.

· Name and address of customers who owe more than $100 but less than $500. Save as Between $100 and $500.

· Name and address of customers who owe $500 or more. Save as $500 or more.

3. Using the information from the database file Airlines, create and merge the letter

below.

Southwest Airlines Home Gate

The Home of Southwest Airlines on the World Wide Web

http://www.Southwest.com

February 7, 2008

«Title» «First» «Last»

«Address»

«City», «State» «Zip»

Dear «Title» «Last»:

This is just a brief reminder, «Title» «Last», that your account is now past due. As you can see from the enclosed statement, you still have an outstanding balance of «Amount». This balance was due as of «Date».

We need your cooperation so that we can continue to give you the service we have provided you for many years.

Please mail or use our web site to make remittance for «Amount» today, so we are not forced to send your account to our collection agency.

Cordially,

Brenda Pitt

Collection Manager

BP/yrs

Enclosure

________________________________________________________________________________

4. Merge letters for customers living in Colorado. Save as Colorado Letters.

5. Merge letters for customers who owe less than $100. Save as Less Than $100

Letters.

6. Merge letters for customers who owe more than $500. Save as More Than $500

Letters.