Which of the following is TRUE about Access' Compact and Repair feature?
A) It fragments a fragmented relational database file.
B) It defragments a fragmented database file if needed.
C) It removes objects and stores them in a secondary file.
D) You should compact your database no more than once a week due to the time required.

Question

Quizplus · Accepted Answer

The Compact and Repair feature in Access defragments a fragmented database file if needed. It also removes any unused space and can improve the overall performance of the database. It is recommended to use this feature regularly, especially after deleting a large amount of data or making significant changes to the database structure. There is no specific guideline on how often to run the Compact and Repair feature, but it should be done as needed to maintain the health and performance of the database.

Which of the Following Is TRUE About Access' Compact and Repair