Making a Access Workout Journal?

[SaKa]

hey all.
I used to know how to use access, and now haven't used it for years and I am having trouble getting started.
I wanted to make a journal that I could enter in data of an exercise routine.

But the thing is I have no idea how to get started.

I want to be able to add in a workout data for each day monday - friday (each a different body part).
do I make several tables? or just one?

Here is an example of all the data I want to put in, got a picture here

I find the excel version is messy and a form would be an easier way to save the data and easier to refer back to. If anyone has any idea's on how to do this thanks!

Saka

 

[llkhoutx]

You need to look at cross tab (queries and/or tables) and sub cross tabs. Excel has them directly, Access only indirectly.

 

[JoeCruse]

Look in the Sample section of these Forums. I put one together and posted it earlier this year. Another poster also put theirs in that post, so you can get a couple of ideas. Look for the last one or two examples posted; one is in Access97 and the other in Access 2000. This will at least give you some ideas, and it can handle both weights and cardio workouts.