How to build a Workout Tracking form

  • Thread starter Thread starter Bryan
  • Start date Start date
B

Bryan

I've been trying to build a db which models tracking of my workout.
Give the basics of sets, reps, weight, intensity, etc I'd like to have
something to enter data into that looks like this.

Date/Time
Person ID
Exericse name 1 RepCnt Weight Intensity ...
Set #1
Set #2
Set #3
... how many needed

Exercise name 2
Set #1
etc.

I'd like to be able to fill in like a spreadsheet the reps, weight,
etc. for the number of sets performed for each exercise performed.

I'm sure this isnn't enough info, but I'm somewhat lost. I could do
this easily in Advanced Revelation, but it's just too darn old so I'm
ttrying to learn Access. Help please. Point me somewhere something
like this has been done so I can study.
 
Bryan,

Sounds like you need three tables:

1. Sessions
2. Exercises
3. Sets

Then you could do a form with a subform and a sub-subform. Your main
form includes the Person, date, etc.

The subform is a continuous form where you put in the exercises. Those
would be picked off a combo box, I'd imagine.

That too has a subform, in datasheet view, with the number of sets per
exrcise.

grep
 
Back
Top