From the course: Access Essential Training (Office 365/Microsoft)
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Compact and repair the database
From the course: Access Essential Training (Office 365/Microsoft)
Compact and repair the database
- [Instructor] When working with your database files, Access keeps track of the changes that you're making in the background and when you delete an object or lots of records, Access doesn't actually give you that disk space back right away. If you notice that your database is running slower or you'd like to squeeze the file size down as much possible, you can use a little tool called compact and repair. You'll find the compact and repair tool either on the database tools tab here in the very first position or you can also find it if you go to the file tab and in the info section, you'll find a copy of it there as well. Either place will accomplish the same task. Now when you click on the button, Access will close the database file then run through some routine maintenance tasks. It throws out old log-in information, rebuilds indexes and just generally cleans up after itself. Then the database file is saved again and reopened. Now for some databases, the compact and repair process is…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
-
-
-
-
(Locked)
Customize groups in the navigation pane2m 52s
-
(Locked)
Compact and repair the database1m 20s
-
(Locked)
Examine database object relationships2m 34s
-
(Locked)
Document your thought process3m 34s
-
(Locked)
Print the blueprint of your database3m 45s
-
(Locked)
Split a database into front and back ends4m 21s
-
(Locked)
Protect the database with a password3m 10s
-
(Locked)
Set startup options3m 25s
-
(Locked)
-