SQLConfiguration SQLConfiguration


Refining Queries  «Prev  Next»

Using query field properties - Exercise

Course project: Setting a query field’s Caption property


Objective:

Set the Caption property for a field in a query.

Exercise scoring


You will receive 10 points for this exercise. The exercise is auto-scored; when you have completed the exercise, click the Submit button to receive full credit.

Background/overview


Recall that you are the Access database administrator for the marketing and documentation departments of companies in the software and networking business. Taking the example discussed in this lesson a bit further, you need to create a query that includes the Projects and Hours tables. Select the ProjectDescription, DateWorked, and a calculated field. You will modify the Caption property of the calculated field to something other than the name of the field.

Download files

As we stated in the first module, the Consulting307.mdb database is included in the compressed download file available on the Resources page. If you have already downloaded the database, continue to work in that version.

Instructions

  1. Create the query by using the Projects and Hours table.
  2. Use the following fields:
  3. ProjectDescription (Projects table)
  4. Rate (Projects table)
  5. HoursWorked (Hours table)
  6. Cost: A calculated field where the expression is Cost: [Rate]*[HoursWorked]
  7. Change the Caption property of the Cost field to Extended Cost.