A local PrimoVision Eyewear store maintains a file named primoappts that contains the customer ID number and date of most recent appointment for each of its customers. The store also maintains a file named primolenses that contains the customer ID number and type of corrective lenses each customer currently uses. The types of corrective lenses includes:

● monofocal lenses

● bifocal lenses

● trifocal lenses

● progressive lenses

● disposable contact lenses

● daily wear contact lenses

● extended wear contact lenses

● bifocal contact lenses

● rigid gas permeable contact lenses

● toric contact lenses The office manager of the PrimoVision Eyewear store needs a file that contains the fields customer ID number, date of most recent visit for each of its customers, and type of corrective lenses the customer currently uses. The manager is also concerned that information on the most recent visit or type of corrective lenses the customer currently uses are missing for some records, and they suspect that these data also include some duplicate records.

a. Append the appropriate value for the field Lens Type in the file primolenses to each record in the file primoappts. Save your results as a file under the name primodata.xlsx.

b. Search the file primodata that you created in part (a) for missing values for the Lens Type field. Provide a list of the names of the customers for whom the value of the field Lens Type is missing.

c. Search the file primodata that you created in part (a) for duplicate records. Provide a list of the customer names for the duplicate records you find.