From the course: Access 2007: Shortcuts
Unlock the full course today
Join today to access over 22,400 courses taught by industry experts or purchase this course individually.
Compacting and repairing a database - Microsoft Access Tutorial
From the course: Access 2007: Shortcuts
Compacting and repairing a database
It's important to do maintenance on your database once in a while. Compacting and repairing your Access file keeps it running smoothly and minimizes your file size. If you find that your database is slowing down or becomes corrupted, Access could use a repair. Or, when you delete records out of your database, Access does not reclaim the disk space and your file size does not get any smaller. To solve both of those issues, perform a Compact and Repair on it. Go up to the Office button, and down to Manage. Choose Compact and Repair Database. Access will trim down your file size and keep itself running smoothly. Be sure to do a Compact and Repair periodically, especially after large deletions.
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.