Access is one of the only programs in the Office suite that doesn’t feature an autorecovery option in the case of a program crash or unexpected shutdown. Because of this, users will want to make sure that database backups are made consistently. Access provides a backup procedure that automatically date stamps the backup files for easy archiving.
- [Instructor] 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 an unexpected shutdown. Because of this, you'll wanna 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 of your database, you'll come up here to the File tab, and then come down to Save As. In the Save Database As section, I'll come down and choose the Backup Database option, and then press Save As.
That'll bring up my standard file dialogue, and I can browse out to a specific location. And it's actually gonna put me into the Chapter 1 folder, which is where my original database was. And you'll notice here at the bottom that it appends today's date to the end of the backup file name. All I need to do is press the Save button. And that's all there is to it. You can now continue working in your database and have the peace of mind that you've got a backup in place should something go wrong.
Author
Released
9/24/2018- Determine the essential uses for the Trust Center.
- Explore the functions of the database Navigation pane.
- Recognize the fundamentals of entering data when using Access.
- Identify the necessary steps when importing a table when using Access.
- Break down the fundamentals of filtering and sorting table data in Access.
- Identify the method utilized when building queries in Design view.
- Determine the role of forms in Access.
- Examine all of the elements involved in maintaining a database in Access.
- Explore how to properly protect an Access database with a password.
Skill Level Beginner
Duration
Views
Related Courses
-
Introduction
-
1. Getting Started
-
Database concepts4m 27s
-
Create the database file3m 53s
-
Understand the Trust Center3m 29s
-
Digging into Ribbon tabs5m 3s
-
The database Navigation pane3m 22s
-
-
2. Creating Tables
-
Enter data3m 44s
-
Primary and foreign keys4m 47s
-
Importing tables4m 29s
-
3. Setting Field Properties
-
Control input with masks4m 37s
-
Set a default value2m 42s
-
Data validation rules4m 53s
-
Data lookup fields3m 58s
-
Additional field properties4m 40s
-
4. Organizing Records
-
Sorting table data3m 7s
-
Filtering table data2m 27s
-
Deleting records1m 32s
-
-
5. Using Queries
-
What are queries?3m 19s
-
The Simple Query Wizard4m 22s
-
Build expressions5m 21s
-
Obtain summary statistics7m 23s
-
-
6. Creating Forms
-
Generate forms from tables5m 16s
-
Using the Form Wizard3m 50s
-
Form Design view4m 38s
-
Find records4m 33s
-
7. Creating Reports
-
Introducing reports3m 27s
-
The Report Wizard4m 37s
-
Edit a report in Layout view5m 11s
-
Group and sort records5m 35s
-
Creating calculated totals2m 59s
-
Create labels3m 31s
-
Adjust print settings3m 38s
-
-
8. Maintaining the Database
-
Set startup options3m 18s
-
Conclusion
-
Next steps55s
-
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Create a database backup