Results 1 to 3 of 3
  1. #1
    noobie4access is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Oct 2015
    Posts
    1

    Need Help (access homework)

    Okay so I imported an excel database into my access database.

    I need to separate the customers from the supervisors into 2 separate tables.

    How do I do that properly?



    Afterward, I need to remove redundant information and establish relationships between the supervisors and each of their customers. I would appreciate some guidance on that too please.

    Thank you!

    This is more my access class. The teacher is giving me really vague instructions.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,646
    How do you know which are customers and which are supervisors? Is there a field that identifies them?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,850

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

Similar Threads

  1. Help with homework
    By wilsontng in forum Queries
    Replies: 9
    Last Post: 06-21-2015, 10:51 AM
  2. Looking for Homework help!!
    By clueLESS85 in forum General Chat
    Replies: 3
    Last Post: 06-02-2015, 08:04 PM
  3. help ! homework
    By primobolan in forum Queries
    Replies: 2
    Last Post: 11-06-2013, 02:43 PM
  4. desperate for homework help in access
    By catzjenn in forum Access
    Replies: 8
    Last Post: 04-23-2013, 11:51 AM
  5. Help me with microsoft access homework!
    By claudia_lovez_u in forum Access
    Replies: 1
    Last Post: 06-30-2012, 05:46 AM

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