How to Save on Microsoft Access


Protect changes by saving your Microsoft Access databases and objects frequently. If you have users with earlier versions of Access, you can save the database as an earlier file format. If you recently upgraded Microsoft Access, update your databases to the newest version to take advantage of new tools. Your tables, queries and reports are automatically saved when you close them, but you may need to change the name of an object or save a copy of it. All of these options are located in one convenient place.

  • Click the "File" tab of the ribbon at the top of the page and select "Save & Publish" to open all of the database file format save options. Click on the "Access Database" to save as the current file format, "Access 2002-2003 Database" or "Access 2000 Database" to save as an earlier file format or "Template" to convert the database into a template.

  • Select "Back Up Database" to save a copy of the database. This is an important process to do periodically. It allows you to restore a previous version of the database if a serious mistake is made while editing the database structure. If you use the database frequently, you should perform backups often.

  • Click the "Save" button to save the currently selected object. Alternatively, you can press CTRL+S to save it without leaving the object screen. Select the "Save Object As" button to save the object with a new name while still maintaining the previous version and name.


  • Photo Credit Justin Sullivan/Getty Images News/Getty Images
Promoted By Zergnet


Related Searches

Is DIY in your DNA? Become part of our maker community.
Submit Your Work!