ONLINE MS ACCESS DATABASE - PERSONAL GYM TRAINER

You need a users table (this will contain your login and identification info)
It should have a Unique ID  (After someone logs in it will be easier to keep track of a single value such as an autonumber rather than carring their Username)

This table could also store the goal deails

The workout plan will probably consist of multiple items (excercises) for each person
Any time you identify a 1 to many relationship in information...  it usually means another table

It would have a field to store the User ID and is how you will link the data back to the user
Determine what information makes up a "Plan Item"   Excercise, repititions, weight, ...   Everything possible that relates to the one excersize
Now you may find some items that need to track X or Y and others use A or B.  Keep seperate fields for each (or use a memo field... but keep the use of memo's to a minimum

IE:   Weight Machines need a weight field and a cross trainer does not but requires Time, which Weight machines do not as they will use Reps and intervals...

Make a list of each item you expect as an item and make another table....  and Excercise table that will be used to "Pick" each excercise from so they don't have to be entered in for each user

Again they will have a unique ID (autonumber) and possibly a grouping (weight, cardio...)


So so far we have User...  Excercise, and User Excercise Plan (for the user)

Then you need to track the daily workout for the user
The user Selects the excercise from his plan and makes an entry on the daily workout record
  1 record for each excercise for each day

Running out of time... but this should get you a start

Rich

Sorry..  Misread your message...  I thought you were looking for directions on how to design it..

Rich

Thanks Rich...I cant seem to edit the question again... my mistake.
I need either advice on how to design/build it  and if someone out there is willing to take this up with agreed terms..
Thanks for your advice Rich. Much appreciated


Regards
Raj

Hi Raj,

> I need either advice on how to design/build it  and if someone out there is willing to take this up with agreed terms..

By the Member Agreement, we cannot use EE as a place to ask for bids :)

However, many participants here do accept project work.  Those who do will indicate how to contact them in their
profiles (the pages you see when you click on our hyperlinked screen names).

Regards,

Patrick

Raj,

>  i have no clue on what tables i need and how the relationship would work

It all depends on what you need to track.

Ultimately, what are you doing?  Is this meant to run a business (and thus will have to calculate costs, rates, billing, etc.),
or purely to track individual exercise plans?

Are you tracking plans for individuals?  Workout sessions?  Exercises done within sessions?  Depending on the answers
to these and other questions, we can help you get started.

One of the things I ask people to do at the outset is to mock-up the kind of reports they would ultimately want to see.

Regards,

Patrick

Im so confused.

Ok... this is what im sure of... I need a online personal trainer built using ms access. Either advice on how to do this or some one willing to take it up as a project which stated by you Patric can be done on profile pages.

Im stuck on what to do extactly. I have no experience in programming and my accesss knowledge is one of a student.

Bascially i want a User to be able to log into this website and be given a pre set work out (body-building, Toning, and Weight loss/cardio) depending on what the user has stated as their main goal when registaring their details.

Also there should be a section in which a user can search for various work out .. very  similar to this website
http://www.personaltrainingprograms.com/exercises/search-ex_eng.asp

I first need help to produce this in MS Access, Thanks Rich for your advice but im finding it hard to uinderstand how to do this... i may need baby terms or steps in which to help identify which tables are needed and how these would be linked.

Of Even producing something ver similar to the website (http://www.personaltrainingprograms.com/exercises/search-ex_eng.asp) would be parfect but again only in MS Access.

Thanks for being patient and understanding when reading my posts. Hope this is more clearer

Regards
Raj