Microsoft Office Tutorials and References
In Depth Information
also takes place behind the scenes, and you probably won’t notice anything. But don’t
be alarmed when you exit Access and it doesn’t prompt you to save changes, as any
change to your data is saved the moment you make it.
Note: The rules are a bit different for database objects (page 710). When you add or edit a database
object, Access waits until you finish and close the object, at which point it prompts you to save or discard
your changes. If you’re a bit paranoid and can’t stand the wait, just choose File➝Save to save the current
database object immediately.
The automatic save feature can pose a problem if you make a change mistakenly.
If you’re fast enough, you can use the Undo feature to reverse your last change (Fig-
ure 25-11). However, the Undo feature reverses only your most recent edit, so it’s no
help if you edit a series of records and then discover the problem. It also doesn’t help
if you close your table and then reopen it.
The Undo command
appears in the Quick
Access toolbar at the
top left of the Access
window, so it’s always
For these reasons, it’s a good idea to make frequent database backups. To make a
database backup, you simply need to copy your database file to another folder, or
make a copy with another name (like Bobblehead_Backup1.accdb). You can
perform these tasks with Windows Explorer, but Access gives you an even easier option.
First, choose File ➝ Save & Publish. Then, under the File Types heading, choose Save
Database As. Finally, under the Save Database As heading, double-click Back Up
Database. This opens to create a copy of your database, in the location you choose
Of course, it’s still up to you to remember to copy your database backup to another
location (like a network server) or to a different type of storage (like a DVD or a USB
memory stick), so you’re ready when disaster hits. You can use any number of
different backup tools to safeguard your computer, including the Backup and Restore
Center included in Windows Vista and Windows 7.