Access 2007 In Pictures

Practice: Working with Queries

  1. Start Microsoft Access.
  2. Open the MusicLibrary2 database.
  3. Create a new query in Design View based on the Artists table.
  4. Add all the fields to the design grid.
  5. Sort Artist Names in Ascending order.
  6. Add the criterion True to the Good Artist field.
  7. Run the query.

    Its results should look like this:

  8. Close the query, saving it as Good Artists.