Here is what I am trying to do, but I am not sure whichone to use for the template, excel or access
1- I need to have a template with 8 tabs (or 6 worksheets) that everytime either opens up or clicked an icon as "New template", generates a new ID number on sheet 1 in a spesific cell for each new patient.
2- Some data from all the 6 sheets needs to automatically get exported into a database.
3- From the database, i want to be able to get reports.
This is like a clinic that everytime a new patient comes in, I will use the template to enter patient information. Then, i want to be able to get reportes based on categories of gender, age, height, weights, etc...
Please help
1- I need to have a template with 8 tabs (or 6 worksheets) that everytime either opens up or clicked an icon as "New template", generates a new ID number on sheet 1 in a spesific cell for each new patient.
2- Some data from all the 6 sheets needs to automatically get exported into a database.
3- From the database, i want to be able to get reports.
This is like a clinic that everytime a new patient comes in, I will use the template to enter patient information. Then, i want to be able to get reportes based on categories of gender, age, height, weights, etc...
Please help
