From the course: Access 2019 Essential Training
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 2019 Essential Training
Compact and repair the database
- [Instructor] When working with your database files, Access keeps tracks of 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 as possible, you can use a little tool called Compact and Repair. You'll find Compact and Repair either on the Database Tools tab, here at the very beginning, or on the File tab in the Info Group, here at the top. Either place will accomplish the same task, when you press the button, Access will close the database file, then run through some routine maintenance tasks. It throws out old log information, it rebuilds indexes, and just generally cleans up after itself. Then the database file is saved again and reopened. For some databases, like the one we're working in, the Compact and Repair process is so quick, that you might only notice a little…
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 37s
-
(Locked)
Compact and repair the database1m 21s
-
(Locked)
Examine database object relationships2m 20s
-
(Locked)
Document your thought process2m 49s
-
(Locked)
Print the blueprint of your database2m 51s
-
(Locked)
Split a database into front and back ends3m 44s
-
(Locked)
Protect the database with a password3m 2s
-
(Locked)
Set startup options3m 18s
-
(Locked)
-