MS access is database application software that lets you create database of various sorts with ease. If your database contains lots of records, it is important that you compact and repair it from time to time. Doing so refreshes your database. Sometimes it happens that you delete certain records but they are still present in the database. Through the use of compact and repair, such records will be eliminated and the excess space taken up by the file will be reduced.