Page 231 - Computer - 10(A&B)
P. 231
Working with Numerical Data
The mathematical functions help us to perform calculations on numerical data.In Base, you can use mathematical
functions to find the count, sum, minimum, maximum, or average of data values. Let’s learn how to create a
query in the Design view to display the marks scored by the students more than passing marks.
To do so, follow the given steps:
Step 1: Click the Queries icon in the Database area.
Step 2: Under Tasks area, click the Create Query in Design View option. The Add Table or Query dialog box
appears.
Step 3: Choose the required table from the dialog and click the Add button. The Query Design window appears.
Step 4: Create the query. To add a custom column, type the name in an empty Field box. You can type a
formula for a calculated field.
Step 5: Save the query and execute it.
113
