I'm attempting to creating a simplified Engineering Change Database. Right now I have an excel form that is filled out directly.



I would like to find out if I can use a system (Web Based / Microsoft Access Based / etc.) to ask appropriate questions, via a drop down menu or similar (name of program / date of change, etc), that would enter the selection into the appropriate cell on a microsoft Excel document.

Even further, if it could then save the document in a certain location (manual or automatic) under a certain automatically generated number, like a digital camera numbers picture files on a memory card.

Is any or all of this possible?