I'd like to create an access database for a vaccine clinic I am managing in a large slum here in South Asia.
So basically I want to create a form that auto-populates. Say a baby comes in: I open a new form, assign a unique id (probably the vaccination card number), enter the child's name, bio data and vaccine received today (say dose 1 of diptheria). The form then automatically stores all the information in a table. Next time the child comes in I simply search by the id and the form opens up autopopulated (with the data that was filled in at the dipth 1 visit). I just verbally confirm the name/address with the mother and then fill in/select that on this date now dose of 2 of diptheria is registered. The form automatically updates the table etc. etc.
At the end of the month I want to do some basic data analysis on the table. I want to see for example, what the average deviation in age is for each vaccine. Dose 1 of dip is supposed to be given at e.g. 2 months of age but if the average age that the child comes in for it is 3 months then I'm concerned.
I can manage the data analysis part by setting up queries (I'm pretty new to access, I only know how to create simple queries and stuff) but I have absolutely no idea how to create such a form - i.e. one that autopopulates a table, is blank when needed (i.e. for a new child) and in searching for an id will autopopulate if the child is on a followup visit..