Manipulate data

Manipulate data effectively. Students should be capable of: Performing calculations by utilizing arithmetic operations or numeric functions, which includes creating calculated fields and controls. Employing formulae and functions to execute calculations in real-time, such as addition, subtraction, multiplication, division, as well as determining sum, average, maximum, minimum, and count. Sorting data based on one or multiple criteria to arrange it in either ascending or descending order. Searching and selecting data by applying one or multiple criteria to extract specific subsets using queries, and conducting searches with various operators like AND, OR, NOT, LIKE, >, <, =, >=, <=, and <>. Additionally, using wildcards in searches.