where condition with the = or <> operator on an approximate numeric data type is performed. where clause is used to specify on which records an SQL operation is peformed, the select-object cmdLet is used to specify which PowerShell-objects are kept in a PowerShell pipeline. autoFilter object allows to filter rows based on the values of its cells. filter also allows to select portions of a range that match a certain criteria. DoCmd.SetOrderBy.