I currently am working for a Childcare Nursery - they don't have a database for mailing purposes or children within the unit. I would like to be able to put together a basic database to include Surname, First Name, DOB, Age (with formula to calculate actual age from DOB), Unit (i.e. Baby, Pre'school, Toddler etc), Hour Rate, Address 1, 2, 3, Town, County, Postcode, Home Tel, Mobile, Email. I would like to be able to fill in a front end form that would automatically update the database but also on the that form be able to select from a drop down list to ensure erros do not occur and the database text is consistent, I would also like to be able to create queries on say, "hour rates", which unit contains which child etc.
I have searched and searched the internet and have not been able to find anything. I would dearly like to get something up and runnng for them as they are struggling at the moment. I used to work on Access but this is something they do not have and will not be purchasing in the short term.
Any assistance with how to create this database would be fantastic and very much appreciated.
Thank you and look forward to someone who is a lot better qualified that I to point me in the correct direction.
From an Excel Database challenged PA