- If one is working with the Expression Builder in Access, what significance
do the words before the colon in an expression have?
- Write a mathematical expression that would calculate the total price of a
meal given the Cost, C of the meal; a tax rate of 6.5%; and a gratuity of
15%.
- Using the above example, create an advanced query that generates the total
cost of a meal for the following meals below. Create any databases, tables,
fields, and their corresponding names, that you deem necessary.
| Chart House |
16 oz Prime Rib Meal |
$ 30.99 |
| Hops |
Jamaican Sirloin |
$ 14.00 |
| Olive Garden |
Lasagna |
$ 10.99 |
| Roadhouse Grill |
Roasted Herb Chicken |
$ 12.99 |
| La Carreta |
Ropa Vieja |
$ 7.50 |