Critical Thinking Questions Case 11-2 in Your Database Course, Your

question 133

Multiple Choice

Critical Thinking Questions Case 11-2 In your database course, your instructor has given you a small database that has a lot of invalid data, issuing the challenge to you that you work to apply validation rules to the data and determine what checks need to be applied in order to restore integrity to the data. The instructor tells you that this is a mailing database, and yet you can see at a glance that there are some records with no data in the city field. What kind of check should you run on this field?

• A) completeness check
• B) range check
• C) consistency check
• D) check digit

Identify the appropriate controls (e.g., toggle button, option group) for different data entry scenarios in forms.

Recognize the importance of the Record Source property in displaying data on forms and how to configure it.

Comprehend the use and configuration of command buttons for performing specific actions (e.g., adding, saving, printing records) in forms.

Understand how to effectively organize and group objects in the Navigation Pane to enhance database user experience.

---

Definitions:

Variable Costing

An accounting method where only variable costs (costs that change with production levels) are included in product costs, excluding fixed costs.

Net Operating Income

The total profit of a business after operating expenses have been deducted, but before taxes and interest.

Variable Costing

An accounting method that includes only variable production costs (direct materials, direct labor, and variable manufacturing overhead) in the cost of goods sold, excluding fixed manufacturing overhead.

Contribution Margin

The gap between sales income and variable expenses, showing the extent to which income aids in offsetting fixed expenses and creating earnings.