I will do this project using Excel and VBA programming. First, I will design a Product Database which will contain the data of the different products. This database allows us to add, edit and delete a product, and even to search for a product.
Next, a form will be made based on your specification. In this form, the user will have the option to enter the Product Number manually, or select the Product Number from a pull-down menu. Once the Product Number is entered, the form will be populated with pertinent data. This will be a very user-friendly form.
In summary, this project will have the following menu:
1. Form Processing
2. Database Management, which allows the user to add, edit, delete and search a product.