You work for a small non-profit. Your boss has given you the task of creating thank-you letters to send to people who have donated to your non-profit organization this past year. She has given you a form letter in Word and a database of donors in Access. You need to merge the two.
-You discover that donor social security numbers are the primary key in the Access database. You ____ in order to keep that information from being available to other people reading the document.
A) decide to enter all data manually
B) change the Unique Identifier field in the Match Fields dialog box to "(not matched)"
C) match the SSN field to "NULL" in the Match Fields dialog box
D) do nothing

Question

Quizplus · Accepted Answer

Changing the Unique Identifier field to "(not matched)" will ensure that the social security numbers are not included in the merged document, as they will not be matched with any field in the Word form letter. This is the best solution as it allows for an efficient and accurate merge, while also protecting sensitive information. Manually entering data would be time-consuming and prone to errors, matching the SSN field to "NULL" could still potentially reveal the information, and doing nothing would result in the social security numbers being included in the merged letters.

You Work for a Small Non-Profit