Case AC 14-1 Ron wants to convert his paper-based customer information system to an Access 2010 database stored on his laptop. However, Ron is concerned about placing the information on his laptop because he also uses the laptop for Internet access. He asks for your advice. Ron questions how a password can be used with an Access database. You explain that when opening a(n) ____ database, Access 2010 will prompt Ron for a password.
A) blocked
B) personal
C) row level locked
D) encrypted

Question

Quizplus · Accepted Answer

The best choice is D, encrypted. Encryption is the process of converting data into a coded language to prevent unauthorized access. Access 2010 allows Ron to encrypt his database with a password, making it much more secure. When Ron opens the encrypted database, Access will prompt him to enter the password before allowing access to the data. This ensures that sensitive customer information is protected from unauthorized access, even if Ron's laptop is stolen or hacked. Choices A, B, and C do not apply to password protection in Access databases.

Case AC 14-1 Ron Wants to Convert His Paper-Based Customer