Matt Miller Owns a Lawn and Landscape Business

question 14

Essay

Matt Miller owns a lawn and landscape business. He has some very particular clients who want their lawns manicured on a specific day of the week. He has other clients who allow him to use his own judgement as to when their lawns need cutting. To maximize his efficiency, he wants to build a query that will show his weekly customers by name, day of the week, subdivision and fee. Matt creates a table called Customers. For those customers whose day of the week varies upon need, he leaves the day of the week field blank. Matt creates a query using the Name, Day of the Week, and Subdivision fields. He wants to sort the records by day of the week, beginning with Monday and ending with Sunday. Because he knows both Ascending and Descending orders sort by number, then alphabetically, he knows the days of the week will be sorted alphabetically and not chronologically. He decides on a workaround that uses a unique number for each day of the week: 1=Monday, 2=Tuesday, etc.
a. Will his idea work?
b. Why or why not?
c. Should he plan to sort in ascending or descending order?

---

Definitions:

Shared Beliefs

Refer to common values, ideas, or attitudes collectively held by members of a group, influencing their behavior and cohesion.

Self-managed Teams

Groups of workers who are given administrative oversight for their task domains, including planning, scheduling, and execution.

Task Composition

The way in which a task is broken down and organized into smaller components or steps to facilitate accomplishment.

Cross-functional Teams

Teams composed of members from different departments within an organization, working towards a common goal.