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

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
all parts of that color and so on....

Maybe AutoFilter meets the need.

With the above data, select columnms A:D and use
Data Filter AutoFilter
Pull-down lists appear in row 1. Using the first pull-down to select a Part id causes only rows with that id to remain showing. Likewise for the other columns. To undo filtering on a column, use the pull-down and choose "All."

For details, look up AutoFilter in Excel's built-in Help.