Home » Microsoft Access » 09 - Forms and Queries
9

Building a Query

Michael is now ready to build another query for the First Report - Skills by Job information.

  1. Click Query > New > Design View > Queries > qy:empApp
  2. Click Close.
  3. Drag and drop job_position and all skill sets to the job area.

  1. Click Total on the toolbar for totals.
  2. A new line appears on the grid area below table.
  3. The first three lines should be labelled Field, Table, Total.
  4. All the entries appear as Group by.

  1. Let job_position remain as Group By.
  2. To change the rest to Sum, click the arrow down button next to Group by.

NOTE: MS Access will not display the arrow icon until you click on that field.

  1. Click Sort in the job_position field.
  2. Select Ascending.

  1. Save the query as Qy:empSum.

Activity: Build an emergency contact query (for the second report). To do this, select design view, and add the employee and contact tables. Select all fields from the employee table except the job code and drag them to the grid area. Select all fields from the contact table except the social security number and drag them to the grid area. Save the select query as Qy: emergency.

Discuss this in the forums

< Prev
|
Next >