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?
Correct Answer:
Verified
b. Because th...
View Answer
Unlock this answer now
Get Access to more Verified Answers free of charge
Q45: Filter By _ filters records based on
Q47: The upper portion of Query Design View
Q52: _ is the term for rules by
Q53: Once you have filtered a datasheet to
Q54: _ means temporarily isolating a subset of
Q55: A filter cannot be saved as a
Q58: _ refers to reorganizing the records in
Q60: Is _ criteria will find all records
Q61: Match each term with the statement that
Q65: SQL is the acronym for " simple
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents