Exam 77-424: Microsoft Access 2013 1.0 Create and Manage a Database 1.4 Protect and Maintain a Database: Compact and Repair Databases

Compact and Repair Before You Begin: Save and Close anything that may be open. As with the other File commands, Access will close all Objects before you start.   Try it: Compact and Repair Go to Database Tools->Tools. Select Compact and Repair Database.   What Do You See? It happens so quickly you may wonder if it worked. If you have a large, fragmented database, you may see a progress bar on the bottom of your Window as the process moves along. Be patient: A big database may take several minutes to Compact and Repair. When the maintenance is done, your database will open again. Memo to Self: You can program the database to Compact and Repair each time it is closed. The option can be found in File->Options->Current Database. Database Tools->Tools->Compact and Repair Database