Job description
I need to create a database that can be accessed from a browser/www, eventually it can be excel. The database must be able to be exported to PDF and printed. The database is to include: product symbol, product name, product type, place where the product is ordered, product measurement unit, quantity field for people who order products, current price, current price date (must be automatically substituted when the price is updated), archival price, current price date automatic, quantity ordered archivally, total archival purchase, space for additional notes. Additionally, the database must have the ability to sort, filter, quick search by keyword, etc. Due to the fact that some of the previously mentioned data are downloaded from another system in text form, it would be nice to optimize it in such a way that I download the data I am interested in, paste them, and they are automatically substituted into the database. Ultimately, the database is to be used for price analysis, updating product prices over time and the easy possibility to update them, add new ones, etc.
