requesting help for database design

[Kaytremain]

I'm new to access and want to design a database that records the results of a particular lab for multiple people. Each person has this lab drawn multiple times and at different time points. The information I would need to record for each person would be the date the lab is drawn and the lab value. I already have one table detailing the demographics of the people and want to make a table for the lab values. I would greatly appreciate any advice on designing a suitable table for this. Thanks in advance.

[hertfordkc]

a few questions that may advance your task.
You should keep the basic individual information in one table. Other information which is being collected for a number of individuals should be broken down into separate tables for different classes of information. Look for links on normalization, but don't obsess on the explanations. It is really important in huge databases and where the database is likely to be expanded, but developing the normalization is not the Holy Grail.
You will need to define the relationship between the personal information table and the other tables. Once you have taken care of these steps, defining querys, forms and reports will follow naturally.
Use the wizards to develop your queries, forms and reports, and take a moment to look at the results and object properties because you will probably will want to develop your forms and reports so that you don't have the wizards doing things that you don't want.

[June7]

Review the 'sticky' thread tutorial on database principles at http://forums.aspfree.com/microsoft-access-help-18/