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.