Stored procedure: how to update multiple tables, how to avoid database lock, how to return multline table

do you think from best practice is okay to do the following

1. create SP to update

2. Show result using SP

3. Create SP to include #1 and #2

do you think SP can recalled in MS access 2010?