Player Draft-Step 1
- Open your database. Close the main menu form,
but leave database open.
- Click the Queries button. New >> Find
Unmatched Query Wizard >> OK to start wizard:
- Players, Next
- Teams, Next
- TeamID selected, Next
- Select: PLayerID, Rating, LastName,
FirstName, BirthDate, and TeamID. Next
- Finish
- You should see the players that have not yet
been assigned to a team (TeamID is blank)
- Change to Design View
- Sort by Rating, Ascending and then by
LastName, Ascending
- Run and view results, then save your query