I am looking to create a Access CRM type of database. This is for personal projects so it may be like one could be Garden and there I can log each time I work on it and if I communicate to one of the contractors. I can then keep track of where each one if up to and what was done last. this would be I guess like a CRM database where you can log each time you communicate with a customer so you can see whet interactions was done and dates in order extra, plus get all their details etc.
I am thinking that I will need a Table for External Stakeholders ( Contractors ) and this would hold each of their details. But what else would I need a table for each of the projects and what else? and how could I have a form for each time I work on a project I can open a form and put which project I am wanting to upload a note too and then upload the note itself?
Thanks in advance for any help.
T
Bookmarks