Access 2003 In Pictures

  1. Create a new query in Design view based on the Artists table.
  2. Add the Good Artist? field to the design grid area.
  3. Add the criterion False to the Good Artist field.
  4. Change the query type to an Update query.
  5. Update all artists to designate them as Good artists.

    TIP: Set the Update To value to True.

    The query design grid should look like this:

  6. Run the query.
  7. Close the query, saving it as Make All Artists Good.
  8. Exit Microsoft Access.