Results 1 to 4 of 4
  1. #1
    rockym567 is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    May 2016
    Location
    New Jersey
    Posts
    2

    Converting an Excel Solution to Access

    Hi all:
    I'm new to Access and DB design, but have enough of a background to get myself into trouble. Here comes my question.
    Background: I created an Excel solution for a fishing tournament. It works good, but I would like to try to learn Access and thought converting my Excel solution would be a good project to start off with.

    Here's the scenario.
    I have teams of up to 6 people fishing on the team, one of which needs to be marked as a captain. (the captain will have additional contact information, such as email and phone number)
    I also have individuals who fish but who are not on a team. (all individuals will also have contact information such as email and a telephone number)
    I need to tell the difference between teams and individuals.
    Then i need to record different species of fish that are caught, how long they are, the type, and the girth of their belly. for example john doe caught 3 fish--> fish 1 bluefish at 15" 10" girth, fish 2 is a striped bass 30" 14" girth, fish 3 is a sun dial 10" 0" girth......

    I know that fishermen are linked to teams. I know that they also need to be linked to the fish that they caught. How do I do this?
    Do I need a fisherman table, a team table. and a fish caught table? Do i need a captain's table and an individual table.

    Also I think i can handle the fields, for example male female child etc. I just need help with the relationship.

    Thanks for looking,


    Rocky

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    i see a tPerson table
    ----------
    personID (aut0num)
    FirstName
    LastName
    addr
    city
    st
    zip
    email
    phone

    tTeams
    --------
    TeamName
    personID (long)
    IsCapt (y/n)
    those fishing and NOT on a team would be on the team NO TEAM (or Teamname=null )

    tCaught
    -----------
    personID
    dateCaught
    FishType
    Len
    Wt

  3. #3
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    all tPersons.PersonID join on tTeams.PersonID
    all tCaught.PersonID join on tTeams.PersonID
    which can rollup into teamName

  4. #4
    rockym567 is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    May 2016
    Location
    New Jersey
    Posts
    2
    Thanks for the replies. Good Stuff! I'm working on the table design now. I'm also viewing some of the tutorials that are given in other posts.
    Rocky

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

Similar Threads

  1. Converting Excel to Access
    By Puggwash in forum Access
    Replies: 2
    Last Post: 04-06-2015, 03:37 PM
  2. Replies: 1
    Last Post: 06-20-2014, 11:43 AM
  3. help in converting excel to access
    By Daniel2000 in forum Access
    Replies: 11
    Last Post: 04-25-2013, 01:43 AM
  4. Converting Excel IF to Access iiF???
    By robertr in forum Queries
    Replies: 5
    Last Post: 10-14-2011, 05:53 AM
  5. Converting to access from Excel
    By Alexpi in forum Database Design
    Replies: 3
    Last Post: 05-24-2011, 02:46 PM

Tags for this Thread

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