Updating tables in access
You could modify the query using the following criteria to obtain this result.
field, include the criteria “PHYS” to select all sections with a Physics subject code.
In that case, you can use brackets  to specify a user-entry criteria field.
When you open a Recordset, the first record is current.
The most direct way to move to a specific record is using the prefix" where field is an indexed field in the underlying base table and prefix is a prefix search string (for example, "ART*" ).
After having found the record you can read or change the record's field values as explained under Edit a record in a DAO Recordset.
The code below opens a recordset taken from a table in the current database on a query or attached table Access defaults the Type property to db Open Dynaset.
When you Open Recordset on a local table, it uses db Open Table by default. Seek instead of Find First), but it cannot be used with attached tables.
Under the Days field you would use the slightly more complex criteria Like “*M*” or Like “*W*” to pick up any record with M or W anywhere in the field.