Results 1 to 3 of 3
  1. #1
    anastam is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2016
    Posts
    9

    Unhappy Relational help

    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

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    "Queries Mortimer. Queries."
    a update query will assign text to a field in bulk.

  3. #3
    orange's Avatar
    orange is offline Moderator
    Windows 8 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Please check whether my ERD is relational
    By JackieFeng in forum Access
    Replies: 9
    Last Post: 03-06-2016, 07:17 PM
  2. Relational Tables
    By soprano in forum Access
    Replies: 3
    Last Post: 11-30-2014, 02:18 AM
  3. Relational databases
    By samdahlr in forum Access
    Replies: 5
    Last Post: 07-29-2014, 01:36 PM
  4. Relational Database
    By javier571 in forum Database Design
    Replies: 1
    Last Post: 04-13-2014, 07:05 AM
  5. Double Relational
    By jammmie999 in forum Access
    Replies: 1
    Last Post: 05-19-2011, 01:37 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums