First of all you should be working with an ADP (Addess Data Project), and not an ACCDB or MDB file. Second, you should know that effective with Access 2013, the ADP format is no longer supported, so you are headed down a dead-end.
Given that caution, you simply choose the Create ribbon, and choose the Query Wizard button, and then choose either Design Stored Procedure for simple sprocs, or Create Text Stored Procedure, where you write the T-SQL a line at a time. (Note that you can also create several other SQL Server object types in the New Query dialog.)
On the other hand, should you decide that's not a good choice, using the .MDB format or .ACCDB format, you can link to a view, and have it be treated like a table within Access, and you can also use pass-through queries to execute sprocs which return records. Both of those subjects require more explanation than can reasonably fit in a formum post however.
You can't see the view if you don't climb the mountain!