Unlike the dialog box, update queries can accept multiple criteria, you can update a large number of records in one pass, and you can change records in multiple tables.

• 与对话框不同的是,更新查询可接受多个条件,可以一次性更新大量记录,还可以更改多个表中的记录。