Explain what the process of compacting a database does.
It reclaims unused space, improves performance, resets counter fields, and re-creates table statistics.
Name three techniques you can use to compact a database.
You can use commands via the user interface, a shortcut that you set up, and the Compact on Close option.
Explain why encrypting a database is a good idea.
Encrypting a database prevents a user from being able to read table data in a text editor.
Explain the downsides of encrypting a database.
An encrypted database functions more slowly than a database that is not encrypted because it constantly encrypts and decrypts objects. Access also places several restrictions on encrypted databases. For example, encryption renders most disk-compression utilities useless because compression software usually relies on repeated patterns of data.