Microsoft Excel - How do I create a Database in Excel 2010 -

Asked By Max Hubble on 13-Nov-12 05:59 AM
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
Harry Boughen replied to Max Hubble on 13-Nov-12 06:06 PM
Hello Max,

This sounds like a more than trivial task in Excel.  If you are familiar with databases why don't you consider using MySQL which is an open source relational database and is freely downloadable.  There is a package called XAMPP that includes all of the necessary software and prerequisites and there is very good documentation and discussion sites out there as well.

Regards

Harry
Harry Boughen replied to Max Hubble on 13-Nov-12 06:37 PM
Hello Max,

This sounds like a more than trivial task in Excel.  If you are familiar with databases why don't you consider using MySQL which is an open source relational database and is freely downloadable.  There is a package called XAMPP that includes all of the necessary software and prerequisites and there is very good documentation and discussion sites out there as well.

This is a brief set of instructions to get you going.

manual.zip

Regards

Harry
John D replied to Max Hubble on 13-Nov-12 07:23 PM
Hi
From your request, Ms Access would be your needs but for a Daycare Unit, possebly it can be done in Excel.
Ms Word is the software for mailing but you can do a mail merge Excel to Word.
This is a link to a form with some of the information you asked.
http://cjoint.com/?3Koba1knSwz
Maybe you can use it and build from that.
You can ask for help here and someone surely reply

John D replied to Max Hubble on 13-Nov-12 10:53 PM
Hi
Use this one : http://cjoint.com/?3KoeXAxQYL8