Case AC 7-1 Ed Brown is the chief financial officer of a medium-sized business distributing geological surveying meters and associated equipment to engineering companies and government agencies. Ed has noticed that the company sales and receipts are not matching properly, and he suspects inadvertent human error in Access database data entry. For the date issue of immediate concern, you decide to use ____ to increase accuracy and efficiency of data entry.
A) validation masks
B) lookup boxes
C) placeholder symbols
D) validation rules

Question

Quizplus · Accepted Answer

Validation rules would be the best choice to increase accuracy and efficiency of data entry. Validation rules can be set up in Access to check for specific criteria when data is entered, such as ensuring that values fall within a certain range or that required fields are not left blank. This can help prevent inadvertent errors from being entered into the database. Validation masks, lookup boxes, and placeholder symbols may also be useful in some situations, but they do not provide the same level of control over data entry as validation rules.

Case AC 7-1 Ed Brown Is the Chief Financial Officer