i want to design a database for work that has part number and other specification and somehow i can access the information quickly by having another menu that search and brings my what im looking for for example

Part Color Material Size
lg45 blue nylon 5
lg46 green copper 6
lg57 blue zinc 3

i need to know how to make another menu where i can type the part number get the all the info on it or say type color and get a list of all parts of that color and so on....