• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Q&A

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.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint