VIN, price, and mileage

Now that you have completed the first part of the Car loan calculator, the next step is to ensure that any new data added to AutoNexa's system is valid. You will apply Data Validation rules one by one to maintain accuracy and consistency.

Validation rules to implement:

• VIN Validation: The VIN (Vehicle Identification Number) must be exactly 17 characters long – no more, no less. This ensures that only properly formatted VINs are entered into the Cars Database.

• Price ($) Validation: The Price column should only accept numeric values. No text or special characters should be allowed.

• Mileage Validation: The Mileage column should also only accept numeric values. This ensures accurate mileage tracking for each vehicle.

Start by using the Excel file from the last exercise, if you lost it use this file 2_3_vin_price_mileage.xlsx