Creating Queries  «Prev  Next»

Creating Calculated Fields -Exercise

Creating calculated fields


Add a calculated field


Objective: Add a calculated field to the Consulting database.
You will receive 5 points for this exercise. The exercise is auto-scored, which means all you need to do to receive full credit for the exercise is click the Submit button.
  1. Open the Project Hours query in the Consulting database.
  2. Add a field called Billable that is equal to Hours Worked times your hourly rate, $50.
Remember to create the new field in a new column of the query grid. Name the field first, type a colon, then type the expression. You may need to use special characters in the expression to tell Access the kind of data you are including
  1. Now try using a Zoom Box: put the cursor in the blank Field cell and press Shift-F2, then type your expression.