Daniel Arno 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. Daniel 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.
Daniel 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. He decides to number each day of the week: 1=Monday, 2=Tuesday, and so forth.a. Will his idea work?b. Why or why not?c. Should he plan to sort in ascending or descending order?
What will be an ideal response?
a. Yes
b. Because the days of the week can be sorted in order from 1-7.
c. Ascending
You might also like to view...
Outlook sorts contacts on the value stored in the ____ box for each contact.
A. File as B. Sort value C. Sort on D. Sort key
________ add professional design to a SharePoint site, including fonts, styles, and professionally designed palettes of colors that go well together
A) Color palettes B) Designs C) Templates D) Themes
There are numerous legitimate programs that need to receive data from the Internet. To allow certain types of communication, an exception list is created in the ________
Fill in the blank(s) with correct word
In mathematics, especially matrix algebra, index values for elements in an array are usually subscripted.
Answer the following statement true (T) or false (F)