Add Save As... back to the Query context menu
In earlier version of Access, when you modified a query the context menu had the choices of “Save”, “Save As…” and “Close” in the context menu. Since the ribbon was introduced, the context menu only provides “Save” and “Close”, if you’ve made a change in the query and don’t want to over write the existing one, you have to go to the File | Save Object As route to get to the “Save As..” dialog box.
There is no need, u can do it by yur own. With this tool http://abiss.de/content/produkte/microsoftcaccess/accesscshortcutcmenuccreator/accesscshortcutcmenuccreator_100144_105367.html it is very easy.
David Peel commented
You can usually access SaveAs by pressing F12 - works in most Office applications.
I add SaveAs to the QAT ... do not like how SaveAs is currently implemented as a backstage command since once we click it, we can no longer see what we are working on which makes coming up with a good name harder.