One additional comment on this process.  I still find the query tools in EM awkward and wanted to make sure people know that you can follow the same process in this article, but using an Access Project to create views, procs and functions in SQL Server.  The interface is almost identical to the options in Access databases and has some features missing or awkward to use in EM.  Just a thought.