Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2006

    Unanswered: Need Help Designing MS Access DB


    I have some experince with MS Access, and with most things computer, however I have need of a DB that is beyond my cursory skills. I am trying to design a DB to be used as a Weight Training/Fitness Log.

    I have an understanding of VB, but not a working skill set. Similarly, I understand MS Access and can create simple databases with a few tables and forms, but I do not have any of the more in-depth skills required to create a very complex database.

    I am using Windows XP, and Microsoft Access 2000.

    I know what each record needs to store, but I am not sure how to make it happen. Each record will be unique by date and most of the fields are easy enough. However, in addition to adding fields such as "Goals (memo)", "Cardio (list)" "Cardio Time (number)" "Cardio Distance (number), etc.

    The problem is that I also need to be able to add an infinite number of unique exercises to each day's record and each exercise must be stored with its weight, sets, and reps. This creates an infinite number of possible records and obviously I can't create a table with each possible exercise with each possible combination of weights, sets, and reps.

    A sample data set would be as follows:

    Date: Sunday, June 11, 2006 (date)
    Goals: Increase Dumbell Flys (memo/text)
    Notes: Will try 1 RM Wednesday (memo/text)
    Streches: Skipped streching today (memo/text)
    Cardio: Walking
    Cardio Time: 10 (number)
    Cardio Distance: 1 (number)
    Exercise_0: Sample_0, 4, 5, 6
    Exercise_1: Sample_1, 7, 8, 9
    Exercise_2: Sample_2, 4, 5, 6
    Exercise_3: Sample_3, 10, 12, 14
    . . .
    . . .
    . . .

    Date: Monday, June 12, 2006 (date)
    Goals: Increase Crunch (memo/text)
    Notes: I love working out (memo/text)
    Streches: I'm too fat to stretch (memo/text)
    Cardio: Cycling
    Cardio Time: 15 (number)
    Cardio Distance: 2 (number)
    Exercise_0: Sample_0, 34, 5, 6
    Exercise_1: Sample_1, 7, 7, 7
    Exercise_2: Sample_2, 0, 9, 9
    Exercise_3: Sample_3, 10, 12, 14
    . . .
    . . .
    . . .

    If there is any more information I could provide that will make this more clear please let me know. I greatly appreciate any help you can provide.

  2. #2
    Join Date
    Feb 2004
    New Zealand
    Provided Answers: 8
    1st Tip Try not to use MEMO feild text feild 255 Should be heaps I have lost 2 database haveing heap of memo ffeilds in then

    Looks like a
    Table of Users
    Table of Goals
    Table of Exercise

    And a Table to join then
    hope this help

    See clear as mud

    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008

  3. #3
    Join Date
    Jun 2006
    Yes, I can certainly fit the contents of those fields into a 255 character text field.

    As for the table of users, actually there will only be one "user" as the db is not for multiple users...just me

    The won't really require a table because that field is really just so I can browse back through and see what daily goals I've been setting and to provide impetus to meet those goals daily. The data in the "goals" field will be random and not constricted.

    I think I will need a table for Workouts (the main table) and a table for exercises, but I don't exactly know how to handle the unique aspects of adding an unspecified number of exercies to the workout table for each day...or if this is even what will need to happen.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts