Microsoft Office® Access 2007 Inside Out

Updating Groups of Rows

It’s easy enough to use a table or a query in Datasheet view to find a single record in your database and change one value. But what if you want to make the same change to many records? Changing each record one at a time could be very tedious.

Remember that in Chapter 7 you learned how to construct queries to test proposed new validation rules. In the HousingDataCopy.accdb database, there’s a table-level validation rule defined in tblFacilityRooms that doesn’t let you enter a WeeklyRate value that is greater than seven times the DailyRate value. If you want to change this rule to ensure that the WeeklyRate value is no more than six times the DailyRate value (thereby ensuring that the weekly rate is a true discount), you ...