I am creating a database for a dating agency (this is for my GCSEs). There are 3 tables, being Males, Females and Dates which combines the other two together. Each male and female have to enter their Name, Surname, Age, Hair Color and Eye Color. I'm wondering if it's possible to create a query where I, for example for hair color, can enter "blonde" or "brunette" and automatically only the females that are blonde or brunette, whatever I enter, are shown, not the others.
And another question, can I make a query where I can enter age 'from' and 'to' and only the people within that age are shown up?
The ideal would be if it was possible to enter hair color, eye color and age in a single query.
If it helps, I am using Microsoft Excel 2003.
Thanks in advance.