Accounting System Using Database Management System — Account STD 11 Commerce — Question

In the access environment a function is named and followed by parenthesis ( ). The function takes some inputs as its argument and in turn sends a value. These functions act as a part of the expression for a computer field. In the SQL environment, following are the main types of functions that are used along with their respective purposes.

1. Domain Aggregate Functions: These functions are used to perform calculation that are based on the values in a field of a table or query. A domain aggregate function uses the syntax as- DFunction (“Fld Name”, “Tbl Name” or Qry Name, “Srch Cond”)

where,

DFunction represents Domain Aggregate Function

Fld Name represents Name of the field to be searched

Tbl Name or Qry Name represents Name of the table or query that contains the above field.

Srch Cond represents Search Condition with the help of which relevant record is searched.

2. SQL Aggregate Functions: These functions are used in those SQL statements that provide the underlying record source of forms and reports. All these functions when used in SQL statement require GROUP BY clause.

3. Other Functions: Apart from Domain Aggregate Function and SQL Aggregate Function, there are some other functions also that are used in SQL. These are mentioned below.

1. IIF: These functions are used to provide a value to the field from a mutually exclusive set of values.

2. Abs: These functions are used to provide the absolute value in return of a numeric value. It takes the absolute value as its input argument and gives back an absolute value.

3. Val: These functions are used to provide numbers contained in a string as a numeric value of appropriate type.