From the course: Access Essential Training (Office 365/Microsoft)

Unlock this course with a free trial

Join today to access over 24,500 courses taught by industry experts.

Create a database backup

Create a database backup - Microsoft Access Tutorial

From the course: Access Essential Training (Office 365/Microsoft)

Start my 1-month free trial Buy for my team

Create a database backup

“

- [Narrator] Access is one of the only programs in the Office suite that doesn't feature an auto recovery option in the case of a program crash or unexpected shutdown. Because of this, you want to make sure that you're backing up your databases on a regular basis. Luckily, Access makes it really easy to create backups, so there's absolutely no reason not to protect yourself and your data. To create a backup file go to the file tab and come down to Save As. Here we have the option to save the database as and from the selections on the right, I'll choose Backup Database. Press the Save As button, and that brings up your file dialogue. Or you can browse out to your system to the location where you want to store the backup file. Notice that Access automatically appends today's date to the end of the file name, so you can just back it up every day and you'll have this incrementing backup file for every day that you save your file. I'll choose the location and press save, and that's it…

Contents