Nancy Smith Comes in to EspressoCoffee to Provide Her New

question 5

Multiple Choice

Nancy Smith comes in to EspressoCoffee to provide her new address and you make the appropriate updates. When preparing a sales receipt for her a week later you notice Nancy's old address appears on receipt. What does this indicate about the database?

• A)The database is working correctly.
• B)Nancy Smith's order was entered incorrectly.
• C)The same customer was entered into the database multiple times.
• D)The address information was updated for the wrong Nancy Smith.

---

Definitions:

Crosstab Query

A query type that aggregates data based on two or more fields and displays it in a tabular form, often used to create matrix reports.

Property Types

Categories or characteristics of properties in programming or real estate, specifying their data type, value range, or physical attributes.

Row Headings

The labels along the left side of a spreadsheet or table that typically indicate the number or name of each row.

Parameter Query

A query that prompts the user to input one or more criteria values when it is run, allowing for dynamic database searches.