How can I create views on my database?

I have imported tables, but I want some forms to access views instead of the tables directly, preferably via stored procedures. Is this possible?

Also need to know how to create a picklist where the description is displayed to the user, but the ID field is returned to the underlying record.