Base 2.0 In Pictures

Practice: Working with Queries

  1. Start Base.
  2. Open the Library 2 database.
  3. Create a new query in Design view based on the Authors table.
  4. Add all the fields to the design grid.
  5. Sort Authors Names in Ascending order.
  6. Add the criteria Yes to the Good Author field.
  7. Run the query.

    Its results should look like this:

  8. Close the query, saving it as Good Authors.
  9. Exit Base.