Hello folks,
I'm fairly new to MS Access.
I have recently accepted a job which requires me to build a Vendor Records Management System for my boss.
Any sort of help or an outline of how I should go about this would be massively appreciated.
This project would involve building a common system of record for all the vendor files, and then adding a GUI in Java or something similar that interacts with the record system.
My boss' idea for the GUI is that he would want to follow the OCC’s Vendor Management LifeCycle:
Clicking on each phase of the lifecycle will take you to a portal that displays relevant information for that phase of vendor management. And clicking the RED hotspot at the top will generate a list of current hot topics around our vendor management program – such as a list of new vendors that are onboarding, existing vendors that are terminating, vendors that are undergoing annual reviews, etc.
The database would need to store vendor contracts, templates that we use, contract amendments, etc.
He would also like to have an ‘events’ log that keeps track of dates that we enter and triggers alerts when something is due – such as a contract us up for renewal, an MSA is about to expire, etc.
I'm in a bit of a pickle here and rather lost. I would massively appreciate any sort of guidance or help on this project.
Thank you so much.