Create a tool in Access that will act as a inventory manager

There's two levels to this project, that will be broken down into two requirements the basic and advanced

Basic: This will need to be an tool in Access that will use a Model number to find parts related to the model, the location of these part(s), and quantity of parts in that location. Then I want it to print a form which lists the Model that was selected, and the part(s) that were selected and the quantity needed (supplies by the user), and the location they are going to get it from.

Advanced: The advances options expands upon the basic. I will need the it to accept a quantity of parts that will be "Picked" and then remove it from the location after the form is printed.