Workshop

The quiz questions and activities are provided for your further understanding of the current hour's topics.

Quiz

1:	What's wrong with the following record selection formula, and how would you fix it? {Orders.Order Date} > "2/25/2000"
A1:	This record selection formula is comparing a date to a string literal. The string on the right would need to be converted to a date-time value before making this comparison. One of the possible solutions is {Orders.Order Data} > #2/25/2000#
2:	What is the purpose of a SQL Expression?
A2:	The purpose of a SQL Expression is to create a formula that is processed on the database server to either use a database-specific function, or to ensure maximum performance when using that formula in the record selection formula.
3:	How are triggered alerts displayed to the user?
A3:	When an alert is triggered, it is displayed to the user in the form of a pop-up dialog, as shown in Figure 15.3.

Activities

To ensure that you are comfortable with the topics discussed in this hour, try to perform the following tasks:

• Create a report on the Orders table with a parameter that allows the user to select which date he wants to see orders for. Perform the appropriate filtering in the record selection formula.

• Create a report on the Employee table that uses a SQL Expression to calculate the employee's age based on the Birth Date field.

• Create a report on the Orders table with an alert for any order of more than five thousand dollars.