An MS Access Patient Database was created, however I need to add some tables and make changes to it:
1. I need a way to easily enter multiple number values for certain parameters in the database so that later the data I entered can be automatically analyzed to calculate ranges and averages. (Ex: I have a patient with 5 values for LDL cholesterol measurement. I need an easy way to enter and store all these values for later analysis).
2. Add 3 tables to the DB that will be linked to each individual patient.
3. Change the format of all table fields so that I can enter letters or numbers into each field.
4. Minor changes to 2 of the already existing Tables