Reference no: EM13318000

Investment and Savings Company presently employs you as a customer service specialist. The bank has begun a new marketing campaign aimed at drawing new customers to the bank. As a customer service representative, you have been asked to attend a local teachers union meeting and set up a booth for potential customers to ask questions. You are dedicated in building long-term relationships with your clients, and you want to be able to show the advantages of opening an account with your bank. One of the promotions is the ability to attain a short-term personal loan. You process short-term personal loans. Customers are rated as having a status of Excellent, Good, Fair, or Poor. These loans are limited to a term of one year or less. Respond fully to the following questions regarding this task:

A - (TCO 2) You have set up an Excel worksheet to determine the loan payment. It is set up so that you enter the customer's credit status, and it finds and returns the correct interest rate. Then, you enter the interest rate and other required information to get the actual payment. Describe the Excel tools used for these tasks, and the information required to obtain the payment.

B - (TCO 10) You know that your list of information on the loans will quickly become very long and that much of the data on the customers will be repeated for multiple loans. Customers will often pay off one loan, and quickly request another. You want to be able to pull up an individual record by customer name, and see the final payment date for the current loan. A friend has suggested that you build your list in Access. What would be the benefit of doing this, particularly in the banking environment? Would this meet your needs?

C - (TCO 10) You want to use the Access form wizard to create an input form for your list. Describe the process of creating the form, and the special tools you might use to make it easier to use and less prone to errors.

D - (TCO 10) You have decided that you would like to be able to pull a list of all loans past and present for any particular customer. Explain how you would obtain such a list, and then print the information. Be specific!