Hire best homework helpers for online homework help 24/7. Are you looking for online homework help? Try our excellent homework help who can help you get A+ grade in your assignment.Order my paper
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.
1135 Cresco Ave
San Luis Obispo
1389 Old York Rd
1580 Lesher St.
110 N. Adle Dr.
491 Popular St.
3735 Fine Canyon Road
491 Popular St.
1697 Elnora Rd.
1040 Whitten St.
883 E. Mount Pleasant Ave.
380 N 48th St.
502 State Hwy 232
S. American St.
131 Kingfield Rd.
1772 Whitney St.
1438 Virginian Rd.
432 Cantril St.
1642 Ludwick St.
1022 Keyser St.
1918 Nicholas St.
690 Mountain Dr.
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
Southwest Airlines Home Gate
The Home of Southwest Airlines on the World Wide Web
February 7, 2008
«Title» «First» «Last»
«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.
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
6. Merge letters for customers who owe more than $500. Save as More Than $500
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.Read more
Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.Read more
Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.Read more
Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.Read more
By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.Read more