Explain the difference between an IIf function and a nested IIf function. Give two examples of when you would use each one
What will be an ideal response?
If functions can be used to determine if a specific condition is true or false. The IIf function introduces decision making into a database. Depending on whether or not specified criteria are met, the IIf function will return a different result depending on the outcome of the condition. Student examples will vary. Some ideas include searching for whether or not an employee is scheduled to work on a given day, whether or not a product is out of stock, or whether or not a customer has redeemed a specific coupon.
There are many occasions when you need to test for multiple conditions. A nested IIf function is when one IIf function is placed inside another. This allows a user to evaluate a series of dependent expressions. Student examples will vary. Some ideas include converting students' grades from a percent to a letter grade, determining how much inventory to order based on in-stock inventory counts, or how much of a salary increase an employee will receive based on a performance evaluation score.
You might also like to view...
When you assign a nonrecurring task, you cannot retain a copy, but can request a status report when the task is completed.
Answer the following statement true (T) or false (F)
Which setting in the Network & Internet category allows you to view information about connections to wired networks such as a connection's IP address?
A. Wi-Fi B. Ethernet C. Dial-up D. Status
Most classes need to be imported before they can be used in an app. Why is every app allowed to use classes System and String without first importing them?
What will be an ideal response?
The ____ tool is an essential tool that you can use to quickly create basic shapes.
A. Star B. Polygon C. Transform D. Shape