MIS: Management Information System Lab Question

1. Prepare a MS Access file using the data specified in the adjacent tables (3). 2. Define data quality and characteristics. Change the data type and edit the field type, if and whenever needed. 3. Create a 'Query'extracting the following information: CustomerlD, FirstName, LastName, SupplierName, TotalAmount, Due Amount, PaymentType. 4. Calculate the late fee at 10% interest rate for each Due Amount, and calculate the total amount of LateFee and Due Amount and TotalPayment. 5. Create a 'Customer Information Form'. Design the form whereever needed. 6. Enter a new input (i.e., "Your Full NAME" and "Your Varsity ID") by using Customer Information Form' and update the Customer table. 7. Create a report using query table. 1. Prepare a MS Access file using the data specified in the adjacent tables (3). 2. Define data quality and characteristics. Change the data type and edit the field type, if and whenever needed. 3. Create a 'Query'extracting the following information: CustomerlD, FirstName, LastName, SupplierName, TotalAmount, Due Amount, PaymentType. 4. Calculate the late fee at 10% interest rate for each Due Amount, and calculate the total amount of LateFee and Due Amount and TotalPayment. 5. Create a 'Customer Information Form'. Design the form whereever needed. 6. Enter a new input (i.e., "Your Full NAME" and "Your Varsity ID") by using Customer Information Form' and update the Customer table. 7. Create a report using query table