| 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. |
