Q1: | Explain what the process of compacting a database does. |
A1: | It reclaims unused space, improves performance, resets counter fields, and re-creates table statistics. |
Q2: | Name three techniques you can use to compact a database. |
A2: | You can use commands via the user interface, a shortcut that you set up, and the Compact on Close option. |
Q3: | Explain why encrypting a database is a good idea. |
A3: | Encrypting a database prevents a user from being able to read table data in a text editor. |
Q4: | Explain the downsides of encrypting a database. |
A4: | 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. |