As you make changes to the database in Design view, you may notice that it will grow in size very quickly. To return your database to a reasonable size you will need to compact it.

To compact a database:

• Open the database in Design view, click on Tools > Database Utilities > Compact and Repair.

This should reduce your database back to close to its original size.

Do you like this tip? Subscribe to my free Newsletter to receive tips via email. Click Here to subscribe.