Hi

I want to create an Access 2007 database for my university.

By the end of it I want to have a form with drop down menu’s that will display information based on the selection’s I make.

Here is how I think it should look
Level- UG ( select one)
PG

Country- List of Countries ( Select one)

Course- List of Courses ( Select one)

Search

And the information brought up based on what I have selected should include;

The entry requirements for an applicant applying for that course from that country.
Scholarships available to them
Then English requirement is required of them.

Please can you explain this in Dummies guide format for me, What or how many tables etc and relationships please are required.

Thanks

Ross