Chapters 15: query by attribute
Chapter 17: query by location
Selection → Select by attribute...
Selection → Select by location...
Right-click → Join and Relate → Join...
Working with Data
Exercise 13c - Editing feature attribute values
Related ArcGIS online help
Selecting records in tables
Spatial joins by feature type