Question editing and changing MS's Contacts database

[Burnsie]

Hello.

First post so be nice. Not used Access since A Levels and not used 2007 before.

I am currently editing the “Contact” database that you can open/download from MS when you open up Access.

What I’m wanting to do is create a database with personal details (name, age, sex, job, job location, pay grade etc). This is already done (or takes easy editing) so this bit is sorted.

I also want to put body measurements in the database base (Wight, height. BMI. BP) etc and obviously link them to the personal details (i.e. if record 1 on Personal details table is “joe Blogs” then record 1 in measurement table also needs to measurement of/for Joe Blogs

Finally, i need a date to tie to each battery of measurements (ie so one day we take all measurements and then 4 weeks later we do the same).

Anyone any ideas how to start explaining this to me J

 

[boblarson]

I think it may take quite a bit of explaining to get you to where you need to be. I would suggest a little reading on your part FIRST and then see what you need.

Check out these:

Normalization

Access 2007 Tutorials

 

[HiTechCoach]

What I would do is create set of tables similar to an order ant eh order detail records. See the Northwind Trader example database that comes with Access 2007.

If it we me, I would use the Northwind Trader example as a template, not the contacts. You would have a whole lot less to change/add.

The Orders would translate to the assessment on a date for a person (customer). The order detail would have a record for each measurement taken (item code).