Learn how to backup a database. Author Jen McBee will discuss the importance of backing up databases and will demonstrate the steps to take to perform the backup. Creating a backup of a database is a challenge that you will probably encounter on the Wor
- [Instructor] We spend so much time creating our tables, forms, reports and queries that it would be a shame if our data were lost due to a computer or server crash. That's why we use backup, and we use backup often. On the Access 2010 MOS exam you may be asked to create a backup copy of your database. In this video we'll learn just how easy and quick it is to create a backup copy of our work. I had the 02_05 exercise file open, so if you're ready let's do some backing up.
Here's our database, and we're going to go ahead and make a backup copy of it. A lot of companies will do a nightly backup of the information and put it onto some kind of an external drive, so you usually have a way to recapture any work that may be lost if your computer does crash, but it's always nice to personally save a backup copy somewhere other than on your computer so that you have access to it right away without having to wait for your IT department to help you.
Let me show you how easy it is. We'll go to file, save and publish. We're going to save the entire database as and come over on the right-hand side and click backup data base. Once we have it selected we'll click save as. On the MOS exam they will ask you to create a backup, and they'll tell you where to put it. Usually there is a file called backup right in your exam folder, or they may ask you to save it somewhere else on the C drive, but for this exercise we're going to save it right in the backup folder.
Notice how Access automatically put the word backup in the document title as well as the date. Now you can come in and you can change the name. You don't have to keep it the default name. However, on the exam they'll probably ask you to accept all of the defaults and just click save, but you certainly can come in and add any information that you want to to the name. I'm just going to go ahead and click save, and it's done. We have now created a backup copy of our database. Notice that the title has changed.
It's now 02_05 backup, and we are all done. Now we can rest easy that we have a current backup of our data so that if one drive fails we can always go to our backup folder, pull up the data and continue working on our database. Backing up your data should be a daily ritual. If not daily then at least weekly, or when you've entered a lot of new data, created a lot of new objects in your database be sure to back it up. It's a very simple task. It doesn't take long to do, and because you may be asked to do this on the Access 2010 MOS exam this will be great practice for you.
- Creating a new Access database
- Applying application parts
- Backing up a database
- Creating new tables and fields
- Sorting and filtering records
- Setting primary keys
- Importing data
- Creating basic forms
- Creating Access queries, including crosstab and multitable queries
- Creating Access reports