Objectives
- To list departments with and without matching employee records.
To achieve these objectives you will complete the following:
Step 1. Build a query over the Department file
Step 2. Run the query
Step 3. Add a new record to the Department file
Step 4. Build a query
Step 5. Run the query
Step 6. Review the query options
Step 7. Run the query again
Step 8. Save the retrieved data
Step 9. Save the query definition
Step 10. Change the Join Type
Summary
Before You Begin
You may wish to review the following topic in this guide: