I have recently learned to used Microsoft Access and although I have used the learning tools on the net provided by microsoft I'm still a little lost with some things.

I'm trying to develop a training/qualifications database where I would like to search for people with a particular qualification specifiying the qulaification and inversly searching for employee's details and individual qualifications specifiying their name.

Is it possible to be able to produce drop down menus on request, where the values in the drop down menu are transferred to the desired locations (ex queries and forms).

Also is it possible to open querries/forms that require specification (for example like a wild card for the criteria in queries), where the speicifcations relate directly to a linked form without requiring repeated typing?