Purchasing database project
Since we are a British Int'l School, most of our teachers are Brits but our support staff came from many different countries. Our School purchasing dept purchased almost the same kind of stuff from stationaries to cleaning materials. A British teacher will request some kind of a stationary and the same kind of stationary was ordered also by a non British support staff but it was named it differently. Our purchaser who is American always get confused and most of time buy different kind of stationary.
Now our SMT tasked me to create a database for the Purchasing Dept which will solve this problem. It has to contain a photo for each item and the detailed description with all the names it can be called and must be searchable either by description or name. The database will be published on the intranet and it has to contain a search bar, for searching the item. I know only MS Access but it has been a long time since I created a database.
Does anyone has a suggestion on how to tackle this project? Or is there any existing database of the same kind you can recommend?
Thanks in advance.