Create an part order form in Access

[JesterGrafix]

Good morning. I have been searching around the internet trying to figure this out. I am new to Access so it's all kind of confusing to me so far. Basically what I need is to create a form in Access that people can fill out that will list items that they need. I have a complete list of the available parts that I currently have on hand. This list includes:
Part Number
Description


Manufacture
Manufacture Item Number
They will also need to be able to add this information for items that are not currently on my current list. My initial thought would be that the person could do a search for the item, for instance using the Manufacture Item Number or a key word in the part description, for example "bearing". When the part is found maybe they click a button that adds it to the list of needed items. They will manually add some information to the order, for instance their name and where the item will be used (a machine number). If anyone could point me in the right direction this would be a huge help to me! I work in a parts crib in a factory and the current system for someone to request items to be ordered is clunky at best using a very outdated Excel sheet. This project could also be done in Excel, I only wanted Access because I have seen some very nice forms made in it that look and seem very functional. Thanks for taking the time to read this!!!

[Micron]

You might find a data model here that will work for you (no sense recreating the wheel, I always say). Use your browser search function to find the ones that deal with parts. If none of them help, post back for more help. At the very least, they should provide some food for thought, and thus meaningful questions. One thing you have to realize is that spreadsheet type design does not a good table make. So if you have Excel brain, you will have to be re-programmed!

IMHO, forms come after proper table and query design as I seldom base forms on tables alone. So if data can't be added through a normal query, it is often a sign of table design problems, meaning the form already created is possibly useless. Certainly, there are things you could do wrong at the start, thereby making progress more difficult than it needs to be - things like multi value fields, lookup fields (in tables), poor naming convention, etc.