Access database application case. Please explain clearly and i will upvote. Thank you!

Application Cases in MIS CASE 3: Lake Country Music Supply Lake Country Music Supply sells musical provides tune-up and repair services. Frank Barnes, owner of Lake Country believes that tune-up and repair services are a key selling point. He cannot ma prices offered by internet and mail-order suppliers, but he has been customer base by being a full service supplier. To drive home the buying lawn equipment from them, Metropolitan with each new instrument they sell. instruments to retail customers and Music Supply strong the advantages offered by offers a year of free service and repair Currently, information about the instruments that have been sold is maintained would allow manually. However, Frank would like to have a computer application that him to retrieve key information about each instrument Metropolitan has sold, and he has asked you to develop it for him. Frank would like to have an application that would allow him to do three key things: Look up information about any instrument when a customer brings it in. The information provided should include the purchase date and the date of the last servicing performed on the instrument. This would allow Frank to quicky determine if 1. ine if an instrument is under the one-year service and repair agreement eve a list of names and addresses of customers whose year of free servicing expires soon (within three months) who have not yet had their instrument serviced. Bob feels that sending a reminder to these customers will help to build goodwill and may also get them in the habit of using his service department 2. Retri Retrieve a list of names and phone numbers of customers whose last instrument servicing was more than ten months ago. This list would be retrieved when business was slow in the service department. The customers identified would be called and offered a discount if they brought their instrument in for service within a two week period. Bob feels that this would help to eliminate slack periods m service department, and would also improve goodwill with customers 4. While a substantial amount of information could be collected about eaclh instrument sold, Frank wants to keep the data collection as simple as possi ble. Data are