Step 1. Build a query over the Employee file

LCE270 - Top-10 and Bottom-10 Query

Top-10 Query

1.  From the toolbar select the File menu and then choose the New command.

     Alternatively, you could select the Create a new query icon from the toolbar.

2.  Double-click on the Employee file to select it.

     Alternatively, highlight the file then press the Enter key.

     The fields of the Employee file will be displayed and become available for selection in your query.

3.  Select the following fields for your query:

• Department

• Department Description from the Departments file

• Identification

• Surname

• Given Names

• Annual Salary

     Note: Adding the Department Description from the Departments file makes this a join query, a condition for creating Top-10 style queries.