How to set look up like field(as in access)

[chintan solanki]

hi guys
im just new to sql
i just want to know how do i set the look up like field in mysql?
and also how do i use stored procedures and triggers(if mysql supports)?
and where to create the forms and reports?
and i would like to save queries also, how to do that?
Thanks for reading
Hopes this will contribute all the question to migrate to mysql from msaccess.