Learn to backup and restore your databases in Microsoft Access

Other than using the basic tools and apps such as Word, Excel, and PowerPoint, many Office users need to deal with other apps as well. One such application is Microsoft Access that lets a user create huge databases for storing and managing a large amount of information. It does not simply allow you to have your essential data stored in one place but also lets you use graphics in it.

This is what makes it different from Excel. There are several advanced software-development tools that are specifically designed for professional use. The information you store over it is later on used for the purpose of referential, reporting as well as making analysis or a project.

Why should you back up your Access data?

In case a user wants to restore his entire database because he has undergone a system failure lately, then having a backup copy of your databases will do wonders for you. Sometimes, the ‘Undo’ command isn’t enough to restore all the data you have lost. At that time, data backup came into the picture.

In case, you feel that creating a backup is not necessary and will eat up your storage space as well as time, then you are completely wrong. Until you undergo the data loss, you will not realize the importance of creating a data backup.

Read Also >> Restrict users from editing Word document or Excel sheet

Therefore, it is advisable to regularly back up your data including designs, etc. This will help you restore corrupted and lost files.

Steps to back up Access database

  1. First of all, you need to open the database of which you wish to create a backup.
  2. From the taskbar of that database, click on the option reading as ‘File’.
  3. After this, you need to tap on the ‘Save As’ option.
  4. Now, choose the option ‘Save Database As’ present under ‘File Types’.
  5. In the next step, you need to click on the ‘Back Up Database’. This option is present under ‘Advanced’.
  6. Now, click on the ‘Save As’, and a dialog box will open.
  7. In this box, review or edit the name of the database backup. You will also see the date when the backup is created.
  8. Now, from the Save as type list, you need to choose the desired file.

Finally, you can click on the ‘Save’ option when you are done with the process.

Steps to restore missing objects in a database

  1. In the first step, you need to open the database on which you want to restore an object of your choice.
  2. To restore missing objects, click on the ‘External Data’ option.
  3. Now, click ‘Access’ after navigating to the ‘Import & Link’ group.
  4. In the dialog box that opens, click on the ‘Browse’ option.
  5. After locating the desired database, click ‘Open’.
  6. Here, in this step, choose the option that reads as “Import tables, queries, forms, reports, macros, and modules into the current database”.
  7. Further, tap ‘OK’ and then select the object that you want to restore.

That is how you can restore an object after following some easy prompts to import the objects. You can do it for other objects as well.


uscomoffice.com is an independent and on-demand Microsoft Office related service provider. We disclaim any association with Microsoft or its subsidiaries. The brand names, facts, logos, and images of Microsoft used here are just for referential purposes and these belong to its propriety i.e. Microsoft. Do not take us to be Microsoft because we in no way are related to it. Go through our terms and conditions and privacy policy before taking any action on this website. In case, you come across third-party links or references, make sure to go through their policies separately.