Explain why you would use the SWITCH function in combination with the WEEKDAY function in adjoining columns.
What will be an ideal response?
The WEEKDAY function returns a serial number representing the day of the week for a date. However, the serial number alone is not very informative. Using the SWITCH function to “read” the serial number and return text that displays the actual weekday is more useful.
You might also like to view...
A _________________________ is a database used to temporarily persist state data for software programs .
Fill in the blank(s) with the appropriate word(s).
Why, in the SlideColor program, is the value of a slider able to reach 255 but the largest labeled tick mark is 250?
What will be an ideal response?
If you enable all macros, then ________
A) all macros are disabled and Access provides security alerts if there are macros present, which is the default setting. B) you disable all macros with notification , except digitally assigned macros which are enabled by default C) Access allows all macros to run which makes your computer vulnerable to potentially malicious code and is not recommended D) all macros and security alerts about macros are disabled
Critical Thinking QuestionsCase 4-1Bradley plans to generate reports from an Access database that a colleague of his built. As he works with the reports, he decides to familiarize himself with each of the views that is available to him. Bradley is almost ready to print one of the reports. He wants to review the first page of the report to see how it will look when printed. Which view should he use? a.Report Viewc.Print Previewb.Layout Viewd.Design View
What will be an ideal response?