Step 1. Build a query over the Department file

LCE231 - Join Query, including Unmatched Records

Create a new Department record using a temporary query

For this part of the exercise you are simply creating a new Department record.

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 Departments file to select.

     Alternatively, highlight the file then press the Enter key.

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

3.  Select all the fields in the Departments file for your query.