Hello!
I have never used Access until last week when my boss told me that she wanted me to use Access instead of Excel for a database I was working on to archive old projects. I've created a fake database to loosely show what I'm working on. I've got the general jist of Access, but I can't figure out how to create a database where I am able to assign multiple keywords to a project without having to enter in all the other data multiple times.
As you can see on my sample, we want to be able to assign multiple keywords to each project and be able to filter those projects based on keywords. How can you do that in Access without putting in the rest of the information over and over? I was told you have to create a relationship between items, but I can't quite figure that out. We also want to have a separate page for each project to put additional notes. Is there a way to input all the basic data into a table without manually typing everything out?
Any info will help! Or a template to work off of would be helpful as well. I've gone through all the templates available on Microsoft but can't find anything that helps me.
Thanks so much! Sample Project -- created data.zip